stage_patient_insurance

178327 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
clientpayerinfoid int 4 √ null
dim_date_key int 4 null
dim_date.dim_date_key Implied ConstraintR
dim_facility_key int 4 null
dim_facility.dim_facility_key Implied ConstraintR
dim_patient_key int 4 null
dim_patient.dim_patient_key Implied ConstraintR
dim_insurance_key int 4 null
dim_insurance.dim_insurance_key Implied ConstraintR
dim_payer_key int 4 null
dim_payer.dim_payer_key Implied ConstraintR
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
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
ineffectivedate datetime 16,3 √ null
deleted varchar 1 √ null
dss_update_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation