EHI Export Data Dictionary

AP_ContactEntry

21 columns Original: AP_ContactEntry.html Checked Nov 11, 2026, 7:22 PM CST

Column	Expanded name	Description
`ContactEntryID`	Contact Entry Details	Unique identifier for each contact entry record.
`AppearOrder`	Appear Order	The order in which the contact appears in lists or reports.
`ContactID`	Contact Details	Unique identifier for the contact associated with the entry.
`ContactTypeID`	Contact Type Details	Identifier indicating the type of contact, such as personal, business, etc.
`DateFrom`	Date From	The start date from which the contact information is valid.
`DateTo`	Date To	The end date until which the contact information is valid.
`IsActive`	Is Active	Indicates whether the contact information is currently active.
`IsActiveDate`	Is Active Date	The date on which the contact information was marked as active.
`Notes`	Notes	Additional notes or comments associated with the contact entry.
`RecptID`	Recipient Details	Unique identifier for the recipient of contact information.
`RecptTypeID`	Recipient Type Details	Identifier indicating the type of recipient, such as patient, provider, etc.
`RelationshipID`	Relationship Details	Unique identifier denoting the relationship between the contact entry and other entries or individuals in the system.
`VendorID`	Vendor Details	Unique identifier for the vendor associated with the contact, if applicable.
`ZUChkSum`	ZU Checksum	Checksum value used for data integrity verification in audit logs.
`ZUDate`	ZU Date	Date on which the last update was made in the audit logs.
`ZULogonHisID`	ZULogon History Details	Identifier for the logon history record associated with the user who made the last update.
`ContactName`	Contact Name	The full name of the contact associated with the entry.
`ContactEmail`	Contact Email	The email address of the contact.
`ContactTypeName`	Contact Type Name	The descriptive name of the contact type.
`Unnamed: 19`	Unnamed: 19	Reserved column for future use or data that is not currently categorized.
`RelationshipName`	Relationship Name	The descriptive name of the relationship associated with the contact entry.