SS_FA_SAP_STLNG(SQL Table) |
Index Back |
---|---|
Self-Service SAP Status TblThis 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. |
# | 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. |