|
Comment |
Household - A household is a group of persons sharing the same physical address and other demographic traits. |
|
Generate |
Yes |
|
Code |
Comment |
Data Type |
Mandatory |
Primary |
|
HOUSEHOLDID |
Household ID - The system-assigned identifying number for the household. |
varchar(8) |
X |
X |
|
ADDRESS |
Address - The street address of the household residence. |
varchar(50) |
|
|
|
STATECD |
State Code - A state abbreviation code for the household address. |
varchar(2) |
|
|
|
ZIPCODE |
Zip Code - The address zip code of the household residence. |
varchar(9) |
|
|
|
COUNTYCD |
County Code - A state-assigned identifying code for each county in which the household resides. |
varchar(3) |
|
|
|
LEGALMUNICIPALITYID |
Legal Municipality - A code indicating the legal municipality in which the household resides. |
varchar(4) |
|
|
|
LOCALMUNICIPALITYID |
Local Municipality - A code indicating the local municipality in which the household resides. |
varchar(4) |
|
|
|
MAILADDRESS |
Mail Address - The mailing address of the household. |
varchar(50) |
|
|
|
MAILCITY |
Mail City - The mailing city of the household. |
varchar(30) |
|
|
|
MAILSTATE |
Mail State - A code indicating the mailing state of the household. |
varchar(2) |
|
|
|
MAILZIP |
Mail Zip - The mailing ZIP code of the household. |
varchar(9) |
|
|
|
TELEPHONE1 |
Telephone 1 - The first telephone number at which to reach a responsible member of the household. |
varchar(10) |
|
|
|
COMMENT1 |
Comment 1 - A brief description of the first telephone number. |
varchar(30) |
|
|
|
TELEPHONE2 |
Telephone 2 - The second telephone number at which to reach a responsible member of the household. |
varchar(10) |
|
|
|
COMMENT2 |
Comment 2 - A brief description of the second telephone number. |
varchar(30) |
|
|
|
TANF |
Temporary Assistance for Needy Families - A flag indicating whether all household members are eligible for WIC benefits due to participation in Temporary Assistance for Needy Families (TANF). |
char(1) |
|
|
|
FOODSTAMPS |
Food Stamps - A flag indicating whether all household members are eligible to receive WIC benefits due to participation in the Food Stamps program. |
char(1) |
|
|
|
HOUSEHOLDSIZE |
Household Size - The number of persons currently residing at the household residence. |
numeric(2) |
|
|
|
LANGUAGE1 |
Language 1 - A code indicating the first language understood by the household. |
char(1) |
|
|
|
LANGUAGE1READ |
Language 1 Read - A flag indicating that the household reads and writes the first language. |
char(1) |
|
|
|
LANGUAGE1SPOKEN |
Language 1 Spoken - A flag indicating that the household speaks the first language. |
char(1) |
|
|
|
LANGUAGE2 |
Language 2 - A code indicating the second language understood by the household. |
char(1) |
|
|
|
LANGUAGE2READ |
Language 2 Read - A flag indicating that the household reads and writes the second language. |
char(1) |
|
|
|
LANGUAGE2SPOKEN |
Language 2 Spoken - A flag indicating that the household speaks the second language. |
char(1) |
|
|
|
LANGUAGEPREFERENCE |
Language Preference - A code indicating the language preferred by the household for correspondence. (See reference dictionary category ‘DOCMNTLANG') |
varchar(2) |
|
|
|
INTERPRETERNEEDED |
Interpreter Needed - A flag indicating whether an interpreter is needed when working with the household. |
char(1) |
|
|
|
HOWHEARDABOUTWIC |
How Heard About WIC - A code indicating how the household heard about the WIC program. |
char(1) |
|
|
|
MIGRANT |
Migrant - A flag indicating whether the household is considered to be a migrant household. |
char(1) |
|
|
|
HOMELESS |
Homeless - A flag indicating that the household is classified as homeless. |
char(1) |
|
|
|
HOMELESSVERIFIEDDATE |
HomelessVerifiedDate - The date in which the homeless indicator was set. |
datetime |
|
|
|
HOUSEHOLDSMOKING |
Household Smoking - A code indicating whether the member lives in an environment where anyone living in the household currently smokes in the home. |
char(1) |
|
|
|
FDPIR |
FDPIR - A flag indicating whether all household members are adjunctively eligible for WIC benefits due to participation in the Food Distribution Program on Indian Reservations. |
char(1) |
|
|
|
UPDATERECORD |
Update Record - A code indicating whether the record has been updated. (N=New, U=Updated, Null=Processed) |
char(1) |
|
|
|
EMAILADDRESS |
Email Address - The email address for the household. |
varchar(100) |
|
|
|
CREATEUSERID |
Created by User Identifier - Identifies the user who created the related row. |
varchar(10) |
|
|
|
CREATEDTTM |
Create Date/Time - The date/time stamp this row was created. The system uses the server system date to value this attribute. |
datetime |
|
|
|
MODIFYUSERID |
Modify User ID - The user that was responsible for last updating this row. |
varchar(10) |
|
|
|
MODIFYDTTM |
Modify Date/Time - The date/time stamp this row was last updated. The system uses the server system date to value this attribute. |
datetime |
|
|
|
Child Table |
Foreign key constraint name |
Foreign Key Columns |
|
FK_ALERT_HOUSEHOLD |
HouseholdID |
|
|
FK_EBACCT_HOUSEHOLD |
HouseholdID |
|
|
FK_MEMBER_HOUSEHOLD |
HouseholdID |
|
Parent Table |
Foreign key constraint name |
Foreign Key Columns |
|
FK_HOUSEHOLD_LEGALMUNICIP |
LegalMunicipalityID |
|
|
FK_HOUSEHOLD_LOCALMUNICIP |
LocalMunicipalityID |
|
Name |
Code |
|
Code |
Sort |
|
ADDRESS |
Ascending |
|
HOUSEHOLDID |
Ascending |
|
|
|