AA_OVRD_CLSN_VW(SQL View) |
Index Back |
|---|---|
View for storing temp overrideView to store overrides in a hidden panel while they are checked to see if they collide with existing overrides. |
| SELECT DISTINCT A.EFFDT, A.EFF_STATUS, A.RQ_AA_OVERRIDE, A.RQ_AA_WHO_CODE, A.RQ_AA_WHO_DATA, A.RQ_AA_OVRD_OPCODE, A.RQ_AA_OVRD_OPLEVEL, C.RQRMNT_GROUP , C.REQUIREMENT, C.RQ_LINE_NBR FROM PS_AA_OVERRIDE A, PS_AA_OVRD_WHERE C WHERE A.EFF_STATUS = 'A' AND A.RQ_AA_OVERRIDE = C.RQ_AA_OVERRIDE AND C.RQ_AA_OVRD_LN_NBR = '0001' AND A.EFFDT = (SELECT MAX(D.EFFDT) FROM PS_AA_OVERRIDE D WHERE D.RQ_AA_OVERRIDE = A.RQ_AA_OVERRIDE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EFFDT |
Date(10) | DATE | Effective Date |
| 2 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 3 | RQ_AA_OVERRIDE | Character(9) | VARCHAR2(9) NOT NULL | Advisement Override |
| 4 | RQ_AA_WHO_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Selection Code
PLAN=Primary Academic Plan PROG=Academic Program STDG=Student Group STDN=Student |
| 5 | RQ_AA_WHO_DATA | Character(15) | VARCHAR2(15) NOT NULL | Selection Data |
| 6 | RQ_AA_OVRD_OPCODE | Character(4) | VARCHAR2(4) NOT NULL |
Override Operation Code
CLST=Course List Override DRCT=Course Directive REQC=Requirement Change REQO=Requirement Override REQW=Requirement Waiver |
| 7 | RQ_AA_OVRD_OPLEVEL | Character(4) | VARCHAR2(4) NOT NULL |
Operation Level
LN=Requirement Line Level RG=Requirement Group Level RQ=Requirement Level |
| 8 | RQRMNT_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Requirement Group |
| 9 | REQUIREMENT | Character(9) | VARCHAR2(9) NOT NULL | Academic Requirement |
| 10 | RQ_LINE_NBR | Character(4) | VARCHAR2(4) NOT NULL | Line Nbr |