Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClinicName | varchar | 200 | √ | null |
|
|
||
| DateofService | date | 6 | √ | 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 | datetime2 | 16 | √ | null |
|
|
||
| ClaimChargeTotal | decimal | 20,2 | √ | null |
|
|
||
| ChargePostedDate | datetime2 | 16 | √ | null |
|
|
||
| ExpectedPaymentPerVisit | varchar | 68 | √ | null |
|
|
||
| ClaimUnits | int | 4 | √ | null |
|
|
||
| ClaimNumber | varchar | 20 | √ | null |
|
|
||
| ClaimCreationDate | date | 6 | √ | null |
|
|
||
| ClaimStartDate | date | 6 | √ | null |
|
|
||
| ClaimEndDate | date | 6 | √ | null |
|
|
||
| ClaimCompleted | varchar | 100 | √ | null |
|
|
||
| PrimaryPaymentID | int | 4 | √ | null |
|
|
||
| PrimaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
| PrimaryPaymentDate | date | 6 | √ | null |
|
|
||
| PrimaryPaymentPostedDate | datetime2 | 16 | √ | null |
|
|
||
| PrimaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
| SecondaryPaymentID | int | 4 | √ | null |
|
|
||
| SecondaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
| SecondaryPaymentDate | date | 6 | √ | null |
|
|
||
| SecondaryPaymentPostedDate | datetime2 | 16 | √ | null |
|
|
||
| SecondaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
| TertiaryPaymentID | int | 4 | √ | null |
|
|
||
| TertiaryPaymentNumber | varchar | 50 | √ | null |
|
|
||
| TertiaryPaymentDate | date | 6 | √ | null |
|
|
||
| TertiaryPaymentPostedDate | datetime2 | 16 | √ | null |
|
|
||
| TertiaryPaymentApplied | varchar | 68 | √ | null |
|
|
||
| PatientPaymentID | int | 4 | √ | null |
|
|
||
| PatientPaymentNumber | varchar | 20 | √ | null |
|
|
||
| PatientPaymentDate | date | 6 | √ | null |
|
|
||
| PatientPaymentPostedDate | datetime2 | 16 | √ | 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 |
|
|
||
| AVA_insdate | datetime2 | 16,3 | √ | (getdate()) |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors