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 |