HR_I9_PERSN_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
7	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
8	BIRTHDATE	Date(10)	DATE NOT NULL	Date of Birth
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	MIDDLE_INITIAL	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
12	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
13	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
15	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
16	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
17	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
18	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
19	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
20	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
21	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
22	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
23	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
24	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
25	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
26	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
27	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
28	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
29	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
30	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
31	COUNTRY_EE	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=United States
32	ZIP_CODE_EE	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
33	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
34	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
35	PHONE_EE	Character(12)	VARCHAR2(12) NOT NULL	Telephone
36	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
37	MAIDEN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Maiden Name
38	I9_ELIG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Type A=Alien C=Citizen N=Non Citizen of US R=Permanent Resident Default Value: C
39	I9_ALIEN_NBR	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
40	I9_ALIEN_AUTH_DT	Date(10)	DATE	Alien Authorization Date
41	I9_ALIEN_NBR2	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
42	I9_ADMISSION_NBR	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
43	I9_SRC_ADMISS_NBR	Character(1)	VARCHAR2(1) NOT NULL	Source of Admission Number C=Customs and Border Protection U=US Citizenship and Immigration
44	I9_PASSPORT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Foreign Passport Number
45	I9_COUNTRY_PASSPRT	Character(3)	VARCHAR2(3) NOT NULL	Country of Issuance Prompt Table: COUNTRY_TBL
46	I9_SPCL_PLACEMENT	Character(1)	VARCHAR2(1) NOT NULL	Special Placement Y/N Table Edit Default Value: N
47	I9_MINOR	Character(1)	VARCHAR2(1) NOT NULL	Minor Y/N Table Edit Default Value: N
48	I9_TRANSLATOR	Character(1)	VARCHAR2(1) NOT NULL	Translator Y/N Table Edit Default Value: N
49	I9_EE_SIGN_DT	Date(10)	DATE NOT NULL	Employee Sign Date
50	NAME_PREPARER	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
51	FIRST_NM_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	First Name
52	LAST_NM_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	Last Name
53	ADDRESS1_PREPARER	Character(55)	VARCHAR2(55) NOT NULL	Address
54	CITY_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	City
55	STATE_PREPARER	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
56	POSTAL_PREPARER	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
57	COUNTRY_PREPARER	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=United States
58	I9_PREP_SIGN_DT	Date(10)	DATE	Preparer Sign Date
59	HIRE_DT	Date(10)	DATE	First Start Date
60	REHIRE_DT	Date(10)	DATE	Rehire Date
61	NAME_ADMIN	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
62	NAME_ADMIN_FIRST	Character(30)	VARCHAR2(30) NOT NULL	Administrator Name
63	NAME_ADMIN_LAST	Character(30)	VARCHAR2(30) NOT NULL	Administrator Name
64	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
65	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
66	I9_ER_SIGN_DT	Date(10)	DATE	Employer Sign Date
67	I9_ER_COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
68	ADDRESS1_COMPANY	Character(55)	VARCHAR2(55) NOT NULL	Address
69	ADDRESS2_COMPANY	Character(55)	VARCHAR2(55) NOT NULL	Address
70	CITY_COMPANY	Character(30)	VARCHAR2(30) NOT NULL	City
71	STATE_COMPANY	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
72	POSTAL_COMPANY	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
73	I9_REV_DOC_TITLE	Character(1)	VARCHAR2(1) NOT NULL	Document Title
74	I9_REV_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
75	I9_REV_DOC_NBR	Character(30)	VARCHAR2(30) NOT NULL	Document Number
76	I9_REV_DOC_EXP_DT	Date(10)	DATE	Exp. Date (if any)
77	I9_REV_RECEIPT_NBR	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
78	I9_REV_REC_EXP_DT	Date(10)	DATE	Exp. Date (if any)
79	I9_REVERIFIED_DT	Date(10)	DATE	Reverification Date
80	I9_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Doc Type A=List A B=List B AND List C Default Value: A
81	I9_DOC_TITLE_A	Character(1)	VARCHAR2(1) NOT NULL	Document Title A=US Passport A=US Passport B=Certificate of US Citizenship C=Certificate of Naturalization D=Foreign Passport E=Alien Registration Receipt F=Temporary Resident Card G=Employment Authorization Card H=Reentry Permit I=Refugee Travel Document J=Employment Authorization Doc K=Perm Res Card/Alien Reg Rcpt L=Foreign pass w/tmp I-551 stmp M=Foreign pass w/Form I-94 N=Employment Auth Doc w/photo O=US Passport Card P=Foreign Pass w/temp I-551 MRIV Q=Foreign Passport w/Form I-94A R=FSM Passport w/Form I-94 S=FSM Passport w/Form I-94A T=RMI Passport w/Form I-94 U=RMI Passport w/Form I-94A
82	I9_DOC_TITLE_A2	Character(1)	VARCHAR2(1) NOT NULL	Document Title
83	I9_DOC_TITLE_A3	Character(1)	VARCHAR2(1) NOT NULL	Document Title
84	I9_DOC_TITLE_B	Character(1)	VARCHAR2(1) NOT NULL	Document Title 1=School Record/Report Card 2=Clinic, Dr. or Hospital Record 3=Day-care/Nursery School Record K=US Driver's License L=Government ID Card M=School ID Card N=Voter's Registration Card O=US Military Card P=Military Dependent's ID Card Q=US Coast Guard/Mariner Card R=Native American Tribal Doc S=Canadian Driver's License X=Special Placement Y=Individual under age 18 Z=Special and Minor
85	I9_DOC_TITLE_C	Character(1)	VARCHAR2(1) NOT NULL	Document Title 8=Certification of Birth(FS-545) 9=Certi.Report of Birth(DS-1350) T=US Social Security AccNo: Card T=US Social Security Card U=Certificate of Birth Abroad V=US Birth Ceritificate W=Native American Tribal Doc X=US Citizen ID Card Y=Resident Citizen ID Card Z=Employment Authorization Doc
86	I9_ISSUE_AUTH_A	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
87	I9_ISSUE_AUTH_A2	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
88	I9_ISSUE_AUTH_A3	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
89	I9_ISSUE_AUTH_B	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
90	I9_ISSUE_AUTH_C	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
91	I9_RECEIPT_FLG_A	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
92	I9_RECEIPT_FLG_A2	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
93	I9_RECEIPT_FLG_A3	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
94	I9_RECEIPT_FLG_B	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
95	I9_RECEIPT_FLG_C	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
96	I9_RECEIPT_NBR_A1	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
97	I9_RECEIPT_NBR_A2	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
98	I9_RECEIPT_NBR_A3	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
99	I9_RECEIPT_NBR_B	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
100	I9_RECEIPT_NBR_C	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
101	I9_REC_EXP_DT_A1	Date(10)	DATE	Exp. Date (if any)
102	I9_REC_EXP_DT_A2	Date(10)	DATE	Exp. Date (if any)
103	I9_REC_EXP_DT_A3	Date(10)	DATE	Exp. Date (if any)
104	I9_REC_EXP_DT_B	Date(10)	DATE	Exp. Date (if any)
105	I9_REC_EXP_DT_C	Date(10)	DATE	Exp. Date (if any)
106	I9_DOC_NBR_A1	Character(30)	VARCHAR2(30) NOT NULL	Document Number
107	I9_DOC_NBR_A2	Character(30)	VARCHAR2(30) NOT NULL	Document Number
108	I9_DOC_NBR_A3	Character(30)	VARCHAR2(30) NOT NULL	Document Number
109	I9_DOC_NBR_B	Character(45)	VARCHAR2(45) NOT NULL	Document Number
110	I9_DOC_NBR_C	Character(30)	VARCHAR2(30) NOT NULL	Document Number
111	I9_DOC_EXP_DT_A1	Date(10)	DATE	Exp. Date (if any)
112	I9_DOC_EXP_DT_A2	Date(10)	DATE	Exp. Date (if any)
113	I9_DOC_EXP_DT_A3	Date(10)	DATE	Exp. Date (if any)
114	I9_DOC_EXP_DT_B	Date(10)	DATE	Exp. Date (if any)
115	I9_DOC_EXP_DT_C	Date(10)	DATE	Exp. Date (if any)
116	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
117	NAME_AC_FIRST	Character(30)	VARCHAR2(30) NOT NULL	First Name
118	NAME_AC_LAST	Character(30)	VARCHAR2(30) NOT NULL	Last Name
119	NAME_AC_MIDDLE	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
120	NAME_FIELD	Character(50)	VARCHAR2(50) NOT NULL	Name Field