Table Detail Report

MEDIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Media
Definition: The Media table contains information specific to alternate types of radiology media. (ex. Video tape, Cine, CD, etc.)
Table Type: ACTIVITY





Column Detail - MEDIA


Column Name Type Null? Definition
CONTINUE_TAPE_ID DOUBLE N The Continue_Tape_Id contains the unique id for the video tape that an exams recording has been continued on to. This may or may not be filled out.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Image_Class table. This uniquely identifies a specific media item.
TAPE_TYPE_CD DOUBLE N The Tape_Type_Cd identifies what type of video tape it is.
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 - MEDIA


Child Column in MEDIA(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID IMAGE_CLASS SEQ_OBJECT_ID


MEDIA_EXAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Media Exam
Definition: The Media_Exam table contains information about a procedure that has been performed and whose results are stored on a type of media other than film.
Table Type: ACTIVITY





Column Detail - MEDIA_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_POSN DOUBLE Y The Exam_Posn field contains a sequential number identifying where in the order the exam exists.
OPTICAL_DISK_SIDE DOUBLE Y The Optical_Disk_Side indicates which side of the optical disk an exam resides on.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SEQ_EXAM_ID DOUBLE N The Seq_Exam_Id is a foreign key to the Exam_Data table. It uniquely identifies the exam.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Media table. This identifies which media item the exam resides on.
TRACK_BEGIN DOUBLE Y The Track_Begin field identifies the track number at which the exams recording starts.
TRACK_END DOUBLE Y The Track_End field identifies the track number at which the exams recording ends.
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 - MEDIA_EXAM


Child Column in MEDIA_EXAM(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID
PERSON_ID PERSON PERSON_ID


RAD_FOREIGN_REQ_ITEMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Foreign Request Items
Definition: The Rad_Foreign_Req_Items table contains information about specific items that have been requested from an outside source.
Table Type: ACTIVITY





Column Detail - RAD_FOREIGN_REQ_ITEMS


Column Name Type Null? Definition
RAD_REQUEST_ID DOUBLE N The Rad_Request_Id is a foreign key to the Rad_Request table. It identifies the Request that the foreign request item is a part of.
REQUEST_ITEM VARCHAR(255) Y The Request_Item is a textual description of the item that is being requested.
SEQUENCE DOUBLE N The Sequence combined with the Rad_Request_Id uniquely identifies a row in the Rad_Foreign_Req_Items table.
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_FOREIGN_REQ_ITEMS


Child Column in RAD_FOREIGN_REQ_ITEMS(FK) Parent Table Name Parent Column Name
Parents: RAD_REQUEST_ID RAD_REQUEST RAD_REQUEST_ID


RAD_LOAN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Loan Information
Definition: The Rad_Loan_Info table contains information about an image management loan transaction.
Table Type: ACTIVITY





Column Detail - RAD_LOAN_INFO


Column Name Type Null? Definition
AGENT VARCHAR(50) Y The Agent identifies the person who picked up the films/folders for the person/place that borrowed it.
COMMENTS VARCHAR(255) Y The Comments field contains any general comments about the loan.
DUE_DT_TM DATETIME Y The Due_Dt_Tm contains the date that the loan is due to be returned.
LOAN_TYPE_FLAG DOUBLE Y The Loan_Type_Flag identifies whether the films/folders were loaned to a physician, patient, internal location, or an external borrower.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Trackable_Object table. It identifies the folder/film that is on loan.
TRACKING_POINT_CD DOUBLE N The Tracking_Point_Cd identifies the borrower. Which table this field a foreign key to is determined by the Loan_Type_Flag.
TRANS_METHOD_CD DOUBLE N the Trans_Method_Cd identifies the method that the loan was sent. (ex. agent, courier, mail, etc.)
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_LOAN_INFO


Child Column in RAD_LOAN_INFO(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID


RAD_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Request
Definition: The Rad_Request table contains information about requests that have been made for films/folders within the image management area.
Table Type: ACTIVITY





Column Detail - RAD_REQUEST


Column Name Type Null? Definition
CONTACTED_DT_TM DATETIME Y The Contacted_Dt_Tm captures the date and time that the lender was contacted concerning the request.
LENDER_ID DOUBLE N The Lender_Id is a foreign key to the Borrower_Lender table. It identifies the Lender that has received the request.
LOGGED_DT_TM DATETIME Y The Logged_Dt_Tm captures the date and time that the request was logged into the system.
PARENT_ENTITY_ID DOUBLE N The Parent_Entity_Id along with the Parent_Entity_Name identifies the person or place that has entered the request.
PARENT_ENTITY_NAME VARCHAR(32) Y The Parent_Entity_Name along with the Parent_Entity_Id identifies the person or place that has entered the request.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RAD_REQUEST_ID DOUBLE N the Rad_Request_Id uniquely identifies a row in the Rad_Request table. It serves no other purpose other than to uniquely identify a row.
REQUEST_COMMENT VARCHAR(255) Y the Request_Comment field contains any general comments about the request.
REQUEST_DT_TM DATETIME Y The Request_Dt_Tm contains the date and time that the films/folders have been requested for.
REQUEST_PRIORITY_CD DOUBLE N The Request_Priority_Cd identifies the priority of the request.
REQUEST_REASON VARCHAR(255) Y The Request_Reason contains the reason that the film/folders are needed.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Trackable_Object table. It identifies the folder that has been requested.
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_REQUEST


Child Column in RAD_REQUEST(FK) Parent Table Name Parent Column Name
Parents: LENDER_ID BORROWER_LENDER BORROWER_LENDER_ID
PERSON_ID PERSON PERSON_ID
SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID




Parent Column in RAD_REQUEST (PK) Child Table Name Child Column Name
Children: RAD_REQUEST_ID RAD_FOREIGN_REQ_ITEMS RAD_REQUEST_ID