SAA_IN_SETUP_FL(SQL Table) | 
Index Back | 
|---|---|
AA Fluid Option SetupAA Fluid Option Setup | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
Academic Institution
 Prompt Table: INSTITUTION_TBL  | 
|
| 2 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL | 
Effective Status
 A=Active I=Inactive Default Value: A  | 
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description | 
| 5 | SAA_HIDE_PRGRS_FL | Character(1) | VARCHAR2(1) NOT NULL | 
Display Progress Chart in Fluid Landing Page Option
 Y/N Table Edit Default Value: N  | 
| 6 | SAA_DESCR64 | Character(64) | VARCHAR2(64) NOT NULL | This field is used to display information in the requirement summary pages for academic advisement reports. | 
| 7 | SAA_START_CD_FL | Character(1) | VARCHAR2(1) NOT NULL | 
Start On
 D=Use Start Date Provided E=Setup Effective Date F=First Date to Enroll O=Open Enrollment Date  | 
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO | 
| 9 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time | 
| 10 | SAA_ADD_START_DAYS | Signed Number(4,0) | DECIMAL(3) NOT NULL | This field is used as the create date search parameter. | 
| 11 | SAA_END_CD_FL | Character(1) | VARCHAR2(1) NOT NULL | 
End On
 D=Use End Date Provided F=First Date to Enroll L=Last Date to Enroll O=Open Enrollment Date X=No End Date  | 
| 12 | END_DATE | Date(10) | DATE | End Date | 
| 13 | END_TIME | Time(15) | TIMESTAMP | Interview End Time | 
| 14 | SAA_ADD_END_DAYS | Signed Number(4,0) | DECIMAL(3) NOT NULL | This field is used as the create date search parameter. | 
| 15 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By | 
| 16 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created | 
| 17 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By | 
| 18 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |