Table Detail Report

CUSTOM_PT_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains custom patient lists.
Definition: This table contains custom patient lists. The contents of the list are stored on the CUSTOM_PT_LIST_ENTRY table.
Table Type: ACTIVITY





Column Detail - CUSTOM_PT_LIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CUSTOM_PT_LIST_ID DOUBLE N This is the unique identifier of a row on this table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LIST_NAME VARCHAR(100) Y This column contains the name of the custom patient list that this row represents.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - CUSTOM_PT_LIST


Child Column in CUSTOM_PT_LIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID




Parent Column in CUSTOM_PT_LIST (PK) Child Table Name Child Column Name
Children: CUSTOM_PT_LIST_ID CUSTOM_PT_LIST_ENTRY CUSTOM_PT_LIST_ID


CUSTOM_PT_LIST_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the entries of custom patient lists.
Definition: This table contains the entries of custom patient lists. The list itself is stored on the CUSTOM_PT_LIST table.
Table Type: ACTIVITY





Column Detail - CUSTOM_PT_LIST_ENTRY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
COMMENT_TEXT VARCHAR(200) Y This field can contain a free text comment pertaining to this patient on this list.
CUSTOM_PT_LIST_ID DOUBLE N This is the identifier of the patient list that this row is an entry for.
CUST_PTL_ENTRY_ID DOUBLE N This is the unique identifier of this row on this table.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - CUSTOM_PT_LIST_ENTRY


Child Column in CUSTOM_PT_LIST_ENTRY(FK) Parent Table Name Parent Column Name
Parents: CUSTOM_PT_LIST_ID CUSTOM_PT_LIST CUSTOM_PT_LIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


DCP_CHART_SUMMARY_LAYOUT



Column Section Top of Page


Table-level Detail

Description: DCP CHART SUMMARY LAYOUT
Definition: Defines the reports used and their position within a chart summary view.
Table Type: REFERENCE





Column Detail - DCP_CHART_SUMMARY_LAYOUT


Column Name Type Null? Definition
COL_NBR DOUBLE N Specifies the starting column position (0 based) for the identified report within the identified chart summary view.
DCP_CHART_SUMMARY_LAYOUT_ID DOUBLE N DCP Chart Summary Layout ID - Primary Key
HEIGHT_NBR DOUBLE N Specifies the height for the identified report within the identified chart summary view.
LAYOUT_CD DOUBLE N The identifier and display name of the chart summary view.
REPORT_CD DOUBLE N The identifier of the report to be included within the chart summary view at the identified position.
ROW_NBR DOUBLE N Specifies the starting row position (0 based) for the identified report within the identified chart summary view.
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.
WIDTH_NBR DOUBLE N Specifies the width for the identified report within the identified chart summary view.


DCP_CONFIG_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Component
Definition: Contains information about the domains,sub-domains,components ,sub-components and this information is used to build a tree structure
Table Type: REFERENCE





Column Detail - DCP_CONFIG_COMP


Column Name Type Null? Definition
COMP_DESC VARCHAR(256) Y description for domain/sub - domain/component
COMP_DISPLAY VARCHAR(100) N Name of domain/sub-domain/component that is displayed to the user
COMP_IND DOUBLE N Indicates whether ccnfig_setting has a standard value or not (1 - for component 0- for others)
COMP_NAME VARCHAR(32) N Unique Name for the domain,sub-domain or component
DCP_CONFIG_COMP_ID DOUBLE N PRIMARY KEY
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 - DCP_CONFIG_COMP




Parent Column in DCP_CONFIG_COMP (PK) Child Table Name Child Column Name
Children: DCP_CONFIG_COMP_ID DCP_CONFIG_COMP_RELTN DCP_CONFIG_COMP_ID
DCP_CONFIG_COMP_TREE DCP_CONFIG_COMP_ID
DCP_CONFIG_COMP_TREE PARENT_COMP_ID


DCP_CONFIG_COMP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Component configuration setting relation
Definition: This table contains data to form a relation using Config_component table's config_components_id column with configuration_setting table's configuration_setting_id column
Table Type: REFERENCE





Column Detail - DCP_CONFIG_COMP_RELTN


Column Name Type Null? Definition
DCP_CONFIG_COMP_ID DOUBLE N identifier for a Component in config_components table
DCP_CONFIG_COMP_RELTN_ID DOUBLE N PRIMARY KEY
DCP_CONFIG_SETTING_ID DOUBLE N identifier for a Component in configuration_setting table
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 - DCP_CONFIG_COMP_RELTN


Child Column in DCP_CONFIG_COMP_RELTN(FK) Parent Table Name Parent Column Name
Parents: DCP_CONFIG_COMP_ID DCP_CONFIG_COMP DCP_CONFIG_COMP_ID
DCP_CONFIG_SETTING_ID DCP_CONFIG_SETTING DCP_CONFIG_SETTING_ID