Table Detail Report

RAD_TECH_FMT_ERPRC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology tech comment format and Service resource and procedure relation.
Definition: The Rad_Tech_Fmt_ErProc_R table holds a relation to a technical comment format and a combination of an exam room and a procedure.
Table Type: REFERENCE





Column Detail - RAD_TECH_FMT_ERPRC_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd identifies a procedure that is related to a technical comment format.
FORMAT_ERPRC_RELTN_ID DOUBLE N The format_ErProc_reltn_Id uniquely identifies a row in the Rad_Tech_Fmt_ErProc_r table. It serves no other purpose other than to uniquely identify the row.
FORMAT_ID DOUBLE N The Format_Id is a foreign key to the Rad_Tech_Format table. It is used to identify a Format.
SEQUENCE DOUBLE N The Sequence identifies an order of fields within a specific format.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd identifies a location that is related to a technical comment 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_FMT_ERPRC_R


Child Column in RAD_TECH_FMT_ERPRC_R(FK) Parent Table Name Parent Column Name
Parents: FORMAT_ID RAD_TECH_FORMAT FORMAT_ID




Parent Column in RAD_TECH_FMT_ERPRC_R (PK) Child Table Name Child Column Name
Children: FORMAT_ERPRC_RELTN_ID RAD_TECH_FMT_ERPRC_OVRD FORMAT_ERPRC_RELTN_ID


RAD_TECH_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Technical Comment Formats
Definition: The Rad_Tech_Format table holds individual radiology technical comment formats.
Table Type: REFERENCE





Column Detail - RAD_TECH_FORMAT


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_FORMAT_IND DOUBLE N The field_format_ind states if this format is tied to one field or if it is an actual format. 0 = Actual Format, 1 = Field Format
FORMAT_DESC VARCHAR(60) N The format description names a radiology technical comment format.
FORMAT_DESC_A_NLS VARCHAR(240) Y The NLS key for searching in all non-English locales.
FORMAT_ID DOUBLE N The Format_Id uniquely identifies a row in the Rad_Tech_Format table. It serves no other purpose other than to uniquely identify the row .
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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_TECH_FORMAT




Parent Column in RAD_TECH_FORMAT (PK) Child Table Name Child Column Name
Children: FORMAT_ID RAD_TECH_FLD_FMT_R FORMAT_ID
RAD_TECH_FMT_ERPRC_R FORMAT_ID


RAD_TEMPLATE_ASSOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Template Association
Definition: The Rad_Templete_Assoc table contains a list of templates
Table Type: REFERENCE





Column Detail - RAD_TEMPLATE_ASSOC


Column Name Type Null? Definition
TASK_ASSAY_CD DOUBLE N The Task_Assay_Cd is a foreign key to the Discrete_Task_Assay table. It identifies which report detail that the template is associated with.
TEMPLATE_GROUP_ID DOUBLE N The Template_Group_Id is a foreign key to the Rad_Template_Group table.
TEMPLATE_ID DOUBLE N The Template_Id is a foreign key to the WP_Template table. It uniquely identify a template.
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_TEMPLATE_ASSOC


Child Column in RAD_TEMPLATE_ASSOC(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
TEMPLATE_GROUP_ID RAD_TEMPLATE_GROUP TEMPLATE_GROUP_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID


RAD_TEMPLATE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Template Group
Definition: The Rad_Template_Group table contains general information about a grouping of templates. This can be done by person_id or as a general grouping.
Table Type: REFERENCE





Column Detail - RAD_TEMPLATE_GROUP


Column Name Type Null? Definition
ASSESSMENT_ID DOUBLE Y This identifies the default Assessment that is to be assigned whenever the template is used.
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. It uniquely identifies an orderable procedure.
CLASSIFICATION_CD DOUBLE N The Classification_Cd indicates the procedure classification that is associated with the template.
GROUP_DESC VARCHAR(50) Y The Group_Desc describes the template group.
MOD_TEXT_FLAG DOUBLE Y The Mod_Text_Flag indicates if the template requires modifications or not.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RECOMMENDATION_ID DOUBLE Y This identifies the default recommendation that is to be used whenever the template is used.
TEMPLATE_GROUP_ID DOUBLE N The Template_Group_Id uniquely identifies a row on the Rad_Template_Group table. It serves no other purpose other than to uniquely identify the row.
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_TEMPLATE_GROUP


Child Column in RAD_TEMPLATE_GROUP(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
PERSON_ID PRSNL PERSON_ID
ASSESSMENT_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
RECOMMENDATION_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID




Parent Column in RAD_TEMPLATE_GROUP (PK) Child Table Name Child Column Name
Children: TEMPLATE_GROUP_ID RAD_TEMPLATE_ASSOC TEMPLATE_GROUP_ID


TECHNIQUE_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Technique Defaults
Definition: This table sets up the relationships between a catalog_cd, department_cd and exam_room_cd for default technique fields.
Table Type: REFERENCE





Column Detail - TECHNIQUE_DEFAULTS


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The catalog_cd is a foreign key to the order_catalog table. It uniquely identifies the procedure that the defaults are set up for.
DEPARTMENT_CD DOUBLE N The department_cd is a foreign key to the service_resource table. It uniquely identifies the department that is having the defaults set up for.
EXAM_ROOM_CD DOUBLE N The Exam_Room_Cd is a foreign key to the service_resource table. It uniquely identifies the exam room that is having defaults set up for.
SEQUENCE DOUBLE Y This column identifies the sequence in which the defaults should appear in Exam Mgmt.
TECHNIQUE_DEFAULT_ID DOUBLE N This column is a meaningless number that only serves as a unique identifier for the row.
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 - TECHNIQUE_DEFAULTS


Child Column in TECHNIQUE_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
DEPARTMENT_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
EXAM_ROOM_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in TECHNIQUE_DEFAULTS (PK) Child Table Name Child Column Name
Children: TECHNIQUE_DEFAULT_ID TECHNIQUE_DEFAULT_VALS TECHNIQUE_DEFAULT_ID