ACCRED_SYSTEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ACCREDITATION SYSTEM |
Definition: | Stored information regarding the accred system. |
Table Type: | REFERENCE |
Column Detail - ACCRED_SYSTEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCRED_SYSTEM_ID | DOUBLE | N | Unique ID associated with an accred system. The value for the ID will be re-generated nightly as the table contents are reloaded (replaced) |
ACCRED_SYSTEM_IDENT | VARCHAR(250) | N | Text identifier associated with an individual Accred_system_id |
INTERACTION_NAME | VARCHAR(250) | N | This value identifies the Interaction name associated with systemColumn |
INTERACTION_VERSION_TEXT | VARCHAR(250) | N | This value identifies the version of the Interaction name that the system supports |
ORGANIZATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It identifies the organization of the service. |
PARTY_KEY_TXT | VARCHAR(250) | N | Identifies a business service within an organization, which could be in the form of OCS-Instance, e.g., D81001-811. |
SERVICE_NAME | VARCHAR(250) | N | Identifies a business service within an organization, which could be in the form of OCS-Instance, e.g., D81001-811. |
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 - ACCRED_SYSTEM
Child Column in ACCRED_SYSTEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
CHARGE_EVENT_ALIAS
Column Section | Top of Page |
Table-level Detail
Description: | This table contains a system's charge event aliases. |
Definition: | Charge Event Alias |
Table Type: | ACTIVITY |
Column Detail - CHARGE_EVENT_ALIAS
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 | VARCHAR(200) | Y | The alias is an identifier for an order. The alias must be unique within an alias type and alias pool code. |
ALIAS_POOL_CD | DOUBLE | N | The alias pool code identifies a unique set or list of order 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. |
CHARGE_EVENT_ALIAS_ID | DOUBLE | N | This is the id for the charge event alias |
CHARGE_EVENT_ALIAS_TYPE_CD | DOUBLE | N | This field defines the type of alias. |
CHECK_DIGIT | DOUBLE | Y | This fields is the alias's check digit. |
CHECK_DIGIT_METHOD_CD | DOUBLE | N | The check digit method code identifies a specific routine, using the alias field, to calculate a check digit. |
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. |
CREDIT_IND | DOUBLE | Y | This field defines if the alias is for a credit (1) or a debit (0). |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
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. |
CONTRIBUTOR_SYSTEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contributor System |
Definition: | The contributor system table contains information which controls the processing specific to each system that is sending transactions and data to be posted in Cerner system database. |
Table Type: | REFERENCE |
Column Detail - CONTRIBUTOR_SYSTEM
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. |
ACT_CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Actual Contributor System Code ValueColumn |
ALT_CONTRIB_SRC_CD | DOUBLE | N | Specifies an alternate coding scheme of coded data used when performing code value alias translation for ESI and ESO transaction processing. Used only when the contributor source code does not find a match. |
AOF_ENABLED_IND | DOUBLE | N | When this field is active, the system states that code values will be added on the fly when possible. |
AUTHORIZATION_TYPE_CD | DOUBLE | N | The method used for the authorizing messages for this contributor system. |
AUTHORIZATION_URL | VARCHAR(255) | N | The URL for authorization information. |
AUTO_COMBINE_IND | DOUBLE | Y | When set on an authenticated feed, this logic will reconcile patients between the same or different contributor systems. It will reconcile all the records that meet the criteria set for "validate for authenticated combine" and "validate for unauthenticated combine" in the Reconcile tab of the ESI Configuration tool. |
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. |
CLIENT_IDENT | VARCHAR(100) | Y | Stores the clientId details to contributor_system table. ; Identifies the globally-unique identifier of the client application.; Values are of type UTF8(STRING). Values SHALL not exceed 100 characters in length. |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | Specifies the default coding scheme of coded data when performing code value alias translation for ESI and ESO transaction processing. |
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. |
CONTR_MODE_CD | DOUBLE | N | A description of the workflow that the contributor system is built for (ex: History, Batch, Real-time, etc). |
CONTR_SYS_TYPE_CD | DOUBLE | N | Indicates the contributor system is an AUTHENTICATED (more complete) or UNAUTHENTICATED (less complete) source of data for person and encounter information. |
DISPLAY | VARCHAR(40) | Y | DisplayColumn |
DOC_EVENT_CLASS_CD | DOUBLE | N | The event class code to use when the event_class_source_flag = 2 (Integrated departmental documents). |
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. |
ENHANCED_PROCESSING_CD | DOUBLE | N | Additonal processing occurs with this value is set. |
ESI_LOG_BITMAP | DOUBLE | N | This field defines the interaction between the ESI_LOG and LONG_BLOB tables for messages generated through the ESI Java server. |
ESI_ORG_ALIAS_CD | DOUBLE | N | Identifies the field in the HL7 transaction that contains the alias to the encounter organization. |
ESI_SPECIAL_SOURCE_FLAG | DOUBLE | N | Describes if and how a special coding system should be processed inbound. |
ESO_SPECIAL_SOURCE_FLAG | DOUBLE | N | Describes if and how a special coding system should be sent outbound. |
EVENT_CLASS_SOURCE_FLAG | DOUBLE | Y | Used for transcription interfaces to determine how to define the parent event class. The options are: Generic MDM documents (default), Generic and Departmental MDM documents, and Integrated Radiology MDM documents. |
GROUPER_HOLD_TIME | DOUBLE | N | An integer number of seconds to wait until releasing orders from the Grouper Server. Default value = 0. If greater than 0, this value will override the SCP release time on the ESI Server. |
GROUPER_MULTI_ORDS_IND | DOUBLE | N | Provides the ability to group orders without using timeframe or number of orders. With this option, an indicator must be sent in OBR-4 to notify the Grouper Server to release the orders for that encounter. |
IO_RESULT_IND | DOUBLE | N | Indicates whether the IO results from interface will be posted to CE_INTAKE_OUTPUT_RESULT table |
LISTENER_ALIAS | VARCHAR(48) | N | The selected Listener Alias is used for Outbound Document Processing through devices associated to this Contributor System |
LOC_FACILITY_CD | DOUBLE | N | This field is the current patient location with a location type of facility. |
MAX_GROUPER_ORDERS | DOUBLE | N | The maximum integer number of orders to hold in the Grouper Server. Default value = 0. If greater than 0, this value will override the SCP release time on the ESI Server. |
MESSAGE_FORMAT_CD | DOUBLE | N | The format of the message, such as HL7, X12. |
MICRO_LIST_REPLACE_FLAG | DOUBLE | Y | For discrete microbiology results, determines how ESI will process updates to organisms and susceptibilities on the ce_susceptibility and/or ce_microbiology rows. The default will not do snapshot processing, but instead will update existing rows or add new rows. |
MICRO_MULTI_INTERP_IND | DOUBLE | Y | For discrete microbiology results, allows ESI to post multiple interps per antibiotic. |
OPF_MATCH_THRESHOLD | VARCHAR(3) | Y | Probabilistic matching weight required for contributor system to determine two people are duplicates and need to be auto combined |
OPF_REPORT_THRESHOLD | VARCHAR(3) | Y | Probabilistic matching weight required for contributor system to determine two people should show on the person matches report to be manually reviewed at a later time |
ORGANIZATION_ID | DOUBLE | N | Identifies the organization associated with the contributor system (feed). This value is the primary identifier of the organization table. |
PRSNL_PERSON_ID | DOUBLE | N | Personnel Person IDColumn |
RESULT_ALIAS_IND | DOUBLE | Y | Describes whether the alias will be used to find an orderable (as defined by order catalog) or event code alias. |
SYS_DIRECTION_CD | DOUBLE | N | Specifies the direction or usage of the contributor system. |
TIME_ZONE | VARCHAR(100) | Y | Default time zone to use for UTC processing if Time Zone Flag is set and no offsets are sent in the HL7 message. |
TIME_ZONE_FLAG | DOUBLE | Y | Determines if ESI will use time zone information from the contributor_system table or use offsets sent in the HL7 message to adjust the time for UTC or other time zone processing. |
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 - CONTRIBUTOR_SYSTEM
Child Column in CONTRIBUTOR_SYSTEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTRIBUTOR_SYSTEM_CD | CODE_VALUE | CODE_VALUE |
LOC_FACILITY_CD | LOCATION | LOCATION_CD | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PRSNL_PERSON_ID | PRSNL | PERSON_ID |
Parent Column in CONTRIBUTOR_SYSTEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONTRIBUTOR_SYSTEM_CD | DISPENSE_HX | CONTRIBUTOR_SYSTEM_CD |
ESI_ALIAS_TRANS | CONTRIBUTOR_SYSTEM_CD | ||
ESI_ENSURE_PARMS | CONTRIBUTOR_SYSTEM_CD | ||
MATCH_TAG_PARMS | CONTRIBUTOR_SYSTEM_CD | ||
ORG_CONTRIBUTOR_SYS_RELTN | CONTRIBUTOR_SYSTEM_CD | ||
PERSON_PHR_RELTN | CONTRIBUTOR_SYSTEM_CD | ||
PERSON_PHR_RELTN_HIST | CONTRIBUTOR_SYSTEM_CD | ||
PFT_ENCNTR_COLLECTION_RELTN | CONTRIBUTOR_SYSTEM_CD | ||
SI_CONTRIBUTOR_SYSTEM_HIST | CONTRIBUTOR_SYSTEM_CD | ||
SI_CUSTOM_CDG_LOG | CONTRIBUTOR_SYSTEM_CD | ||
SI_SPECIAL_CONFIG_OPTIONS | CONTRIBUTOR_SYSTEM_CD | ||
SI_XDOC_QUERY_PERSON_RELTN | CONTRIBUTOR_SYSTEM_CD |
ESI_ALIAS_TRANS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ESI Alias Translation |
Definition: | The ESI alias translation table contains information that determines which data fields from the incoming transaction will be used as alias identifiers in the HNA system. |
Table Type: | REFERENCE |
Column Detail - ESI_ALIAS_TRANS
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_ENSURE_PARMS_FLAG | DOUBLE | N | This flag is used in conjunction with the PERSON_ALIAS_ENSURE_TYPE_CD and the ENCNTR_ALIAS_ENSURE_TYPE_CD on the ESI_ENSURE_PARMS table to determine which alias rows are eligible for the 'override' logic provided by these 'alias' ensure type codes. The options are eligible or not eligible (default). |
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_FILTER_CD | DOUBLE | N | The filter method applied to the alias value (trim leading zeroes or trim trailing spaces and leading zeroes) before posting the alias value to the database. |
ALIAS_POOL_CD | DOUBLE | N | Alias pool code identifies a unique set or list of identifiers. |
ASSIGN_AUTHORITY_SYS_CD | DOUBLE | N | This field determines whether an alias will release an item from the hold queue. |
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. |
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. |
ELIGIBLE_FOR_QUERY_IND | DOUBLE | N | Indicates that this alias is eligible to be sent out for MPI queries. |
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. |
ESI_ALIAS_FIELD_CD | DOUBLE | N | The HL7 or X12 message field containing the alias identifier (such as PID-2-External Identifier, PID-3-Internal Identifier). |
ESI_ALIAS_TRANS_ID | DOUBLE | N | Unique identifier for the ESI_ALIAS_TRANS table. |
ESI_ALIAS_TYPE | VARCHAR(50) | Y | The alias type literal found in the message field containing the alias identifier. When valued it will be used to assist in identifying the alias row that defines the alias pool code and other processing options. For example in PID-3, the 5th component of the CX data type contains the alias type literal. |
ESI_ASSIGN_AUTH | VARCHAR(50) | Y | The assigning authority literal found in the message field containing the alias identifier. When valued it will be used to assist in identifying the alias row that defines the alias pool code and other processing options. For example in PID-3, the 4th component of the CX data type contains the assigning authority literal. When the literal is also an alias to an assigning authority organization, the SI Manager will flex the list of alias pool codes available for selection in this row. |
ESI_ASSIGN_FAC | VARCHAR(50) | Y | The place or location identifier where the identifier was first assigned to the patient. This component is not an inherent part of the identifier, but rather a part of the history of the identifier. |
ESI_SOURCE | VARCHAR(50) | Y | The personnel source literal found in the message field containing the personnel identifier. It is used to represent the personnel type and/or source. When valued it will be used to assist in identifying the alias row that defines the alias pool code and other processing options. When the literal is also an alias to an assigning authority organization, the SI Manager will flex the list of alias pool codes available for selection in this row. |
PERSON_PROC_OPT_CD | DOUBLE | N | Options for processing person information via ESI. |
PRSNL_FT_STRING | VARCHAR(50) | Y | The specified alias value that identifies this personnel as free-text, such as '99999'. |
PRSNL_PROC_OPT_CD | DOUBLE | N | This option defines how and when the interface will match existing personnel, create new 'add on the fly' personnel, and insert personnel relationship rows. |
SKIP_STRING | VARCHAR(100) | Y | A specified alias value to ignore during processing. |
TRUNC_SIZE | DOUBLE | Y | The number of characters of the alias field that remain after truncation, but before any alias filters are applied. For example, 000444 becomes 0004 when the trunc_size = 4. This is not a recommended option. Also used for the Pharmacy IVR prescription validation when the alias filter is First or Last. |
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 - ESI_ALIAS_TRANS
Child Column in ESI_ALIAS_TRANS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALIAS_POOL_CD | ALIAS_POOL | ALIAS_POOL_CD |
CONTRIBUTOR_SYSTEM_CD | CONTRIBUTOR_SYSTEM | CONTRIBUTOR_SYSTEM_CD |
ESI_ENSURE_PARMS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ESI Ensure Parameters |
Definition: | The ESI alias translation table contains information that determines by contributor system and transaction type the add, update and delete privilege for person, encounter, and event data groups. |
Table Type: | REFERENCE |
Column Detail - ESI_ENSURE_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. |
ALLERGY_SEGMENT_ENS_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal encounter ensure configuration. For a given transaction, if the Encounter Ensure would prevent the add or update of encounter data, the allergy segment ensure will override and allow allergy segments (AL1 and ZAL) to be processed. The only valid values are ADD and 0. |
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. |
CODING_SEGMENT_ENS_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal encounter ensure configuration. For a given transaction, if the Encounter Ensure would prevent the add or update of encounter data, the coding segment ensure will override and allow coding segments (DG1, DRG ad PR1) to be processed. The only valid values are ADD and 0. |
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. |
ENCNTR_ALIAS_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal encounter ensure configuration. For a given transaction, if the Encounter Ensure would prevent the add or update of encounter data, the Encounter Alias Ensure would override and allow a new encounter alias to be added. This ENSURE is used in conjunction with the ALIAS_ENSURE_PARMS_FLAG on the ESI_ALIAS_TRANS table. The only valid values are ADD and 0. |
ENCNTR_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option identifies the database update privilege level for updating encounter data. Examples of these options are: ADD, UPDATE, EXISTS. |
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. |
ESI_ENSURE_PARMS_ID | DOUBLE | N | Unique identifier for the ESI_ENSURE_PARMS table. |
ESI_TASK_CD | DOUBLE | N | ESI task identifies the HL7 trigger event (transaction type) such as Admit, Discharge, Transfer, etc. |
EVENT_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option identifies the database update privilege level for updating event data. Examples of these options are: ADD, UPDATE, REPLACE. |
NK1_SEGMENT_ENS_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal ensure configuration for authenticated persons. For a given transaction, with the Person or Encounter Ensure set to add or update, the processing of authenticated persons do not update the person data in the database. With this option set, if there is an authenticated match found, then the authenticated person will be ensured from the NK1 segment information. The only valid values are UPDATE and 0. |
ORDER_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option is used to know when to find and update an order status during clinical event processing. The only valid values are "complete for ORU message" and 0. |
PERSON_ALIAS_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal person ensure configuration. For a given transaction, if the Person Ensure would prevent the add or update of person data, the Person Alias Ensure would override and allow a new Person alias to be added. This parameter is used in conjunction with the ALIAS_ENSURE_PARMS_FLAG on the ESI_ALIAS_TRANS table. The only valid values are ADD and 0. |
PERSON_ENSURE_TYPE_CD | DOUBLE | N | This ENSURE option identifies the database update privilege level for updating person level data. Examples of these options are: ADD, UPDATE, EXISTS. |
PROBLEM_SEGMENT_ENS_TYPE_CD | DOUBLE | N | This ENSURE option provides the ability to override the normal encounter ensure configuration. For a given transaction, if the Encounter Ensure would prevent the add or update of encounter data, the problem segment ensure will override and allow problem segments (PRB) to be processed. The only valid values are ADD and 0. |
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 - ESI_ENSURE_PARMS
Child Column in ESI_ENSURE_PARMS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTRIBUTOR_SYSTEM_CD | CONTRIBUTOR_SYSTEM | CONTRIBUTOR_SYSTEM_CD |