SEV_EMPL_AUTH_R

(SQL Table)
 Index Back

SEVIS Employment Auth Remarks

This record contains the Remarks associated with the Employment Authorization.

  • Parent record: SEV_EMPL_AUTH

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

    Default Value: SEV_EMPL_AUTH.EMPLID

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

    Default Value: SEV_EMPL_AUTH.SEV_SCHOOL_CD

    3 SEV_EMPL_TYPE Character(2) VARCHAR2(2) NOT NULL SEVIS Employment Type
    01=Optional Practical Training
    02=Curricular Practical Training
    03=Off-Campus

    Default Value: SEV_EMPL_AUTH.SEV_EMPL_TYPE

    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: SEV_EMPL_AUTH.SEQNUM

    5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    6 SEV_EMPL_REMARKS Long Character(250) VARCHAR2(250) SEVIS 6.0 - SEV Employment Remarks