RUN_CNTL_AD_SR (SQL Table)	Index Back
Run Control Admissions-Records RUN_CNTL_AD_SR contains fields that are used as input parameters for the COBOL Process that activates admission applicants. Input data is retrieved from this record when the process is triggered from the Process Scheduler.

RUN_CNTL_AD_SR

(SQL Table)

Run Control Admissions-Records

RUN_CNTL_AD_SR contains fields that are used as input parameters for the COBOL Process that activates admission applicants. Input data is retrieved from this record when the process is triggered from the Process Scheduler.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

4 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_TBL

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

6 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
Prompt Table: ADMIT_TYPE_TBL

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

8 ASOFDATE Date(10) DATE NOT NULL As of Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
4	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_TBL
5	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: SAD_APP_PRG_VW
6	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Prompt Table: ADMIT_TYPE_TBL
7	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: TERM_TBL
8	ASOFDATE	Date(10)	DATE NOT NULL	As of Date Default Value: %date