| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 4 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 5 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 6 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 7 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 8 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 9 |
MIDDLE_INITIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
The employee's middle initial
|
| 10 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 11 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 13 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 14 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 15 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 16 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 17 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 18 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 19 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 20 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 21 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 22 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 23 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 24 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 25 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 26 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 27 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 28 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 29 |
COUNTRY_EE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
CAN=Canada
MEX=Mexico
USA=United States
Default Value: USA
|
| 30 |
ZIP_CODE_EE |
Character(10) |
VARCHAR2(10) NOT NULL |
Postal Code
|
| 31 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 32 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 33 |
PHONE_EE |
Character(12) |
VARCHAR2(12) NOT NULL |
Telephone
|
| 34 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 35 |
MAIDEN_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Maiden Name
|
| 36 |
I9_ELIG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligibility Type
A=Alien
C=Citizen
N=Non Citizen of US
R=Permanent Resident
|
| 37 |
I9_ALIEN_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Alien Number
|
| 38 |
I9_ALIEN_AUTH_DT |
Date(10) |
DATE |
Alien Authorization Date
|
| 39 |
I9_ALIEN_NBR2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Alien Number
|
| 40 |
I9_ADMISSION_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Alien Number
|
| 41 |
I9_SRC_ADMISS_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Admission Number
C=Customs and Border Protection
U=US Citizenship and Immigration
|
| 42 |
I9_PASSPORT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Foreign Passport Number
|
| 43 |
I9_COUNTRY_PASSPRT |
Character(3) |
VARCHAR2(3) NOT NULL |
Country of Issuance
Prompt Table:
COUNTRY_TBL
|
| 44 |
I9_SPCL_PLACEMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Placement
Y/N Table Edit
Default Value: N
|
| 45 |
I9_MINOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Minor
Y/N Table Edit
Default Value: N
|
| 46 |
I9_TRANSLATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Translator
Y/N Table Edit
Default Value: N
|
| 47 |
I9_EE_SIGN_DT |
Date(10) |
DATE |
Employee Sign Date
|
| 48 |
NAME_PREPARER |
Character(50) |
VARCHAR2(50) NOT NULL |
Administrator Name
|
| 49 |
FIRST_NM_PREPARER |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 50 |
LAST_NM_PREPARER |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 51 |
ADDRESS1_PREPARER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 52 |
CITY_PREPARER |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 53 |
STATE_PREPARER |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 54 |
POSTAL_PREPARER |
Character(10) |
VARCHAR2(10) NOT NULL |
Postal Code
|
| 55 |
COUNTRY_PREPARER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
CAN=Canada
MEX=Mexico
USA=United States
Default Value: USA
|
| 56 |
I9_PREP_SIGN_DT |
Date(10) |
DATE |
Preparer Sign Date
|
| 57 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 58 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 59 |
NAME_ADMIN |
Character(50) |
VARCHAR2(50) NOT NULL |
Administrator Name
|
| 60 |
NAME_ADMIN_FIRST |
Character(30) |
VARCHAR2(30) NOT NULL |
Administrator Name
|
| 61 |
NAME_ADMIN_LAST |
Character(30) |
VARCHAR2(30) NOT NULL |
Administrator Name
|
| 62 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 63 |
TITLE |
Character(35) |
VARCHAR2(35) NOT NULL |
Title
|
| 64 |
I9_ER_SIGN_DT |
Date(10) |
DATE |
Employer Sign Date
|
| 65 |
I9_ER_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 66 |
ADDRESS1_COMPANY |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 67 |
ADDRESS2_COMPANY |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 68 |
CITY_COMPANY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 69 |
STATE_COMPANY |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 70 |
POSTAL_COMPANY |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 71 |
I9_REV_DOC_TITLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Title
|
| 72 |
I9_REV_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 73 |
I9_REV_DOC_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Number
|
| 74 |
I9_REV_DOC_EXP_DT |
Date(10) |
DATE |
Exp. Date (if any)
|
| 75 |
I9_REV_RECEIPT_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 76 |
I9_REV_REC_EXP_DT |
Date(10) |
DATE |
Exp. Date (if any)
|
| 77 |
I9_REVERIFIED_DT |
Date(10) |
DATE |
Reverification Date
|
| 78 |
I9_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Doc Type
A=List A
B=List B AND List C
Default Value: A
|
| 79 |
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
|
| 80 |
I9_DOC_TITLE_A2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Title
|
| 81 |
I9_DOC_TITLE_A3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Title
|
| 82 |
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
|
| 83 |
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
|
| 84 |
I9_ISSUE_AUTH_A |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 85 |
I9_ISSUE_AUTH_A2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 86 |
I9_ISSUE_AUTH_A3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 87 |
I9_ISSUE_AUTH_B |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 88 |
I9_ISSUE_AUTH_C |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 89 |
I9_RECEIPT_FLG_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 90 |
I9_RECEIPT_FLG_A2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 91 |
I9_RECEIPT_FLG_A3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 92 |
I9_RECEIPT_FLG_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 93 |
I9_RECEIPT_FLG_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt
Y/N Table Edit
Default Value: N
|
| 94 |
I9_RECEIPT_NBR_A1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 95 |
I9_RECEIPT_NBR_A2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 96 |
I9_RECEIPT_NBR_A3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 97 |
I9_RECEIPT_NBR_B |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 98 |
I9_RECEIPT_NBR_C |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Document Number
|
| 99 |
I9_REC_EXP_DT_A1 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 100 |
I9_REC_EXP_DT_A2 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 101 |
I9_REC_EXP_DT_A3 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 102 |
I9_REC_EXP_DT_B |
Date(10) |
DATE |
Exp. Date (if any)
|
| 103 |
I9_REC_EXP_DT_C |
Date(10) |
DATE |
Exp. Date (if any)
|
| 104 |
I9_DOC_NBR_A1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Number
|
| 105 |
I9_DOC_NBR_A2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Number
|
| 106 |
I9_DOC_NBR_A3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Number
|
| 107 |
I9_DOC_NBR_B |
Character(45) |
VARCHAR2(45) NOT NULL |
Document Number
|
| 108 |
I9_DOC_NBR_C |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Number
|
| 109 |
I9_DOC_EXP_DT_A1 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 110 |
I9_DOC_EXP_DT_A2 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 111 |
I9_DOC_EXP_DT_A3 |
Date(10) |
DATE |
Exp. Date (if any)
|
| 112 |
I9_DOC_EXP_DT_B |
Date(10) |
DATE |
Exp. Date (if any)
|
| 113 |
I9_DOC_EXP_DT_C |
Date(10) |
DATE |
Exp. Date (if any)
|
| 114 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 115 |
NAME_AC_FIRST |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 116 |
NAME_AC_LAST |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 117 |
NAME_AC_MIDDLE |
Character(1) |
VARCHAR2(1) NOT NULL |
The employee's middle initial
|
| 118 |
NAME_FIELD |
Character(50) |
VARCHAR2(50) NOT NULL |
Employer Representative
|