RUN_CNTL_EVCODE(SQL Table) |
Index Back |
---|---|
Assign Evaluation CodesThis 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 |