SEV_EMPL_AUTH(SQL Table) |
Index Back |
---|---|
SEVIS Employment AuthThis record contains the Employment Authorization data. |
# | 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 |