UPG_SAA_CND_TAO

(SQL Table)
Index Back

Temp Table for AA Fix

This is a temp table for application engine program 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 CONDITION_SPEC Character(6) VARCHAR2(6) NOT NULL Condition Specification
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
4 SAA_CONDITION_NEXT Character(6) VARCHAR2(6) NOT NULL This field contains the next condition id to be used in academic advisement.