SS_FA_SAP_STLNG

(SQL Table)
Index Back

Self-Service SAP Status Tbl

This table allows users to store custom descriptions for the Translate values for the field SAT_ACADEMIC_PRG, used on Packaging Status Summary (STDNT_AID_ATRBT). The custom description is used for the FA self-service pages.

  • Related Language Record for SS_FA_SAP_STAT
  • Parent record: SS_FA_INSTALL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 SAT_ACADEMIC_PRG Character(1) VARCHAR2(1) NOT NULL Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
    A=Academic Plan
    N=Not Meeting Satis Acad Prgrs
    P=Probation
    U=SAP Undetermined
    W=Warning
    Y=Meeting Satis Acad Progress
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SS_FA_SAP_ALT_DESC Character(30) VARCHAR2(30) NOT NULL This field is used on FA SAP Self Service Installtion to allow users to enter an alternate SAP status descripiton which overrides the xlat value for the SAP status on packaging status summary.
    6 SS_FA_SAP_MSG100 Character(100) VARCHAR2(100) NOT NULL This field holds the user set up SAP message to be displayed on the SAP Self Service page.