PULL_FOLDERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pull Folders
Definition: The Pull_Folders table contains a list of folders that qualified to be transferred as a part of a transfer pull list.
Table Type: ACTIVITY





Column Detail - PULL_FOLDERS


Column Name Type Null? Definition
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PULL_FOLDER_ID DOUBLE N The Pull_Folder_Id uniquely identifies a row within the Pull_Folders table. This field serves no purpose other than to uniquely identify the row.
PULL_LIST_ID DOUBLE N The Pull_List_Id is a foreign key to the Pull_List table. It identifies which pull list this specific folder is a part of.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Trackable_Object table. This is used to identify the folder that is to be pulled as a part of this pull list.
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 - PULL_FOLDERS


Child Column in PULL_FOLDERS(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PULL_LIST_ID PULL_TRANS_REQ PULL_LIST_ID
SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID


PULL_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pull List
Definition: The Pull_List table contain common information about a pull list.
Table Type: ACTIVITY





Column Detail - PULL_LIST


Column Name Type Null? Definition
PRINT_DT_TM DATETIME Y The Print_Dt_Tm contains the date and time that the pull list should print.
PULL_LIST_ID DOUBLE N The Pull_List_Id uniquely identifies a row within the Pull_List table. This field serves no purpose other than to uniquely identify the row.
REQ_PULL_DT_TM DATETIME Y The Req_Pull_Dt_Tm contains the date and time that the folder(s) should be pulled.
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 - PULL_LIST




Parent Column in PULL_LIST (PK) Child Table Name Child Column Name
Children: PULL_LIST_ID ORDER_RADIOLOGY PULL_LIST_ID
PULL_ORD_SCHED PULL_LIST_ID
PULL_TRANS_REQ PULL_LIST_ID


PULL_LIST_CONTROLS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pull List Controls
Definition: The Pull_List_Controls table contains settings pertaining to how pull lists are to behave within the system.
Table Type: REFERENCE





Column Detail - PULL_LIST_CONTROLS


Column Name Type Null? Definition
CURRENT_ORDER_NBR_DAYS DOUBLE Y The Current_Order_Nbr_Days identifies the number of days beyond today that define an order pull list as current.
CURRENT_SCHED_NBR_DAYS DOUBLE Y The Current_Sched_Nbr_Days identifies the number of days beyond today that a schedule pull list is considered to be current.
FUTURE_ORDER_NBR_DAYS DOUBLE Y The Future_Order_Nbr_Days field identifies the number of days in advance of request that pull listsshould print.
INCLUDE_EXAMS_IND DOUBLE Y The Include_Exams_Ind indicates if exams should be included on an order pull list if they have already appeared on a schedule pull list.
NBR_DAYS_PRIOR_PULL_LIST DOUBLE Y Indicates how many days back to look for a previously printed pull list.
PREV_EXAMS_BY_LIBGRP_IND DOUBLE Y Indicates if the pull list should only show exams within a given library group.
PRINT_FOR_EVERY_ORDER_IND DOUBLE Y Indicates if a pull list should print for every order.
PRINT_LIB_TRK_PT_FLAG DOUBLE Y The Print_Lib_Trk_Pt_Flag field idicates if pull lists should print to the library or tracking point printer.
PRINT_MASTER_FLAG DOUBLE Y The Print_Master_Flag indicates if only the active master or all masters are to print on the order/schedule pull list.
PRINT_NEW_MASTER_IND DOUBLE Y The Print_New_Master_Ind field indicates if new masters are to print on sched/order pull lists.
PRINT_ORDER_FLAG DOUBLE Y The Print_Order_Flag indicates when pull lists will be printed for ordered procedures.
PULL_LIST_NBR_DAYS DOUBLE Y The Pull_List_Nbr_Days field indicates the number of days to keep pull lists on the system.
SCHED_DAYS_IN_ADVANCE DOUBLE Y The Sched_Days_In_Advance field indicates the number of days in advance of the scheduled date that schedule pull lists should print.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Service Resource table. It uniquely identifies theLibrary Group that the pull list controls are set up for.
UPDATE_SUBSECT_OPTION_IND DOUBLE Y The Update_Subsect_Option_Ind indicates if the subsection sort option for order/sched pull lists should be updated.
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 - PULL_LIST_CONTROLS


Child Column in PULL_LIST_CONTROLS(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


PULL_ORD_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order/Schedule Pull Lists
Definition: The Pull_Ord_Sched table contains information specific to order and schedule pull lists.
Table Type: ACTIVITY





Column Detail - PULL_ORD_SCHED


Column Name Type Null? Definition
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. It identifies the order that this pull list is related to.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PULL_LIST_ID DOUBLE N The Pull_List_Id is a foreign key to the Pull_List table. It identifies which pull list this is related to.
SCHED_ID DOUBLE N The Sched_Id is a foreign key to scheduling. It identifies the scheduled procedure that this pull list is related to.
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 - PULL_ORD_SCHED


Child Column in PULL_ORD_SCHED(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
PERSON_ID PERSON PERSON_ID
PULL_LIST_ID PULL_LIST PULL_LIST_ID


PULL_TRANS_REQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transfer/Request Pull Lists
Definition: The Pull_Trans_Req table contains information specific to transfer and request pull lists.
Table Type: ACTIVITY





Column Detail - PULL_TRANS_REQ


Column Name Type Null? Definition
BORROWING_ENTITY_ID DOUBLE N *** OBSOLETE *** The Borrowing_Entity_Id contains the primary key of the table that contains the borrower. This, along with the borrowing_entity_name, identifies the borrower whose request generated the request pull list.
BORROWING_ENTITY_NAME VARCHAR(32) Y *** OBSOLETE *** The Borrowing_Entity_Name contains the name of the table that contains the borrower. This, along with the borrowing_entity_id, identifies the borrower whose request generated the request pull list.
FROM_LIB_CD DOUBLE N The From_Lib_Cd identifies the library that folders will be pulled from as a part of a transfer.
PULL_LIST_ID DOUBLE N The Pull_List_Id is a foreign key to the Pull_List table. It identifies which pull list this is related to.
TO_LIB_CD DOUBLE N The To_Lib_Cd identifies the library that folders will be moving to as a part of a transfer.
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 was used.
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 - PULL_TRANS_REQ


Child Column in PULL_TRANS_REQ(FK) Parent Table Name Parent Column Name
Parents: PULL_LIST_ID PULL_LIST PULL_LIST_ID
TRANS_RULE_ID RAD_FOLD_TRANS_RULE TRANS_RULE_ID
FROM_LIB_CD TRACK_PT_LIBRARY SERVICE_RESOURCE_CD
TO_LIB_CD TRACK_PT_LIBRARY SERVICE_RESOURCE_CD




Parent Column in PULL_TRANS_REQ (PK) Child Table Name Child Column Name
Children: PULL_LIST_ID PULL_FOLDERS PULL_LIST_ID