The PTmerge.doc file data has the following fields (all fields refer to those entered as patients into an account):
- FirstName
- MI (middle initial)
- LastName
- Title
- SrJr
- SalutationName (whatever was entered in this field by user)
- FullFormalName (such as Mr. Thomas A. Edison Sr.)
- FirstNamePlusMI (such as Alfred E.)
- Account_ID
- Patient_Type
- Chart_Number
- FirstVisit (date)
- LastVisit (date)
- LastStatementDate
- Age
- BirthDOW (birthday day of week, Monday, Tuesday, etc. for a birthday that is coming up, not the day they were originally born)
- BirthMonth (month of birth, January, February, etc.)
- Bdayth (the birth day such as 1st, 2nd, 24th, etc.)
- DoctorInitials (initials for assigned doctor for this account)
- Street_Address
- City
- State
- Zip_Code
- BalanceAmount
- DueNowAmount
- CurrentAmount
- Over30Days
- Over60Days
- Over90Days
- LastPaymentDate
- LastPaymentAmount (from the patient)
These fields are available to you if you create your own merge letters.
|