I9_IAUTH_REV_VW

(SQL View)
 Index Back

Issuing Auth Reverification

Issuing Authority Reverification

SELECT '00' ,'N/A' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '01' ,'U.S. Passport' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '02' ,'U.S. Passport Card' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '03' ,'Perm. Resident Card (Form I-551)' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '04' ,'Alien Reg. Receipt Card (Form I-551)' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '05' ,'Foreign Passport with Temp. I-551 Stamp' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '06' ,'Foreign Passport with Temp. I-551 MRIV' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '07' ,'Employment Auth. Document (Form I-766)' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '08' ,'Foreign Passport with Form I-94, endorsement' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '09' ,'FSM Passport with Form I-94' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '10' ,'RMI Passport with Form I-94' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '11' ,'Receipt: Form I-94/I-94A w/I-551 stamp, photo' ,'Y' ,'05' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '12' ,'Receipt: Form I-94/I-94A w/refugee stamp (or RE class of admission)' ,'Y' ,'05' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '13' ,'Social Security Card (Unrestricted)' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '14' ,'Form FS-545' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '15' ,'Form DS-1350' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '30' ,'Form FS-240' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '16' ,'U.S. Birth certificate' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '17' ,'Native American tribal document' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '18' ,'Form I-197' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '19' ,'Form I-179' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '20' ,'Employment auth. document (DHS)' ,'N' ,' ' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '21' ,'Receipt: Replacement Perm. Resident Card (Form I-551)' ,'Y' ,'03' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '22' ,'Receipt: Replacement Employment Auth. Document (Form I-766)' ,'Y' ,'07' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '23' ,'Receipt: Replacement Foreign Passport with Form I-94, endorsement' ,'Y' ,'08' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '24' ,'Receipt: Replacement FSM passport/Form I-94' ,'Y' ,'09' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '25' ,'Receipt: Replacement RMI passport/Form I-94' ,'Y' ,'10' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '26' ,'Receipt: Replacement Social Security Card' ,'Y' ,'13' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '27' ,'Receipt: Replacement Birth Certificate' ,'Y' ,'16' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '28' ,'Receipt: Replacement Native American Tribal Document' ,'Y' ,'17' ,'A' FROM PS_INSTALLATION UNION ALL SELECT '29' ,'Receipt: Replacement Employment Auth. Doc (DHS)' ,'Y' ,'20' ,'A' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 I9_REV_DOC_TITLE Character(2) VARCHAR2(2) NOT NULL Document Title
2 I9_REV_DOCTITLE Character(50) VARCHAR2(50) NOT NULL Document Title
3 I9_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Flag
4 I9_RCPT_DOC_TITLE Character(2) VARCHAR2(2) NOT NULL Receipt Flag
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive