I9_IAUTH_A_VW

(SQL View)
 Index Back

Issuing Authority ListA

Issuing Authority ListA

SELECT 'C' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'N' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'01' ,'U.S. Passport' ,'U.S. Department of State' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'02' ,'U.S. Passport Card' ,'U.S. Department of State' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'N' ,'01' ,'U.S. Passport' ,'U.S. Department of State' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'N' ,'02' ,'U.S. Passport Card' ,'U.S. Department of State' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'03' ,'Perm. Resident Card (Form I-551)' ,'U.S. Citizenship and Immigration Services' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'03' ,'Perm. Resident Card (Form I-551)' ,'DOJ Immigration and Naturalization Service' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'04' ,'Alien Reg. Receipt Card (Form I-551)' ,'DOJ Immigration and Naturalization Service' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'05' ,'Foreign Passport with Temp. I-551 Stamp' ,' ' ,'Y' ,'Y' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'18' ,'Foreign Passport with Temp. I-551 MRIV' ,' ' ,'Y' ,'Y' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'06' ,'Receipt: Form I-94/I-94A w/I-551 stamp, photo' ,'U.S. Department of Homeland Security' ,'N' ,'N' ,'N' ,'Y' ,'05' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'07' ,'Receipt Replacement Perm. Res. Card (Form I-551)' ,'U.S. Citizenship and Immigration Services' ,'N' ,'N' ,'N' ,'Y' ,'03' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'08' ,'Employment Auth. Document (Form I-766)' ,'U.S. Citizenship and Immigration Services' ,'N' ,'N' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'09' ,'Foreign Passport, work-authorized nonimmigrant' ,' ' ,'Y' ,'Y' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'10' ,'FSM Passport with Form I-94' ,'Federated States of Micronesia' ,'N' ,'Y' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'12' ,'RMI Passport with Form I-94' ,'Republic of the Marshall Islands' ,'N' ,'Y' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'13' ,'Receipt: Replacement EAD (Form I-766)' ,'U.S. Citizenship and Immigration Services' ,'N' ,'N' ,'N' ,'Y' ,'08' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'14' ,'Receipt: Form I-94/I-94A w/refugee stamp (or RE class of admission)' ,'U.S. Department of Homeland Security' ,'N' ,'N' ,'N' ,'Y' ,'09' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'15' ,'Receipt: Foreign Passport, work-authorized nonimmigrant' ,' ' ,'Y' ,'Y' ,'Y' ,'Y' ,'09' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'16' ,'Receipt: FSM Passport with Form I-94' ,'Federated States of Micronesia' ,'N' ,'Y' ,'N' ,'Y' ,'10' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'17' ,'Receipt: RMI Passport with Form I-94' ,'Republic of the Marshall Islands' ,'N' ,'Y' ,'N' ,'Y' ,'12' ,'A' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 I9_ELIG_TYPE Character(1) VARCHAR2(1) NOT NULL Eligibility Type
A=Alien
C=Citizen
N=Non Citizen of US
R=Permanent Resident
2 I9_DOC_TITLE_A Character(2) VARCHAR2(2) NOT NULL Document Title
3 I9_DOCTITLE_A Character(50) VARCHAR2(50) NOT NULL Document Title
4 I9_ISSUE_AUTH_A Character(50) VARCHAR2(50) NOT NULL Issuing Authority
5 I9_IAUTH_FLG Character(1) VARCHAR2(1) NOT NULL Issuing Authority Flag
6 I9_LIST_A2_FLG Character(1) VARCHAR2(1) NOT NULL Issuing Authority Flag
7 I9_LIST_A3_FLG Character(1) VARCHAR2(1) NOT NULL Issuing Authority Flag
8 I9_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Flag
9 I9_RCPT_DOC_TITLE Character(2) VARCHAR2(2) NOT NULL Receipt Flag
10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive