SEVMSTPGM_A_VW

(SQL View)
 Index Back

SEVIS Master - Program Data

SEVIS Status Active Program Data

SELECT A.EMPLID , A.SEV_SCHOOL_CD , A.SEV_PRG_NBR , A.SEV_STATUS , A.EFFDT , A.SEV_EXT_BATCH_ID , A.SEV_EXT_REQUEST_ID , A.EFF_STATUS , A.SEV_MAJOR , A.SEV_CIP_MAJOR , A.SEV_SEC_MAJOR , A.SEV_CIP_SEC_MAJOR , A.SEV_MINOR , A.SEV_CIP_MINOR , A.LENGTH_OF_STUDY , A.FROM_DATE , A.TO_DATE , A.SEV_END_PGM_RSN , A.SEV_EFFDT , A.ENG_PROFICIENCY , A.PROFICENCY_TEST , A.ACAD_PLAN , A.SUBJ_FIELD_CODE , A.VISITOR_CATEGORY , A.SEV_MATRIC_TYPE , A.PROG_ACTION , A.INSTITUTION , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.LASTUPDOPRID , A.LASTUPDDTTM FROM PS_SEV_MST_PGM A WHERE A.SEV_STATUS = 'A' AND A.LASTUPDDTTM = ( SELECT MAX(A1.LASTUPDDTTM) FROM PS_SEV_MST_PGM A1 WHERE A1.SEV_STATUS = 'A' AND A1.EMPLID = A.EMPLID AND A1.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD AND A1.SEV_PRG_NBR = A.SEV_PRG_NBR)

# 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 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
4 SEV_STATUS Character(1) VARCHAR2(1) NOT NULL SEVIS Status
A=Active
C=Cancelled
D=Deactivated
F=Draft
I=Initial
L=Invalid
N=No Show
P=Completed
T=Terminated
V=Inactive
5 AS_OF_DATE Date(10) DATE As of Date
6 SEV_EXT_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Extract Batch ID
7 SEV_EXT_REQUEST_ID Character(20) VARCHAR2(20) NOT NULL SEVIS Extract Request ID
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
9 SEV_MAJOR Character(10) VARCHAR2(10) NOT NULL SEVIS Major - Acad Plan

Prompt Table: ACAD_PLAN_TBL

10 SEV_CIP_MAJOR Character(13) VARCHAR2(13) NOT NULL CIP 2000
11 SEV_SEC_MAJOR Character(10) VARCHAR2(10) NOT NULL SEVIS Secondary Major

Prompt Table: ACAD_PLAN_TBL

12 SEV_CIP_SEC_MAJOR Character(13) VARCHAR2(13) NOT NULL CIP 2000
13 SEV_MINOR Character(10) VARCHAR2(10) NOT NULL SEVIS Minor
14 SEV_CIP_MINOR Character(13) VARCHAR2(13) NOT NULL CIP 2000
15 LENGTH_OF_STUDY Number(2,0) SMALLINT NOT NULL SEVIS Length of study
16 FROM_DATE Date(10) DATE From Date
17 TO_DATE Date(10) DATE Latest Date to be sent to PYR
18 SEV_END_PGM_RSN Character(4) VARCHAR2(4) NOT NULL SEVIS End Program Reason
APED=Adjusted program end date
CCHG=Cancellation - status change
CCHG=Cancellation - status change
CHG=Change of Status
CHG=Change of Status
COMP=Completed
COMP=Completed
CSHS=Cultural shock/homesickness
DCHG=Denied - change of status
DCHG=Denied - change of status
DOE=Death of EV
ICP=Inability to continue program
ICP=Inability to continue program
IFS=Inadequate financial support
MEHE=Medical emergency/health
MEHF=Medical/health of family
NOS=No Show
NOS=No Show
OTHR=Other
PCP=PgmCmp >=30 days before End Dt
PCP=PgmCmp >=30 days before End Dt
POCE=Program objectives comp early
WFP=Withdrawal from program
19 SEV_EFFDT Date(10) DATE SEVIS Effective Date
20 ENG_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL English Proficiency Required

Y/N Table Edit

21 PROFICENCY_TEST Character(1) VARCHAR2(1) NOT NULL Proficient
N=Student is not proficient yet
Y=Student is proficient
22 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
23 SUBJ_FIELD_CODE Character(8) VARCHAR2(8) NOT NULL Subj/Field Code

Prompt Table: SEV_CIP_CODE_VW

24 VISITOR_CATEGORY Character(2) VARCHAR2(2) NOT NULL Visitor's Category
25 SEV_MATRIC_TYPE Character(1) VARCHAR2(1) NOT NULL Matriculation Type
A=Associates
B=Bachelors
D=Doctorate
M=Masters
26 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal
27 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

28 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: ACAD_CAR_TBL

29 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
30 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31 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.