SSF_IN_SETUP_FL

(SQL Table)
Index Back

SF Fluid Option Setup

SF Fluid Option Setup

  • Related Language Record: SSF_INSET_FL_LN
  • # 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