SS_FA_SAP_STCPY(SQL View) |
Index Back |
|---|---|
Self-Service SAP Status Copy VThis is a view of SS_FA_SAP_STAT used when the copy button is pushed to copy data to a new aid year. |
| SELECT INSTITUTION , AID_YEAR , SAT_ACADEMIC_PRG , SS_FA_SAP_ALT_DESC , SS_FA_SAP_MSG100 FROM PS_SS_FA_SAP_STAT |
| # | 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 | 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. |
| 5 | 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. |