Field Names Description

Patient

Short Name Description
AC Active
AD Address Line 1
AD2 Address Line 2
ADACD ADA Code
AMT Amount
ANNIVDATE Anniversary Date
APD Appointment Date & Time
APID Appointment ID
APL Appointment Length
APN Appointment Notes
APS Appointment Status
ATY Appointment Type
BD Birth Date
BLC Balance
CARAD1 Carrier Address 1
CARAD2 Carrier Address 2
CARCITY Carrier City
CARNAME Carrier Name
CARPAYERID Carrier Payer ID
CARPHONE Carrier Phone
CARSTATE Carrier State
CARTY Carrier Type
CARZIP Carrier Zip
CBO Created On
CBY Created By
CD Code
CID Claim ID
CNO Chart Number
CP Cell Phone Number
CT City
CUID Culture ID
CURRBLC Current Balance
DE Day End
DES Description
DH Date Holiday
DS Day Start
DU Duration
EFD Effective Date
EM E-Mail
ESTINS Estimated Insurance Payment
ESTPAT Estimated Patient Payment
FAMDEDUCT Family Deductible
FAMDEDUCTREM Family Deductible Remaining
FAMMAX Family Maximum
FAMMAXREM Family Maximum Remaining
FEE Appointment Fee
FN First Name
FV First Visit
GRPNO Group Number
HP Home Phone Number
INDDEDUCT Individual Deducible
INDDEDUCTREM Individual Deducible Remaining
INDMAX Individual Maximum
INDMAXREM Individual Maximum Remaining
INDORTHOMAX Individual Ortho Maximum
INDORTHOREM Individual Ortho Remaining
INSID Insurance ID
ISAE No Auto Email
ISAPN On Appointment now
ISAS No Auto SMS
ISASAP Flag To Show Short Notice Appointment Slot
ISC Is Cancelled
ISCD Is Correspondence
ISM Is Missed
ISN Is Short Notice
ISNP Is New Patient
ISP Is Posted
ISSCHD Is Scheduled
LEID Ledger ID
LN Last Name
LTY Ledger Type 1
LTY2 Ledger Type 2
LUE Lunch End
LUS Lunch Start
LV Last Visit
MBO Modified On
MBY Modified By
MEDA Medical Alert
MI Middle Initial
Short Name Description
MSG Message
NPI Provider NPI
O Office ID
OFN Office Name
OPID Operatory ID
OPN Operatory Name
OSID Office Short ID
OVR120BAL Patient Balance over 120 days old
OVR30BAL Patient Balance over 30 days old
OVR60BAL Patient Balance over 60 days old
OVR90BAL Patient Balance over 90 days old
P Practice Group ID
PDR Provider ID
PDSID Provider Short ID
PDTY Provider Type
PGN Practice Group Name
PH Phone
PID Patient ID
PLNID Plan ID
PLNTY Plan Type
PN Patient Note
PPRSID Preferred Provider ID
PRC Production Color
PRDUR Procedure Duration
PREINS Procedure Est Insurance
PREPAT Procedure Est Patient
PRIMORSEC Primary Or Secondary Insurance
PRN Provider Name
PRPDR Procedure Provider
PRTY Production Type
PTY Patient Type
RCINT Recall Integer value
RCUNT Recall Unit (Month,Year,Day)
RDT Recall Date
RELTOSUB Patient RRelationship to Subscriber
RETRP Relation to Responsible Party
RFBY Referred By
RFTY Referral Type
RID Responsible Party ID
RPTY Responsible Party Type
RR Recall Reason
RS Record Status (Added/Modified/Deleted)
SCHDT Scheduled Date
SCHTM Scheduled Time
SID Short ID
ST State
STS Starts At
SUBAD1 Subscriber Address 1
SUBAD2 Subscriber Address 2
SUBBDAY Subscriber Birthday
SUBCITY Subscriber City
SUBFNAME Subscriber First Name
SUBGENDER Subscriber Gender
SUBID Subscriber ID
SUBLNAME Subscriber Last Name
SUBSTATE Subscriber State
SUBZIP Subscriber Zip
SURF Surface
SX Sex
TD Transaction Date
TTH Tooth
TXDUR Treatment Duration
TXFD Treatment Finalized Date?
TXORDRID Treat Plan order ID
TXPHASE Treatment Phase
TXPID Treatment Plan ID
TXPN Treatment Plan
TXPREAUTHDT Treatment Pre Authorization Date??
TXPRPDT Treat Plan Proposed Date
TXS Treat Plan Status
TXSCHD Treat Plan Scheduled Date
TXSP Treat Plan Sales Person
TXSTRTDT Treatment Plan Start Date
TY Type
TZ Time Zone
WP Work Phone Number
WSKPT Flag To Show A Kept Appointment
ZP Zip Code

