PC_BUD_TEO3 (SQL Table)	Index Back
CCU TEO temp table CCU TEO temp table copy of PC_BUD_DETAIL

PC_BUD_TEO3

(SQL Table)

CCU TEO temp table

CCU TEO temp table copy of PC_BUD_DETAIL

# 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 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID

5 PC_BUD_TYPE Character(1) VARCHAR2(1) NOT NULL This field defines a Projects Budget as either Cost or Revenue Based.
C=Cost Budget
R=Revenue Budget

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

7 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

8 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM

9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

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

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

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

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

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

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

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

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

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

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

21 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

22 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

23 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

24 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

25 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

26 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

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

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

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

30 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

31 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPRUNT_BUGL2_VW

32 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODCT_BUGL2_VW

33 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL2_VW

34 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_BUGL2_VW

35 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRM_BUGL2_VW

36 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUDREF_BUGL2_VW

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

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

39 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA01

40 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL2_VW

41 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL2_VW

42 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL2_VW

43 PC_WEIGHT_POINTS Number(10,0) DECIMAL(10) NOT NULL Weight Points

44 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause

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

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

47 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

48 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.

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

50 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".

51 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.

52 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

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

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

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

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

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

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

59 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

60 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

61 KK_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control
B=Budget Check
C=Budget Create
D=Distributed
E=Posting Error
K=Post to Commitment control
N=None
S=Security Error

62 TRANS_DT Date(10) DATE Transaction Date

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

64 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.

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

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

67 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.

68 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.

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

70 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

71 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	PC_BUDGET_ID	Number(3,0)	SMALLINT NOT NULL	Budget Plan ID
5	PC_BUD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field defines a Projects Budget as either Cost or Revenue Based. C=Cost Budget R=Revenue Budget
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
8	PC_BUDGET_ITEM	Character(15)	VARCHAR2(15) NOT NULL	Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
11	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
12	BUDGET_LN	Number(6,0)	INTEGER NOT NULL	BUDGET_LN
13	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
14	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
15	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
16	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
17	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
18	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
19	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
22	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
23	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
24	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
25	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
26	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
27	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
28	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
29	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
30	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
31	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPRUNT_BUGL2_VW
32	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODCT_BUGL2_VW
33	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL2_VW
34	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_BUGL2_VW
35	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRM_BUGL2_VW
36	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUDREF_BUGL2_VW
37	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
38	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
39	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA01
40	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL2_VW
41	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL2_VW
42	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL2_VW
43	PC_WEIGHT_POINTS	Number(10,0)	DECIMAL(10) NOT NULL	Weight Points
44	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
45	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
46	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
47	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
48	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.
49	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
50	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".
51	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.
52	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
53	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
54	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
55	BUDGET_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_CATEGORY
56	GM_FA_SEQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Fixed and Administrative 1=Base (Non F&A) 2=Fixed and Administrative
57	GM_CS_SEQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cost Sharing 1=Sponsor 2=Cost Sharing
58	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
59	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
60	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
61	KK_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control B=Budget Check C=Budget Create D=Distributed E=Posting Error K=Post to Commitment control N=None S=Security Error
62	TRANS_DT	Date(10)	DATE	Transaction Date
63	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
64	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.
65	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
66	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
67	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.
68	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.
69	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
70	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
71	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code