VW_PCC_ar_aging

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
current_month date 6 √ null
resident_mrn varchar 35 √ null
last_name varchar 50 √ null
first_name varchar 50 √ null
insurance_name varchar 80 √ null
ability_insurance_name varchar 1000 √ null
insurance varchar 1000 √ null
payer_type varchar 20 √ null
payer_code varchar 16 √ null
payer_description varchar 50 √ null
fac_id int 4 null
facility_code varchar 5 null
facility_name varchar 375 null
facility_type varchar 254 null
facility_state varchar 3 √ null
property_owner varchar 50 null
property_type varchar 50 null
Current numeric 40,4 √ null
30 days numeric 40,4 √ null
60 days numeric 40,4 √ null
90 days numeric 40,4 √ null
120 days numeric 40,4 √ null
150 days numeric 40,4 √ null
180 days numeric 40,4 √ null
210 days numeric 40,4 √ null
240 days numeric 40,4 √ null
270 days numeric 40,4 √ null
300 days numeric 40,4 √ null
330 days numeric 40,4 √ null
360 days + numeric 40,4 √ null
FutureCash numeric 40,4 √ null
total_credit numeric 40,4 √ null
ar_type varchar 10 null
PCCSource varchar 50 null

View Definition

Possibly Referenced Tables/Views