Data element |
Definition |
Application_Key
|
An identifying number for an application, assigned in the data warehouse. |
City |
The city associated with the permanent address of the applicant. Free-form un-validated text; this field may be in all uppercase, or in title case. |
Country |
The country code associated with the address. This is often the 2-character code for country, but the historical data from older records was not validated against any dataset. Values of 'ZZ' and 'Un' in this column can be assumed to be 'US'. |
Country_Desc |
The country name associated with the address. |
Non US Postal Code |
For addresses that are not in the United States (and also not in Canada), this is the postal code associated with the applicant's address. |
Non US CA State Province |
For addresses that are not in the United States (and also not in Canada), this is the state or province associated with the applicant's address. |
Record_Type |
The type of address. The best, most-recent value to use is the 'EnrPerm' or 'P', depending on the application record source. Notification addresses were not captured before CN.
Values:
EnrPerm : Perm address as-of CN enrollment
EnrNotif : Notification address as-of CN enrollment
P : Perm address as-of application submittal
N : Notification address as-of application submittal
|
State |
The 2-character code for the US State or territory, or Canadian Province associated with the permanent adddress of the applicant.
Values:
AA |
MILITARY ADDRESS |
AE |
MILITARY ADDRESS |
AP |
MILITARY ADDRESS |
AL |
ALABAMA |
AK |
ALASKA |
AZ |
ARIZONA |
AR |
ARKANSAS |
AS |
AMERICAN SAMOA |
CA |
CALIFORNIA |
CO |
COLORADO |
CT |
CONNECTICUT |
CZ |
CANAL ZONE (PANAMA) |
DE |
DELAWARE |
DC |
DISTRICT OF COLUMBIA |
FL |
FLORIDA |
FM |
MILITARY ADDRESS |
GA |
GEORGIA |
GU |
GUAM |
HI |
HAWAII |
ID |
IDAHO |
IL |
ILLINOIS |
IN |
INDIANA |
IA |
IOWA |
KS |
KANSAS |
KY |
KENTUCKY |
LA |
LOUISIANA |
ME |
MAINE |
MD |
MARYLAND |
MA |
MASSACHUSETTS |
MH |
MILITARY ADDRESS |
MI |
MICHIGAN |
MN |
MINNESOTA |
MP |
MILITARY ADDRESS |
MS |
MISSISSIPPI |
MO |
MISSOURI |
MT |
MONTANA |
NE |
NEBRASKA |
NV |
NEVADA |
NH |
NEW HAMPSHIRE |
NJ |
NEW JERSEY |
NM |
NEW MEXICO |
NY |
NEW YORK |
NC |
NORTH CAROLINA |
ND |
NORTH DAKOTA |
OH |
OHIO |
OK |
OKLAHOMA |
OR |
OREGON |
PA |
PENNSYLVANIA |
PR |
PUERTO RICO |
RI |
RHODE ISLAND |
SC |
SOUTH CAROLINA |
SD |
SOUTH DAKOTA |
TN |
TENNESSEE |
TX |
TEXAS |
TT |
PACIFIC TRUST TERRITORY |
UT |
UTAH |
VT |
VERMONT |
VA |
VIRGINIA |
VI |
VIRGIN ISLANDS |
WA |
WASHINGTON |
WV |
WEST VIRGINIA |
WI |
WISCONSIN |
WY |
WYOMING |
AB |
ALBERTA |
BC |
BRITISH COLUMBIA |
LB |
LABRADOR |
MB |
MANITOBA |
NB |
NEW BRUNSWICK |
NF |
NEWFOUNDLAND |
NT |
NORTHWEST TERRITORIES |
NS |
NOVA SCOTIA |
ON |
ONTARIO |
PE |
PRINCE EDWARD ISLAND |
PQ |
QUEBEC |
SK |
SASKATCHEWAN |
YT |
YUKON |
|
Street1 |
The text of the first address line associated with the applicant's permanent address. May contain non-alphanumeric characters such as '/' or '#'. |
Street2 |
The text of the second address line associated with the applicant's permanent address. May be null. May contain non-alphanumeric characters such as '/' or '#'. |
Zip |
The US zip code or non-US postal code associated with the applicant's permanent address. |