UPG_AA900_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COURSE_LIST	Character(9)	VARCHAR2(9) NOT NULL	Course List
3	EFFDT	Date(10)	DATE	Effective Date
4	SAA_WHERE_CLAUSE	Long Character	CLOB	This field contains the where clause used in different processes in academic advisement.
5	R_COURSE_SEQUENCE	Number(7,0)	INTEGER NOT NULL	Course Sequence
6	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
7	ACAD_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Academic Group
8	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
9	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
10	SAA_ROW_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
11	SAA_TOTAL_ROWS	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
12	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
13	RQ_LINE_KEY_NBR	Character(4)	VARCHAR2(4) NOT NULL	Background Key
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	SAA_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to designate if a value exists.
16	DESCR254A	Character(254)	VARCHAR2(254) NOT NULL	Long Description
17	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
18	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