Table Detail Report

SN_PICKLIST_REQUEST_PC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Request Preference Card
Definition: Defines the quantity requested from a preference card
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_REQUEST_PC


Column Name Type Null? Definition
HOLD_QTY DOUBLE N The quantity of the requested item that should be picked, but not opened
OPEN_QTY DOUBLE N The quantity of the requested item that should be picked and opened
PREF_CARD_ID DOUBLE N The preference card id that contains the requested quantity information
REQUEST_QTY DOUBLE N The total quantity of the requested item that should be picked
SN_PICKLIST_REQUEST_ID DOUBLE N The request row that the preference card data is for
SN_PICKLIST_REQUEST_PC_ID DOUBLE N PRIMARY KEY
SN_PREF_CARD_ID DOUBLE Y A foreign key to the sn_pref_card table. This field will be zero or null if the pref_card_id fild is populated. the pref_card_id OR the sn_pref_card_id should be filled out (which one is filled out will tell us which model - old or new - was used for the given picklist)
SURG_CASE_PROC_ID DOUBLE N The surgical procedure that the item is being requested for
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 - SN_PICKLIST_REQUEST_PC


Child Column in SN_PICKLIST_REQUEST_PC(FK) Parent Table Name Parent Column Name
Parents: PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
SN_PICKLIST_REQUEST_ID SN_PICKLIST_REQUEST SN_PICKLIST_REQUEST_ID
SN_PREF_CARD_ID SN_PREF_CARD SN_PREF_CARD_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


SN_PICKLIST_RETURN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Return
Definition: Defines the quantity of an item instance on a picklist that was returned
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_RETURN


Column Name Type Null? Definition
RETURN_DT_TM DATETIME Y The Date and Time that the quantity was returned
RETURN_LOCATION_CD DOUBLE N The location the instance of an item was returned to
RETURN_QTY DOUBLE N The quantity of the instance of an item that was returned
RETURN_STATUS_FLAG DOUBLE N Defines where in the process the item was returned (during fill, in the OR, etc.) - 0=Returned During Fill 1=Returned In OR 2=Marked for Return 3=Return Completed
SN_PICKLIST_ITEM_DETAIL_ID DOUBLE N The instance of an item on the picklist that the quantity is being returned
SN_PICKLIST_RETURN_ID DOUBLE N PRIMARY KEY
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 - SN_PICKLIST_RETURN


Child Column in SN_PICKLIST_RETURN(FK) Parent Table Name Parent Column Name
Parents: SN_PICKLIST_ITEM_DETAIL_ID SN_PICKLIST_ITEM_DETAIL SN_PICKLIST_ITEM_DETAIL_ID


SN_PICKLIST_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Picklist Status
Definition: Contains Status information for picklists
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_STATUS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
PICKLIST_STATUS_CD DOUBLE N The current status of the picklist
PRSNL_ID DOUBLE N The User who set or took an action that caused the status to be set
SN_PICKLIST_ID DOUBLE N Picklist that this status defines
SN_PICKLIST_STATUS_ID DOUBLE N PRIMARY KEY
STATUS_DT_TM DATETIME Y The Date/Time the status of the picklist was set
SYSTEM_TRIGGERED_IND DOUBLE N Indicates that the status was automatically triggered from another action within the picklist
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 - SN_PICKLIST_STATUS


Child Column in SN_PICKLIST_STATUS(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SN_PICKLIST_ID SN_PICKLIST SN_PICKLIST_ID


SN_PICKLIST_USE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Use
Definition: Defines the quantity used of an item instance on the picklist for a procedure
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_USE


Column Name Type Null? Definition
EQUIPMENT_STATUS_CD DOUBLE N The status of the equipment instance at the time the instance was used
SN_PICKLIST_ITEM_DETAIL_ID DOUBLE N The instance of an item on the picklist that the quantity is being used
SN_PICKLIST_USE_ID DOUBLE N PRIMARY KEY
SURG_CASE_PROC_ID DOUBLE N The surgical procedure that the instance of the item was used for
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.
USE_DT_TM DATETIME Y The Date and Time that the quantity was used
USE_QTY DOUBLE N The quantity of the instance of an item that was used



Relationship Detail - SN_PICKLIST_USE


Child Column in SN_PICKLIST_USE(FK) Parent Table Name Parent Column Name
Parents: SN_PICKLIST_ITEM_DETAIL_ID SN_PICKLIST_ITEM_DETAIL SN_PICKLIST_ITEM_DETAIL_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID


SN_PICKLIST_WASTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Waste
Definition: Defines the quantity of an item instance on a picklist that was wasted during the surgical case
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_WASTE


Column Name Type Null? Definition
SN_PICKLIST_ITEM_DETAIL_ID DOUBLE N The instance of an item on the picklist that the quantity is being wasted
SN_PICKLIST_WASTE_ID DOUBLE N PRIMARY KEY
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.
WASTE_DT_TM DATETIME Y The Date and Time that the quantity was wasted
WASTE_QTY DOUBLE N The quantity of the instance of an item that was wasted
WASTE_REASON_CD DOUBLE N The reason the quantity of the item is being wasted.
WASTE_STATUS_FLAG DOUBLE N Defines where in the process the item was wasted (during fill, during the case, etc.) 0=Wasted During Fill 1= Wasted in OR 2= Wasted During Return



Relationship Detail - SN_PICKLIST_WASTE


Child Column in SN_PICKLIST_WASTE(FK) Parent Table Name Parent Column Name
Parents: SN_PICKLIST_ITEM_DETAIL_ID SN_PICKLIST_ITEM_DETAIL SN_PICKLIST_ITEM_DETAIL_ID