ADM_APPL_MC_VW (SQL View)	Index Back
Adm Applicant Mass Change View This view is used in Mass Change to select a group of records in order to assign an Evaluation Code to the Admissions Applicant Evaluation table.

ADM_APPL_MC_VW

(SQL View)

Adm Applicant Mass Change View

This view is used in Mass Change to select a group of records in order to assign an Evaluation Code to the Admissions Applicant Evaluation table.

Select A.Emplid, A.Acad_Career, A.Stdnt_Car_Nbr, A.Adm_Appl_Nbr, A.Appl_Prog_Nbr, A.Effdt, A.Effseq, A.Institution, A.Acad_Prog, A.Prog_Status, A.Prog_Action, A.Action_Dt, A.Prog_Reason, A.Admit_Term, A.Acad_Load_Appr, A.Campus, A.Acad_Prog_Dual, A.Joint_Prog_Appr, C.Adm_Appl_Ctr, C.Admit_Type, C.Fin_Aid_Interest, C.Housing_Interest, C.Appl_Fee_Status, C.Appl_Fee_Dt, C.Notification_Plan, C.Region, C.Region_From, C.Recruiter_Id, C.Last_Sch_Attend, C.Adm_Creation_Dt, C.Adm_Creation_By, C.Adm_Updated_Dt, C.Adm_Updated_By, C.Adm_Appl_Complete, C.Adm_Appl_Dt, C.Adm_Appl_Cmplt_Dt, C.Graduation_Dt, C.Prior_Appl, C.Appl_Fee_Type, C.Adm_Appl_Method, C.Appl_Fee_Amt, C.Appl_Fee_Paid, C.Currency_Cd, C.Tender_Category, C.Academic_Level, C.Override_Deposit, C.Ext_Adm_Appl_Nbr, D.Evaluatn_Status, D.Evaluation_Dt, D.Stdnt_Car_Nbr_Sr, D.Create_Prog_Status from PS_ADM_APPL_PROG A, PS_ADM_APPL_DATA C, PS_ADM_APP_CAR_SEQ D where A.Effdt = (Select Max(Effdt) from PS_ADM_APPL_PROG A1 where A1.Emplid = A.Emplid AND A1.Acad_Career = A.Acad_Career AND A1.Stdnt_Car_Nbr = A.Stdnt_Car_Nbr AND A1.Adm_Appl_Nbr = A.Adm_Appl_Nbr AND A1.Appl_Prog_Nbr = A.Appl_Prog_Nbr AND A1.Effdt <= %CurrentDateIn) AND A.Effseq = (Select Max(Effseq) from PS_ADM_APPL_PROG A2 where A2.Emplid = A.Emplid AND A2.Acad_Career = A.Acad_Career AND A2.Stdnt_Car_Nbr = A.Stdnt_Car_Nbr AND A2.Adm_Appl_Nbr = A.Adm_Appl_Nbr AND A2.Appl_Prog_Nbr = A.Appl_Prog_Nbr AND A2.Effdt = A.Effdt) AND C.Emplid = A.Emplid AND C.Acad_Career = A.Acad_Career AND C.Stdnt_Car_Nbr = A.Stdnt_Car_Nbr AND C.Adm_Appl_Nbr = A.Adm_Appl_Nbr AND D.Emplid = A.Emplid AND D.Acad_Career = A.Acad_Career AND D.Stdnt_Car_Nbr = A.Stdnt_Car_Nbr AND D.Adm_Appl_Nbr = A.Adm_Appl_Nbr AND D.Appl_Prog_Nbr = A.Appl_Prog_Nbr

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

3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
Default Value: 0

4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
Default Value: 0

6 EFFDT Date(10) DATE Effective Date
Default Value: %Date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

9 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_TBL

10 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted

11 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
Prompt Table: ADM_ACTION_TBL

12 ACTION_DT Date(10) DATE Action Date

13 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
Prompt Table: PROG_RSN_TBL

14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
Prompt Table: TERM_TBL

15 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time

16 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
Prompt Table: CAMPUS_TBL

17 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program

18 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved
Y/N Table Edit

19 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
Default Value: UG
Prompt Table: ADM_APPLCTR_TBL

20 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
Default Value: FYR
Prompt Table: ADMIT_TYPE_VW

21 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest
Y/N Table Edit

22 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing

23 APPL_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL Application Fee Status
DEF=Deferred Payment
PEN=Pending
REC=Received
WRQ=Waiver Request
WVD=Waived

24 APPL_FEE_DT Date(10) DATE Application Fee Date

25 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
ERLY=Early Admission Decision
REG=Regular Admission Decision
ROLL=Rolling Admission

26 REGION Character(10) VARCHAR2(10) NOT NULL Region
Prompt Table: REGION_TBL

27 REGION_FROM Character(1) VARCHAR2(1) NOT NULL Region from
A=Address
O=School
R=Region Tree

28 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
Prompt Table: RECRUITER_SRCH

29 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended
Prompt Table: SCHOOL_TBL

30 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date

31 ADM_CREATION_BY Character(30) VARCHAR2(30) NOT NULL Admission Data Created By

32 ADM_UPDATED_DT Date(10) DATE Last Updated On

33 ADM_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL Last Updated By

34 ADM_APPL_COMPLETE Character(1) VARCHAR2(1) NOT NULL Application Complete
Y/N Table Edit

35 ADM_APPL_DT Date(10) DATE Application Date

36 ADM_APPL_CMPLT_DT Date(10) DATE Completed Date

37 GRADUATION_DT Date(10) DATE Graduation Date

