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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | EFFDT | 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 |