Table Detail Report
CR_REPORT_REQUEST_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CR REPORT REQUEST ACTIVITY |
Definition: | this table serves as checkpoints for the various statuses of a ; CR_REPORT_REQUEST row. We would only INSERT and SELECT from this table |
Table Type: | ACTIVITY |
Column Detail - CR_REPORT_REQUEST_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_TS | DATETIME(6) | Y | ACTION TIMETAMP For when thee status action occurred |
REPORT_REQUEST_ACTIVITY_ID | DOUBLE | N | PRIMARY KEY |
REPORT_REQUEST_ID | DOUBLE | Y | Foreign key value from the CR_REPORT_REQUEST row |
REPORT_STATUS_CD | DOUBLE | Y | Current status as of this activity time (code set 367571) |
Relationship Detail - CR_REPORT_REQUEST_ACTIVITY
Child Column in CR_REPORT_REQUEST_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID |
CR_REPORT_REQUEST_ARCHIVE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Report request archive |
Definition: | The report request archive table is used to store the long blob ids referenced to the long_blob table that contain the XML representation of the archived requests |
Table Type: | ACTIVITY |
Column Detail - CR_REPORT_REQUEST_ARCHIVE
Column Name | Type | Null? | Definition |
---|---|---|---|
ARCHIVED_DT_TM | DATETIME | Y | The date and time of the last archive |
ARCHIVED_REPORT_NBR | DOUBLE | N | The total number of reports archived for all xml files stored in the zip file. |
LOGICAL_DOMAIN_ID | DOUBLE | N | Logical domain for purge file |
LONG_BLOB_ID | DOUBLE | N | The id of the long blob that contains the zip file of the archived requests |
MAX_REQUEST_DT_TM | DATETIME | N | Maximum requested date/time included in zip entry |
MIN_REQUEST_DT_TM | DATETIME | N | Minimum requested date/time included in zip entry |
REPORT_REQUEST_ARCHIVE_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 - CR_REPORT_REQUEST_ARCHIVE
Child Column in CR_REPORT_REQUEST_ARCHIVE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID |
CR_REPORT_REQUEST_ENCNTR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CR Report Request / Encounter cross reference |
Definition: | Contains the set of Encounters for a cross-encounter report |
Table Type: | ACTIVITY |
Column Detail - CR_REPORT_REQUEST_ENCNTR
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table row. It is an internal system assigned number. |
ENCNTR_SEQ | DOUBLE | N | Selected encounter sequence |
REPORT_REQUEST_ENCNTR_ID | DOUBLE | N | This is the primary key identifier for this table. |
REPORT_REQUEST_ID | DOUBLE | N | This is the value of the unique primary key of the CR_REPORT_REQUEST table. It is an internal system assigned number. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - CR_REPORT_REQUEST_ENCNTR
Child Column in CR_REPORT_REQUEST_ENCNTR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
CR_REPORT_REQUEST_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Report Request Event |
Definition: | Stores the identifiers of the specific events that should be included on the report. |
Table Type: | ACTIVITY |
Column Detail - CR_REPORT_REQUEST_EVENT
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_ID | DOUBLE | N | This is the identifier of the clinical event. It is an internal system assigned number. |
REPORT_REQUEST_EVENT_ID | DOUBLE | N | This is the primary key identifier for this table. |
REPORT_REQUEST_ID | DOUBLE | N | This is the value of the unique primary key of the cr_report_request 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 - CR_REPORT_REQUEST_EVENT
Child Column in CR_REPORT_REQUEST_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID |
CR_REPORT_REQUEST_SECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Report Request Section |
Definition: | Stores the identifier of the specific report sections that should be included on the report. |
Table Type: | ACTIVITY |
Column Detail - CR_REPORT_REQUEST_SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
REPORT_REQUEST_ID | DOUBLE | N | This is the value of the unique primary key of the cr_report_request table. It is an internal system assigned number. |
REPORT_REQUEST_SECTION_ID | DOUBLE | N | This is the primary key identifier for this table. |
SECTION_ID | DOUBLE | N | This is the identifier of the report section. 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 - CR_REPORT_REQUEST_SECTION
Child Column in CR_REPORT_REQUEST_SECTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID |
SECTION_ID | CR_REPORT_SECTION | REPORT_SECTION_ID |