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 |