Table Detail Report
TEMPORARY_DETAILS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Temporary Details |
Definition: | The Temporary_Details table contains information about each component of a temporary exam. |
Table Type: | ACTIVITY |
Column Detail - TEMPORARY_DETAILS
Column Name | Type | Null? | Definition |
---|---|---|---|
DISCRETE_ASSAY_TASK_CD | DOUBLE | N | The Discrete_Assay_Task_Cd is a foreign key to the Discrete_Task_Assay table. It uniquely identifies the detail procedure that is contained in the temporary folder. |
SEQ_EXAM_ID | DOUBLE | N | The Seq_Exam_Id is a foreign key to the Temporary_Exam table. It identifies the temporary Exam that the detail exams are a part of. |
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 - TEMPORARY_DETAILS
Child Column in TEMPORARY_DETAILS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEQ_EXAM_ID | TEMPORARY_EXAM | SEQ_EXAM_ID |
TEMPORARY_EXAM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Temporary Exam |
Definition: | The Temporary_Exam table contains information about exams that have been placed in a temporary folder. |
Table Type: | ACTIVITY |
Column Detail - TEMPORARY_EXAM
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
EXAM_OBJECT_ID | DOUBLE | N | The Exam_Object_Id is a foreign key to the Film_Exam table. |
SEQ_EXAM_ID | DOUBLE | N | The Seq_Exam_Id is a foreign key to the Exam_Data table. |
SEQ_OBJECT_ID | DOUBLE | N | The Seq_Object_Id is a foreign key to the Temporary_Folder table. It uniquely identifies the temporary folder that the temporary exam is stored in. |
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 - TEMPORARY_EXAM
Child Column in TEMPORARY_EXAM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
SEQ_EXAM_ID | EXAM_DATA | SEQ_EXAM_ID | |
SEQ_OBJECT_ID | TEMPORARY_FOLDER | SEQ_OBJECT_ID | |
EXAM_OBJECT_ID | TRACKABLE_OBJECT | SEQ_OBJECT_ID |
Parent Column in TEMPORARY_EXAM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEQ_EXAM_ID | TEMPORARY_DETAILS | SEQ_EXAM_ID |
TEMPORARY_FOLDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Temporary Folder |
Definition: | The Temporary_Folder table contains information about temporary folders that exists within the image management area. |
Table Type: | ACTIVITY |
Column Detail - TEMPORARY_FOLDER
Column Name | Type | Null? | Definition |
---|---|---|---|
SEQ_OBJECT_ID | DOUBLE | N | The Seq_Object_Id is a foreign key to the Image_Class table. |
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 - TEMPORARY_FOLDER
Child Column in TEMPORARY_FOLDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEQ_OBJECT_ID | IMAGE_CLASS | SEQ_OBJECT_ID |
Parent Column in TEMPORARY_FOLDER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEQ_OBJECT_ID | TEMPORARY_EXAM | SEQ_OBJECT_ID |
TRACKABLE_OBJECT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Trackable Object |
Definition: | The Trackable_Object table contains information about those items that can be physically tracked within the image management area. These items include folders and all types of media. |
Table Type: | ACTIVITY |
Column Detail - TRACKABLE_OBJECT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
EXAM_IND | DOUBLE | Y | The Exam_Ind indicates if the trackable object is an exam or a folder. |
LOAN_TYPE_FLAG | DOUBLE | Y | The Loan_Type_Flag indicates is the current location of the folder/exam is a physician, patient, borrower, tracking point or library. |
MED_LEGAL_IND | DOUBLE | Y | The Med_Legal_Ind indicates if this trackable object has been marked as medical legal. |
RETURN_LOCATION_CD | DOUBLE | N | The Return_Location_Cd is a foreign key to the Track_Pt_Library table. It indicates where the trackable object resides permanently. |
SEQ_OBJECT_ID | DOUBLE | N | The Seq_Object_Id uniquely identifies a row in the Trackable_Object table. It serves no other purpose other than to uniquely identify the row. |
TRACKING_POINT_CD | DOUBLE | N | The Tracking_Point_Cd identifies the trackable objects current location. This could be a physician, borrower, tracking point, library or patient. |
TRK_PT_ARRIVE_DT_TM | DATETIME | N | The Trk_Pt_Arrive_Dt_Tm captures the date and time that the trackable object entered the current tracking point. |
TRK_PT_ARRIVE_ID | DOUBLE | N | The Trk_Pt_Arrive_Id captures the id of the user that moved the trackable object to its current location. |
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 - TRACKABLE_OBJECT
Child Column in TRACKABLE_OBJECT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TRK_PT_ARRIVE_ID | PRSNL | PERSON_ID |
Parent Column in TRACKABLE_OBJECT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEQ_OBJECT_ID | FILM_EXAM | SEQ_OBJECT_ID |
FILM_EXAM | TEMP_FOLDER_ID | ||
IMAGE_CLASS | SEQ_OBJECT_ID | ||
IMAGE_HISTORY | SEQ_OBJECT_ID | ||
PULL_FOLDERS | SEQ_OBJECT_ID | ||
RAD_LOAN_INFO | SEQ_OBJECT_ID | ||
RAD_REQUEST | SEQ_OBJECT_ID | ||
TEMPORARY_EXAM | EXAM_OBJECT_ID |
TRANS_EXAM_EXCLUSIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Transfer Exam Exclusions |
Definition: | The Trans_Exam_Exclusion table contains exams that should be excluded whenever a batch folder transfer is executed. |
Table Type: | REFERENCE |
Column Detail - TRANS_EXAM_EXCLUSIONS
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 exam that is to be excluded from the transfer pull list. |
TRANS_RULE_ID | DOUBLE | N | The trans_rule_id serves as a foreign key to the rad_fold_trans_rule table. It uniquely identifies the transfer rule that the exam exclusions are a part of. |
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 - TRANS_EXAM_EXCLUSIONS
Child Column in TRANS_EXAM_EXCLUSIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
TRANS_RULE_ID | RAD_FOLD_TRANS_RULE | TRANS_RULE_ID |