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