Table Detail Report

CSM_REQUESTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM REQUESTS
Definition: This table is the actual ordered requests.
Table Type: ACTIVITY





Column Detail - CSM_REQUESTS


Column Name Type Null? Definition
CSM_CAT_ID DOUBLE N Unique identifier for the category
CSM_COMPL_DT_TM DATETIME Y The completion date/time of the request.
CSM_CURRENT_USER CHAR(50) Y Shows the current user when the request is being edited in the CSM Request Viewer
CSM_DUE_DT_TM DATETIME Y The due date/time of the request.
CSM_ORD_DT_TM DATETIME Y Date and time that the service request was ordered.
CSM_PRIOR_ID DOUBLE N Unique priority id
CSM_REQ_COM_ID DOUBLE N long text id for the request comments
CSM_REQ_ID DOUBLE N The unique id for the request.
CSM_RSLT_COM_ID DOUBLE N long text id for the result comments
CSM_SUB_CAT_ID DOUBLE N Unique Sub-Category ID
LOCATION_CD DOUBLE N location code for the ordering location
ORGANIZATION_ID DOUBLE N Organization id for the ordering organization
PHONE_ID DOUBLE N Unique identifier for the phone number
PROBLEM_REQ_COMMENT_ID DOUBLE N Contains the problem requisition comment identifier to relate this request to the appropriate long text string.
SELECTED_PHONE_ID DOUBLE N Phone ID for the currently selected phone number
STATUS_CD DOUBLE N code value for the service request 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_REQUESTS


Child Column in CSM_REQUESTS(FK) Parent Table Name Parent Column Name
Parents: CSM_CAT_ID CSM_CATEGORIES CSM_CAT_ID
CSM_PRIOR_ID CSM_PRIORITIES CSM_PRIOR_ID
CSM_SUB_CAT_ID CSM_SUB_CATEGORIES CSM_SUB_CAT_ID
CSM_REQ_COM_ID LONG_TEXT LONG_TEXT_ID
CSM_RSLT_COM_ID LONG_TEXT LONG_TEXT_ID
PROBLEM_REQ_COMMENT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PHONE_ID PHONE PHONE_ID
SELECTED_PHONE_ID PHONE PHONE_ID




Parent Column in CSM_REQUESTS (PK) Child Table Name Child Column Name
Children: CSM_REQ_ID CSM_LST_CONTACT CSM_REQ_ID


CSM_REQUESTS_ARCHIVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM REQUESTS ARCHIVE
Definition: This table will hold the requests purged from the CSM_REQUESTS table.
Table Type: ACTIVITY





Column Detail - CSM_REQUESTS_ARCHIVE


Column Name Type Null? Definition
COMPL_PRSNL_ID DOUBLE N Person who updated the request last from the UPDT_ID on the CSM_REQUESTS table.
CONTACT VARCHAR(100) Y Name of last person contacted at time of Purge for that requests. Comes form CSM_LST_CONTACT table.
CSM_AD_HOC_EXT CHAR(100) Y Ad Hoc phon number extension from CSM_AD_HOCS table.
CSM_AD_HOC_PHONE CHAR(100) Y Ad Hoc phone number from CSM_AD_HOCS table.
CSM_CAT_ID DOUBLE N Request Category Identifier from CSM_REQUESTS table.
CSM_COMPL_DT_TM DATETIME Y Date and Time the Request was completed from CSM_REQUESTS table.
CSM_DUE_DT_TM DATETIME Y The original due date of the request from the CSM_REQUESTS table.
CSM_ORD_DT_TM DATETIME Y The original order date and time of the request from the CSM_REQUESTS table.
CSM_PHONE_STAT_DESC CHAR(40) Y The phone description of the call back number at the time of the purge for the request from the CSM_REQUESTS table.
CSM_PRIOR_ID DOUBLE N CSM Request Piority Identifier from the CSM_REQUESTS table.
CSM_REQ_ID DOUBLE N The unique request identifier from the CSM_REQUESTS table.
CSM_SUB_CAT_ID DOUBLE N Request Sub-Category identifier for the request from the CSM_REQUESTS table.
LOCATION_CD DOUBLE N Location for the Request from the CSM_REQUEST table.
ORGANIZATION_ID DOUBLE N Organization for the Request from the CSM_REQUESTS table.
PARENT_ENTITY_ID DOUBLE N Unique Identifier on table listed in PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME CHAR(32) Y Location of name of Parent Table of Parent_Entity_Id
PHONE_ID DOUBLE N Unique identifier for the phone number
PURGED_DT_TM DATETIME Y Date and time the request was purged.
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_REQUESTS_ARCHIVE


Child Column in CSM_REQUESTS_ARCHIVE(FK) Parent Table Name Parent Column Name
Parents: CSM_CAT_ID CSM_CATEGORIES CSM_CAT_ID
CSM_PRIOR_ID CSM_PRIORITIES CSM_PRIOR_ID
CSM_SUB_CAT_ID CSM_SUB_CATEGORIES CSM_SUB_CAT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PHONE_ID PHONE PHONE_ID


CSM_REQ_REF_CD_XREF



Column Section Top of Page


Table-level Detail

Description: CSM REQ REF CD XREF
Definition: table to list associated clinical id's for requests
Table Type: ACTIVITY





Column Detail - CSM_REQ_REF_CD_XREF


Column Name Type Null? Definition
CSM_REQ_ID DOUBLE N Request Id from CSM_REQUESTS Table.
PARENT_ENTITY_ID DOUBLE N Unique Identifier of row on Parent_Entity_Name table.
PARENT_ENTITY_NAME CHAR(32) N Location of name of Parent Table of Parent_Entity_Id.
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_SUB_CATEGORIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSM SUB CATEGORIES
Definition: A sub-category id assigned to the sub-category.
Table Type: REFERENCE





Column Detail - CSM_SUB_CATEGORIES


Column Name Type Null? Definition
CSM_SUB_CAT_DESC VARCHAR(40) Y The description is assigned to the sub-category.
CSM_SUB_CAT_ID DOUBLE N The unique id assigned to the sub-category.
REQ_TEMPL_ID DOUBLE N The unique id of the template assigned to the request sub-category.
RESL_TEMPL_ID DOUBLE N The unique id of the template assigned to the result of the 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_SUB_CATEGORIES




Parent Column in CSM_SUB_CATEGORIES (PK) Child Table Name Child Column Name
Children: CSM_SUB_CAT_ID CSM_CAT_SUB_XREF CSM_SUB_CAT_ID
CSM_REQUESTS CSM_SUB_CAT_ID
CSM_REQUESTS_ARCHIVE CSM_SUB_CAT_ID


CSM_SYS_PARAMS



Column Section Top of Page


Table-level Detail

Description: CSM SYS PARAMS
Definition: Global default parameters needed for the Client Services product.
Table Type: REFERENCE





Column Detail - CSM_SYS_PARAMS


Column Name Type Null? Definition
CHG_DUE_DATE_IND DOUBLE Y Allows the administrator to decide whether or not to allow CSM due dates to be reset by the users.
CSM_CHARTABLE_IND DOUBLE Y Indicates whether or not callback info is to be charted.
CSM_DEF_PRIOR_IND DOUBLE N Indicates whether or not the CSM system should default a priority when service requests are ordered.
CSM_PARAMS VARCHAR(10) N Blank key.
CSM_PURGE_DAYS_DEF DOUBLE N Default number of purge days taht will be used if the request does not have a number of purge days.
CSM_TEMPL_IND DOUBLE Y A global indicator for the use of templates.
DEF_RSLT_COM_IND DOUBLE Y Reserved for future use.
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.