SEV_I20_DEP_COM

(SQL Table)
 Index Back

SEVIS I-20 Comments

  • Parent record: I20_FORM

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

    Default Value: SEV_I20_DEP.EMPLID

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

    Default Value: SEV_I20_DEP.SEV_SCHOOL_CD

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: SEV_I20_DEP.EFFDT

    4 SEV_DEP_EMPLID Character(11) VARCHAR2(11) NOT NULL SEVIS Dependent ID

    Default Value: SEV_I20_DEP.SEV_DEP_EMPLID

    Prompt Table: PEOPLE_SRCH

    5 SEV_COMM_ID Character(4) VARCHAR2(4) NOT NULL SEVIS Comment ID
    DSA=Subject/Field Remarks
    DSB=Funding Comments
    DSD=Other Reason
    I20A=School Fund Type
    I20C=Education Comment
    I20D=Dependent Termination Other
    I20E=Other Expenses
    I20F=Funding Remarks
    I20G=Create Remarks
    I20O=Other Reason
    I20R=Proficiency Reason
    I20S=Other Source Funds
    I20T=Transferred From

    Default Value: I20D

    6 SEV_COMMENTS Long Character(500) VARCHAR2(500) SEVIS Comments