Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
clientpayerinfoid | int | 4 | √ | null |
|
|
||||
dim_date_key | int | 4 | null |
|
|
|||||
dim_facility_key | int | 4 | null |
|
|
|||||
dim_patient_key | int | 4 | null |
|
|
|||||
dim_insurance_key | int | 4 | null |
|
|
|||||
dim_payer_key | int | 4 | null |
|
|
|||||
facilityid | int | 4 | √ | null |
|
|
||||
patientid | int | 4 | √ | null |
|
|
||||
payerid | int | 4 | √ | null |
|
|
||||
insuranceid | int | 4 | √ | null |
|
|
||||
plantype | varchar | 254 | √ | null |
|
|
||||
insurance_plan | varchar | 100 | √ | null |
|
|
||||
insuredsname | varchar | 102 | √ | null |
|
|
||||
patientrelationship | varchar | 3 | √ | null |
|
|
||||
policynumber | varchar | 30 | √ | null |
|
|
||||
groupname | varchar | 50 | √ | null |
|
|
||||
groupnumber | varchar | 30 | √ | null |
|
|
||||
effectivedate | datetime | 16,3 | √ | null |
|
|
||||
dss_update_time | datetime | 16,3 | √ | null |
|
|