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 | ASOF_DATE | Date(10) | DATE | As of Date |
12 | 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: Y |