MULT_PROG_SRCH (SQL View)	Index Back
Adm Appl Multi Prog Add Search MULT_PROG_SRCH is the add mode search view used to add an additional program record to an existing application. This is only necessary if the program was not created at the time the orginal application was entered.

MULT_PROG_SRCH

(SQL View)

Adm Appl Multi Prog Add Search

MULT_PROG_SRCH is the add mode search view used to add an additional program record to an existing application. This is only necessary if the program was not created at the time the orginal application was entered.

SELECT c.emplid ,c.acad_career ,c.stdnt_car_nbr ,c.adm_appl_nbr ,c.appl_prog_nbr ,c.acad_prog ,c.admit_term ,c.institution ,c.campus ,a.adm_appl_ctr ,a.admit_type ,a.recruiter_id FROM PS_ADM_APPL_DATA a , ps_adm_appl_prog c WHERE c.adm_appl_nbr = a.adm_appl_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
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
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

6 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

7 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

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

9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

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

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

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

#	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 Default Value: OPR_DEF_TBL_CS.ACAD_CAREER 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
6	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
7	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term
8	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
9	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus
10	ADM_APPL_CTR	Character(4)	VARCHAR2(4) NOT NULL	Application Center Default Value: UG Prompt Table: ADM_APPLCTR_TBL
11	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Default Value: FYR Prompt Table: ADMIT_TYPE_VW
12	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID Prompt Table: RECRUITER_SRCH