I9_IAUTH_A3_VW

(SQL View)
 Index Back

Issuing Authority ListA3

Issuing Authority ListA3

SELECT 'A' ,'00' ,'00' ,'N/A' ,'N/A' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'N' ,'00' ,'00' ,'N/A' ,'N/A' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'R' ,'00' ,'00' ,'N/A' ,'N/A' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'00' ,'00' ,'N/A' ,'N/A' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'15' ,'01' ,'Form I-20' ,'U.S. Immigration and Customs Enforcement' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'15' ,'01' ,'Form I-20' ,'US DOJ INS' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'15' ,'02' ,'Form DS-2019' ,'U.S. Deptartment of State' ,'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_A3 Character(2) VARCHAR2(2) NOT NULL Document Title
4 I9_DOCTITLE_A3 Character(50) VARCHAR2(50) NOT NULL Document Title
5 I9_ISSUE_AUTH_A3 Character(50) VARCHAR2(50) NOT NULL Issuing Authority
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive