Table Detail Report
SI_SPECIAL_CONFIGURATION
Column Section | Top of Page |
Table-level Detail
Description: | System Integration Special Configurations |
Definition: | This table stores the definitions of the SI_Manager Special Configurations. |
Table Type: | REFERENCE |
Column Detail - SI_SPECIAL_CONFIGURATION
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS_TYPE_DISPLAY_TXT | VARCHAR(200) | N | This extension works in conjunction with the "Alias Type List" extension. In certain cases, the value in the "Alias Type List" extension will not make sense to the user and a different display is needed. This is the format of the field. " |
ALIAS_TYPE_LIST_TXT | VARCHAR(200) | N | This extension stores available options for alias type meanings, if multiple options are possible. This is the format of the field. " |
CATEGORY_TXT | VARCHAR(40) | N | This is the category for which the related value falls under. For example: Orders, Results, Person/Encounter processing. |
CODE_SET | DOUBLE | N | Special Configuration's Code Set |
CONFIGURATION_CD | DOUBLE | N | Special Configurations Code Value |
CONFIGURATION_CDF_TXT | VARCHAR(12) | N | the CDF_Meaning related to the Code Value used to define this record |
DEF_MEANING_TXT | VARCHAR(20) | N | Certain values require a specified Alias Meaning be set when the code value is activated. This extension stores the expected default Alias Meaning. |
FIELD_TXT | VARCHAR(25) | N | This extension serves multiple purposes. It defines any special processing related to the given code value, for example "ProFit" and the ZM2 code values. It also defines the type of alias required by the related code value Alias Text (If multiple Aliases are possible), Receiving App, and Sending App. Possible values include "Alias Text", "Receiving App", "Sending App", or a pre-defined text that the code has been setup to recognize. |
QUESTION_TXT | VARCHAR(300) | N | This extension holds the question/description of the code value that an alias needs to be set for. |
SECTION_TXT | VARCHAR(40) | N | This is the section for which the related value falls under. The related code value does not require a section to be set if the Category extension is sufficient for placement in the hierarchy. |
SERVER_VERSION_TXT | VARCHAR(20) | N | Indicates which version of the ESI Server is being used. Possible values are "New," "Old," and "Both." |
SI_SPECIAL_CONFIGURATION_ID | DOUBLE | N | Unique Identifier |
SORT_SEQUENCE | DOUBLE | N | Sort Order for the position of the configuration in the display. |
SUBSECTION_TXT | VARCHAR(40) | N | This is the sub-section for which the related value falls under. The related code value does not require a sub-section if either the Section extension was not populated or the Category/Section relationship is sufficient for placement in the hierarchy. |
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_OPTION_TABLE_IND | DOUBLE | N | If the value of this extension is "1", then the code should query the SI_SPECIAL_CONFIG_OPTIONS table for the configured values for the given code value. See the SI_SPECIAL_CONFIG_OPTIONS section for details on this new table. |
SI_SPECIAL_CONFIG_OPTIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Special Configuration Options |
Definition: | Special Configurations for Contributor Systems |
Table Type: | REFERENCE |
Column Detail - SI_SPECIAL_CONFIG_OPTIONS
Column Name | Type | Null? | Definition |
---|---|---|---|
ADDITIONAL_INFO | VARCHAR(255) | N | Additional information related to the answer. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
QUESTION_CD | DOUBLE | N | A code value related to Special Configuration questions from code sets 15769, 18089, 20389, 16089, 28320, 28321, 16091 |
QUESTION_VALUE_TXT | VARCHAR(100) | N | The value related to the question used for the configuration. |
SI_SPECIAL_CONFIG_OPTIONS_ID | DOUBLE | N | 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. |
Relationship Detail - SI_SPECIAL_CONFIG_OPTIONS
Child Column in SI_SPECIAL_CONFIG_OPTIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTRIBUTOR_SYSTEM_CD | CONTRIBUTOR_SYSTEM | CONTRIBUTOR_SYSTEM_CD |
SI_SYSTEM_ORG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration System Organization Relation |
Definition: | This table will store relationships between Contributor Systems, Organizations, and Alias Pools. |
Table Type: | REFERENCE |
Column Detail - SI_SYSTEM_ORG_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS_POOL_CD | DOUBLE | N | This Alias Pool needs to have an OID valued on the SI_OID table to qualify to be selected. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
ORGANIZATION_ID | DOUBLE | N | This is the Organization ID that is part of the relationship between contributor systems and alias pools. This value is required. |
PRIMARY_IND | DOUBLE | N | This is the primary relationship for the system, organization, and alias pool when this indicator is set. |
SI_SYSTEM_ORG_RELTN_ID | DOUBLE | N | Unique Identifier for the SI_SYSTEM_ORG_RELTN 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 - SI_SYSTEM_ORG_RELTN
Child Column in SI_SYSTEM_ORG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
SI_UNMTCHD_PRSN_ALIAS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Unmatched Person Alias |
Definition: | This table will store the aliases related to an inbound message if it can't be matched to an existing person. |
Table Type: | ACTIVITY |
Column Detail - SI_UNMTCHD_PRSN_ALIAS
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS_NAME | VARCHAR(200) | N | Primary Alias from message |
ALIAS_POOL_CD | DOUBLE | N | Alias Pool Code from Message |
ALIAS_TYPE_CD | DOUBLE | N | Alias type code from message |
SI_UNMTCHD_PRSN_ALIAS_ID | DOUBLE | N | PRIMARY KEY IDENTIFIER |
SI_UNMTCHD_PRSN_QUE_ID | DOUBLE | N | Foreign key to si_unmatched_person_qure |
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 - SI_UNMTCHD_PRSN_ALIAS
Child Column in SI_UNMTCHD_PRSN_ALIAS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SI_UNMTCHD_PRSN_QUE_ID | SI_UNMTCHD_PRSN_QUE | SI_UNMTCHD_PRSN_QUE_ID |
SI_UNMTCHD_PRSN_QUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Unmatched Person Queue |
Definition: | This table stores unmatched person records from inbound messages. |
Table Type: | ACTIVITY |
Column Detail - SI_UNMTCHD_PRSN_QUE
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. |
ADDRESS_ID | DOUBLE | N | Home address from the inbound message |
ASSIGNING_PRSNL_ID | DOUBLE | N | Personnel assigning person_id to record |
BIRTH_DT_TM | DATETIME | Y | Date of birth from message |
BIRTH_TZ | DOUBLE | N | Time zone associated with the corresponding BIRTH_DT_TM column. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
GENDER_CD | DOUBLE | N | Gender code from message |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MESSAGE_DT_TM | DATETIME | N | Date the message entered the system |
NAME_FIRST | VARCHAR(200) | N | First name from message |
NAME_LAST | VARCHAR(200) | N | Last name from message |
NAME_MIDDLE | VARCHAR(200) | N | Middle name from message |
NEW_PERSON_IND | DOUBLE | N | Indicates that a new person was created for the unmatched person. |
ORGANIZATION_ID | DOUBLE | N | Organization related to the sending Contributor System |
PERSON_ID | DOUBLE | N | Person related to the Inbound Message |
PROCESS_STATUS_CD | DOUBLE | N | The status of the person match record |
SI_UNMTCHD_PRSN_QUE_ID | DOUBLE | N | Primary Key |
TELEPHONE_NUMBER | VARCHAR(50) | N | Telephone number from message |
UNAUTH_PERSON_ID | DOUBLE | N | Person record used to store message information, will be used to combine into the selected person_id |
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 - SI_UNMTCHD_PRSN_QUE
Child Column in SI_UNMTCHD_PRSN_QUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADDRESS_ID | ADDRESS | ADDRESS_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
ASSIGNING_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in SI_UNMTCHD_PRSN_QUE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SI_UNMTCHD_PRSN_QUE_ID | SI_UNMTCHD_PRSN_ALIAS | SI_UNMTCHD_PRSN_QUE_ID |