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 |