I20_FORM

(SQL Table)
 Index Back

I20 Form

Used for creation of I20 Forms.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code

    Default Value: OPR_DEF_TBL_CS.SEV_SCHOOL_CD

    Prompt Table: SEV_SCH_SCTY_PR

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    8 SEV_COMMUTER Character(1) VARCHAR2(1) NOT NULL SEVIS Commuter

    Y/N Table Edit

    Default Value: N

    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SEV_CITIZEN_VW

    10 SEV_ISSUE_REASON Character(1) VARCHAR2(1) NOT NULL SEVIS Issue Reason
    C=Continued Attendance
    I=Initial Creation
    O=Other
    R=Reinstatement Request
    S=Initial - Change of Status
    T=School Transfer
    11 LVL_OF_EDUC Character(2) VARCHAR2(2) NOT NULL Level of Education
    01=Primary
    02=Secondary
    03=Associate
    04=Bachelors
    05=Masters
    06=Doctorate
    07=Language training
    08=High School
    09=Flight training
    10=Other vocational school
    11=Other
    99=No Valid Values

    Prompt Table: XLAT_LVLED_VW

    12 FROM_DATE Date(10) DATE From Date
    13 TO_DATE Date(10) DATE Latest Date to be sent to PYR
    14 LENGTH_OF_STUDY Number(2,0) SMALLINT NOT NULL SEVIS Length of study
    15 ENG_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL English Proficiency Required

    Y/N Table Edit

    Default Value: Y

    16 PROFICENCY_TEST Character(1) VARCHAR2(1) NOT NULL Proficient
    N=Student is not proficient yet
    Y=Student is proficient
    17 NBR_MONTH Number(2,0) SMALLINT NOT NULL Months in an academic term
    18 TUITION_FEES Number(8,0) INTEGER NOT NULL Tuition and fees
    19 LIVING_EXPENSES Number(8,0) INTEGER NOT NULL Living expenses
    20 DEPENDENT_EXPENSES Number(8,0) INTEGER NOT NULL Dependent Expenses
    21 OTHER_EXPENSES Number(8,0) INTEGER NOT NULL Other expenses
    22 PERSONAL_FUND Number(8,0) INTEGER NOT NULL Student's personal funds
    23 SCHOOL_FUND Number(8,0) INTEGER NOT NULL School fund
    24 FUND_OTHER_SOURCE Number(8,0) INTEGER NOT NULL Funds from another source
    25 ON_CAMPUS_EMPLOY Number(8,0) INTEGER NOT NULL On-campus employment
    26 SEV_FUNDING_VERIFY Character(1) VARCHAR2(1) NOT NULL SEVIS Funding Verified

    Y/N Table Edit

    Default Value: N

    27 SEV_DSO_EMPLID Character(11) VARCHAR2(11) NOT NULL SEVIS School Official Emplid

    Prompt Table: SEV_SCH_OFF_VW

    28 DATE_ISSUED Date(10) DATE Date Issued

    Default Value: %Date

    29 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    30 SEV_CANCEL_RSN Character(2) VARCHAR2(2) NOT NULL SEVIS Student Cancellation Reason
    01=Student not attending
    02=Visa for different SEVIS ID
    03=Registered under different ID
    04=Arrived under different ID
    05=Record created in error
    06=Offer withdrawn
    31 SEV_TRNSFR_DT Date(10) DATE SEVIS Transfer Date
    32 SEV_CAPGAP_EXT Character(1) VARCHAR2(1) NOT NULL SEVIS 6.0 - Cap Gap Extension Status
    C=Cancelled
    F=Filed
    T=Waitlisted
    33 REMARKS_I20 Long Character(500) VARCHAR2(500) Remarks
    34 SEV_USADR_EXPCD Character(2) VARCHAR2(2) NOT NULL SEVIS Explanation Code
    OB=Campus business address
    OH=Campus housing address
    OM=Campus mailing address
    ON=New mailing address
    OO=Other override
    OP=New physical address
    35 SEV_USADR_EXPTX Character(200) VARCHAR2(200) NOT NULL SEVIS Explanation Code
    36 SEV_ISS_DATE Date(10) DATE SEVIS Initial Session Start Date
    37 SEV_CITIZEN_STAT Character(2) VARCHAR2(2) NOT NULL SEVIS Citizen Status
    03=Born to Foreign Diplomat
    04=Expatriate