SAA_RQUSAGE_AET

(SQL Table)
Index Back

State Record for AA Fix

This 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