FILING_NUMBER_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores terminal filing digit sequence for a service_resource_cd
Definition: This table holds the position and sequence numbers for a service_resource_cd that is used to determine a terminal filing number for a library.
Table Type: REFERENCE





Column Detail - FILING_NUMBER_POSITION


Column Name Type Null? Definition
POSITION DOUBLE N Individual position of a filing number
SEQUENCE DOUBLE N Holds filing order for a given position
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the track_pt_library table. This serves as a unique identifier for the library.
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 - FILING_NUMBER_POSITION


Child Column in FILING_NUMBER_POSITION(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD TRACK_PT_LIBRARY SERVICE_RESOURCE_CD


FILM_EXAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Film Exam
Definition: The Film_Exam table contains information about an exam, that has been performed, that is specific the the media type of film.
Table Type: ACTIVITY





Column Detail - FILM_EXAM


Column Name Type Null? Definition
FILM_COUNT DOUBLE Y The Film_Count contains the actual number of films that were produced as a result of the exam being performed. This is for tracking purposes only.
FOLDER_ID DOUBLE N The Folder_Id is a foreign key to the Folder table. This identifies the folder that the exam resides in within the image management area.
LOST_COMMENT VARCHAR(255) Y The Lost_Comment contains any comments pertaining to lost films.
LOST_COUNT DOUBLE Y The Lost_Count identifies how many films have been lost out of the total film count.
LOST_IND DOUBLE Y The Lost_Ind indicates if the film has been lost.
MULTI_DAY_IN_PROC_IND DOUBLE Y The Multi_Day_In _Proc_Ind indicates whether or not a multi-day study is currently in process.
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 Trackable_Object table. This identifies the film exam as a trackable object within the image management area.
TEMP_FOLDER_ID DOUBLE N The Temp_Folder_Id is a foreign key to the Temporary Folder table. This identifies the temporary folder that the exam is currently residing in, if it's in a temporary folder at all.
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 - FILM_EXAM


Child Column in FILM_EXAM(FK) Parent Table Name Parent Column Name
Parents: SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID
FOLDER_ID FOLDER SEQ_OBJECT_ID
SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID
TEMP_FOLDER_ID TRACKABLE_OBJECT SEQ_OBJECT_ID


FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Folder
Definition: The Folder table contains info about a patients image management folder.
Table Type: ACTIVITY





Column Detail - FOLDER


Column Name Type Null? Definition
OLD_CERNER_NUMBER VARCHAR(50) Y The Old_Cerner_Number contains the folders unique identifier from a previous Cerner system.
PARENT_OBJECT_ID DOUBLE N The Parent_Object_Id identifies the folder that the current folder resides in. This allows for a hierarchical structure among folders.
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_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Image_Class table. This uniquely identifies a folder within the image management area.
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 - FOLDER


Child Column in FOLDER(FK) Parent Table Name Parent Column Name
Parents: PARENT_OBJECT_ID FOLDER SEQ_OBJECT_ID
SEQ_OBJECT_ID IMAGE_CLASS SEQ_OBJECT_ID
PERSON_ID PERSON PERSON_ID




Parent Column in FOLDER (PK) Child Table Name Child Column Name
Children: SEQ_OBJECT_ID FILM_EXAM FOLDER_ID
FOLDER PARENT_OBJECT_ID


FOREIGN_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Foreign Content
Definition: The Foreign_Content table contains information about what exists in a certain foreign folder.
Table Type: ACTIVITY





Column Detail - FOREIGN_CONTENT


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.
CONTENT_NAME VARCHAR(255) Y The Content_Name is a free text entry used to identify an item contained in a foreign folder.
CONTENT_TYPE_CD DOUBLE N The Content_Type_Cd identifies the media type of the foreign content item.
FILM_COUNT DOUBLE Y The Film_Count captures the number of films that are a part of the foreign content item.
SEQ_FOREIGN_ID DOUBLE N The Seq_Foreign_Id uniquely identifies a row within the Foreign_Content table. It has no other meaning or purpose other than to serve as a unique id.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Foreign_Folder table. This uniquely identifies the foreign folder that the foreign content resides in.
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 - FOREIGN_CONTENT


Child Column in FOREIGN_CONTENT(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID FOREIGN_FOLDER SEQ_OBJECT_ID


FOREIGN_FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Foreign Folder
Definition: The Foreign_Folder table contains information about folders that have been received from outside our system.
Table Type: ACTIVITY





Column Detail - FOREIGN_FOLDER


Column Name Type Null? Definition
CONTENT_COMMENT VARCHAR(255) Y The Content_Comment field contains any general comments about the contents of a foreign folder.
CUSTODIAN VARCHAR(50) Y The Custodian contains a free text entry identifying the person(s) responsible for the foreign folder.
DUE_DT_TM DATETIME Y The Due_Dt_Tm field contains the date and time that the foreign folder should be returned to its origin.
LENDER_ID DOUBLE N The Lender_id is a foreign key to the Borrower_Lender table. It uniquely identifies the lender from which the foreign folder was received.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RECEIVED_DT_TM DATETIME Y The Received_Dt_Tm captures the date and time that the foreign folder was received.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Image_Class table. It serves as a unique identifier for the foreign folder.
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 - FOREIGN_FOLDER


Child Column in FOREIGN_FOLDER(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID IMAGE_CLASS SEQ_OBJECT_ID
PERSON_ID PERSON PERSON_ID




Parent Column in FOREIGN_FOLDER (PK) Child Table Name Child Column Name
Children: SEQ_OBJECT_ID FOREIGN_CONTENT SEQ_OBJECT_ID