ADM_APPL_SBPLAN (SQL Table)	Index Back
Admission Applicant Subplan This table is used to record the Academic SubPlans which an applicant has applied to. These plans are supplemental to the applicant's Academic Plan. In order to have an entry in this table an applicant must have applied to an Academic Plan.

ADM_APPL_SBPLAN

(SQL Table)

Admission Applicant Subplan

This table is used to record the Academic SubPlans which an applicant has applied to. These plans are supplemental to the applicant's Academic Plan. In order to have an entry in this table an applicant must have applied to an Academic Plan.

Parent record: 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: PERSONAL_DATA

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: ADM_APPL_PLAN

9 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
Prompt Table: SAD_APP_SPLN_VW

10 DECLARE_DT Date(10) DATE NOT NULL Declare Date
Default Value: ADM_APPL_PLAN.DECLARE_DT

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

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

13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

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

15 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: PERSONAL_DATA
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: ADM_APPL_PLAN
9	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan Prompt Table: SAD_APP_SPLN_VW
10	DECLARE_DT	Date(10)	DATE NOT NULL	Declare Date Default Value: ADM_APPL_PLAN.DECLARE_DT
11	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term Prompt Table: TERM_TBL
12	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
13	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
14	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
15	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time