Data Elements in the Personnel Data Warehouse Per_Addr Table

Click on data element name for CPS data dictionary information

Data Element Name	CPS FOCUS Name	Size	Comment
Employee_Name_Addr	EMPNAME	35
Social_Security_Name_Addr	SOCSECNO	9
Home_Address_Line_1	PERMADR1	30
Home_Address_Line_2	PERMADR2	30
Home_Address_City	PERMCITY	21
Home_Address_State	PERMSTATE	2
Home_Address_Zip	PERMPOST	5
Home_Address_Disclosure	ADRDISCIND	1
Work_Address_Line_1	MAILADR1	30
Work_Address_Line_2	MAILADR2	30
Work_Address_Campus	MAILCAMPUS	13
Work Address City St Cntry	MAILCSC	30
Work_Address_Zip	MAILPOST	10
Work_Email	EMAILADD	50	Not populated for LBL, Hastings or ASUCLA
Foradd_Ind	FORADD_IND	1	F=Foreign address
Foradd_Prov	FORADD_PROV	15
Foradd_Ctry	FORADD_CTRY	30	Translation of foreign country code in PPS
Foradd_Post	FORADD_POST	10
Department	DEPARTMENT	60	Department from Telecom file
Campus_Addr_1	CAMPUS_ADDR_1	32
Campus_Addr_2	CAMPUS_ADDR_2	32
Campus_City	CAMPUS_CITY	32
Campus_State	CAMPUS_STATE	2
Campus_Zip	CAMPUS_ZIP	5
Work_Phone	WORK_PHONE	21