RUN_CNTL_EVSTAT (SQL Table)	Index Back
Update Applicatn Eval Status This is a Run Control record for updating the Evaluation Status of an Admissions Applicant. The fields are accepted as input parms for an SQR program that will update the the evaluation status on the Admissions Applicant Career Sequence table. This Run Control record will allow the process to run from process scheduler.

RUN_CNTL_EVSTAT

(SQL Table)

Update Applicatn Eval Status

This is a Run Control record for updating the Evaluation Status of an Admissions Applicant. The fields are accepted as input parms for an SQR program that will update the the evaluation status on the Admissions Applicant Career Sequence table. This Run Control record will allow the process to run from 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).

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

3 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code
Prompt Table: EVALUATION_TBL

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

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

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

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

8 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
Prompt Table: TERM_VAL_TBL

9 EVALUATN_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Status
CM=Complete
IP=In Progress
Prompt Table: EVAL_STATUS_TBL

10 EVALUATN_STATUS2 Character(2) VARCHAR2(2) NOT NULL Update Eval Status
Prompt Table: EVAL_STATUS_TBL

11 ACTION_DT Date(10) DATE NOT NULL Action 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).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EVALUATION_CODE	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Code Prompt Table: EVALUATION_TBL
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
5	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_TBL
6	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: SAD_APP_PRG_VW
7	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Prompt Table: ADMIT_TYPE_TBL
8	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: TERM_VAL_TBL
9	EVALUATN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Evaluation Status CM=Complete IP=In Progress Prompt Table: EVAL_STATUS_TBL
10	EVALUATN_STATUS2	Character(2)	VARCHAR2(2) NOT NULL	Update Eval Status Prompt Table: EVAL_STATUS_TBL
11	ACTION_DT	Date(10)	DATE NOT NULL	Action Date Default Value: %Date