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