I9_IAUTH_A2_VW

(SQL View)
 Index Back

Issuing Authority View A2

Issuing Authority ListA2

SELECT 'C' ,'00' ,'00' ,'N/A' ,'N/A' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'00' ,'00' ,'N/A' ,'N/A' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'N' ,'00' ,'00' ,'N/A' ,'N/A' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'05' ,'01' ,'Temporary I-551 Stamp' ,'U.S. Citizenship and Immigration Services' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'05' ,'01' ,'Temporary I-551 Stamp' ,'DOJ Immigration and Naturalization Service' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'18' ,'02' ,'Machine-readable immigrant visa (MRIV)' ,'U.S. Department of State' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,' ' ,'03' ,'Form I-94/I-94A' ,'' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,' ' ,'04' ,'Receipt: Form I-94/I-94A' ,'' ,'Y' ,'03' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,' ' ,' ' ,'' ,'U.S. Citizenship and Immigration Services' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,' ' ,' ' ,' ' ,'U.S. Customs and Border Protection' ,'N' ,' ' ,'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_DOC_TITLE_A2 Character(2) VARCHAR2(2) NOT NULL Document Title
4 I9_DOCTITLE_A2 Character(50) VARCHAR2(50) NOT NULL Document Title
5 I9_ISSUE_AUTH_A2 Character(50) VARCHAR2(50) NOT NULL Issuing Authority
6 I9_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Flag
7 I9_RCPT_DOC_TITLE Character(2) VARCHAR2(2) NOT NULL Receipt Flag
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive