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 |