SEVMSTPGM_I_VW (SQL View)	Index Back
SEVIS Master - Program Data SEVIS Status Active Program Data

SEVMSTPGM_I_VW

(SQL View)

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 = 'I' AND A.LASTUPDDTTM = ( SELECT MAX(A1.LASTUPDDTTM) FROM PS_SEV_MST_PGM A1 WHERE A1.SEV_STATUS = 'I' 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.

#	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.