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 |