Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| FacilityCode | varchar | 5 | null |
|
|
|||||
| FacilityID | int | 4 | null |
|
|
|||||
| PatientId | 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 | 38 | null |
|
|
|||||
| Ethnicity | int | 4 | √ | null |
|
|
||||
| Vaccinated | varchar | 5 | null |
|
|
|||||
| Vaccine | varchar | 100 | √ | 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 |
|
|
||||
| VaccineBooster1Date | date | 6 | √ | null |
|
|
||||
| VaccineBooster1ExpDate | smalldatetime | 16 | √ | null |
|
|
||||
| VaccineBooster1Manufacturer | varchar | 50 | √ | null |
|
|
||||
| VaccineBooster1Lot | varchar | 10 | √ | null |
|
|
||||
| VaccineBooster2Date | date | 6 | √ | null |
|
|
||||
| VaccineBooster2ExpDate | smalldatetime | 16 | √ | null |
|
|
||||
| VaccineBooster2Manufacturer | varchar | 50 | √ | null |
|
|
||||
| VaccineBooster2Lot | varchar | 10 | √ | null |
|
|
||||
| VaccineBooster3Date | date | 6 | √ | null |
|
|
||||
| VaccineBooster3ExpDate | smalldatetime | 16 | √ | null |
|
|
||||
| VaccineBooster3Manufacturer | varchar | 50 | √ | null |
|
|
||||
| VaccineBooster3Lot | varchar | 10 | √ | null |
|
|
||||
| VaccineBooster4Date | date | 6 | √ | null |
|
|
||||
| VaccineBooster4ExpDate | smalldatetime | 16 | √ | null |
|
|
||||
| VaccineBooster4Manufacturer | varchar | 50 | √ | null |
|
|
||||
| VaccineBooster4Lot | varchar | 10 | √ | null |
|
|
||||
| VaccineBooster5Date | date | 6 | √ | null |
|
|
||||
| VaccineBooster5ExpDate | smalldatetime | 16 | √ | null |
|
|
||||
| VaccineBooster5Manufacturer | varchar | 50 | √ | null |
|
|
||||
| VaccineBooster5Lot | varchar | 10 | √ | null |
|
|
||||
| PrimaryPayor | varchar | 200 | √ | null |
|
|
||||
| PrimaryPayorPolicyNumber | varchar | 100 | √ | null |
|
|
||||
| InsuranceCompanyName1 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber1 | varchar | 200 | √ | null |
|
|
||||
| InsurancePolicyNumber1 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName2 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber2 | varchar | 200 | √ | null |
|
|
||||
| InsurancePolicyNumber2 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName3 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber3 | varchar | 200 | √ | null |
|
|
||||
| InsurancePolicyNumber3 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName4 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber4 | varchar | 200 | √ | null |
|
|
||||
| InsurancePolicyNumber4 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName5 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber5 | varchar | 200 | √ | null |
|
|
||||
| InsurancePolicyNumber5 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName6 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber6 | int | 4 | √ | null |
|
|
||||
| InsurancePolicyNumber6 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName7 | varchar | 18 | √ | null |
|
|
||||
| InsuranceGroupNumber7 | int | 4 | √ | null |
|
|
||||
| InsurancePolicyNumber7 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName8 | varchar | 21 | √ | null |
|
|
||||
| InsuranceGroupNumber8 | int | 4 | √ | null |
|
|
||||
| InsurancePolicyNumber8 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName9 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber9 | int | 4 | √ | null |
|
|
||||
| InsurancePolicyNumber9 | varchar | 200 | √ | null |
|
|
||||
| InsuranceCompanyName10 | varchar | 200 | √ | null |
|
|
||||
| InsuranceGroupNumber10 | int | 4 | √ | null |
|
|
||||
| InsurancePolicyNumber10 | varchar | 200 | √ | null |
|
|
||||
| censusEvents | varchar | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
