SN_PREF_CARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: SugiNet Preference Card
Definition: Surgical Preference Card to define attributes (items, comments, etc.) for a surgical procedure
Table Type: REFERENCE





Column Detail - SN_PREF_CARD


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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ARCHIVED_DT_TM DATETIME Y The date and time the preference card was archived;
ARCHIVED_IND DOUBLE N Indicates whether the card is valid or has temporarily been archived;
ARCHIVED_PRSNL_ID DOUBLE N The user who marked the Preference Card as being archived;
CREATE_DT_TM DATETIME N The date and time the preference card was created;
CREATE_PRSNL_ID DOUBLE N The user who created the Preference Card;
PREF_CARD_DESCRIPTION VARCHAR(500) Y Description of the Preference Card;
PREF_CARD_NAME VARCHAR(150) N Name of the Preference Card;
PREF_CARD_NAME_KEY VARCHAR(150) N Indexed name of preference Card;
SN_PREF_CARD_ID DOUBLE N PRIMARY KEY
SURG_AREA_CD DOUBLE N Surgical Area Code;
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_PREF_CARD


Child Column in SN_PREF_CARD(FK) Parent Table Name Parent Column Name
Parents: SURG_AREA_CD CODE_VALUE CODE_VALUE
ARCHIVED_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in SN_PREF_CARD (PK) Child Table Name Child Column Name
Children: SN_PREF_CARD_ID SCHED_CASE_PICK_LIST SN_PREF_CARD_ID
SN_PICKLIST_PREF_CARD_R SN_PREF_CARD_ID
SN_PICKLIST_REQUEST_PC SN_PREF_CARD_ID
SN_PREF_CARD_COMMENT SN_PREF_CARD_ID
SN_PREF_CARD_EXCEPTION SN_PREF_CARD_ID
SN_PREF_CARD_ITEM SN_PREF_CARD_ID
SN_PREF_CARD_LOCK SN_PREF_CARD_ID
SN_PREF_CARD_MODIFY_HIST SN_PREF_CARD_ID
SN_PREF_CARD_PROCEDURE SN_PREF_CARD_ID


SN_PREF_CARD_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SugiNet Preference Card Exception Comment
Definition: Defines comment changes for an exception
Table Type: REFERENCE





Column Detail - SN_PREF_CARD_COMMENT


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME N Date Time when the active ind was changed
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.
ACTIVE_PRSNL_ID DOUBLE Y user who activated the row
COMMENT_TXT LONGTEXT Y The text value for the comment being defined;
COMMENT_TYPE_CD DOUBLE N The type of comment being defined;
CREATE_DT_TM DATETIME N Date Time the comment was created;
CREATE_PRSNL_ID DOUBLE N User who created the comment for the preference card;
SN_PREF_CARD_COMMENT_ID DOUBLE N PRIMARY KEY
SN_PREF_CARD_ID DOUBLE Y Preference Card the attribute is being defined 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_PREF_CARD_COMMENT


Child Column in SN_PREF_CARD_COMMENT(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
SN_PREF_CARD_ID SN_PREF_CARD SN_PREF_CARD_ID


SN_PREF_CARD_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SugiNet Preference Card Exception
Definition: Defines what exceptions exist for a Preference Card
Table Type: REFERENCE





Column Detail - SN_PREF_CARD_EXCEPTION


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME N Date and Time the exception was made active or inactive;
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.
ACTIVE_PRSNL_ID DOUBLE Y user who activated the row
CREATE_DT_TM DATETIME N Date and Time the exception was created;
CREATE_PRSNL_ID DOUBLE N User who created the exception;
EXCEPTION_TYPE_FLAG DOUBLE N Defines what the exception is tied to (ex. Surgeon, Specialty, etc.);
PARENT_ENTITY_ID DOUBLE N Parent Table PK the exception applies to;
PARENT_ENTITY_NAME VARCHAR(30) N Parent Table Name the exception applies to;
SN_PREF_CARD_EXCEPTION_ID DOUBLE N PRIMARY KEY
SN_PREF_CARD_ID DOUBLE Y Preference Card the exception is 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_PREF_CARD_EXCEPTION


Child Column in SN_PREF_CARD_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
SN_PREF_CARD_ID SN_PREF_CARD SN_PREF_CARD_ID




Parent Column in SN_PREF_CARD_EXCEPTION (PK) Child Table Name Child Column Name
Children: SN_PREF_CARD_EXCEPTION_ID SN_PREF_CARD_EXCEPT_ADD SN_PREF_CARD_EXCEPTION_ID
SN_PREF_CARD_EXCEPT_COMMENT SN_PREF_CARD_EXCEPTION_ID
SN_PREF_CARD_EXCEPT_REMOVE SN_PREF_CARD_EXCEPTION_ID


SN_PREF_CARD_EXCEPT_ADD



Column Section Relationship Section Top of Page


Table-level Detail

Description: SugiNet Preference Card Exception Add
Definition: Defines what items are added or modified for an exception
Table Type: REFERENCE





Column Detail - SN_PREF_CARD_EXCEPT_ADD


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME N Date and Time the item exception was made active or inactive;
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.
ACTIVE_PRSNL_ID DOUBLE Y User who changed the active status
CREATE_DT_TM DATETIME N Date and Time the item exception was created;
CREATE_PRSNL_ID DOUBLE N User who created the item exception;
HOLD_QTY DOUBLE N The quantity of the item that should be picked but not opened;
ITEM_ID DOUBLE N The item being added or modified on the exception
OPEN_QTY DOUBLE N The quantity of the item that should be opened
SN_PREF_CARD_EXCEPTION_ID DOUBLE Y Preference Card Exception the item is for;
SN_PREF_CARD_EXCEPT_ADD_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_PREF_CARD_EXCEPT_ADD


Child Column in SN_PREF_CARD_EXCEPT_ADD(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
SN_PREF_CARD_EXCEPTION_ID SN_PREF_CARD_EXCEPTION SN_PREF_CARD_EXCEPTION_ID


SN_PREF_CARD_EXCEPT_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SugiNet Preference Card Exception Comment
Definition: Defines comment changes for an exception
Table Type: REFERENCE





Column Detail - SN_PREF_CARD_EXCEPT_COMMENT


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME N Date and Time the comment exception was made active or inactive
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.
ACTIVE_PRSNL_ID DOUBLE Y User who changed the active status of the row
COMMENT_TXT LONGTEXT Y The comment text that should be set for the exception
COMMENT_TYPE_CD DOUBLE N The comment type being added or modified on the exception;
CREATE_DT_TM DATETIME N Date and Time the comment exception was created;
CREATE_PRSNL_ID DOUBLE N User who created the comment exception;
SN_PREF_CARD_EXCEPTION_ID DOUBLE Y Preference Card Exception the item is for
SN_PREF_CARD_EXCEPT_COMMENT_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_PREF_CARD_EXCEPT_COMMENT


Child Column in SN_PREF_CARD_EXCEPT_COMMENT(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
SN_PREF_CARD_EXCEPTION_ID SN_PREF_CARD_EXCEPTION SN_PREF_CARD_EXCEPTION_ID