I9_IAUTH_C_VW(SQL View) |
Index Back |
|---|---|
Issuing Authority ListCIssuing Authority ListC |
| SELECT 'C' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'01' ,'Social Security Card (Unrestricted)' ,'Social Security Administration' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'01' ,'Social Security Card (Unrestricted)' ,'U.S. Department of Health and Human Services' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'01' ,'Social Security Card (Unrestricted)' ,'Social Security Board' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'01' ,'Social Security Card (Unrestricted)' ,'Department of Health, Education and Welfare' ,'Y' ,'N' , ' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'02' ,'Form FS-545' ,'U.S. Department of State' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'03' ,'Form DS-1350' ,'U.S. Department of State' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'04' ,'U.S. Birth certificate' ,' ' ,'T' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'05' ,'Native American tribal document' ,' ' ,'T' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'06' ,'Form I-197' ,'DOJ Immigration and Naturalization Service' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'07' ,'Form I-179' ,'DOJ Immigration and Naturalization Service' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'08' ,'Employment auth. document (DHS)' ,'DHS' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'09' ,'Receipt replacement SS card (unrestricted)' ,'Social Security Administration' ,'Y' ,'Y' ,'01' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'10' ,'Receipt replacement U.S. birth certificate' ,' ' ,'T' ,'Y' ,'04' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'11' ,'Receipt Replace. Native American Tribal Doc.' ,' ' ,'T' ,'Y' ,'05' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'12' ,'Receipt Replace. Employment Auth. Doc (DHS)' ,'DHS' ,'Y' ,'Y' ,'08' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'C' ,'13' ,'Form FS-240' ,'U.S. Department of State' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'00' ,'N/A' ,'N/A' ,'N' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'21' ,'Social Security Card (Unrestricted)' ,'Social Security Administration' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'21' ,'Social Security Card (Unrestricted)' ,'U.S. Department of Health and Human Services' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'21' ,'Social Security Card (Unrestricted)' ,'Social Security Board' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'21' ,'Social Security Card (Unrestricted)' ,'Department of Health, Education and Welfare' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'22' ,'Native American tribal document' ,' ' ,'T' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'23' ,'Employment auth. document (DHS)' ,'DHS' ,'Y' ,'N' ,' ' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'24' ,'Receipt Replace. Native American Tribal Doc.' ,' ' ,'T' ,'Y' ,'22' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'25' ,'Receipt replacement SS card (unrestricted)' ,'Social Security Administration' ,'Y' ,'Y' ,'21' , 'A' FROM PS_INSTALLATION UNION ALL SELECT 'A' ,'26' ,'Receipt Replace. Employment Auth. Doc (DHS)' ,'DHS' ,'Y' ,'Y' ,'23' ,'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_C |
Character(2) | VARCHAR2(2) NOT NULL |
Document Title
8=Certification of Birth(FS-545) 9=Certi.Report of Birth(DS-1350) T=US Social Security Card T=US Social Security AccNo: 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 |
| 3 | I9_DOCTITLE_C |
Character(50) | VARCHAR2(50) NOT NULL | Document Title |
| 4 | I9_ISSUE_AUTH_C |
Character(50) | VARCHAR2(50) NOT NULL | Issuing Authority |
| 5 | I9_IAUTH_FLG | Character(1) | VARCHAR2(1) NOT NULL | Issuing Authority Flag |
| 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 |