Documentation for HC_ApptTrail.csv

Health Care Data for Appointment Trail - HC_ApptTrail.csv

Original Column Name Expanded Column 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.