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