Table Detail Report

DM_DCM_WP_STATUS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Change Management Work Plan Status History
Definition: A table to track status changes to work plan items for the change management solution
Table Type: ACTIVITY





Column Detail - DM_DCM_WP_STATUS_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DM_DCM_WORK_PLAN_ID DOUBLE N Points to the DM_DCM_WORK_PLAN table
DM_DCM_WP_STATUS_HIST_ID DOUBLE N PRIMARY KEY
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
STATUS_CD DOUBLE N Holds the status of the work plan
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 - DM_DCM_WP_STATUS_HIST


Child Column in DM_DCM_WP_STATUS_HIST(FK) Parent Table Name Parent Column Name
Parents: DM_DCM_WORK_PLAN_ID DM_DCM_WORK_PLAN DM_DCM_WORK_PLAN_ID


DM_DS_SERVER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_DS_SERVER
Definition: Store information about Database Service Servers
Table Type: REFERENCE





Column Detail - DM_DS_SERVER


Column Name Type Null? Definition
DM_DS_SERVER_ID DOUBLE N Server Identifier
SERVER_NAME VARCHAR(50) N Server Name
SERVER_NBR DOUBLE N Server Number
SERVER_TYPE_FLAG DOUBLE N Server Type. 1 = Cerner, 2 = Client
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 - DM_DS_SERVER




Parent Column in DM_DS_SERVER (PK) Child Table Name Child Column Name
Children: DM_DS_SERVER_ID DM_DS_SERVER_RELTN DM_DS_SERVER_ID


DM_DS_SERVER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_DS_SERVER_RELTN
Definition: This is a Relationship table for the DM_DS_SERVER, DM_DS_SERVICE, and DM_DS_TEMPLATE tables.
Table Type: REFERENCE





Column Detail - DM_DS_SERVER_RELTN


Column Name Type Null? Definition
DM_DS_SERVER_ID DOUBLE N SERVER IDENTIFIER
DM_DS_SERVER_RELTN_ID DOUBLE N PRIMARY KEY
DM_DS_SERVICE_ID DOUBLE N SERVICE IDENTIFIER
DM_DS_TEMPLATE_ID DOUBLE N TEMPLATE IDENTIFIER
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 - DM_DS_SERVER_RELTN


Child Column in DM_DS_SERVER_RELTN(FK) Parent Table Name Parent Column Name
Parents: DM_DS_SERVER_ID DM_DS_SERVER DM_DS_SERVER_ID
DM_DS_SERVICE_ID DM_DS_SERVICE DM_DS_SERVICE_ID
DM_DS_TEMPLATE_ID DM_DS_TEMPLATE DM_DS_TEMPLATE_ID


DM_DS_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_DS_SERVICE
Definition: Store information about Database Services as related to servers.
Table Type: REFERENCE





Column Detail - DM_DS_SERVICE


Column Name Type Null? Definition
DM_DS_SERVICE_ID DOUBLE N Service Identifier
SERVICE_NAME VARCHAR(50) N Service Name
SERVICE_TYPE_FLAG DOUBLE N Service Type. 1 = Cerner, 2 = Client
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 - DM_DS_SERVICE




Parent Column in DM_DS_SERVICE (PK) Child Table Name Child Column Name
Children: DM_DS_SERVICE_ID DM_DS_SERVER_RELTN DM_DS_SERVICE_ID


DM_DS_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_DS_TEMPLATE
Definition: Store information about Database Service Templates
Table Type: REFERENCE





Column Detail - DM_DS_TEMPLATE


Column Name Type Null? Definition
DM_DS_TEMPLATE_ID DOUBLE N The Template Identifier
TEMPLATE_DESCRIPTION VARCHAR(80) N Template Description
TEMPLATE_NAME VARCHAR(30) N Template Name
TEMPLATE_TYPE_FLAG DOUBLE N Template Type. 1 = Cerner, 2 = Client
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 - DM_DS_TEMPLATE




Parent Column in DM_DS_TEMPLATE (PK) Child Table Name Child Column Name
Children: DM_DS_TEMPLATE_ID DM_DS_SERVER_RELTN DM_DS_TEMPLATE_ID