SN_PICKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SURGINET PICKLIST
Definition: Picklist for specific document type for a surgical case
Table Type: ACTIVITY





Column Detail - SN_PICKLIST


Column Name Type Null? Definition
DOC_TYPE_CD DOUBLE N The document type for the surgical case the picklist is associated to
GENERATED_DT_TM DATETIME Y The Date/Time that the picklist was last generated
OPTIMIZED_DT_TM DATETIME Y The identifier of the user who last optimized the picklist
OPTIMIZED_PRSNL_ID DOUBLE N The identifier of the user who last optimized the picklist
REGENERATED_IND DOUBLE N indicates the picklist has be regenerated after the picking process has begun
SN_PICKLIST_ID DOUBLE N PRIMARY KEY
SURG_CASE_ID DOUBLE N Surigcal Case the picklist is associated to
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


Child Column in SN_PICKLIST(FK) Parent Table Name Parent Column Name
Parents: OPTIMIZED_PRSNL_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in SN_PICKLIST (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_ID SN_PICKLIST_ITEM SN_PICKLIST_ID
SN_PICKLIST_LOCK SN_PICKLIST_ID
SN_PICKLIST_LOC_STATUS SN_PICKLIST_ID
SN_PICKLIST_PREF_CARD_R SN_PICKLIST_ID
SN_PICKLIST_STATUS SN_PICKLIST_ID


SN_PICKLIST_FILL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Fill
Definition: Defines the quantity filled of an item instance on the picklist
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_FILL


Column Name Type Null? Definition
EQUIPMENT_STATUS_CD DOUBLE N The status of the equipment instance at the time the instance was filled
FILL_DT_TM DATETIME Y The Date and Time that the quantity was filled
FILL_LOCATION_CD DOUBLE N The location that the quantity was filled from
FILL_QTY DOUBLE N The quantity of the instance of an item that was filled
IN_CASE_FILL_IND DOUBLE N Indicates whether the quanity was filled during the surgical case (rather than being filled during the initial fill)
SN_PICKLIST_FILL_ID DOUBLE N PRIMARY KEY
SN_PICKLIST_ITEM_DETAIL_ID DOUBLE N Indicates whether the quanity was filled during the surgical case (rather than being filled during the initial fill)
SUPPLY_CABINET_IND DOUBLE N Indicates whether the fill was generated via Supply Cabinet Integration
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_FILL


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


SN_PICKLIST_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Picklist Item
Definition: Unique Item contained on the given picklist
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_ITEM


Column Name Type Null? Definition
AD_HOC_IND DOUBLE N Indicates that this item was added by the user after the picklist has been generated
DOC_AT_COMPONENT_IND DOUBLE N Indicates that the documentation of use/waste/reutrn should be at the compoent level. Should only be set if this item is a set/pack item and the build setting for the item is that the children generate supply transactions
EQUIPMENT_TRACKED_IND DOUBLE N Indicates that the item is an equipment type that requires instance information when filled
EXPIRATION_DATE_IND DOUBLE N Indicates whether this item requires the expiration date to be documented
ITEM_ID DOUBLE N Inventory Item represented by this row. From the ITEM_DEFINITION table
LOT_IND DOUBLE N Indicates whether this item requires the lot number to be documented
MANUFACTURE_DATE_IND DOUBLE N Indicates whether this item requires the manufacture date to be documented
PACK_IND DOUBLE N Indictes that this item is a parent level item and that it has children components contained within it
PARENT_PICKLIST_ITEM_ID DOUBLE N Specifies the parent set/pack that this item belongs to
SERIAL_NBR_IND DOUBLE N Indicates whether this item requires the serial number to be documented
SN_PICKLIST_ID DOUBLE N Picklist Identifier that this item applies to
SN_PICKLIST_ITEM_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.
USE_COMP_HIERARCHY_IND DOUBLE N If the item is a set/pack, If true this indicates whether the components of the set/pack should follow the component hierarchy. If False, componentes of the set/pack would follow the normal Fill/Return hierarchy



Relationship Detail - SN_PICKLIST_ITEM


Child Column in SN_PICKLIST_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
SN_PICKLIST_ID SN_PICKLIST SN_PICKLIST_ID
PARENT_PICKLIST_ITEM_ID SN_PICKLIST_ITEM SN_PICKLIST_ITEM_ID




Parent Column in SN_PICKLIST_ITEM (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_ITEM_ID SN_PICKLIST_ITEM PARENT_PICKLIST_ITEM_ID
SN_PICKLIST_ITEM_DETAIL SN_PICKLIST_ITEM_ID
SN_PICKLIST_REQUEST SN_PICKLIST_ITEM_ID


SN_PICKLIST_ITEM_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Item Detail
Definition: Unique Instance of a given item on a surgical picklist
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_ITEM_DETAIL


Column Name Type Null? Definition
DEVICE_IDENTIFIER_TXT VARCHAR(255) Y The device identifier of the instance of the item
DONATION_IDENT VARCHAR(255) Y The donation Identified of the instance of the item
EXPIRATION_DT_TM DATETIME Y the date of expiration of the instance of the item
LOT_NBR_TXT VARCHAR(255) Y The lot number of the instance of the item
LOT_NUMBER_ID DOUBLE N If the item contains a lot numner, the identifier of the lot number for this instance of the item
MANF_CATALOG_NBR_TXT VARCHAR(255) Y The catalog number of the manufacturers item
MANF_CD DOUBLE N The manufacturer of the instance of the item
MANUFACTURE_DT_TM DATETIME Y The date of manufacture of the instance of the item
MM_INSTANCE_ID DOUBLE N The instance identifier contains a serial numner, the instance identifier for this instance of the item
PARENT_PICKLIST_ITEM_DETAIL_ID DOUBLE N PARENT DETAIL ID
SERIAL_NBR_TXT VARCHAR(255) Y The serial Number of the instance of the item
SN_PICKLIST_ITEM_DETAIL_ID DOUBLE N PRIMARY KEY
SN_PICKLIST_ITEM_ID DOUBLE N The item on the picklist that this detail is defining.
UDI_HRF_TXT VARCHAR(255) Y The Human readable (formatted) version of the barcode of the instance of the item
UDI_MRF_TXT VARCHAR(255) Y The machine readable (raw) version of the barcode of the instance of the item;
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_ITEM_DETAIL


Child Column in SN_PICKLIST_ITEM_DETAIL(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
MM_INSTANCE_ID MM_INSTANCE MM_INSTANCE_ID
SN_PICKLIST_ITEM_ID SN_PICKLIST_ITEM SN_PICKLIST_ITEM_ID
PARENT_PICKLIST_ITEM_DETAIL_ID SN_PICKLIST_ITEM_DETAIL SN_PICKLIST_ITEM_DETAIL_ID




Parent Column in SN_PICKLIST_ITEM_DETAIL (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_ITEM_DETAIL_ID SN_PICKLIST_FILL SN_PICKLIST_ITEM_DETAIL_ID
SN_PICKLIST_ITEM_DETAIL PARENT_PICKLIST_ITEM_DETAIL_ID
SN_PICKLIST_RETURN SN_PICKLIST_ITEM_DETAIL_ID
SN_PICKLIST_USE SN_PICKLIST_ITEM_DETAIL_ID
SN_PICKLIST_WASTE SN_PICKLIST_ITEM_DETAIL_ID


SN_PICKLIST_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Picklist Lock
Definition: Lock information for a given picklist
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_LOCK


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.
BREAK_TYPE_FLAG DOUBLE N How the lock was unlocked, through normal process or broken by another user. 0=Not broken - normal unlock 1=Broken by current user in a different session 2=Lock was expired and broken by another user 3=Lock was forcibly broken prior to expiring;
LAST_UPDT_DT_TM DATETIME Y The last time the picklist was updated. This is used to determine if a lock is eligible to be broken
LOCK_DT_TM DATETIME Y Date and Time the lock was acquired
LOCK_PRSNL_ID DOUBLE N The provider who obtained the lock
SN_PICKLIST_ID DOUBLE N Picklist Identifier that this lock applies to
SN_PICKLIST_LOCK_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_LOCK


Child Column in SN_PICKLIST_LOCK(FK) Parent Table Name Parent Column Name
Parents: LOCK_PRSNL_ID PRSNL PERSON_ID
SN_PICKLIST_ID SN_PICKLIST SN_PICKLIST_ID