INSTALLATION_AA

(SQL Table)
Index Back

AA Installation Table

This table contains characteristics used to control the display and processing in academic advisement.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAA_SYNCH_ACAD_LVL Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any academic level record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

2 SAA_SYNCH_ENRL Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when a STDNT_ENRL record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

3 SAA_SYNCH_EXT_DEGR Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any external degree record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

4 SAA_SYNCH_INT_DEGR Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any internal degree record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

5 SAA_SYNCH_MILESTON Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any milestone record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

6 SAA_SYNCH_PROGPLN Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when a program, plan, or subplan is changed for the student.

Y/N Table Edit

Default Value: N

7 SAA_SYNCH_STDNT_GR Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any student group record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

8 SAA_SYNCH_TC Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any transfer credit record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

9 SAA_SYNCH_PLANNER Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any planner record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

10 SAA_SYNCH_SHOPCART Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any shopping cart record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: N

11 SAA_SYNCH_AA_EXCPT Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any student exception record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: Y

12 SAA_SYNCH_AA_CRSSB Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag that controls if the field SAA_SYNCHRONIZE is set on STDNT_CAREER when any course substitution record is added, changed, or deleted for the student.

Y/N Table Edit

Default Value: Y

13 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
14 SAA_OBEY_SELECT_LN Character(1) VARCHAR2(1) NOT NULL This field is a yes/no field used on the INSTALLATION_AA table used to identify if the courses in the display select line should be automatically loaded in SAA_ADB_CRSEAVL. If the field is not selected, then the display select line data is always loaded regardless of the value from the requirement line. If the value is selected, the display select data is loaded only if value from the requirement line is set to Y.

Y/N Table Edit

Default Value: N

15 SAA_ENABLE_FLUID Character(1) VARCHAR2(1) NOT NULL Enable Academic Advisement Fluid Features flag

Y/N Table Edit

Default Value: N