38 PRIOR_APPL Character(1) VARCHAR2(1) NOT NULL Prior Application
Y/N Table Edit

39 APPL_FEE_TYPE Character(3) VARCHAR2(3) NOT NULL Application Fee Type
INT=International
STN=Standard

40 ADM_APPL_METHOD Character(3) VARCHAR2(3) NOT NULL Application Method
DSK=Diskette
EDI=EDI
HRD=Hard Copy
OUA=Ontario University Application
SRV=Application Service
WWW=Web Application

41 APPL_FEE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Application Fee Amount

42 APPL_FEE_PAID Signed Number(18,2) DECIMAL(16,2) NOT NULL Application Fee Paid

43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

44 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer

45 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD

46 OVERRIDE_DEPOSIT Character(1) VARCHAR2(1) NOT NULL Override Deposit

47 EXT_ADM_APPL_NBR Character(15) VARCHAR2(15) NOT NULL External Application Nbr

48 EVALUATN_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Status
CM=Complete
IP=In Progress
Prompt Table: EVAL_STATUS_TBL

49 EVALUATION_DT Date(10) DATE Evaluation Date
Default Value: %Date

50 STDNT_CAR_NBR_SR Number(3,0) SMALLINT NOT NULL Student Career Number

51 CREATE_PROG_STATUS Character(1) VARCHAR2(1) NOT NULL Create Program Status
E=Fatal SQL Error(s) Encountered
M=Readmit Error
R=Required
S=Successfully Processed
T=Setup/Input Error

#	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	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
3	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr Default Value: 0
4	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
5	APPL_PROG_NBR	Number(3,0)	SMALLINT NOT NULL	Application Program Nbr Default Value: 0
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %Date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
9	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_TBL
10	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
11	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 Prompt Table: ADM_ACTION_TBL
12	ACTION_DT	Date(10)	DATE	Action Date
13	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason Prompt Table: PROG_RSN_TBL
14	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: TERM_TBL
15	ACAD_LOAD_APPR	Character(1)	VARCHAR2(1) NOT NULL	Approved Academic Load B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time
16	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: CAMPUS_TBL
17	ACAD_PROG_DUAL	Character(5)	VARCHAR2(5) NOT NULL	Dual Academic Program
18	JOINT_PROG_APPR	Character(1)	VARCHAR2(1) NOT NULL	Joint Program Approved Y/N Table Edit
19	ADM_APPL_CTR	Character(4)	VARCHAR2(4) NOT NULL	Application Center Default Value: UG Prompt Table: ADM_APPLCTR_TBL
20	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Default Value: FYR Prompt Table: ADMIT_TYPE_VW
21	FIN_AID_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Financial Aid Interest Y/N Table Edit
22	HOUSING_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Housing Interest C=Commuter F=Off Campus Housing H=On Campus Housing
23	APPL_FEE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Application Fee Status DEF=Deferred Payment PEN=Pending REC=Received WRQ=Waiver Request WVD=Waived
24	APPL_FEE_DT	Date(10)	DATE	Application Fee Date
25	NOTIFICATION_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Notification Plan ERLY=Early Admission Decision REG=Regular Admission Decision ROLL=Rolling Admission
26	REGION	Character(10)	VARCHAR2(10) NOT NULL	Region Prompt Table: REGION_TBL
27	REGION_FROM	Character(1)	VARCHAR2(1) NOT NULL	Region from A=Address O=School R=Region Tree
28	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID Prompt Table: RECRUITER_SRCH
29	LAST_SCH_ATTEND	Character(11)	VARCHAR2(11) NOT NULL	Last School Attended Prompt Table: SCHOOL_TBL
30	ADM_CREATION_DT	Date(10)	DATE	Admission Data Creation Date
31	ADM_CREATION_BY	Character(30)	VARCHAR2(30) NOT NULL	Admission Data Created By
32	ADM_UPDATED_DT	Date(10)	DATE	Last Updated On
33	ADM_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last Updated By
34	ADM_APPL_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Application Complete Y/N Table Edit
35	ADM_APPL_DT	Date(10)	DATE	Application Date
36	ADM_APPL_CMPLT_DT	Date(10)	DATE	Completed Date
37	GRADUATION_DT	Date(10)	DATE	Graduation Date
38	PRIOR_APPL	Character(1)	VARCHAR2(1) NOT NULL	Prior Application Y/N Table Edit
39	APPL_FEE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Application Fee Type INT=International STN=Standard
40	ADM_APPL_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Application Method DSK=Diskette EDI=EDI HRD=Hard Copy OUA=Ontario University Application SRV=Application Service WWW=Web Application
41	APPL_FEE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Application Fee Amount
42	APPL_FEE_PAID	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Application Fee Paid
43	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
44	TENDER_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Tender Category CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer
45	ACADEMIC_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Academic Level 00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD
46	OVERRIDE_DEPOSIT	Character(1)	VARCHAR2(1) NOT NULL	Override Deposit
47	EXT_ADM_APPL_NBR	Character(15)	VARCHAR2(15) NOT NULL	External Application Nbr
48	EVALUATN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Evaluation Status CM=Complete IP=In Progress Prompt Table: EVAL_STATUS_TBL
49	EVALUATION_DT	Date(10)	DATE	Evaluation Date Default Value: %Date
50	STDNT_CAR_NBR_SR	Number(3,0)	SMALLINT NOT NULL	Student Career Number
51	CREATE_PROG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Create Program Status E=Fatal SQL Error(s) Encountered M=Readmit Error R=Required S=Successfully Processed T=Setup/Input Error