Table Detail Report
CDI_WORK_QUEUE_PRSNL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CDI Work Queue Personnel Relationship |
Definition: | The tables specifies individual users that are granted or denied access to a specific work queue. |
Table Type: | REFERENCE |
Column Detail - CDI_WORK_QUEUE_PRSNL_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
CDI_WORK_QUEUE_ID | DOUBLE | N | A foreign key from the CDI_WORK_QUEUE table. It is the work queue the personnel has access to. |
CDI_WORK_QUEUE_PRSNL_RELTN_ID | DOUBLE | N | The unique pimary key of this table. It is an internally generated number. |
EXCEPTION_IND | DOUBLE | N | Specified if the personnel is excluded. |
PERSON_ID | DOUBLE | N | A foreign key from the PRSNL table. It is the ID of the person that can access the queue. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CDI_WORK_QUEUE_PRSNL_RELTN
Child Column in CDI_WORK_QUEUE_PRSNL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CDI_WORK_QUEUE_ID | CDI_WORK_QUEUE | CDI_WORK_QUEUE_ID |
PERSON_ID | PRSNL | PERSON_ID |
CDI_WORK_QUEUE_TIME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CDI Work Queue Time |
Definition: | The table specifies the day of the week and times when each work queue is open. |
Table Type: | REFERENCE |
Column Detail - CDI_WORK_QUEUE_TIME
Column Name | Type | Null? | Definition |
---|---|---|---|
CDI_WORK_QUEUE_ID | DOUBLE | N | Work Queue the times apply to. |
CDI_WORK_QUEUE_TIME_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
CLOSE_TIME | DOUBLE | N | Time the queue closes on the days specified. |
OPEN_DAYS_BITMAP | DOUBLE | N | Bitmap of days the queue is open (Sun=1, Mon=2, Tue=4, Wed=8, Thu=16, Fri=32, Sat=64). |
OPEN_TIME | DOUBLE | N | Time the queue opens on the days specified. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CDI_WORK_QUEUE_TIME
Child Column in CDI_WORK_QUEUE_TIME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CDI_WORK_QUEUE_ID | CDI_WORK_QUEUE | CDI_WORK_QUEUE_ID |