Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CensusDate | date | 6 | null |
|
|
|||||
| FacilityId | int | 4 | √ | null |
|
|
||||
| ClientId | int | 4 | √ | null |
|
|
||||
| ResidentNumber | varchar | 20 | √ | null |
|
|
||||
| FirstName | varchar | 100 | √ | null |
|
|
||||
| MiddleName | varchar | 100 | √ | null |
|
|
||||
| LastName | varchar | 100 | √ | null |
|
|
||||
| DOB | date | 6 | √ | null |
|
|
||||
| Gender | varchar | 100 | √ | null |
|
|
||||
| Race | varchar | 100 | √ | null |
|
|
||||
| Ethnicity | varchar | 100 | √ | null |
|
|
||||
| PrimaryPayor | varchar | 200 | √ | null |
|
|
||||
| PrimaryPayorPolicyNumber | varchar | 100 | √ | null |
|
|
||||
| Ins_1 | varchar | 200 | √ | null |
|
|
||||
| Ins_1_PolicyNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_1_GroupNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_2 | varchar | 200 | √ | null |
|
|
||||
| Ins_2_PolicyNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_2_GroupNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_3 | varchar | 200 | √ | null |
|
|
||||
| Ins_3_PolicyNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_3_GroupNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_4 | varchar | 200 | √ | null |
|
|
||||
| Ins_4_PolicyNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_4_GroupNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_5 | varchar | 200 | √ | null |
|
|
||||
| Ins_5_PolicyNumber | varchar | 200 | √ | null |
|
|
||||
| Ins_5_GroupNumber | varchar | 200 | √ | null |
|
|
||||
| Medicaid_ClientID | varchar | 200 | √ | null |
|
|
||||
| Medicare_HIC_Num | varchar | 200 | √ | null |
|
|
||||
| WA_Medicaid_ClientID | varchar | 200 | √ | null |
|
|
||||
| Medicare_Beneficiary_ID | varchar | 200 | √ | null |
|
|
||||
| Medicaid_Num | varchar | 200 | √ | null |
|
|
||||
| Insurance | varchar | 200 | √ | null |
|
|
||||
| PolicyNum | varchar | 200 | √ | null |
|
|
||||
| InsuranceName | varchar | 200 | √ | null |
|
|
||||
| Insurance_Policy_Num | varchar | 200 | √ | null |
|
|
||||
| Provider_One_ID | varchar | 200 | √ | null |
|
|
||||
| Insurance_2 | varchar | 200 | √ | null |
|
|
||||
| PolicyNum_2 | varchar | 200 | √ | null |
|
|
||||
| Insurance_3 | varchar | 200 | √ | null |
|
|
||||
| PolicyNum_3 | varchar | 200 | √ | null |
|
|
||||
| VaccineDose1Date | date | 6 | √ | null |
|
|
||||
| VaccineDose1ExpDate | date | 6 | √ | null |
|
|
||||
| VaccineDose1Manufacturer | varchar | 200 | √ | null |
|
|
||||
| VaccineDose1Lot | varchar | 100 | √ | null |
|
|
||||
| VaccineDose2Date | date | 6 | √ | null |
|
|
||||
| VaccineDose2ExpDate | date | 6 | √ | null |
|
|
||||
| VaccineDose2Manufacturer | varchar | 200 | √ | null |
|
|
||||
| VaccineDose2Lot | varchar | 100 | √ | null |
|
|
||||
| VaccineDose3Date | date | 6 | √ | null |
|
|
||||
| VaccineDose3ExpDate | date | 6 | √ | null |
|
|
||||
| VaccineDose3Manufacturer | varchar | 200 | √ | null |
|
|
||||
| VaccineDose3Lot | varchar | 100 | √ | null |
|
|
||||
| CensusEvents | varchar | 2147483647 | √ | null |
|
|
||||
| AVA_insdate | datetime2 | 16 | (getdate()) |
|
|
Relationships
Close relationships within degrees of separation
