Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RowNumber | int identity | 4 | √ | null |
|
|
||
| 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 |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors