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. ";" The ";" is a delimiter between displayed values. It isn't necessary to populate this extension, but if it is to be used then for each value in the "Alias Type List" there must be a corresponding value in this extension.
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. ";" The ";" is a delimiter between stored values. Remember that the extension field is 100 characters in length; steps should be taken to ensure that this length is met, otherwise other options will have to be used.
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