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 |