ADM_APPL_PLANVW (SQL View)	Index Back
Admission Applicant Plan View This Admission Applicant Plan Table view is used to propagate changes made to the Student Records Academic Program stack to the Admissions Application stack. Changes are copied only if the Academic Program originated from the Admissions stack.

ADM_APPL_PLANVW

(SQL View)

Admission Applicant Plan View

This Admission Applicant Plan Table view is used to propagate changes made to the Student Records Academic Program stack to the Admissions Application stack. Changes are copied only if the Academic Program originated from the Admissions stack.

SELECT emplid , acad_career , stdnt_car_nbr , adm_appl_nbr , appl_prog_nbr , effdt , effseq , acad_plan , declare_dt , plan_sequence , req_term ,SSR_APT_INSTANCE ,SSR_YR_OF_PROG ,SCC_ROW_ADD_OPRID ,SCC_ROW_ADD_DTTM ,SCC_ROW_UPD_OPRID ,SCC_ROW_UPD_DTTM FROM PS_ADM_APPL_PLAN

# 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
Prompt Table: STDNT_CAREER

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

4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
Prompt Table: ADM_APPL_DATA

5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
Prompt Table: ADM_APP_CAR_SEQ

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

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

8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
Prompt Table: ACAD_PLAN_TBLVW

9 DECLARE_DT Date(10) DATE Declare Date
Default Value: %date

10 PLAN_SEQUENCE Number(2,0) SMALLINT NOT NULL Plan Sequence

11 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term
Prompt Table: TERM_TBL

12 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number

13 SSR_YR_OF_PROG Character(4) VARCHAR2(4) NOT NULL Year of Program
00=Not Set
01=01 - First Year
02=02 - Second Year
03=03 - Third Year
04=04 - Fourth Year
05=05 - Fifth Year
06=06 - Sixth Year

14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

#	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 Prompt Table: STDNT_CAREER
3	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
4	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr Prompt Table: ADM_APPL_DATA
5	APPL_PROG_NBR	Number(3,0)	SMALLINT NOT NULL	Application Program Nbr Prompt Table: ADM_APP_CAR_SEQ
6	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBLVW
9	DECLARE_DT	Date(10)	DATE	Declare Date Default Value: %date
10	PLAN_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Plan Sequence
11	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term Prompt Table: TERM_TBL
12	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number
13	SSR_YR_OF_PROG	Character(4)	VARCHAR2(4) NOT NULL	Year of Program 00=Not Set 01=01 - First Year 02=02 - Second Year 03=03 - Third Year 04=04 - Fourth Year 05=05 - Fifth Year 06=06 - Sixth Year
14	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
15	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
16	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
17	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time