SEV_I20_COMG_VW

(SQL View)
 Index Back

SEVIS I-20 Comments View


SELECT EMPLID , SEV_SCHOOL_CD , EFFDT , SEV_COMM_ID , SEV_COMMENTS FROM PS_SEV_I20_COMMENT WHERE SEV_COMM_ID = 'I20G'

  • 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: I20_FORM.EMPLID

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

    Default Value: I20_FORM.SEV_SCHOOL_CD

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: I20_FORM.EFFDT

    4 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
    5 SEV_COMMENTS Long Character(500) VARCHAR2(500) SEVIS Comments