Table Detail Report

SN_PICKLIST_LOC_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - SN_PICKLIST_LOC_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.
LOCATION_CD DOUBLE N The location that the status is for
LOCATION_STATUS_CD DOUBLE N The status of the location for the given picklist
PRSNL_ID DOUBLE N The user who took an action that caused the location status to be updated
SN_PICKLIST_ID DOUBLE N The picklist that the location status is for
SN_PICKLIST_LOC_STATUS_ID DOUBLE N PRIMARY KEY
STATUS_DT_TM DATETIME Y The date and time the status of the location was updated
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_LOC_STATUS


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


SN_PICKLIST_MESSAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Message
Definition: Contains message information for surgical picklist and picklist items
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_MESSAGE


Column Name Type Null? Definition
MESSAGE_TYPE_CD DOUBLE N A code indicating the Type of message
PARENT_ENTITY_ID DOUBLE N Contains the primary key to the parent table identified in field PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Contains the table name of the parent
RESOLVED_DT_TM DATETIME Y Indicates the date when the message was resolved
RESOLVED_IND DOUBLE N Indicates whether or not the message has been resolved
RESOLVED_PRSNL_ID DOUBLE N The personnel id of the user who resolved the message
SN_PICKLIST_MESSAGE_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_MESSAGE


Child Column in SN_PICKLIST_MESSAGE(FK) Parent Table Name Parent Column Name
Parents: RESOLVED_PRSNL_ID PRSNL PERSON_ID




Parent Column in SN_PICKLIST_MESSAGE (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_MESSAGE_ID SN_PICKLIST_MESSAGE_TEXT SN_PICKLIST_MESSAGE_ID


SN_PICKLIST_MESSAGE_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Message Text
Definition: Contains message text for surgical picklist and picklist item messages
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_MESSAGE_TEXT


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Indicates when the message was created
CREATE_PRSNL_ID DOUBLE N The personnel id of the user who created the message
LAST_MODIFIED_DT_TM DATETIME Y Indicates when the message was last modified
LAST_MODIFIED_PRSNL_ID DOUBLE N The personnel id of the user who last modified the message
MESSAGE_TXT VARCHAR(4000) N The text of the message
PARENT_MESSAGE_TEXT_ID DOUBLE N
SN_PICKLIST_MESSAGE_ID DOUBLE N Contains the identifier for the message for this message text
SN_PICKLIST_MESSAGE_TEXT_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_MESSAGE_TEXT


Child Column in SN_PICKLIST_MESSAGE_TEXT(FK) Parent Table Name Parent Column Name
Parents: CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_MODIFIED_PRSNL_ID PRSNL PERSON_ID
SN_PICKLIST_MESSAGE_ID SN_PICKLIST_MESSAGE SN_PICKLIST_MESSAGE_ID
PARENT_MESSAGE_TEXT_ID SN_PICKLIST_MESSAGE_TEXT SN_PICKLIST_MESSAGE_TEXT_ID




Parent Column in SN_PICKLIST_MESSAGE_TEXT (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_MESSAGE_TEXT_ID SN_PICKLIST_MESSAGE_TEXT PARENT_MESSAGE_TEXT_ID


SN_PICKLIST_PREF_CARD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Preference Card Relationship
Definition: Preference Cards used in the generation of the picklist
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_PREF_CARD_R


Column Name Type Null? Definition
ADDED_DT_TM DATETIME Y The date and time the prefernce card was added to the picklist
CATALOG_CD DOUBLE Y The procedure code that caused the preference card to be used for the picklist. Only populated if sn_pref_card_id is populated.
POST_GENERATION_IND DOUBLE N Inidcates that the Preference Card was added to the picklist manually, after the picklist was automatically generated
PREF_CARD_ID DOUBLE N Preference Card Id used to generate the picklist
SN_PICKLIST_ID DOUBLE N The related Surginet Picklist id;
SN_PICKLIST_PREF_CARD_R_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)
SURGEON_ID DOUBLE Y The surgeon associated to the procedure for the prerence card. Used for exception logic. Only applies if sn_pref_card_id is populated.
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.
USER_SELECTED_IND DOUBLE Y Indicates if the user manually selected the preference card to be used instead of using the system defined preference card



Relationship Detail - SN_PICKLIST_PREF_CARD_R


Child Column in SN_PICKLIST_PREF_CARD_R(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
SURGEON_ID PRSNL PERSON_ID
SN_PICKLIST_ID SN_PICKLIST SN_PICKLIST_ID
SN_PREF_CARD_ID SN_PREF_CARD SN_PREF_CARD_ID


SN_PICKLIST_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surginet Picklist Request
Definition: Defines the quantity requested of an item on the picklist for a specified procedure
Table Type: ACTIVITY





Column Detail - SN_PICKLIST_REQUEST


Column Name Type Null? Definition
HOLD_QTY DOUBLE N The quantity of the rquested item that should be picked, but not opened
MERGE_TYPE_FLAG DOUBLE N The type of merging that was done for the item if it was requested for multiple procedures for the surgical case
OPEN_QTY DOUBLE N The quantity of the requested item that should be opened
ORIGINAL_HOLD_QTY DOUBLE N The original hold quantity of the item prior to optimization
ORIGINAL_OPEN_QTY DOUBLE N The original open quantity of the item prior to optimization
ORIGINAL_REQUEST_QTY DOUBLE N The original requested quantity of the item prior to optimization
REQUEST_DT_TM DATETIME N The date/time the request for items was made
REQUEST_QTY DOUBLE N The quantity of the item being requested
SN_PICKLIST_ITEM_ID DOUBLE N The item on the picklist that the quantity is being requested for
SN_PICKLIST_REQUEST_ID DOUBLE N PRIMARY KEY
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


Child Column in SN_PICKLIST_REQUEST(FK) Parent Table Name Parent Column Name
Parents: SN_PICKLIST_ITEM_ID SN_PICKLIST_ITEM SN_PICKLIST_ITEM_ID
SURG_CASE_PROC_ID SURG_CASE_PROCEDURE SURG_CASE_PROC_ID




Parent Column in SN_PICKLIST_REQUEST (PK) Child Table Name Child Column Name
Children: SN_PICKLIST_REQUEST_ID SN_PICKLIST_REQUEST_PC SN_PICKLIST_REQUEST_ID