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