Table Detail Report
SN_NOMEN_ST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SN_NOMEN_ST |
Definition: | Table will store Nomenclature's documented at the "case" and "procedure" level |
Table Type: | ACTIVITY |
Column Detail - SN_NOMEN_ST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTUAL_IND | DOUBLE | N | Indicates whether this row holds scheduled data (0) or documented data (1) |
DIAGNOSIS_DISPLAY | VARCHAR(255) | N | Holds the nomenclature string if NOMENCLATURE_ID is supplied, otherwise, holds the free text user entered for the diagnosis |
DIAGNOSIS_IDENTIFIER | VARCHAR(50) | N | Holds the nomenclature identifier if NOMENCLATURE_ID is supplied, otherwise, is empty |
NOMENCLATURE_ID | DOUBLE | N | The nomenclature(s) value when the case was finalized |
NOMENCLATURE_SEQ | DOUBLE | N | The order the nomenclature(s) were listed when the case was finalized |
POSTOP_IND | DOUBLE | N | Indicates whether this nomenclature is PreOp (0), or PostOp (1) |
SN_NOMEN_ST_ID | DOUBLE | N | PRIMARY KEY |
SURG_CASE_ID | DOUBLE | N | Foreign key to the SURGICAL_CASE table. This identifiers the surgical case containing nomenclature(s) at either the case level, procedure level or both. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - SN_NOMEN_ST
Child Column in SN_NOMEN_ST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
SURG_CASE_ID | SURGICAL_CASE | SURG_CASE_ID |
SN_PREFCARD_MPAGE_SNOOZE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | sn_pref_card_mpage_snooze |
Definition: | SurgiNet Preference Card MPage Snooze Table |
Table Type: | ACTIVITY |
Column Detail - SN_PREFCARD_MPAGE_SNOOZE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | N | action snoozed: 0 - modify, 1 - add, 2 - remove |
CREATE_DT_TM | DATETIME | Y | date time user snoozed the action |
EXPIRATION_DT_TM | DATETIME | Y | date snooze expires |
ITEM_ID | DOUBLE | N | item being snoozed on prefcard by user |
PREF_CARD_ID | DOUBLE | N | prefcard having item snoozed by user |
SN_PREFCARD_MPAGE_SNOOZE_ID | DOUBLE | N | Unique generated number that identifies a single row on the table. Primary Key. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
USER_ID | DOUBLE | N | user snoozing action on item on prefcard |
Relationship Detail - SN_PREFCARD_MPAGE_SNOOZE
Child Column in SN_PREFCARD_MPAGE_SNOOZE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_MASTER | ITEM_ID |
PREF_CARD_ID | PREFERENCE_CARD | PREF_CARD_ID | |
USER_ID | PRSNL | PERSON_ID |
SN_PREFS
Column Section | Top of Page |
Table-level Detail
Description: | SurgiNet Preferences |
Definition: | This tables contains system preferences for SurgiNet applications |
Table Type: | REFERENCE |
Column Detail - SN_PREFS
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | Parent Entity ID |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Parent Entity Name |
PREF_DOMAIN | VARCHAR(60) | Y | Preference Domain |
PREF_ID | DOUBLE | N | Preference ID |
PREF_NAME | VARCHAR(60) | N | Preference Name |
PREF_SECTION | VARCHAR(60) | Y | Preference Section |
PREF_VALUE_CD | DOUBLE | N | Preference Value Code |
PREF_VALUE_DT_TM | DATETIME | Y | Preference Value Date/Time |
PREF_VALUE_ID | DOUBLE | N | Preference Value ID |
PREF_VALUE_NAME | VARCHAR(32) | Y | Preference Value Name |
PREF_VALUE_NBR | DOUBLE | Y | Preference Value Number |
PREF_VALUE_STR | VARCHAR(255) | Y | Preference Value String |
REFERENCE_IND | DOUBLE | N | Reference Indicator |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
SN_PRIV
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SN PRIV |
Definition: | Contains all privileging information for SurgiNet applications. |
Table Type: | REFERENCE |
Column Detail - SN_PRIV
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESS_FLAG | DOUBLE | N | Indicates the type of access to the specified application for a given person or position. |
APPLICATION_NUMBER | DOUBLE | N | The application that this privilege applies to. |
CREATE_APPLCTX | DOUBLE | Y | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | Y | The date and time the row was initially inserted. |
CREATE_PRSNL_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. |
CREATE_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted or updated the row. |
PARENT_ENTITY_ID | DOUBLE | N | The primary key ID of the table in the PARENT_ENTITY_NAME that this privilege belongs to. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | The name of the table this privilege is associated with. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
POSITION_CD | DOUBLE | N | The position code value that this privilege applies to. |
PRIV_ID | DOUBLE | N | The primary key ID for this table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - SN_PRIV
Child Column in SN_PRIV(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
SN_PRIV_APP_REF
Column Section | Top of Page |
Table-level Detail
Description: | Reference table holding applications for a given privilege type. |
Definition: | This table holds the applications that are available for building privileges of a specific type. |
Table Type: | REFERENCE |
Column Detail - SN_PRIV_APP_REF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESS_FLAG | DOUBLE | N | Indicates the type of access to the specified application for a given person or position. |
APPLICATION_NUMBER | DOUBLE | N | The number off of the APPLICATION table for an application that will be used for a privilege type. |
PARENT_ENTITY_ID | DOUBLE | N | The _id of the reference object in the table listed in PARENT_ENTITY_NAME that needs to have applications attached to it. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the table that this privilege type refers to. |
PRIV_APP_REF_ID | DOUBLE | N | The primary key for this table. |
PRIV_TYPE_NAME | VARCHAR(32) | N | The name of the privilege type that these applications are available for. Typically, this is the name of another table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |