SAA_RQUSAGE_AET(SQL Table) |
Index Back |
|---|---|
State Record for AA FixThis record is the state record for UPD782226_A1. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | 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 |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | CONDITION_SPEC | Character(6) | VARCHAR2(6) NOT NULL | Condition Specification |
| 5 | SAA_CONDITION_NEXT | Character(6) | VARCHAR2(6) NOT NULL | This field contains the next condition id to be used in academic advisement. |
| 6 | RQ_ENTITY_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Academic Entity Group |
| 7 | SAA_ENT_GRP_NEXT | Character(6) | VARCHAR2(6) NOT NULL | This field contains the next entity group id to be used in academic advisement. |
| 8 | COND_LINE_SEQ | Number(3,0) | SMALLINT NOT NULL | Condition Line Sequence |
| 9 | ENT_GRP_ITEM_NBR | Number(3,0) | SMALLINT NOT NULL | Entity Group Item Number |
| 10 | RQRMNT_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Requirement Group |
| 11 | REQUIREMENT | Character(9) | VARCHAR2(9) NOT NULL | Academic Requirement |
| 12 | RQ_LINE_KEY_NBR | Character(4) | VARCHAR2(4) NOT NULL | Background Key |
| 13 | RQ_LINE_DET_SEQ | Number(3,0) | SMALLINT NOT NULL | Line Detail Sequence |
| 14 | CONDITION_SPEC_UPD | Character(6) | VARCHAR2(6) NOT NULL | This field is a copy of the condition code used for updating dynamic conditions with new dynamic condition values. |
| 15 | CONDITION_DATA | Character(10) | VARCHAR2(10) NOT NULL | Condition Data |