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 |