CSM_AD_HOCS



Column Section Top of Page


Table-level Detail

Description: CSM AD HOCS
Definition: lists the ad hoc phone numbers for callback requests
Table Type: ACTIVITY





Column Detail - CSM_AD_HOCS


Column Name Type Null? Definition
CSM_AD_HOC_EXT CHAR(100) Y Ad Hoc phone number extension for the callback requests
CSM_AD_HOC_PHONE CHAR(100) N ad hoc phone number for the callback requests
CSM_REQ_ID DOUBLE N Unique identifier for the service request
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.


CSM_CATEGORIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Categories are high level groupings for client service requests.
Definition: This table is the beginning stage of building the client services database.
Table Type: REFERENCE





Column Detail - CSM_CATEGORIES


Column Name Type Null? Definition
CSM_CAT_DESC CHAR(40) N The description given to the category, limit of 40 characters.
CSM_CAT_ID DOUBLE N The unique identifier given to the 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_CATEGORIES




Parent Column in CSM_CATEGORIES (PK) Child Table Name Child Column Name
Children: CSM_CAT_ID CSM_CAT_SUB_XREF CSM_CAT_ID
CSM_Q_CAT_XREF CSM_CAT_ID
CSM_REQUESTS CSM_CAT_ID
CSM_REQUESTS_ARCHIVE CSM_CAT_ID


CSM_CAT_SUB_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: A combination of categories and subcategories will make a request.
Definition: This is the request table for CSM.
Table Type: REFERENCE





Column Detail - CSM_CAT_SUB_XREF


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CSM_CALLBACK_IND DOUBLE Y Field to allow user to categorize request as a callback/non-callback type.
CSM_CAT_ID DOUBLE N Id of the category associated with this request.
CSM_SUB_CAT_ID DOUBLE N Id for the sub category associated with this request.
REQ_AV_FLAG DOUBLE Y Auto-Verify flag. 0 - on
REQ_MNEMONIC CHAR(10) Y A mnemonic given to the request to make ordering easier for the user.
REQ_PHONE_FLAG DOUBLE N 0 = Patient Location, 1 = Chart Copy-to Location
REQ_PURGE_DAYS DOUBLE Y Number of days to retain request data on the system.
REQ_SECURITY DOUBLE Y Reserved for future use.
REQ_TEMPL_ID DOUBLE N The unique id of the template to be used for inputting data on the request.
RESL_TEMPL_ID DOUBLE N The unique id for the template to input data on lthe result of the request.
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_CAT_SUB_XREF


Child Column in CSM_CAT_SUB_XREF(FK) Parent Table Name Parent Column Name
Parents: CSM_CAT_ID CSM_CATEGORIES CSM_CAT_ID
CSM_SUB_CAT_ID CSM_SUB_CATEGORIES CSM_SUB_CAT_ID
REQ_TEMPL_ID WP_TEMPLATE TEMPLATE_ID
RESL_TEMPL_ID WP_TEMPLATE TEMPLATE_ID


CSM_LST_CONTACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM LST CONTACT
Definition: lists the last contact made for each phone id that comes through the CSM system
Table Type: ACTIVITY





Column Detail - CSM_LST_CONTACT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CONTACT VARCHAR(100) Y free textname for the contact
CSM_CONTACT_ID DOUBLE N Not used, can't remove for packets
CSM_LST_DT_TM DATETIME N date and time of last contact
CSM_LST_REC_ID DOUBLE N unique record identifier
CSM_PHONE_STAT_ID DOUBLE N unique identifier for the phone status during the last contact attempt
CSM_REQ_ID DOUBLE Y Uniquely identifies the related request.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHONE_ID DOUBLE N Unique identifier of a phone number
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CSM_LST_CONTACT


Child Column in CSM_LST_CONTACT(FK) Parent Table Name Parent Column Name
Parents: CSM_PHONE_STAT_ID CSM_PHONE_STATS CSM_PHONE_STAT_ID
CSM_REQ_ID CSM_REQUESTS CSM_REQ_ID
PHONE_ID PHONE PHONE_ID
PERSON_ID PRSNL PERSON_ID


CSM_PHONE_STATS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM PHONE STATS
Definition: lists the phone statuses for CSM
Table Type: REFERENCE





Column Detail - CSM_PHONE_STATS


Column Name Type Null? Definition
CSM_PHONE_STAT_DESC CHAR(40) N description of the phone status
CSM_PHONE_STAT_ID DOUBLE N Unique identifier for the phone status
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_PHONE_STATS




Parent Column in CSM_PHONE_STATS (PK) Child Table Name Child Column Name
Children: CSM_PHONE_STAT_ID CSM_LST_CONTACT CSM_PHONE_STAT_ID