Table Detail Report
RAD_COMBINE_RPT
Column Section | Top of Page |
Table-level Detail
Description: | This table contains information that pertains to the combine report. |
Definition: | rad combine report |
Table Type: | ACTIVITY |
Column Detail - RAD_COMBINE_RPT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DESC | VARCHAR(20) | Y | This column contains the action that will print on the report. |
CATALOG_CD | DOUBLE | Y | This column contains the identifier for the procedure. If a procedure was moved. |
COMBINE_ID | DOUBLE | N | This column identifies the combine that the report information pertains to. |
COMBINE_IND | DOUBLE | N | This column indicates if the info is for a combine or uncombine. |
COMP_DT_TM | DATETIME | Y | This column contains the completion date and time for the procedure that was moved. |
FOLD_TYPE_CD | DOUBLE | Y | This column contains the identifier for the folder type that was moved. |
FOLD_TYPE_DESC | VARCHAR(2) | Y | This is the description for the folder type that was moved. |
FROM_FILING_NBR | VARCHAR(20) | Y | This column contains the filing number for the folder associated with the from patient. |
FROM_FOLD_ID | DOUBLE | Y | This column contains the identifier for the from folder. |
FROM_LOAN_TYPE_FLAG | DOUBLE | Y | This column is used to identify the origin of the from folders tracking point. |
FROM_PERSON_ID | DOUBLE | Y | This column contains the identifier for the from person. |
FROM_TRK_PT_CD | DOUBLE | Y | this field contains the identifier for the folders current location. |
FROM_VOL | DOUBLE | Y | This column identifies the volume number for the from folder. |
LABEL_IND | DOUBLE | Y | This column indicates if a label was produced for the folder. |
LIB_GRP_CD | DOUBLE | Y | This column identifies the library group that the folder is associated with. |
LIB_GRP_DESC | VARCHAR(40) | Y | This column contains the description of the library group |
SEQUENCE | DOUBLE | N | This identifies the order in which entries will appear on the report. |
TO_FILING_NBR | VARCHAR(20) | Y | This is the filing number for the to folder. |
TO_FOLD_ID | DOUBLE | Y | This is the identifier for the to folder. |
TO_LOAN_TYPE_FLAG | DOUBLE | Y | This indicates the origin of the to folder's tracking point. |
TO_PERSON_ID | DOUBLE | Y | This identifies the to person. |
TO_TRK_PT_CD | DOUBLE | Y | This identifies the to folders current location. |
TO_VOL | DOUBLE | Y | This is the volume number for the to folder. |
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. |
RAD_MEDS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Meds |
Definition: | This table contains those medications that were administered while performing a radiological procedure. |
Table Type: | ACTIVITY |
Column Detail - RAD_MEDS
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. |
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 | N | 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. |
ADMIN_DT_NBR | DOUBLE | Y | A conversion of the admin_dt_tm to an integer. |
ADMIN_DT_TM | DATETIME | Y | The date and time the med was administered. For the MAR, it is considered the time that the administration was completed, since all meds added through RadNet are completed meds. |
ADMIN_MIN_NBR | DOUBLE | Y | Admin minute number. |
ADMIN_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
EVENT_ID | DOUBLE | N | Identifier to the Medication Documentation created for the MAR. |
MODIFIED_DT_TM | DATETIME | N | This column is the date that the data was last changed by a user. |
MODIFIED_PRSNL_ID | DOUBLE | N | This column identifies the personnel that modified the med. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
RAD_MED_ID | DOUBLE | N | This column contains a meaningless number that serves the purpose of uniquely identifying a row. |
SYNONYM_ID | DOUBLE | N | This column is a foreign key to the order_catalog_synonym table. It identifies the medication that was administered. |
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_MEDS
Child Column in RAD_MEDS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
PERSON_ID | PERSON | PERSON_ID | |
MODIFIED_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in RAD_MEDS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RAD_MED_ID | RAD_MED_DETAILS | RAD_MED_ID |
RAD_MED_DETAILS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Med Details |
Definition: | This table contains detail information about medications that were administered as a part of a radiological procedure. |
Table Type: | ACTIVITY |
Column Detail - RAD_MED_DETAILS
Column Name | Type | Null? | Definition |
---|---|---|---|
RAD_MED_DETAIL_ID | DOUBLE | N | This column contains a meaningless number that serves as a unique identifier for the row. |
RAD_MED_FIELD_ID | DOUBLE | N | This column is a foreign key to the rad_med_fields table. It identifies the field that is being documented. |
RAD_MED_ID | DOUBLE | N | This column is a foreign key to the rad_meds table. It identifies the recorded medication that the details belong to. |
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. |
VALUE_DT_TM | DATETIME | Y | Value date/time |
VALUE_NBR | DOUBLE | Y | Value number |
VALUE_TXT | VARCHAR(255) | Y | The value assigned to this level. The lower value within a range of values. |
Relationship Detail - RAD_MED_DETAILS
Child Column in RAD_MED_DETAILS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RAD_MED_ID | RAD_MEDS | RAD_MED_ID |
RAD_MED_FIELD_ID | RAD_MED_FIELDS | RAD_MED_FIELD_ID |
Parent Column in RAD_MED_DETAILS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RAD_MED_DETAIL_ID | RAD_MED_DETAILS_HIST | RAD_MED_DETAIL_ID |
RAD_MED_DETAILS_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Radiology medication detail history |
Definition: | This table contains a history of changes that have been made to the rad_meds and rad_med_details tables |
Table Type: | ACTIVITY |
Column Detail - RAD_MED_DETAILS_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIN_DT_TM | DATETIME | Y | This column will contain the administration Date/time of the med |
MODIFIED_DT_TM | DATETIME | N | This column is the date that the data was modified on. |
MODIFIED_PRSNL_ID | DOUBLE | N | This is the personnel that modified the data |
RAD_MED_DETAILS_HIST_ID | DOUBLE | N | This column contains a meaningless number that serves the purpose of uniquely identifying a row |
RAD_MED_DETAIL_ID | DOUBLE | N | This column is a foreign key to the rad_med_details table. |
RAD_MED_FIELD_ID | DOUBLE | N | This column is a foreign key to the rad_med_fields table |
RAD_MED_ID | DOUBLE | N | This column is a foreign key to the rad_meds 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. |
VALUE_DT_TM | DATETIME | Y | This column will contain a date/time for those fields that are of type date/time. |
VALUE_NBR | DOUBLE | Y | This column will contain a numeric value for those fields that are of type numeric. |
VALUE_TXT | VARCHAR(255) | Y | This column will contain a string of text for those fields that are of type text. |
Relationship Detail - RAD_MED_DETAILS_HIST
Child Column in RAD_MED_DETAILS_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MODIFIED_PRSNL_ID | PRSNL | PERSON_ID |
RAD_MED_DETAIL_ID | RAD_MED_DETAILS | RAD_MED_DETAIL_ID |
RAD_PACKET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Radiology Patient Packet table. |
Definition: | This table serves as a placeholder for patient packets that need to print. The Rad_Packet table is a child of Order Radiology. |
Table Type: | ACTIVITY |
Column Detail - RAD_PACKET
Column Name | Type | Null? | Definition |
---|---|---|---|
ORDER_ID | DOUBLE | N | The Order_Id column is a foreign key to the Order_Radiology table. It identifies the order that the patient packet is related to. |
PACKET_ID | DOUBLE | N | The Packet_Id is a meaningless identifier for the packet entry. It along with the Order_Id uniquely identifies a rad_packet row. |
PRINT_DT_TM | DATETIME | Y | The print_dt_tm contains the date and time that the patient packet printed. |
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_PACKET
Child Column in RAD_PACKET(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDER_RADIOLOGY | ORDER_ID |