PC_RES_FUN_TEO3 (SQL Table)	Index Back
CCU TEO temp table CCU temporary table for PC_RES_FUND

PC_RES_FUN_TEO3

(SQL Table)

CCU TEO temp table

CCU temporary table for PC_RES_FUND

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

5 TRANS_DT Date(10) DATE Transaction Date

6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

7 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

8 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

11 BUDGET_LN Number(6,0) INTEGER NOT NULL BUDGET_LN

12 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

13 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

14 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

16 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity

17 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

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

19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

22 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

23 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

24 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

25 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

26 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

27 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

28 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

29 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

30 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

31 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

32 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

33 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

34 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

35 DESCR Character(30) VARCHAR2(30) NOT NULL Description

36 KK_BUDG_LN_TYPE Character(3) VARCHAR2(3) NOT NULL Budget Journal Line Types
0=Original
1=Adjustment
2=Transfer
3=Roll Forward
4=Closing

37 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

38 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

39 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

40 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.

41 BD_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Header Status: N - Posting has not been run against the journal E - The journal has failed edits V - The journal has passed edits but cannot be posted due to monetary related issues S - One ore more journal lines have failed the security edits P - The journal has been posted the ledger U - The journal has been unposted I - Incomplete journal pending SaveEdit to validate Security
B=Not Balanced
C=Checked Only
E=Error
I=Incomplete
N=None
P=Posted
S=Security Error
U=Unposted
V=Errors

42 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

43 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

44 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY

45 GM_FA_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL Fixed and Administrative
1=Base (Non F&A)
2=Fixed and Administrative

46 GM_CS_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL Cost Sharing
1=Sponsor
2=Cost Sharing

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

48 GM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
M=Modified
N=None
P=To be processed

49 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

50 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

51 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

52 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

53 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

54 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

55 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

56 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

57 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
5	TRANS_DT	Date(10)	DATE	Transaction Date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
8	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
9	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	BUDGET_LN	Number(6,0)	INTEGER NOT NULL	BUDGET_LN
12	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
13	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
14	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
15	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
16	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
17	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
20	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
23	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
24	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
25	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
26	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
27	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
28	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
29	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
30	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
31	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
32	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
33	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
34	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
35	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
36	KK_BUDG_LN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Budget Journal Line Types 0=Original 1=Adjustment 2=Transfer 3=Roll Forward 4=Closing
37	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
38	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
39	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
40	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
41	BD_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Header Status: N - Posting has not been run against the journal E - The journal has failed edits V - The journal has passed edits but cannot be posted due to monetary related issues S - One ore more journal lines have failed the security edits P - The journal has been posted the ledger U - The journal has been unposted I - Incomplete journal pending SaveEdit to validate Security B=Not Balanced C=Checked Only E=Error I=Incomplete N=None P=Posted S=Security Error U=Unposted V=Errors
42	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
43	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
44	BUDGET_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_CATEGORY
45	GM_FA_SEQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Fixed and Administrative 1=Base (Non F&A) 2=Fixed and Administrative
46	GM_CS_SEQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cost Sharing 1=Sponsor 2=Cost Sharing
47	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
48	GM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored M=Modified N=None P=To be processed
49	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
50	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
51	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
52	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
53	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
54	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
55	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
56	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
57	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code