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 |