Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TransID | int | 4 | null |
|
|
|||
| PeriodYear | int | 4 | null |
|
|
|||
| PeriodMonth | int | 4 | null |
|
|
|||
| ClientID | int | 4 | √ | null |
|
|
||
| FacID | int | 4 | null |
|
|
|||
| GLAccountNumber | varchar | 75 | √ | null |
|
|
||
| ConsAccountNumber | varchar | 75 | √ | null |
|
|
||
| AccountTypeCode | varchar | 1 | null |
|
|
|||
| AccountTypeDesc | varchar | 50 | null |
|
|
|||
| last_name | varchar | 50 | √ | null |
|
|
||
| first_name | varchar | 50 | √ | null |
|
|
||
| client_id_number | varchar | 50 | √ | null |
|
|
||
| TransDesc | varchar | 100 | √ | null |
|
|
||
| TransactionAmount | money | 21,4 | √ | null |
|
|
||
| ServiceFromDate | datetime2 | 16,3 | √ | null |
|
|
||
| ServiceToDate | datetime2 | 16,3 | √ | null |
|
|
||
| TransactionDate | datetime2 | 16,3 | √ | null |
|
|
||
| TransType | varchar | 10 | √ | null |
|
|
||
| PayerType | varchar | 50 | √ | null |
|
|
||
| PayerCode | varchar | 20 | √ | null |
|
|
||
| PayerCode2 | varchar | 20 | √ | null |
|
|
||
| PayerName | varchar | 100 | √ | null |
|
|
||
| ChargeCode | varchar | 20 | √ | null |
|
|
||
| CareLevel | varchar | 50 | √ | null |
|
|
||
| MedicareCert | varchar | 20 | √ | null |
|
|
||
| MedicaidCert | varchar | 20 | √ | null |
|
|
||
| batch_number | int | 4 | null |
|
|
|||
| actual_posting_date | datetime2 | 16,3 | √ | null |
|
|
||
| lic_description | varchar | 300 | √ | null |
|
|
||
| ability_insurance_name | varchar | 300 | √ | null |
|
|
||
| AVA_insdate | datetime2 | 16,3 | (getdate()) |
|
|
|||
| AVA_Source | varchar | 50 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PCC_ar_baddebt | Primary key | Asc/Asc | TransID + AVA_Source |
Diagram producer might be missing
No diagrams were produced please see application output for any errors