SEV_EMPL_AUTH

(SQL Table)
Index Back

SEVIS Employment Auth

This record contains the Employment Authorization data.

  • Parent Record Of SEV_EMPL_ADDR SEV_EMPL_AUTH_R
  • # 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_SCHL_CD_TBL

    3 SEV_EMPL_TYPE Character(2) VARCHAR2(2) NOT NULL SEVIS Employment Type
    01=Optional Practical Training
    02=Curricular Practical Training
    03=Off-Campus
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 START_DATE Date(10) DATE Start Date for Gen Standing PO
    6 END_DATE Date(10) DATE End Date
    7 SEV_EMPL_CODE Character(2) VARCHAR2(2) NOT NULL SEVIS Employment Code
    01=Full Time
    02=Part Time

    Default Value: 01

    8 SEV_OFF_REASON Character(2) VARCHAR2(2) NOT NULL SEVIS Off Campus Employment Reason
    01=Economic Hardship
    02=International Organization
    03=Special Student Relief
    9 SEV_CANCEL_EMP Character(1) VARCHAR2(1) NOT NULL Cancel Employment

    Y/N Table Edit

    Default Value: N

    10 SEV_ACAD_YR_MET Character(1) VARCHAR2(1) NOT NULL SEVIS Academic Year Met

    Y/N Table Edit

    Default Value: N

    11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 SEV_OPT_COMP_TYP Character(2) VARCHAR2(2) NOT NULL SEVIS 6.0 - OPT Completion Type.
    01=Pre Completion
    02=Post Completion
    13 SEV_17_MONTH_EXT Character(1) VARCHAR2(1) NOT NULL SEVIS 6.0 - OPT 17 Month Extension.
    N=No
    Y=Yes
    14 SEV_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL SEVIS 6.0 - Request Status.
    A=Approved
    C=Canceled
    D=Denied
    P=Pending
    R=Requested
    U=Unknown
    W=Withdrawn
    15 SEV_EXT_START_DT Date(10) DATE SEVIS 6.0 - OPT Extension Start Date
    16 SEV_EXT_END_DT Date(10) DATE SEVIS 6.0 - OPT Extension End Date.
    17 SEV_STDNT_REMARK Long Character(500) VARCHAR2(500) SEVIS 6.0 - Student Remarks
    18 SEV_EMPL_REMARKS Long Character(250) VARCHAR2(250) SEVIS 6.0 - SEV Employment Remarks