SAD_APLPLAN_AET (SQL Table)	Index Back
Pop Select Program Update Application Engine program to update the Admissions Program stack driven by Pop Select. This is similiar to ADMPGPGS.SQR in functionality.

SAD_APLPLAN_AET

(SQL Table)

Pop Select Program Update

Application Engine program to update the Admissions Program stack driven by Pop Select. This is similiar to ADMPGPGS.SQR in functionality.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 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

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

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

6 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

7 EFFDT Date(10) DATE Effective Date

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

9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

10 DECLARE_DT Date(10) DATE Declare Date

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

12 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term

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

14 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

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

16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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
4	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
5	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
6	APPL_PROG_NBR	Number(3,0)	SMALLINT NOT NULL	Application Program Nbr
7	EFFDT	Date(10)	DATE	Effective Date
8	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
9	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan
10	DECLARE_DT	Date(10)	DATE	Declare Date
11	PLAN_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Plan Sequence
12	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term
13	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number
14	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
15	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
16	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
17	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
18	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time