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 | PROCESS_INSTANCE | 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 |