Appointment

Short Name Description
APD Appointment Date
APID Appointment ID
APL Appointment Length
APPTID Appointment ID
APS Appointment Status
ATY Appointment Type
CANCELLATIONCODEID Cancellation Code ID
CANCELLATIONNOTE Appointment Cancellation Note (maximum 1024 characters)
CBO Created By On (Created Date)
CBY Created By
CD Code
DES Description
DU Appointment Duration
FEE Fee
ISASAP Is As Soon As Possible/Emergency
ISBLOCKED Is Blocked Appointment
ISNP Is New Patient
Message Message
MSG Message
NOTETOOFFICE Notes to Office (maximum 3950 characters)
O Office ID
OPID Operatory ID
OPN Operatory Name
PDR Provider ID
PID Patient ID
PRN Provider Name
PRTY Provider Type
SID Short ID
STS Time Appointment Starts
WSKPT Was Appointment Kept

Setup

Short Name Description
AC Active
AD Address Line 1
AD2 Address Line 2
APNDUR Appointment Duration
BAD Billing Address 1
BAD2 Billing Address 2
BCT Billing City
BST BIlling State
BZP BIlling Zip Code
CAD Carrier Address
CBO Created By On (Created Date)
CBY Created By
CD Code
CID Carrier ID
CN Carrier Name
CT City
CUID Culture ID
DE Day End
DES Description
DH Date Holiday (Holiday Date)
DS Day Start
DU Duration
EFD Effective Date
EM Email
FAX Fax Number
FN First Name
FriEnd Friday End Time
FriLunEnd Friday Lunch End Time
FriLunStart Friday Lunch Start Time
FriStart Friday Start Time
ISACT Is Active
ISAPN Is On Appointnow
LIC License Number
LN Last Name
LUE Lunch End
LUS Lunch Start
MBO Modified By On (Modified Date)
MBY Modified By
MonEnd Monday End Time
MonLunEnd Monday Lunch End Time
MonLunStart Monday Lunch Start Time
MonStart Moday Start Time
NPID National Provider Identifier Number
O Office ID
Short Name Description
OPID Operatory ID
OPN Operatory Name
OSID Office Short ID
P Practice Group ID
PDR Provider ID
PDSID Provider Short ID
PDTY Provider Type
PGN Practice Group Name
PH Phone Number 1
PH2 Phone Number 2
PID Carrier PayerID
PRC Provider Color
PRTY Provider Type
PWD Provider Carrier Login Password
SatEnd Saturday End Time
SatLunEnd Saturday Lunch End Time
SatLunStart Saturday Lunch Start Time
SatStart Saturday Start Time
SID Short Id/Name
ST State
STS Schedule Starts At - Date providers effective schedule goes into effect
SunEnd Sunday End Time
SunLunEnd Sunday Lunch End Time
SunLunStart Sunday Lunch Start Time
SunStart Sunday Start Time
ThurEnd Thursday End Time
ThurLunEnd Thursday Lunch End Time
ThurLunStart Thursday Lunch Start Time
ThurStart Thursday Start Time
TuesEnd Tuesday End Time
TuesLunEnd Tuesday Lunch End Time
TuesLunStart Tuesday Lunch Start Time
TuesStart Tuesday Start Time
TY Holiday Type - In office or out of office holiday
TypeId Referral Type ID
TypeName Referral Type Name or Where Refered From
TZ Time Zone
UN Provider Carrier Login Username
WedEnd Wednesday End Time
WedLunEnd Wednesday Lunch End Time
WedLunStart Wednesday Lunch Start Time
WedStart Wednesday Start Time
WS Web Site
ZP Zip Code

Patient Registration

Short Name Description
Answer Answer to the Question
BirthDate Patients Date of Birth
FirstName Patients First Name
IsExistingPatient Does the Patient Exist
IsHeader If the Question is the header
LastName Patients Last Name
PatientId Patient ID
PickList Option List
PickListId Option List ID
Qid Question ID
Qorder Question Order
Qtype Question Type
Question Actual Question
TemporaryPatientId Temporary Patient ID
Type Type of Question(Medical, Dental, Alert)