SAD_PRS_CREATE

(SQL Table)
 Index Back

Prospect Create Run Control

This record will hold the run control values for the Prospect Create from Data Loads process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

Prompt Table: SAD_TST_SCTY_VW

4 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

6 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: ACAD_CAR_SCRTY

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

Prompt Table: CAMPUS_TBL

8 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PAPL=Pre-Applicant
PROS=Prospect
SUSP=Suspect

Default Value: INQR

9 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

Default Value: OPR_DEF_TBL_CS.ADM_RECR_CTR

Prompt Table: ADM_RECRCTR_SVW

10 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source

Prompt Table: REFERL_SRCE_TBL

11 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

Prompt Table: ADMIT_TYPE_VW

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

Prompt Table: TERM_TBL

13 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
14 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: SAD_PRS_PRG_VW

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

Prompt Table: SAD_PRS_PLN_VW

16 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

Prompt Table: SAD_PRS_SPLN_VW

17 SEND_COMM Character(1) VARCHAR2(1) NOT NULL Assign 3C

Y/N Table Edit

Default Value: N

18 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

Prompt Table: %EDITTABLE2