SAA_CMPLXLN_AET (SQL Table)	Index Back
State Record for AA Fix This record is the state record for UPD701903_A1.

SAA_CMPLXLN_AET

(SQL Table)

State Record for AA Fix

This record is the state record for UPD701903_A1.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key

5 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr

6 SAA_ROW_COUNT Number(10,0) DECIMAL(10) NOT NULL This field is a row counter used by academic advisement.

7 SAA_COMPLEX_RQ_LN Character(1) VARCHAR2(1) NOT NULL This field is used to identify if the requirement line contains complex set logic used to select courses to be used in an advising report.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	RQ_LINE_KEY_NBR	Character(4)	VARCHAR2(4) NOT NULL	Background Key
5	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
6	SAA_ROW_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
7	SAA_COMPLEX_RQ_LN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if the requirement line contains complex set logic used to select courses to be used in an advising report.