BILL_ONLY_PROC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Only Procedure Relation
Definition: The Bill_Only_Proc_Reltn table contains the relationship between an orderable procedure and a bill only or bill only category.
Table Type: REFERENCE





Column Detail - BILL_ONLY_PROC_RELTN


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. It identifies the exam that has the bill only or bill only category associated with it.
ENTITY_ID DOUBLE N The Entity_Id contains a primary key from one of a couple of tables. It along with the Entity_Name identifies the bill only or bill only category that is associated with this procedure.
ENTITY_NAME VARCHAR(40) N The Entity_Name contains the table name that corresponds with the Entity_Id. It along with the Entity_Id identifies the bill only or bill only category that is associated with this procedure.
STANDARD_QTY DOUBLE Y The Standard_Qty contains the standard number, of this specific bill only, that is used.
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 - BILL_ONLY_PROC_RELTN


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


BILL_ONLY_SUBSECT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Only Sub Section Relation
Definition: The Bill_Only_Subsect_Reltn table contains the relationship between a sub section and a bill only or bill only category.
Table Type: REFERENCE





Column Detail - BILL_ONLY_SUBSECT_RELTN


Column Name Type Null? Definition
ENTITY_ID DOUBLE N The Entity_Id contains a primary key from one of a couple of tables. It along with the Entity_Name identifies the bill only or bill only category that is associated with this procedure.
ENTITY_NAME VARCHAR(40) N The Entity_Name contains the table name that corresponds with the Entity_Id. It along with the Entity_Id identifies the bill only or bill only category that is associated with this procedure.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Sub_Section table. It identifies the sub section that has the bill only or bill only category associated with it.
STANDARD_QTY DOUBLE Y The Standard_Qty contains the standard number, of this specific bill only, that is used.
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 - BILL_ONLY_SUBSECT_RELTN


Child Column in BILL_ONLY_SUBSECT_RELTN(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


EXAM_FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Exam Folder
Definition: The Exam_Folder table establishes relationships between orders and image management. It indicates which folders/media an ordered procedure can load to.
Table Type: REFERENCE





Column Detail - EXAM_FOLDER


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies a certain orderable procedure.
IMAGE_CLASS_TYPE_CD DOUBLE N The Image_Class_Type_Cd is a foreign key to the Image_Class_Type table. This identifies a folder type that the exam should load to.
LIB_GROUP_CD DOUBLE N The Lib_Group_Cd is a foreign key to the Library Group table. This identifies the library group related to the image class type.
REQUIRED_IND DOUBLE Y The Required_Ind field indicates which folder types are required and which folder types are alternate folder types or media.
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 - EXAM_FOLDER


Child Column in EXAM_FOLDER(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD SERVICE_DIRECTORY CATALOG_CD
LIB_GROUP_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


EXAM_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Exam Reason
Definition: The Exam_Reason table contains the relationships between orderable procedures and coded reasons for exam.
Table Type: REFERENCE





Column Detail - EXAM_REASON


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies a certain orderable procedure.
EXAM_REASON_ID DOUBLE N The exam_reason_id is a unique, meaningless number that serves only as an identifier for a reason for exam
ICD9_ID DOUBLE N The ICD9_id field serves as a foreign key to the Nomenclature table. It identifies the ICD9 code that has been been attached to the procedure/reason for exam combination.
SEQUENCE DOUBLE N The Sequence field allows for the ability to tie multiple ICD9 codes to a given reason for exam.
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 - EXAM_REASON


Child Column in EXAM_REASON(FK) Parent Table Name Parent Column Name
Parents: EXAM_REASON_ID CODED_EXAM_REASON EXAM_REASON_ID
CATALOG_CD SERVICE_DIRECTORY CATALOG_CD


EXAM_ROOM_LIB_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Exam Room Library Group Relation
Definition: The Exam_Room_Lib_Grp_Reltn table contains relationships between exam rooms and library groups that will aid in image management loading logic.
Table Type: REFERENCE





Column Detail - EXAM_ROOM_LIB_GRP_RELTN


Column Name Type Null? Definition
LIB_GROUP_CD DOUBLE N The Lib_Group_Cd is a foreign key to the Library Group table. This identifies a specific library group within the image management area.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Library Group table. This allows library groups to be logically linked to exam rooms for image management loading purposes.F143
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 - EXAM_ROOM_LIB_GRP_RELTN


Child Column in EXAM_ROOM_LIB_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: LIB_GROUP_CD LIBRARY_GROUP SERVICE_RESOURCE_CD
SERVICE_RESOURCE_CD RAD_EXAM_ROOM SERVICE_RESOURCE_CD