RUN_CNTL_EVCODE

(SQL Table)
Index Back

Assign Evaluation Codes

This is a Run Control record for assigning Evaluation Codes to an Admissions Applicant. The fields are accepted as input parms for an SQR program that will insert the appropriate records into ADM_APPL_EVAL, ADM_EVAL_COM, ADM_APPL_CMP, ADM_EVALUATOR, ADM_EVAL_SCHEME, ADM_EVAL_RTNG. 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

4 EVALUATN_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Status
CM=Complete
IP=In Progress

Prompt Table: EVAL_STATUS_TBL

5 EVALUATION_DT Date(10) DATE NOT NULL Evaluation Date

Default Value: %Date

6 EVALUATN_STATUS2 Character(2) VARCHAR2(2) NOT NULL Update Eval Status

Prompt Table: EVAL_STATUS_TBL

7 EVALUATION_DT2 Date(10) DATE NOT NULL Evaluation Date

Default Value: %Date

8 EVALUATN_STATUS3 Character(2) VARCHAR2(2) NOT NULL Evaluation Status

Prompt Table: EVAL_STATUS_TBL

9 EVALUATION_DT3 Date(10) DATE NOT NULL Evaluation Date

Default Value: %Date