Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ClinicName | varchar | 200 | √ | null |
|
|
||
DateofService | varchar | 40 | √ | null |
|
|
||
VisitID | int | 4 | √ | null |
|
|
||
AppointmentCategory | varchar | 100 | √ | null |
|
|
||
TreatingTherapist | varchar | 200 | √ | null |
|
|
||
BillingTherapist | varchar | 200 | √ | null |
|
|
||
Case | varchar | 1000 | √ | null |
|
|
||
AppointmentType | varchar | 200 | √ | null |
|
|
||
ProgramType | varchar | 100 | √ | null |
|
|
||
CaseDiscipline | varchar | 100 | √ | null |
|
|
||
VisitSigned | varchar | 20 | √ | null |
|
|
||
DateSigned | varchar | 40 | √ | null |
|
|
||
ClaimChargeTotal | varchar | 68 | √ | null |
|
|
||
ChargePostedDate | varchar | 40 | √ | null |
|
|
||
ExpectedPaymentPerVisit | varchar | 68 | √ | null |
|
|
||
ClaimUnits | int | 4 | √ | null |
|
|
||
ClaimNumber | varchar | 20 | √ | null |
|
|
||
ClaimCreationDate | varchar | 40 | √ | null |
|
|
||
ClaimStartDate | varchar | 40 | √ | null |
|
|
||
ClaimEndDate | varchar | 40 | √ | null |
|
|
||
ClaimCompleted | varchar | 100 | √ | null |
|
|
||
PrimaryPaymentID | int | 4 | √ | null |
|
|
||
PrimaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
PrimaryPaymentDate | varchar | 40 | √ | null |
|
|
||
PrimaryPaymentPostedDate | varchar | 40 | √ | null |
|
|
||
PrimaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
SecondaryPaymentID | int | 4 | √ | null |
|
|
||
SecondaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
SecondaryPaymentDate | varchar | 40 | √ | null |
|
|
||
SecondaryPaymentPostedDate | varchar | 40 | √ | null |
|
|
||
SecondaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
TertiaryPaymentID | int | 4 | √ | null |
|
|
||
TertiaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
TertiaryPaymentDate | varchar | 40 | √ | null |
|
|
||
TertiaryPaymentPostedDate | varchar | 40 | √ | null |
|
|
||
TertiaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
PatientPaymentID | int | 4 | √ | null |
|
|
||
PatientPaymentNumber | varchar | 20 | √ | null |
|
|
||
PatientPaymentDate | varchar | 40 | √ | null |
|
|
||
PatientPaymentPostedDate | varchar | 40 | √ | null |
|
|
||
PatientPaymentApplied | varchar | 68 | √ | null |
|
|
||
TotalPaymentApplied | varchar | 68 | √ | null |
|
|
||
TotalContractualAdjustment | varchar | 68 | √ | null |
|
|
||
TotalOtherAdjustment | varchar | 68 | √ | null |
|
|
||
TotalUserAdjustment | varchar | 68 | √ | null |
|
|
||
PrimaryPayerBalance | varchar | 68 | √ | null |
|
|
||
SecondaryPayerBalance | varchar | 68 | √ | null |
|
|
||
TertiaryPayerBalance | varchar | 68 | √ | null |
|
|
||
PatientOwes | varchar | 68 | √ | null |
|
|
||
TotalBalance | varchar | 68 | √ | null |
|
|
||
PrimaryPayerCategory | varchar | 200 | √ | null |
|
|
||
PrimaryInsurancePayer | varchar | 200 | √ | null |
|
|
||
SecondaryInsurancePayer | varchar | 200 | √ | null |
|
|
||
TertiaryInsurancePayer | varchar | 200 | √ | null |
|
|
||
ReferralSourceName | varchar | 200 | √ | null |
|
|
||
ReferralSourceType | varchar | 200 | √ | null |
|
|
||
ReferringMD | varchar | 200 | √ | null |
|
|