I9_IAUTH_B_VW

(SQL View)
 Index Back

Issuing Authority ListB

Issuing Authority ListB

SELECT '00' ,'N/A' ,'N/A' ,'N' ,'N' ,'N' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '01' ,'Driver''s license issued by state/territory' ,' ' ,'S' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '02' ,'ID card issued by federal/state/local government' ,' ' ,'S' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '03' , 'Government ID card' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '04' ,'School ID card' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '05' ,'Voter''s registration card' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '06' ,'U.S. Military card' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '07' ,'U.S. Military draft record' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '08' ,'Military dependent''s ID card' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '09' ,'USCG Merchant Mariner card' ,'U.S. Coast Guard' ,'Y' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '10' ,'Native American tribal document' ,' ' ,'T' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '11' ,'Canadian driver''s license' ,' ' ,'C' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '12' ,'School record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '13' ,'Report card (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '14' ,'Clinic record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '15' ,'Doctor record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '16' ,'Hospital record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '17' ,'Day-care record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '18' ,'Nursery School record (under age 18)' ,' ' ,'T' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '19' ,'Individual under Age 18' ,'N/A ' ,'Y' ,'N' ,' ' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '20' ,'Special Placement' ,'N/A' ,'N' ,'N' ,' ' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '21' ,'Receipt Replacement Driver''s License' ,' ' ,'S' ,'Y' ,'01' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '22' ,'Receipt Replacement ID Card' ,' ' ,'S' ,'Y' ,'02' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '23' ,'Receipt Replacement Government ID card' ,' ' ,'T' ,'Y' ,'03' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '24' ,'Receipt Replacement School ID card' ,' ' ,'T' ,'Y' ,'04' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '25' ,'Receipt Replacement Voter Reg. Card' ,' ' ,'T' ,'Y' ,'05' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '26' ,'Receipt Replacement U.S. Military card' ,' ' ,'T' ,'Y' ,'06' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '27' ,'Receipt Replacement Military Draft Record' ,' ' ,'T' ,'Y' ,'07' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '28' ,'Receipt Replacement Military Dep. Card' ,' ' ,'T' ,'Y' ,'08' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '29' ,'Receipt replacement USCG Merchant Mariner card' ,'U.S. Coast Guard' ,'N' ,'Y' ,'09' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '30' ,'Receipt Replacement Native American Tribal Doc' ,' ' ,'T' ,'Y' ,'10' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '31' ,'Receipt Replacement Canadian DL' ,' ' ,'C' ,'Y' ,'11' ,'N' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '32' ,'Receipt Replacement School Record (under age 18)' ,' ' ,'T' ,'Y' ,'12' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '33' ,'Receipt Replacement Report Card (under age 18)' ,' ' ,'T' ,'Y' ,'13' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '34' ,'Receipt Replacement Clinic Record (under age 18)' ,' ' ,'T' ,'Y' ,'14' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '35' ,'Receipt Replacement Doctor Record (under age 18)' ,' ' ,'T' ,'Y' ,'15' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '36' ,'Receipt Replace. Hospital Record (under age 18)' ,' ' ,'T' ,'Y' ,'16' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '37' ,'Receipt Replace. DAY-Care Record (under age 18)' ,' ' ,'T' ,'Y' ,'17' ,'Y' , 'A' FROM PS_INSTALLATION UNION ALL SELECT '38' ,'Receipt Replace. Nursery School Record (under age 18)' ,' ' ,'T' ,'Y' ,'18' ,'Y' ,'A' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 I9_DOC_TITLE_B Character(2) VARCHAR2(2) NOT NULL Document Title
1=School Record/Report Card
2=Clinic, Dr. or Hospital Record
3=Day-care/Nursery School Record
K=US Driver's License
L=Government ID Card
M=School ID Card
N=Voter's Registration Card
O=US Military Card
P=Military Dependent's ID Card
Q=US Coast Guard/Mariner Card
R=Native American Tribal Doc
S=Canadian Driver's License
X=Special Placement
Y=Individual under age 18
Z=Special and Minor
2 I9_DOCTITLE_B Character(50) VARCHAR2(50) NOT NULL Document Title
3 I9_ISSUE_AUTH_B Character(50) VARCHAR2(50) NOT NULL Issuing Authority
4 I9_IAUTH_FLG Character(1) VARCHAR2(1) NOT NULL Issuing Authority Flag
5 I9_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Flag
6 I9_RCPT_DOC_TITLE Character(2) VARCHAR2(2) NOT NULL Receipt Flag
7 I9_MINOR_FLG Character(1) VARCHAR2(1) NOT NULL Minor FLag
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive