KK_FS_INQA_F_VW

(SQL View)

SELECT FUND_SOURCE , FUNDING_TYPE , FUND_SOURCE_AMOUNT , OBLIGATED_AMT , FUND_SOURCE_AMOUNT - OBLIGATED_AMT , CURRENCY_CD FROM %Table(KK_FUND_SOURCE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FUND_SOURCE Character(6) VARCHAR2(6) NOT NULL Funding Source

2 FUNDING_TYPE Character(2) VARCHAR2(2) NOT NULL Funding Type
BN=Bond
DN=Donations
FE=Federal
IN=Internal
LO=Local
ST=State

3 FUND_SOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Funding Source Amount

4 OBLIGATED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Applied Amount

5 AMT_UNALLOCATED Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Not Allocated

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
2	FUNDING_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Funding Type BN=Bond DN=Donations FE=Federal IN=Internal LO=Local ST=State
3	FUND_SOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funding Source Amount
4	OBLIGATED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Applied Amount
5	AMT_UNALLOCATED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Not Allocated
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code