Table Detail Report

RAD_PACKET_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Packet Component
Definition: This table identifies those patient packet components that have printed for a given order.
Table Type: ACTIVITY





Column Detail - RAD_PACKET_COMPONENT


Column Name Type Null? Definition
ORDER_ID DOUBLE N The ORDER_ID is a foreign key to the Order_Radiology table.
PRINT_DT_TM DATETIME Y The PRINT_DT_TM contains the date and time the packet was 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.
USAGE_TYPE_CD DOUBLE N Identifies the packet component that was printed.



Relationship Detail - RAD_PACKET_COMPONENT


Child Column in RAD_PACKET_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


RAD_PROC_FIELD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Procedure Field Relation
Definition: This table stores the exposure fields related to a specific procedure
Table Type: REFERENCE





Column Detail - RAD_PROC_FIELD_RELTN


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This column contains the unique identifier for a given procedure.
EXPOSURE_FIELD_CD DOUBLE N This column contains the unique identifier for an exposure field.
SEQUENCE DOUBLE Y This column contains the order that the fields should appear for a given procedure.
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_PROC_FIELD_RELTN


Child Column in RAD_PROC_FIELD_RELTN(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


RAD_TECH_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Technical Comment Fields
Definition: The Rad_Tech_Field table holds individual radiology technical comments fields
Table Type: REFERENCE





Column Detail - RAD_TECH_FIELD


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 Y 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.
FIELD_DESC VARCHAR(60) N The field description names a radiology technical comment field.
FIELD_ID DOUBLE N The Field_Id uniquely identifies a row in the Rad_Tech_Field table. It serves no other purpose other than to uniquely identify the row .
FIELD_TYPE_FLAG DOUBLE N The field type flags defines the type of a field. 0 = Header, 1 = Number, 2 = Text, 3 = Date, 4 = Single Choice, 5 = Multi Choice
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_TECH_FIELD




Parent Column in RAD_TECH_FIELD (PK) Child Table Name Child Column Name
Children: FIELD_ID RAD_OMF_TC_INDICATOR FIELD_ID
RAD_OMF_TC_IND_R PARENT_FIELD_ID
RAD_TECH_CMT_DATA FIELD_ID
RAD_TECH_CMT_DATA PARENT_FIELD_ID
RAD_TECH_CMT_DATA_HIST FIELD_ID
RAD_TECH_CMT_DATA_HIST PARENT_FIELD_ID
RAD_TECH_FLD_FMT_R FIELD_ID
RAD_TECH_FLD_FMT_R PARENT_FIELD_ID


RAD_TECH_FLD_FMT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Tech comment field format relations.
Definition: The rad_tech_fld_fmt_r table holds a relation between a technical comment format and a list fields for that format.
Table Type: REFERENCE





Column Detail - RAD_TECH_FLD_FMT_R


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 Y 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.
CHARTABLE_IND DOUBLE N The Chartable_ind defines if this field is to be charted for this format.
DEFAULT_CHOICE_IND DOUBLE Y The Chartable_ind defines if this field is to be charted for this format.
DEFAULT_DT_TM DATETIME Y The Default_Date field holds date default data.
DEFAULT_NBR DOUBLE Y The Default_Nbr field holds numeric default data.
DEFAULT_TEXT VARCHAR(255) Y The Default_Text field holds textual default data.
FIELD_FORMAT_RELTN_ID DOUBLE N The field_format_reltn_Id uniquely identifies a row in the Rad_Tech_Fld_Fmt_r table. It serves no other purpose other than to uniquely identify the row
FIELD_ID DOUBLE N Uniquely identifies a field. FK from the Rad_tech_field table.
FORMAT_ID DOUBLE N Uniquely identifies a format. FK from the rad_tech_format table.
MAX_NBR DOUBLE Y The max_nbr field holds a maximum numerical value. It can only be set for a field that is a number type.
MIN_NBR DOUBLE Y The min_nbr field holds a minimum numerical value. It can only be set for a field that is a number type.
PARENT_FIELD_ID DOUBLE N The Parent_Field_Id is a foreign key to the Rad_Tech_Field table. It is used to identify a parent field for the row.
REQUIRED_IND DOUBLE N The Required_ind defines if this field is required to be filled out before exam completion
SEQUENCE DOUBLE N The Sequence identifies an order of fields within a specific format.
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_TECH_FLD_FMT_R


Child Column in RAD_TECH_FLD_FMT_R(FK) Parent Table Name Parent Column Name
Parents: FIELD_ID RAD_TECH_FIELD FIELD_ID
PARENT_FIELD_ID RAD_TECH_FIELD FIELD_ID
FORMAT_ID RAD_TECH_FORMAT FORMAT_ID




Parent Column in RAD_TECH_FLD_FMT_R (PK) Child Table Name Child Column Name
Children: FIELD_FORMAT_RELTN_ID RAD_TECH_FMT_ERPRC_OVRD FIELD_FORMAT_RELTN_ID


RAD_TECH_FMT_ERPRC_OVRD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology tech comment format attributes override
Definition: The Rad_Tech_Fmt_ErProc_Ovrd table holds attributes about fields in a format ,for a given service resource and procedure, that are different than those specified just the format level.
Table Type: REFERENCE





Column Detail - RAD_TECH_FMT_ERPRC_OVRD


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 Y 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.
CHARTABLE_IND DOUBLE N The Chartable_ind defines if this field is to be charted for this format.
DEFAULT_CHOICE_IND DOUBLE Y The Chartable_ind defines if this field is to be charted for this format.
DEFAULT_DT_TM DATETIME Y The Default_Date field holds date default data.
DEFAULT_NBR DOUBLE Y The Default_Nbr field holds numeric default data.
DEFAULT_TEXT VARCHAR(255) Y The Default_Text field holds textual default data.
FIELD_FORMAT_RELTN_ID DOUBLE N Field Format Relation identifier.
FORMAT_ERPRC_RELTN_ID DOUBLE N The Format_Erproc_reltn_Id is a foreign key to the Rad_Tech_Fmt_ErProc_r table. It is used to define a format that has had field attribute changes for a given procedure and an exam room.
FORMAT_OVRD_ID DOUBLE N The format_Ovrd_Id uniquely identifies a row in the Rad_Tech_Fmt_ErProc_Ovrd table. It serves no other purpose other than to uniquely identify the row
MAX_NBR DOUBLE Y The max_nbr field holds a maximum numerical value. It can only be set for a field that is a number type.
MIN_NBR DOUBLE Y The min_nbr field holds a maximum numerical value. It can only be set for a field that is a number type..
REQUIRED_IND DOUBLE N The Required_ind defines if this field is required to be filled out before exam completion
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_TECH_FMT_ERPRC_OVRD


Child Column in RAD_TECH_FMT_ERPRC_OVRD(FK) Parent Table Name Parent Column Name
Parents: FIELD_FORMAT_RELTN_ID RAD_TECH_FLD_FMT_R FIELD_FORMAT_RELTN_ID
FORMAT_ERPRC_RELTN_ID RAD_TECH_FMT_ERPRC_R FORMAT_ERPRC_RELTN_ID