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	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	BIRTHDATE	Date(10)	DATE NOT NULL	Date of Birth
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
12	MIDDLE_INITIAL	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
16	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
17	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
18	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
19	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
20	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
21	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
22	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
23	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
24	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
25	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
26	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
27	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
28	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
29	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
30	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
31	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
32	COUNTRY_EE	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=United States
33	ZIP_CODE_EE	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
34	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
35	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
36	PHONE_EE	Character(12)	VARCHAR2(12) NOT NULL	Telephone
37	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
38	MAIDEN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Maiden Name
39	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
40	I9_ALIEN_NBR	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
41	I9_ALIEN_AUTH_DT	Date(10)	DATE	Alien Authorization Date
42	I9_ALIEN_USCIS	Character(1)	VARCHAR2(1) NOT NULL	Alien/USCIS Number A=Alien Number U=USCIS Number
43	I9_ALIEN_USCIS_2	Character(1)	VARCHAR2(1) NOT NULL	Alien/USCIS Number A=Alien Number U=USCIS Number
44	I9_ALIEN_NBR2	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
45	I9_ADMISSION_NBR	Character(12)	VARCHAR2(12) NOT NULL	Alien Number
46	I9_SRC_ADMISS_NBR	Character(1)	VARCHAR2(1) NOT NULL	Source of Admission Number C=Customs and Border Protection U=US Citizenship and Immigration
47	I9_PASSPORT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Foreign Passport Number
48	I9_COUNTRY_PASSPRT	Character(3)	VARCHAR2(3) NOT NULL	Country of Issuance Prompt Table: COUNTRY_TBL
49	I9_SPCL_PLACEMENT	Character(1)	VARCHAR2(1) NOT NULL	Special Placement Y/N Table Edit Default Value: N
50	I9_MINOR	Character(1)	VARCHAR2(1) NOT NULL	Minor Y/N Table Edit Default Value: N
51	I9_TRANSLATOR	Character(1)	VARCHAR2(1) NOT NULL	Translator Y/N Table Edit Default Value: N
52	I9_EE_SIGN_DT	Date(10)	DATE NOT NULL	Employee Sign Date
53	NAME_PREPARER	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
54	FIRST_NM_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	First Name
55	LAST_NM_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	Last Name
56	ADDRESS1_PREPARER	Character(55)	VARCHAR2(55) NOT NULL	Address
57	CITY_PREPARER	Character(30)	VARCHAR2(30) NOT NULL	City
58	STATE_PREPARER	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
59	POSTAL_PREPARER	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
60	COUNTRY_PREPARER	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=United States
61	I9_PREP_SIGN_DT	Date(10)	DATE	Preparer Sign Date
62	HIRE_DT	Date(10)	DATE	First Start Date
63	REHIRE_DT	Date(10)	DATE	Rehire Date
64	NAME_ADMIN	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
65	NAME_ADMIN_FIRST	Character(30)	VARCHAR2(30) NOT NULL	Administrator Name
66	NAME_ADMIN_LAST	Character(30)	VARCHAR2(30) NOT NULL	Administrator Name
67	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
68	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
69	I9_ER_SIGN_DT	Date(10)	DATE	Employer Sign Date
70	I9_ER_COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
71	ADDRESS1_COMPANY	Character(55)	VARCHAR2(55) NOT NULL	Address
72	ADDRESS2_COMPANY	Character(55)	VARCHAR2(55) NOT NULL	Address
73	CITY_COMPANY	Character(30)	VARCHAR2(30) NOT NULL	City
74	STATE_COMPANY	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
75	POSTAL_COMPANY	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
76	I9_REV_DOC_TITLE	Character(2)	VARCHAR2(2) NOT NULL	Document Title
77	I9_REV_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
78	I9_REV_DOC_NBR	Character(30)	VARCHAR2(30) NOT NULL	Document Number
79	I9_REV_DOC_EXP_DT	Date(10)	DATE	Exp. Date (if any)
80	I9_REV_RECEIPT_NBR	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
81	I9_REV_REC_EXP_DT	Date(10)	DATE	Exp. Date (if any)
82	I9_REVERIFIED_DT	Date(10)	DATE	Reverification Date
83	I9_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Doc Type A=List A B=List B AND List C Default Value: A
84	I9_DOC_TITLE_A	Character(2)	VARCHAR2(2) NOT NULL	Document Title
85	I9_DOC_TITLE_A2	Character(2)	VARCHAR2(2) NOT NULL	Document Title
86	I9_DOC_TITLE_A3	Character(2)	VARCHAR2(2) NOT NULL	Document Title
87	I9_DOC_TITLE_B	Character(2)	VARCHAR2(2) 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
88	I9_DOC_TITLE_C	Character(2)	VARCHAR2(2) NOT NULL	Document Title 8=Certification of Birth(FS-545) 9=Certi.Report of Birth(DS-1350) T=US Social Security Card T=US Social Security AccNo: 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
89	I9_ISSUE_AUTH_A	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
90	I9_ISSUE_AUTH_A2	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
91	I9_ISSUE_AUTH_A3	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
92	I9_ISSUE_AUTH_B	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
93	I9_ISSUE_AUTH_C	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority
94	I9_RECEIPT_FLG_A	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
95	I9_RECEIPT_FLG_A2	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
96	I9_RECEIPT_FLG_A3	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
97	I9_RECEIPT_FLG_B	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
98	I9_RECEIPT_FLG_C	Character(1)	VARCHAR2(1) NOT NULL	Receipt Y/N Table Edit Default Value: N
99	I9_RECEIPT_NBR_A1	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
100	I9_RECEIPT_NBR_A2	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
101	I9_RECEIPT_NBR_A3	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
102	I9_RECEIPT_NBR_B	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
103	I9_RECEIPT_NBR_C	Character(30)	VARCHAR2(30) NOT NULL	Receipt Document Number
104	I9_REC_EXP_DT_A1	Date(10)	DATE	Exp. Date (if any)
105	I9_REC_EXP_DT_A2	Date(10)	DATE	Exp. Date (if any)
106	I9_REC_EXP_DT_A3	Date(10)	DATE	Exp. Date (if any)
107	I9_REC_EXP_DT_B	Date(10)	DATE	Exp. Date (if any)
108	I9_REC_EXP_DT_C	Date(10)	DATE	Exp. Date (if any)
109	I9_DOC_NBR_A1	Character(39)	VARCHAR2(39) NOT NULL	Document Number
110	I9_DOC_NBR_A2	Character(39)	VARCHAR2(39) NOT NULL	Document Number
111	I9_DOC_NBR_A3	Character(39)	VARCHAR2(39) NOT NULL	Document Number
112	I9_DOC_NBR_B	Character(45)	VARCHAR2(45) NOT NULL	Document Number
113	I9_DOC_NBR_C	Character(39)	VARCHAR2(39) NOT NULL	Document Number
114	I9_DOC_EXP_DT_A1	Date(10)	DATE	Exp. Date (if any)
115	I9_DOC_EXP_DT_A2	Date(10)	DATE	Exp. Date (if any)
116	I9_DOC_EXP_DT_A3	Date(10)	DATE	Exp. Date (if any)
117	I9_DOC_EXP_DT_B	Date(10)	DATE	Exp. Date (if any)
118	I9_DOC_EXP_DT_C	Date(10)	DATE	Exp. Date (if any)
119	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
120	NAME_AC_FIRST	Character(30)	VARCHAR2(30) NOT NULL	First Name
121	NAME_AC_LAST	Character(30)	VARCHAR2(30) NOT NULL	Last Name
122	NAME_AC_MIDDLE	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
123	NAME_FIELD	Character(50)	VARCHAR2(50) NOT NULL	Name Field
124	I9_MSG_TXT	Long Character	CLOB	Message
125	I9_PREP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Preparer CheckBox
126	I9_PREP_COUNT	Character(1)	VARCHAR2(1) NOT NULL	How Many 1=1 2=2 3=3 4=4 5=5
127	I9_LIST_C7_TITLE	Character(30)	VARCHAR2(30) NOT NULL	List C#7 Title
128	I9_EXP_DS	Character(3)	VARCHAR2(3) NOT NULL	Expiration Date D/S
129	I9_NAME_PREPARER_2	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
130	I9_NAME_PREPARER_3	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
131	I9_NAME_PREPARER_4	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
132	I9_NAME_PREPARER_5	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
133	I9_PREP_SIGN_DT_2	Date(10)	DATE	Preparer Sign Date
134	I9_PREP_SIGN_DT_3	Date(10)	DATE	Preparer Sign Date
135	I9_PREP_SIGN_DT_4	Date(10)	DATE	Preparer Sign Date
136	I9_PREP_SIGN_DT_5	Date(10)	DATE	Preparer Sign Date
137	I9_LAST_NM_PREP_2	Character(30)	VARCHAR2(30) NOT NULL	Last Name
138	I9_LAST_NM_PREP_3	Character(30)	VARCHAR2(30) NOT NULL	Last Name
139	I9_LAST_NM_PREP_4	Character(30)	VARCHAR2(30) NOT NULL	Last Name
140	I9_LAST_NM_PREP_5	Character(30)	VARCHAR2(30) NOT NULL	Last Name
141	I9_FIRST_NM_PREP_2	Character(30)	VARCHAR2(30) NOT NULL	First Name
142	I9_FIRST_NM_PREP_3	Character(30)	VARCHAR2(30) NOT NULL	First Name
143	I9_FIRST_NM_PREP_4	Character(30)	VARCHAR2(30) NOT NULL	First Name
144	I9_FIRST_NM_PREP_5	Character(30)	VARCHAR2(30) NOT NULL	First Name
145	I9_MID_NM_PREP_2	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
146	I9_MID_NM_PREP_3	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
147	I9_MID_NM_PREP_4	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
148	I9_MID_NM_PREP_5	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
149	I9_ADDRESS1_PREP_2	Character(55)	VARCHAR2(55) NOT NULL	Address
150	I9_ADDRESS1_PREP_3	Character(55)	VARCHAR2(55) NOT NULL	Address
151	I9_ADDRESS1_PREP_4	Character(55)	VARCHAR2(55) NOT NULL	Address
152	I9_ADDRESS1_PREP_5	Character(55)	VARCHAR2(55) NOT NULL	Address
153	I9_CITY_PREP_2	Character(30)	VARCHAR2(30) NOT NULL	City
154	I9_CITY_PREP_3	Character(30)	VARCHAR2(30) NOT NULL	City
155	I9_CITY_PREP_4	Character(30)	VARCHAR2(30) NOT NULL	City
156	I9_CITY_PREP_5	Character(30)	VARCHAR2(30) NOT NULL	City
157	I9_STATE_PREP_2	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
158	I9_STATE_PREP_3	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
159	I9_STATE_PREP_4	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
160	I9_STATE_PREP_5	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
161	I9_COUNTRY_PREP_2	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=USA
162	I9_COUNTRY_PREP_3	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=USA
163	I9_COUNTRY_PREP_4	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=USA
164	I9_COUNTRY_PREP_5	Character(3)	VARCHAR2(3) NOT NULL	Country CAN=Canada MEX=Mexico USA=USA
165	I9_POSTAL_PREP_2	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
166	I9_POSTAL_PREP_3	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
167	I9_POSTAL_PREP_4	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
168	I9_POSTAL_PREP_5	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
169	I9_PASSPORT_COUNTR	Character(33)	VARCHAR2(33) NOT NULL	Foreign Passport Number and Co
170	I9_VERIFY_DOC	Character(1)	VARCHAR2(1) NOT NULL	E Verify Documents N=No Y=Yes
171	I9_REVERIFY_DOC	Character(1)	VARCHAR2(1) NOT NULL	E Verify Documents N=No Y=Yes
172	I9_ADMIN_NAME_TITL	Character(50)	VARCHAR2(50) NOT NULL	Administrator Name
173	MIDDLE_NM_PREPARER	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
174	I9_REV_MSG_TXT	Long Character	CLOB	Message
175	I9_NAME_AC_LAST_2	Character(30)	VARCHAR2(30) NOT NULL	Last Name
176	I9_NAME_AC_LAST_3	Character(30)	VARCHAR2(30) NOT NULL	Last Name
177	I9_NAME_AC_FIRST_2	Character(30)	VARCHAR2(30) NOT NULL	First Name
178	I9_NAME_AC_FIRST_3	Character(30)	VARCHAR2(30) NOT NULL	First Name
179	I9_NAME_AC_MIDDLE2	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
180	I9_NAME_AC_MIDDLE3	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
181	I9_REV_DOCTITLE2	Character(50)	VARCHAR2(50) NOT NULL	Document Title Prompt Table: I9_IAUTH_REV_VW
182	I9_REV_DOCTITLE3	Character(50)	VARCHAR2(50) NOT NULL	Document Title Prompt Table: I9_IAUTH_REV_VW
183	I9_REV_DOC_NBR2	Character(30)	VARCHAR2(30) NOT NULL	Document Number
184	I9_REV_DOC_NBR3	Character(30)	VARCHAR2(30) NOT NULL	Document Number
185	I9_REV_DOC_EXP_DT2	Date(10)	DATE	Exp. Date (if any)
186	I9_REV_DOC_EXP_DT3	Date(10)	DATE	Exp. Date (if any)
187	I9_REV_MSG_TXT2	Long Character	CLOB	Message
188	I9_REV_MSG_TXT3	Long Character	CLOB	Message
189	I9_REVERIFY_DOC2	Character(1)	VARCHAR2(1) NOT NULL	E Verify Documents N=No Y=Yes
190	I9_REVERIFY_DOC3	Character(1)	VARCHAR2(1) NOT NULL	E Verify Documents N=No Y=Yes
191	I9_REVERIFIED_DT_2	Date(10)	DATE	Reverification Date
192	I9_REVERIFIED_DT_3	Date(10)	DATE	Reverification Date
193	I9_REV_SIGNATURE2	Character(1)	VARCHAR2(1) NOT NULL	Employer Signature S=Signature
194	I9_REV_SIGNATURE3	Character(1)	VARCHAR2(1) NOT NULL	Employer Signature S=Signature
195	I9_NAME_FIELD2	Character(50)	VARCHAR2(50) NOT NULL	Name Field
196	I9_NAME_FIELD3	Character(50)	VARCHAR2(50) NOT NULL	Name Field
197	I9_REHIRE_DT_2	Date(10)	DATE	Rehire Date
198	I9_REHIRE_DT_3	Date(10)	DATE	Rehire Date
199	I9_DOCTITLE_A	Character(50)	VARCHAR2(50) NOT NULL	Document Title
200	I9_DOCTITLE_A2	Character(50)	VARCHAR2(50) NOT NULL	Document Title
201	I9_DOCTITLE_A3	Character(50)	VARCHAR2(50) NOT NULL	Document Title
202	I9_DOCTITLE_B	Character(50)	VARCHAR2(50) NOT NULL	Document Title
203	I9_DOCTITLE_C	Character(50)	VARCHAR2(50) NOT NULL	Document Title
204	I9_REV_DOCTITLE	Character(50)	VARCHAR2(50) NOT NULL	Document Title
205	REVISION_DT	Date(10)	DATE	Revision Date
206	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
207	I9_STATUS	Character(1)	VARCHAR2(1) NOT NULL	I9 status A=Approved D=Denied I=Draft M=Pushed Back P=Pending Approval Q=I9 Verified- Not Approved R=I9 Reverified S=Submitted T=New Document - Pending Approva U=New Document Submitted V=Completed X=Not Started
208	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.