Table Detail Report
RAD_RPT_LOCK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Report Lock |
Definition: | The Rad_Rpt_Lock table is an extension of the order_radiology table. It shows which orders have been locked in order to modify the associated report. |
Table Type: | ACTIVITY |
Column Detail - RAD_RPT_LOCK
Column Name | Type | Null? | Definition |
---|---|---|---|
LOCK_TYPE_FLAG | DOUBLE | N | Indicates the type of lock being held. A 1 indicates a Radiologist Hold on a report to be completed later. A 0 indicates a Regular lock of report that could occur by application access of the report. |
ORDER_ID | DOUBLE | N | This is a foreign key to the order_radiology table. This table may not contain all of the order_id's on the order_radiology table. |
PS_RPT_LOCK_IND | DOUBLE | N | Indicates that the report is currently being dictated by PowerScribe. |
RPT_LOCK_DT_TM | DATETIME | Y | This is the date and time that the report lock was created. |
RPT_LOCK_ID | DOUBLE | N | The rpt_lock_id is the person id of the personnel that has the report locked. |
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 - RAD_RPT_LOCK
Child Column in RAD_RPT_LOCK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDER_RADIOLOGY | ORDER_ID |
RPT_LOCK_ID | PRSNL | PERSON_ID |
RAD_RPT_PRSNL_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains a cumulative list of prsnl that have taken action on the rep |
Definition: | Radiology Report Personnel History |
Table Type: | ACTIVITY |
Column Detail - RAD_RPT_PRSNL_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_CD | DOUBLE | N | This column represents the action that the personnel took on a given radiology report. |
ACTION_DT_TM | DATETIME | N | This column contains the date and time that the prsnl took an action on a given radiology report. |
ACTION_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
PROXIED_FOR_ID | DOUBLE | N | This column is only valued if the action was Proxy. It indicates who was proxied for. |
RAD_REPORT_ID | DOUBLE | N | This column contains a foreign key to the Rad_Report table. It uniquely identifies the report that the personnel are associated with. |
REPORT_PRSNL_ID | DOUBLE | N | This column contains a foreign key to the Prsnl table. It uniquely identifies the personnel that is associated with a given radiology report. |
RPT_PRSNL_HIST_ID | DOUBLE | N | This column contains a meaningless number that only serves to uniquely identify a row on the rad_rpt_prsnl_hist 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 - RAD_RPT_PRSNL_HIST
Child Column in RAD_RPT_PRSNL_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROXIED_FOR_ID | PRSNL | PERSON_ID |
REPORT_PRSNL_ID | PRSNL | PERSON_ID | |
RAD_REPORT_ID | RAD_REPORT | RAD_REPORT_ID |
RAD_STG_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Radiology Staging Data |
Definition: | To temporarily hold untrusted data that has come from an external source (e.g. FHIR). |
Table Type: | ACTIVITY |
Column Detail - RAD_STG_DATA
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. |
AUTHORIZING_ORG_ID | DOUBLE | Y | Organisation id of the authorizing Organisation. |
CLIENT_IDENT | VARCHAR(80) | Y | Represents the client who wrote the data to the system. |
CORRELATION_IDENT | VARCHAR(80) | Y | Uppercase, hyphenated GUID that identifies the transaction that updated this row. |
EFFECTIVE_DT_TM | DATETIME | Y | The clinicaly significant date time of this document. |
ENCNTR_ID | DOUBLE | Y | The encounter related to the external data. |
EVENT_CD | DOUBLE | Y | Code value that represents the event code associated for the diagnostic report. |
EVENT_CD_STD_CD_ID | DOUBLE | Y | Unique identifier for the event code standard code. |
EVENT_ID | DOUBLE | Y | The id of the clinical event associated to this radiology result. |
ISSUED_DT_TM | DATETIME | Y | The date and time this external document was reviewed or verified. |
JSON_VRSN_TXT | VARCHAR(20) | Y | Stores the version of Json that is used in the CLOB column. |
LOGICAL_DOMAIN_ID | DOUBLE | Y | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
PARENT_RAD_STG_DATA_ID | DOUBLE | Y | This unique identifier is used to indicate the parent external data that groups this external data row is related to. |
PERSON_ID | DOUBLE | Y | The person related to the external data; |
RAD_EXT_CLOB | LONGTEXT | Y | External JSON content |
RAD_STG_DATA_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RAD_STG_DATA table. |
REPORT_STATUS_CD | DOUBLE | Y | Code value that represents the status of the diagnostic report. |
REPORT_STATUS_STD_CD_ID | DOUBLE | Y | Unique identifier for the report status standard code. |
STG_STATUS_CD | DOUBLE | Y | Code value that represents the status of the imported document. |
TRANSMITTING_ORG_ID | DOUBLE | Y | Organisation id of the transmitting Organization. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - RAD_STG_DATA
Child Column in RAD_STG_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
AUTHORIZING_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
TRANSMITTING_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PARENT_RAD_STG_DATA_ID | RAD_STG_DATA | RAD_STG_DATA_ID | |
EVENT_CD_STD_CD_ID | RAD_STG_STANDARD_CODE | RAD_STG_STANDARD_CODE_ID | |
REPORT_STATUS_STD_CD_ID | RAD_STG_STANDARD_CODE | RAD_STG_STANDARD_CODE_ID |
Parent Column in RAD_STG_DATA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RAD_STG_DATA_ID | RAD_STG_DATA | PARENT_RAD_STG_DATA_ID |
RAD_STG_EXT_IDENTIFIER | RAD_STG_DATA_ID |
RAD_STG_EXT_IDENTIFIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Radiology Staging External Identifier |
Definition: | This table holds the external identifiers for the document sent from external sources. |
Table Type: | ACTIVITY |
Column Detail - RAD_STG_EXT_IDENTIFIER
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. |
EVENT_ID | DOUBLE | Y | The clinical event identifier of the document when it is added to patient chart. |
ORG_ID | DOUBLE | Y | Identifier of the organization that issued/managed the external identifier. |
RAD_STG_DATA_ID | DOUBLE | Y | The unique id of the external document this external identifier is linked to. |
RAD_STG_EXT_IDENTIFIER_ID | DOUBLE | N | Unique generated number that identifies a single row on the RAD_STG_EXT_IDENTIFIER table. |
SYSTEM_URI | VARCHAR(100) | Y | Namespace for the identifier value. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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. |
VALUE_TXT | VARCHAR(100) | Y | External identifier used for the Diagnostic report. |
Relationship Detail - RAD_STG_EXT_IDENTIFIER
Child Column in RAD_STG_EXT_IDENTIFIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORG_ID | ORGANIZATION | ORGANIZATION_ID |
RAD_STG_DATA_ID | RAD_STG_DATA | RAD_STG_DATA_ID |
RAD_STG_STANDARD_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RadNet Staging Standard Code |
Definition: | Contains codified values from an external source like FHIR and association to the RadNet staged data. |
Table Type: | ACTIVITY |
Column Detail - RAD_STG_STANDARD_CODE
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. |
CODE_SYSTEM_TXT | VARCHAR(100) | Y | The standard code system that defines the meaning of the symbol in the code. |
CODE_TXT | VARCHAR(80) | Y | The standard code value which is a symbol in syntax defined by the system. |
DISPLAY_TXT | VARCHAR(255) | Y | The display text of the standard code that represents the meaning of the code. |
RAD_STG_STANDARD_CODE_ID | DOUBLE | N | Unique generated number that identifies a single row on the RAD_STG_STANDARD_CODE table. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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. |
VERSION_TXT | VARCHAR(10) | Y | The version of the standard code system. |
Relationship Detail - RAD_STG_STANDARD_CODE
Parent Column in RAD_STG_STANDARD_CODE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RAD_STG_STANDARD_CODE_ID | RAD_STG_DATA | EVENT_CD_STD_CD_ID |
RAD_STG_DATA | REPORT_STATUS_STD_CD_ID |