EHI Export Data Dictionary
HC_ApptTrail
Health Care Data for Appointment Trail
| Column | Expanded name | Description |
|---|---|---|
ApptTrailID |
Appointment Trail Details | Contains detailed information or identifiers for the corresponding appointment trail. |
ApptDate |
Appointment Date | Specifies the date associated with the appointment event or record. |
ApptID |
Appointment Details | Contains detailed information or identifiers for the corresponding appointment. |
ChangesFlag |
Changes Flag | Indicates any modifications or updates in the changes flag. |
IsTracking |
Is Tracking | Provides information related to is tracking. |
PtID |
Patient Details | Contains detailed information or identifiers for the corresponding patient. |
ResID |
Res Details | Contains detailed information or identifiers for the corresponding res. |
ResTypeID |
Res Type Details | Contains detailed information or identifiers for the corresponding res type. |
SiteID |
Site Details | Contains detailed information or identifiers for the corresponding site. |
StatusID |
Status Details | Contains detailed information or identifiers for the corresponding status. |
TrackTime |
Track Time | Provides information related to track time. |
TrailChanges |
Trail Changes | Indicates any modifications or updates in the trails. |
TrailProcs |
Trail Procs | Provides information related to trail procs. |
TrailNote |
Trail Note | Provides information related to trail note. |
TrailTimeStamp |
Trail Time Stamp | Provides information related to trail time stamp. |
TrailTypeID |
Trail Type Details | Contains detailed information or identifiers for the corresponding trail type. |
UserID |
User Details | Contains detailed information or identifiers for the corresponding user. |
ZUChkSum |
ZUChk Sum | Provides information related to zuchk sum. |
ZUDate |
ZUDate | Specifies the date associated with the zudate event or record. |
ZULogonHisID |
ZULogon History Details | Records the historical data or changes related to the zulogon details. |
ApptID.1 |
Appointment ID.1 | Provides information related to appointment id.1. |
ApptExID |
Appointment Exception Details | Contains detailed information or identifiers for the corresponding appointment exception. |
ApptGroupID |
Appointment Group Details | Contains detailed information or identifiers for the corresponding appointment group. |
ApptStatusID |
Appointment Status Details | Contains detailed information or identifiers for the corresponding appointment status. |
ApptStatusSecID |
Appointment Status Security Details | Contains detailed information or identifiers for the corresponding appointment status security. |
ApptPayment |
Appointment Payment | Provides information related to appointment payment. |
DateAppt |
Date Appointment | Specifies the date associated with the date appointment event or record. |
RecallID |
Recall Details | Contains detailed information or identifiers for the corresponding recall. |
IsBatchAppt |
Is Batch Appointment | Provides information related to is batch appointment. |
IsCompleted |
Is Completed | Provides information related to is completed. |
NoteX |
Note X | Provides information related to note x. |
PDMHash |
PDMHash | Provides information related to pdmhash. |
PtID.1 |
Patient ID.1 | Provides information related to patient id.1. |
ProcCodeIDs |
Proc Code IDs | Provides information related to proc code ids. |
ProcServicePlaceID |
Proc Service Place Details | Contains detailed information or identifiers for the corresponding proc service place. |
PrvID_Attn |
Provider ID_ Attn | Provides information related to provider id_ attn. |
PrvID_Ord |
Provider ID_ Ord | Provides information related to provider id_ ord. |
PrvID_Ref |
Provider ID_ Ref | Provides information related to provider id_ ref. |
PrvID_Ren |
Provider ID_ Ren | Provides information related to provider id_ ren. |
PrvTime |
Provider Time | Provides information related to provider time. |
PtEncID |
Patient Enc Details | Contains detailed information or identifiers for the corresponding patient enc. |
PtPolicyID |
Patient Policy Details | Contains detailed information or identifiers for the corresponding patient policy. |
SiteID.1 |
Site ID.1 | Provides information related to site id.1. |
TimeFrom |
Time From | Provides information related to time from. |
TimeTo |
Time To | Provides information related to time to. |
TmplSequenceID |
Tmpl Sequence Details | Contains detailed information or identifiers for the corresponding tmpl sequence. |
ZUChkSum.1 |
ZUChk Sum.1 | Provides information related to zuchk sum.1. |
ZUDate.1 |
ZUDate.1 | Specifies the date associated with the zudate.1 event or record. |
ZULogonHisID.1 |
ZULogon History ID.1 | Records the historical data or changes related to the zulogon id.1. |
No columns match your filter.