SFA_SLC_TFRAVW4 (SQL View)	Index Back
SLC TFRA Fee Amt Total View Calculates the Fee Amount Total in the TRFA Detail table by Payment Type. Joins TFRA Detail table to TFRA Header table to get Payment Type value.

SFA_SLC_TFRAVW4

(SQL View)

SLC TFRA Fee Amt Total View

Calculates the Fee Amount Total in the TRFA Detail table by Payment Type. Joins TFRA Detail table to TFRA Header table to get Payment Type value.

SELECT B.SFA_SLC_HEI_CD ,B.SFA_SLC_ACAD_YR ,SUM(B.SFA_SLC_FEE_AMT) ,A.SFA_SLC_PAYMNT_TYP ,B.CURRENCY_CD FROM PS_SFA_SLC_TFRADTL B , PS_SFA_SLC_TFRAHDR A WHERE A.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND A.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND A.SFA_FILE_NAME = B.SFA_FILE_NAME GROUP BY B.SFA_SLC_HEI_CD, B.SFA_SLC_ACAD_YR , A.SFA_SLC_PAYMNT_TYP, B.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_FEE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Fee Amount

4 SFA_SLC_PAYMNT_TYP Character(1) VARCHAR2(1) NOT NULL Payment Type
G=Tuition Fee Grant
T=Tuition Fee Loan

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

#	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_FEE_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Fee Amount
4	SFA_SLC_PAYMNT_TYP	Character(1)	VARCHAR2(1) NOT NULL	Payment Type G=Tuition Fee Grant T=Tuition Fee Loan
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY