Table Detail Report

CHART_REQUEST_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a sub set of section_ids for a given chart_request
Definition: chart_request_section
Table Type: ACTIVITY





Column Detail - CHART_REQUEST_SECTION


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.
CHART_REQUEST_ID DOUBLE N Foreign key to the CHART_REQUEST table
CHART_SECTION_ID DOUBLE N Foreign key to the CHART_SECTION table
CR_SECT_SEQ DOUBLE Y Sequence of the section_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.



Relationship Detail - CHART_REQUEST_SECTION


Child Column in CHART_REQUEST_SECTION(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID
CHART_SECTION_ID CHART_SECTION CHART_SECTION_ID


CHART_REQ_INERR_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart request In Error events
Definition: This table stores "In Error" events not printed on a chart.
Table Type: ACTIVITY





Column Detail - CHART_REQ_INERR_EVENT


Column Name Type Null? Definition
CHART_REQUEST_ID DOUBLE N The unique identifier for a chart request which has "in error" clinical events when chart request is originally processed successfully.
CHART_REQ_INERR_EVENT_ID DOUBLE N Unique identifier to the chart_request_inerr_event table.
EVENT_ID DOUBLE N Unique identifier for a clinical event, which is in an "in error" status when a request is originally processed.
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 - CHART_REQ_INERR_EVENT


Child Column in CHART_REQ_INERR_EVENT(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID


CHART_ROUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Routing
Definition: This table defines the individual chart routes.
Table Type: REFERENCE





Column Detail - CHART_ROUTE


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.
BANNER_PAGE_IND DOUBLE N Stores if a banner page is requested to print with chart route. 0 = no, 1 = yes.
CHART_ROUTE_ID DOUBLE N Stores the unique identifier for the chart route
ROUTE_NAME VARCHAR(255) N Stores the display name of the chart route
ROUTE_NAME_KEY VARCHAR(255) N Stores the display name of the chart route in all upper case and without spaces or special characters
ROUTE_TYPE_FLAG DOUBLE N Stores the type of the route. 0 = Provider, 1 = Organization, 2 = Location
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 - CHART_ROUTE




Parent Column in CHART_ROUTE (PK) Child Table Name Child Column Name
Children: CHART_ROUTE_ID CHART_REQUEST CHART_ROUTE_ID
CHART_SEQUENCE_GROUP CHART_ROUTE_ID
CR_REPORT_REQUEST ROUTE_ID


CHART_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the chart section
Definition: chart section
Table Type: REFERENCE





Column Detail - CHART_SECTION


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.
CHART_SECTION_DESC VARCHAR(64) Y This is a free text description given to the chart section
CHART_SECTION_ID DOUBLE N This is the number that uniquely identifies a chart section
SECTION_TYPE_FLAG DOUBLE Y This field identifies the type of section (i.e. horizontal, vertical etc.)
SECT_PAGE_BRK_IND DOUBLE N Specifies whether a page break should be appended to the section during processing
UNIQUE_IDENT VARCHAR(60) Y Text form of Unique 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 - CHART_SECTION




Parent Column in CHART_SECTION (PK) Child Table Name Child Column Name
Children: CHART_SECTION_ID CHART_FORMAT_CODES CHART_SECTION_ID
CHART_FORM_SECTS CHART_SECTION_ID
CHART_GROUP CHART_SECTION_ID
CHART_PRINTED_SECTIONS CHART_SECTION_ID
CHART_REQUEST_SECTION CHART_SECTION_ID
CHART_SECT_FLDS CHART_SECTION_ID


CHART_SECT_FLDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This section defines the fields that will be displayed in a chart section
Definition: chart section fields
Table Type: REFERENCE





Column Detail - CHART_SECT_FLDS


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.
BOOKMARK VARCHAR(10) Y This field is not used at this time
CHART_SECTION_ID DOUBLE N This is the number that uniquely identifies a chart section
FIELD_ID DOUBLE N Data Field
FIELD_ROW DOUBLE Y Indicates row in which field is located
FIELD_SEQ DOUBLE N This field is not used at this time
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 - CHART_SECT_FLDS


Child Column in CHART_SECT_FLDS(FK) Parent Table Name Parent Column Name
Parents: CHART_SECTION_ID CHART_SECTION CHART_SECTION_ID