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 |