INSTALLATION_AA(SQL Table) |
Index Back |
---|---|
AA Installation TableThis 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 |