| Table Name: | job |
| Table Number: | 5046 |
| Group: | Task Mgr |
| Description: | Tracks instances of a business process. Reserved; not used |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| arch_ind | LONG | int | DIRECT, ALLOW_NULL | When set to 1, indicates the object is ready for purge/archive | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| id_number | CHAR | varchar | 4 | 32 | Unique job number assigned based on auto-numbering definition | |||
| job_history | CHAR | text | 23 | ALLOW_NULL | The multi-line field that contains the history of the job | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| title | CHAR | varchar | 2 | 50 | Title of the job |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| job_act2act_entry | OTM | act_entry | act_entry2job | Related activity log entries | |||
| job_result2case | MTO | case | case_orig2job | Reserved; future | |||
| job_cmit2commit_log | OTM | commit_log | job_commit2job | Commitments for the job | |||
| job_state2condition | OTOP | condition | job_condition2job | The condition of the job | |||
| job_sts2gbst_elm | MTO | gbst_elm | job_status2job | Status of the job | |||
| job2life_cycle | MTO | life_cycle | cycle2job | Business process to which the job belongs | |||
| job_notes2notes_log | OTM | notes_log | job_notes2job | Job notes logs | |||
| job_prevq2queue | MTO | queue | prevq2job | Used to record which queue job was accepted from; for temporary accept | |||
| job_currq2queue | MTO | queue | currq2job | The queue the job is currently dispatched to | |||
| job2reject_msg | OTM | reject_msg | reject_reason2job | Reasons for rejecting the job | |||
| job2status_chg | OTM | status_chg | job_status_chg2job | Status changes for the job | |||
| job2subcase | OTM | subcase | subcase2job | Subcases originated from the job | |||
| job_owner2user | MTO | user | curr_owner2job | User that owns the job | |||
| job_originator2user | MTO | user | originator2job | User that originated the job | |||
| job_wip2wipbin | MTO | wipbin | wipbin2job | The WIPbin the job is accepted into |
| Index Name | Fields | Flags |
|---|---|---|
| job_index | id_number | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| job_index | id_number | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| job | |||