SAA_IN_SETUP_FL

(SQL Table)
Index Back

AA Fluid Option Setup

AA Fluid Option Setup

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