AA_REVENG_SRCH(SQL View) |
Index Back |
---|---|
AA Search RevEng ReportingThis record is a search view used to keep the run control records used on the requisite side from being used on the advisement side. |
SELECT OPRID , RUN_CNTL_ID , RQRMNT_USEAGE FROM PS_RUN_CNTL_REVENG WHERE RQRMNT_USEAGE <> 'ENR' |
# | 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 | RQRMNT_USEAGE | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
ADV=Academic Advisement ENR=Requisite/Restriction PLNR=Student Planner Report SHR=Rq Course Share Restrictn SHR1=Entity Course Share Restrictn STD=Student Individualized Plan |