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. |