SSF_IN_SETUP_FL(SQL Table) |
Index Back |
---|---|
SF Fluid Option SetupSF Fluid Option Setup |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL |
Institution Set
Prompt Table: INSTITUTION_SET |
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 | SSF_HIDE_PYDUE_FL | Character(1) | VARCHAR2(1) NOT NULL |
Display Direct Deposit Self Service Flag
Y/N Table Edit Default Value: N |
6 | SSF_DESCR27 | Character(27) | VARCHAR2(27) NOT NULL | Length 100 Description |
7 | SSF_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 | SSF_ADD_START_DAYS | Signed Number(4,0) | DECIMAL(3) NOT NULL | This field is used as the create date search parameter. |
11 | SSF_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 | SSF_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 |