SEV_CCSEVFCETMP

(SQL Table)
Index Back

Temp Table for SEVIS Extract

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: SEV_SCH_INS_VW2

4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

Prompt Table: SEV_SCH_INS_VW3

5 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

Prompt Table: STDNT_GROUP_TBL

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

8 STRM Character(4) VARCHAR2(4) NOT NULL Term
9 SEV_EXCP_UNT Number(9,3) DECIMAL(8,3) NOT NULL SEVIS Exception Units
10 INSERT_ROW Character(1) VARCHAR2(1) NOT NULL Insert Row
11 SEV_SCT_EXISTS Character(1) VARCHAR2(1) NOT NULL SEVIS Stdnt Car Term Exists
12 SEV_FULCRS_EXISTS Character(1) VARCHAR2(1) NOT NULL SEVIS FulCrsExcp Exists
13 SEV_COMMENTS Long Character(500) VARCHAR2(500) SEVIS Comments