ADM_SS_APPL_CAT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTN_SCRTY

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
Prompt Table: ACAD_CAR_SCRTY

4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_SCTY

5 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
Prompt Table: PEOPLE_SRCH

6 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

7 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
Prompt Table: ADM_PRS_TRM_VW

8 RECRUITMENT_CAT Character(4) VARCHAR2(4) NOT NULL Recruitment Category
Prompt Table: RCR_CAT_VW

9 RECRUITMENT_GRP Character(4) VARCHAR2(4) NOT NULL Recruitment Group
ACAD=Academic
ALUM=Alumni
ATHL=Athletics
MUSC=Music
REGN=Geographic Region
SPEC=Special

10 RECR_RESPON_SLCT Character(1) VARCHAR2(1) NOT NULL Recruiter Responsible Selectn
N=Non Primary
P=Primary

11 SS_SORT_CAT_APP Character(1) VARCHAR2(1) NOT NULL Sort results by
C=Category
G=Group
N=Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTN_SCRTY
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 Prompt Table: ACAD_CAR_SCRTY
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_SCTY
5	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID Prompt Table: PEOPLE_SRCH
6	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
7	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: ADM_PRS_TRM_VW
8	RECRUITMENT_CAT	Character(4)	VARCHAR2(4) NOT NULL	Recruitment Category Prompt Table: RCR_CAT_VW
9	RECRUITMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	Recruitment Group ACAD=Academic ALUM=Alumni ATHL=Athletics MUSC=Music REGN=Geographic Region SPEC=Special
10	RECR_RESPON_SLCT	Character(1)	VARCHAR2(1) NOT NULL	Recruiter Responsible Selectn N=Non Primary P=Primary
11	SS_SORT_CAT_APP	Character(1)	VARCHAR2(1) NOT NULL	Sort results by C=Category G=Group N=Name