Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MonthID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each monthly balance record |
|
| AsOfDate | smalldatetime | 16 | null |
|
|
As of date - Date for which this monthly balance snapshot was calculated |
||
| SiteID | int | 4 | null |
|
|
Site reference - Links to the service delivery site for this balance |
||
| SiteName | varchar | 50 | √ | null |
|
|
Site name - Name of the service delivery site |
|
| NewBillingAmount | money | 21,4 | √ | null |
|
|
New billing amount - Total amount of new billing for the month |
|
| NewPayment | money | 21,4 | √ | null |
|
|
New payment amount - Total amount of new payments received for the month |
|
| HoldBilledCharged | money | 21,4 | √ | null |
|
|
Hold billed charged amount - Amount of charges that are on hold from previous billing |
|
| HoldNewCharged | money | 21,4 | √ | null |
|
|
Hold new charged amount - Amount of new charges that are placed on hold |
|
| VoidAmount | money | 21,4 | √ | null |
|
|
Void amount - Total amount of voided transactions for the month |
|
| DeleteAdjust | money | 21,4 | √ | null |
|
|
Delete adjustment amount - Adjustment amount for deleted transactions |
|
| PartialPaidAdjust | money | 21,4 | √ | null |
|
|
Partial paid adjustment - Adjustment amount for partially paid claims |
|
| AmountchargeAdjust | money | 21,4 | √ | null |
|
|
Amount charge adjustment - Adjustment to charge amounts |
|
| VoidPaidAdjust | money | 21,4 | √ | null |
|
|
Void paid adjustment - Adjustment amount for voided payments |
|
| DeletePaidAdjust | money | 21,4 | √ | null |
|
|
Delete paid adjustment - Adjustment amount for deleted payments |
|
| VoidPaidByFHAdjust | money | 21,4 | √ | null |
|
|
Void paid by FH adjustment - Adjustment for voided payments by foster home |
|
| PaidByFHAdjust | money | 21,4 | √ | null |
|
|
Paid by FH adjustment - Adjustment for payments made by foster home |
|
| ImportAdjust | money | 21,4 | √ | null |
|
|
Import adjustment - Adjustment amount from imported transactions |
|
| CurrentBalance | money | 21,4 | √ | null |
|
|
Current balance - Current outstanding balance as of the snapshot date |
|
| PreviousEndingBalance | money | 21,4 | √ | null |
|
|
Previous ending balance - Ending balance from the previous month |
|
| NetChange | money | 21,4 | √ | null |
|
|
Net change - Net change in balance from previous month to current month |
|
| Before601 | money | 21,4 | √ | null |
|
|
Before 601 days - Balance amount for claims older than 601 days |
|
| After701 | money | 21,4 | √ | null |
|
|
After 701 days - Balance amount for claims older than 701 days |
|
| OtherAmt | money | 21,4 | √ | null |
|
|
Other amount - Other miscellaneous amounts not categorized elsewhere |
|
| Unbilled | money | 21,4 | √ | null |
|
|
Unbilled amount - Amount of services provided but not yet billed |
|
| Writeoffamount | money | 21,4 | √ | null |
|
|
Write-off amount - Amount written off as uncollectible for the month |
