EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMPrompt Table: TERM_TBL
Y/N Table Edit
CAN=Cancelled
NWD=
WDR=Withdrew
STDNT_P_RATA_VW(SQL View) |
Index Back |
|---|---|
Student Pro Rata View |
| SELECT A.EMPLID , A.INSTITUTION , A.STRM , A.ELIG_TO_ENROLL , A.WITHDRAW_CODE , A.REFUND_PCT , A.PRO_RATA_ELIGIBLE FROM PS_STDNT_CAR_TERM A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
| 4 | ELIG_TO_ENROLL | Character(1) | VARCHAR2(1) NOT NULL |
Eligible to Enroll
Y/N Table Edit |
| 5 | WITHDRAW_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Withdrawal \ Cancel
CAN=Cancelled NWD= WDR=Withdrew |
| 6 | REFUND_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Refund Percentage |
| 7 | PRO_RATA_ELIGIBLE | Character(1) | VARCHAR2(1) NOT NULL | Pro-Rata Eligible |