KK_FUND_SOURCE (SQL Table)	Index Back
Funding Source Table

KK_FUND_SOURCE

(SQL Table)

Funding Source Table

# 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 FEDERAL_AID_AGENCY Character(30) VARCHAR2(30) NOT NULL Federal Aid Agency

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

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

6 CFDA_NBR Number(6,3) DECIMAL(5,3) NOT NULL CFDA Number

7 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID

8 DESCRLONG Long Character CLOB Long Description

9 REIMB_AUTH_SW Character(1) VARCHAR2(1) NOT NULL Reimbursable Authority
Y/N Table Edit
Default Value: N

10 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
Prompt Table: SP_SETID_NONVW

11 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_ALL_A3_VW

12 REIMB_AGREEMENT Character(25) VARCHAR2(25) NOT NULL Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

14 BUSINESS_UNIT_OPTN Character(1) VARCHAR2(1) NOT NULL Business Unit Option
A=All Business Units
V=Specific Business Unit
Default Value: A

15 KK_FS_FLD_DATE Date(10) DATE Additional Commitment Control Funding Source Date Field. User activates it on Installation page and defines its label there.

16 KK_FS_FLD_CHAR1 Character(30) VARCHAR2(30) NOT NULL Additional Commitment Control Funding Source Char1 Field. User activates it on Installation page and defines its label there.

17 KK_FS_FLD_CHAR2 Character(30) VARCHAR2(30) NOT NULL Additional Commitment Control Funding Source Char2 Field. User activates it on Installation page and defines its label there.

#	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	FEDERAL_AID_AGENCY	Character(30)	VARCHAR2(30) NOT NULL	Federal Aid Agency
4	FUND_SOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funding Source Amount
5	OBLIGATED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Applied Amount
6	CFDA_NBR	Number(6,3)	DECIMAL(5,3) NOT NULL	CFDA Number
7	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID
8	DESCRLONG	Long Character	CLOB	Long Description
9	REIMB_AUTH_SW	Character(1)	VARCHAR2(1) NOT NULL	Reimbursable Authority Y/N Table Edit Default Value: N
10	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID Prompt Table: SP_SETID_NONVW
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_ALL_A3_VW
12	REIMB_AGREEMENT	Character(25)	VARCHAR2(25) NOT NULL	Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
14	BUSINESS_UNIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Option A=All Business Units V=Specific Business Unit Default Value: A
15	KK_FS_FLD_DATE	Date(10)	DATE	Additional Commitment Control Funding Source Date Field. User activates it on Installation page and defines its label there.
16	KK_FS_FLD_CHAR1	Character(30)	VARCHAR2(30) NOT NULL	Additional Commitment Control Funding Source Char1 Field. User activates it on Installation page and defines its label there.
17	KK_FS_FLD_CHAR2	Character(30)	VARCHAR2(30) NOT NULL	Additional Commitment Control Funding Source Char2 Field. User activates it on Installation page and defines its label there.