Table Detail Report

ESI_STATISTIC



Column Section Top of Page


Table-level Detail

Description: ESI STATISTIC
Definition: Keeps statistics for ESI Server transactions
Table Type: ACTIVITY





Column Detail - ESI_STATISTIC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ADD_CODE_VALUE_CNT DOUBLE Y Code Values added by this contributor systemColumn
ADD_HEALTH_PLAN_CNT DOUBLE Y Health Plans added by this contributor systemColumn
ADD_ORGANIZATION_CNT DOUBLE Y Organizations added by this contributor systemColumn
ADD_PRSNL_CNT DOUBLE Y Prsnl added by this contributor systemColumn
AUTO_RECONCILE_CNT DOUBLE Y Auto reconciles performed on transactions from this contributor systemColumn
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE Y 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.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ESI_STATISTIC_ID DOUBLE N ESI Statistic IDColumn
LAST_UPDT_DT_TM DATETIME Y Last date and time this row was updatedColumn
NEW_ENCNTR_CNT DOUBLE Y New encounters added by this contibutor system
NEW_PERSON_CNT DOUBLE Y New persons added by this contributor system
TRANSACTION_CNT DOUBLE Y Transactions received from this contributor systemColumn
UPDT_ENCNTR_CNT DOUBLE Y Encounters updated by this contributor systemColumn
UPDT_PERSON_CNT DOUBLE Y Person updated by this contributor system


MATCH_TAG_PARMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Match & Tag Parameters
Definition: The match & tag parameter table contains processing parameters by contributor system. These parameters define which fields are used when attempting to find a match between the person on the incoming transaction and an existing person in the database.
Table Type: REFERENCE





Column Detail - MATCH_TAG_PARMS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIAS_ENTITY_ALIAS_TYPE_CD DOUBLE N This field represents the identifier type, such as internal identifier type or alias type. The specific code set for the identifier type varies and corresponds to the alias_entity_name attribute within the same row.
ALIAS_ENTITY_NAME VARCHAR(32) Y This field represents the parent table for which the alias identifier, internal identifier or other identifier type will be created or found.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of identifiers.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BILLING_IND DOUBLE Y Determines the value of the billing indicator (BILL_ORD_NBR_IND) on the order alias table.
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.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MATCH_FIELD_CD DOUBLE N The identifier or demographic element that is used during the match or reconciliation process.
MATCH_FUNCTION_CD DOUBLE N The validation routine used during the match or reconciliation process, such as Order Match, GT1 Person Match, or Person Match (Authenticated Records).
MATCH_SEQ DOUBLE N Match Sequence
MATCH_TAG_PARMS_ID DOUBLE N Unique identifier for the MATCH_TAG_PARMS table.
MATCH_VALIDATION_CD DOUBLE N This code helps to determine what action will be performed if a field in the message does not match the same field of an existing row in a table. For example, Match Required or Warn Mismatch.
OPF_IND DOUBLE Y Indicates whether this match and tag parameter is used by OPF for its probabilistic matching routine.
ORDER_CONTROL_CD DOUBLE N Enables different order match criteria based on the order control code transmitted in the HL7 message.
PRIM_ALIAS_IND DOUBLE Y Used to identify the primary alias or identifier used for match processing.
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.
WEIGHT DOUBLE Y Determines the weight given to the particular match and tag parameter as used by OPF for its probabilistic matching routine.



Relationship Detail - MATCH_TAG_PARMS


Child Column in MATCH_TAG_PARMS(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD
CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD


ORG_CONTRIBUTOR_SYS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Contributor System Relationship
Definition: The organization-contributor system relationship table contains the relationships between organizations from the organization table and contributor systems from the contributor system table. The kind of relationships defines how the organization and contributor system are related.
Table Type: REFERENCE





Column Detail - ORG_CONTRIBUTOR_SYS_RELTN


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.
AUTHORIZATION_TYPE_CD DOUBLE N The standard used to determine if the organization is authorized to access the contributing system
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONSENT_POLICY_ID DOUBLE N Foreign key to the ppr_consent_policy table to identify the policy associated with the contributor system and organization
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.
DOMAIN_ADDR VARCHAR(255) N A URL associated with the contributing system
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INFO_SUB_TYPE_CD DOUBLE N This column stores what type of information is written to the row.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
ORG_CONTRIBUTOR_SYS_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the organization-contributor system relationship table. It is an internally assigned number and generally not revealed to the user.
RELTN_TYPE_CD DOUBLE N Code value indicating the type of relationship (I.e., PHR)
UDF_CONSENT_CD DOUBLE N Contains the user defined, granted consent code value.
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 - ORG_CONTRIBUTOR_SYS_RELTN


Child Column in ORG_CONTRIBUTOR_SYS_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
CONSENT_POLICY_ID PPR_CONSENT_POLICY CONSENT_POLICY_ID


SI_ALIAS_FLD_CONTR_SRC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Alias Field Contributor Source Relation
Definition: This table contains relations between alias fields and contributor sources.
Table Type: REFERENCE





Column Detail - SI_ALIAS_FLD_CONTR_SRC_R


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_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIAS_FLD_CONTR_SRC_R_ID DOUBLE N Alias Field Contributor Source Identifier. Primary Key.
CONTRIBUTOR_SOURCE_CD DOUBLE N The contributor source that should be used for the alias field
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. Contributor System Code
FIELD_CD DOUBLE N The alias field that should use the special coding system
FIELD_NAME VARCHAR(256) Y Name of the segment in which the alias field is located
SEGMENT_NAME VARCHAR(256) Y Name of the segment in which the alias field is located
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_ALIAS_FLD_CONTR_SRC_R




Parent Column in SI_ALIAS_FLD_CONTR_SRC_R (PK) Child Table Name Child Column Name
Children: ALIAS_FLD_CONTR_SRC_R_ID SI_HIST_ALIAS_FLD_CONTR_SRC_R ALIAS_FLD_CONTR_SRC_R_ID


SI_BATCH_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds all the batch events.
Definition: Each row corresponds to a event for a given batch.
Table Type: ACTIVITY





Column Detail - SI_BATCH_EVENT


Column Name Type Null? Definition
BATCH_EVENT_ID DOUBLE N Unique batch event identifier.
BATCH_ID DOUBLE N Unique batch identifier.
BATCH_SORT_FLAG DOUBLE Y Indicates the event type.
SORT_STRING VARCHAR(255) Y String in which the batch events can be sorted on.
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_BATCH_EVENT


Child Column in SI_BATCH_EVENT(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID SI_BATCH BATCH_ID




Parent Column in SI_BATCH_EVENT (PK) Child Table Name Child Column Name
Children: BATCH_EVENT_ID BILL_REC BATCH_EVENT_ID
ESI_LOG BATCH_EVENT_ID
SI_BATCH_EVENT_SYS BATCH_EVENT_ID