Table Detail Report

CSM_PRIORITIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM PRIORITIES
Definition: This table holds specific priorities for client services.
Table Type: REFERENCE





Column Detail - CSM_PRIORITIES


Column Name Type Null? Definition
CSM_ACTIVE_IND DOUBLE N Indicates that the priority is active.
CSM_DEFAULT_IND DOUBLE N Indicates that this priority should be used as a default when any request is ordered. There can only be one default priority.
CSM_PRIOR_DESC CHAR(40) N The priorities description.
CSM_PRIOR_ID DOUBLE N A unique id for a priority.
CSM_TAT_IND DOUBLE N The indicator denoting whether the TAT is in days or hours.
CSM_TAT_LEN_IND DOUBLE N The numerical value for turn around time.
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 - CSM_PRIORITIES




Parent Column in CSM_PRIORITIES (PK) Child Table Name Child Column Name
Children: CSM_PRIOR_ID CSM_REQUESTS CSM_PRIOR_ID
CSM_REQUESTS_ARCHIVE CSM_PRIOR_ID


CSM_QUEUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM QUEUES
Definition: The table that records the queue names, ids, and parameters for CSM.
Table Type: REFERENCE





Column Detail - CSM_QUEUES


Column Name Type Null? Definition
CSM_QUEUE_DESC CHAR(40) N The queue name field.
CSM_QUEUE_ID DOUBLE N The unique identifier for a queue.
CSM_QUEUE_TYPE_IND DOUBLE N Indicates whether the queue is for Callbacks or Call-ins.
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 - CSM_QUEUES




Parent Column in CSM_QUEUES (PK) Child Table Name Child Column Name
Children: CSM_QUEUE_ID CSM_QUEUE_PERS_XREF CSM_QUEUE_ID
CSM_Q_CAT_XREF CSM_QUEUE_ID
CSM_Q_ORG_XREF CSM_QUEUE_ID


CSM_QUEUE_PERS_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM QUEUE PERS XREF
Definition: The table to record which users have access to which queues for CSM.
Table Type: REFERENCE





Column Detail - CSM_QUEUE_PERS_XREF


Column Name Type Null? Definition
CSM_QUEUE_ID DOUBLE N The unique identifier for the queue.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - CSM_QUEUE_PERS_XREF


Child Column in CSM_QUEUE_PERS_XREF(FK) Parent Table Name Parent Column Name
Parents: CSM_QUEUE_ID CSM_QUEUES CSM_QUEUE_ID
PERSON_ID PRSNL PERSON_ID


CSM_Q_CAT_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM Q CAT XREF
Definition: The table to list the categories associated with various CSM queues.
Table Type: REFERENCE





Column Detail - CSM_Q_CAT_XREF


Column Name Type Null? Definition
CSM_CAT_ID DOUBLE N The unique identifier for the CSM category.
CSM_CAT_INCL_FLAG DOUBLE Y The flag to indicate whether or not to include/exclude the record.
CSM_QUEUE_ID DOUBLE N The unique identifier for the CSM queue.
CSM_SUB_CAT_ID DOUBLE N The unique identifier for the CSM sub category.
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 - CSM_Q_CAT_XREF


Child Column in CSM_Q_CAT_XREF(FK) Parent Table Name Parent Column Name
Parents: CSM_CAT_ID CSM_CATEGORIES CSM_CAT_ID
CSM_QUEUE_ID CSM_QUEUES CSM_QUEUE_ID


CSM_Q_ORG_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM Q ORG XREF
Definition: The table to list limits for which orgs to include in various CSM queues.
Table Type: REFERENCE





Column Detail - CSM_Q_ORG_XREF


Column Name Type Null? Definition
CSM_ORG_INCL_FLAG DOUBLE Y The flag to determine whether the recored indicates an include or an exclude.
CSM_QUEUE_ID DOUBLE N The unique identifier for the CSM queue.
ORGANIZATION_ID DOUBLE N The unique identifier for the client org.
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 - CSM_Q_ORG_XREF


Child Column in CSM_Q_ORG_XREF(FK) Parent Table Name Parent Column Name
Parents: CSM_QUEUE_ID CSM_QUEUES CSM_QUEUE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID