Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ExportKey | varchar | 20 | null |
|
|
|||||
Ownership | varchar | 50 | null |
|
|
|||||
report_month | date | 6 | null |
|
|
|||||
report_day | date | 6 | null |
|
|
|||||
insert_datetime | datetime2 | 16,3 | (getdate()) |
|
|
|||||
Facility_ID | int | 4 | null |
|
|
|||||
Facility | varchar | 100 | null |
|
|
|||||
RevenueType | char | 1 | √ | null |
|
|
||||
RevenueSource | char | 1 | √ | null |
|
|
||||
Payer | varchar | 100 | √ | null |
|
|
||||
PayerPlan | varchar | 100 | √ | null |
|
|
||||
Payer_ID | int | 4 | √ | null |
|
|
||||
PaySrcInternalID | int | 4 | √ | null |
|
|
||||
PaySrcDisplayOrd | int | 4 | √ | null |
|
|
||||
Part | char | 1 | √ | null |
|
|
||||
PTRevenue | float | 8 | √ | null |
|
|
||||
OTRevenue | float | 8 | √ | null |
|
|
||||
STRevenue | float | 8 | √ | null |
|
|
||||
TotRevenue | float | 8 | √ | null |
|
|
||||
FootNote | varchar | 100 | √ | null |
|
|
||||
SortOrder | int | 4 | √ | null |
|
|
||||
MTDCacheDate | datetime | 16,3 | √ | null |
|
|
||||
RevenueMonth | datetime | 16,3 | √ | null |
|
|
||||
MaxRevenueDate | datetime | 16,3 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
CIX_ROX_Monthly_Revenue | Performance | Asc/Asc/Asc | ExportKey + report_month + report_day |