SFA_SLC_HEI_CDPrompt Table: SFA_SLC_HEI_VW
SFA_SLC_ACAD_YRPrompt Table: SFA_SLC_ACYR_VW
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
SFA_SLC_TFRASR2(SQL View) |
Index Back |
|---|---|
SLC TFRA Staging Search RecordSLC TFRA Staging Table Search Record |
| SELECT SFA_SLC_HEI_CD ,SFA_SLC_ACAD_YR , SUM(SFA_SLC_TOT_FEE) , CURRENCY_CD FROM PS_SFA_SLC_TFRAHDR GROUP BY SFA_SLC_HEI_CD , SFA_SLC_ACAD_YR , CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table: SFA_SLC_HEI_VW |
| 2 | SFA_SLC_ACAD_YR |
Character(4) | VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table: SFA_SLC_ACYR_VW |
| 3 | SFA_SLC_GRND_TOTAL | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Grand Total |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |