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 |