Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgeID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each aging balance record |
|
| AsOfDate | smalldatetime | 16 | √ | null |
|
|
Report date - Date as of which the aging balance was calculated |
|
| Sitename | varchar | 50 | √ | null |
|
|
Site name - Name of the healthcare site or location for this aging report |
|
| Day30 | money | 21,4 | √ | null |
|
|
30-day balance - Outstanding balance for accounts 0-30 days old |
|
| Day60 | money | 21,4 | √ | null |
|
|
60-day balance - Outstanding balance for accounts 31-60 days old |
|
| Day90 | money | 21,4 | √ | null |
|
|
90-day balance - Outstanding balance for accounts 61-90 days old |
|
| Day120 | money | 21,4 | √ | null |
|
|
120-day balance - Outstanding balance for accounts 91-120 days old |
|
| Day365 | money | 21,4 | √ | null |
|
|
365-day balance - Outstanding balance for accounts 121-365 days old |
|
| Over365 | money | 21,4 | √ | null |
|
|
Over 365-day balance - Outstanding balance for accounts over 365 days old |
|
| SiteAmount | money | 21,4 | √ | null |
|
|
Total site amount - Total outstanding balance for the site |
|
| Day180 | money | 21,4 | √ | null |
|
|
180-day balance - Outstanding balance for accounts 121-180 days old |
|
| Day270 | money | 21,4 | √ | null |
|
|
270-day balance - Outstanding balance for accounts 181-270 days old |
Relationships
Close relationships within degrees of separation
