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