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 |