PC_BDTOPC_SUM_V (SQL View)	Index Back
Projects Budgets TIP

PC_BDTOPC_SUM_V

(SQL View)

Projects Budgets TIP

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.FOREIGN_AMOUNT , A.CURRENCY_CD , A.SYSTEM_SOURCE , A.ACCOUNTING_DT , A.EMPLID , A.JOBCODE , A.TRANS_DT , A.ANALYSIS_TYPE , A.PC_BUDGET_ID , A.BD_HDR_STATUS , A.KK_DISTRIB_STATUS , A.PC_DISTRIB_STATUS FROM PS_PC_BUD_PLAN B , PS_PC_BUD_DETAIL A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.PC_BUDGET_ID = B.PC_BUDGET_ID AND B.PC_BUDGET_STATUS <> '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

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

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

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

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

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

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

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

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

10 TRANS_DT Date(10) DATE Transaction Date

11 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Default Value: INSTALLATION_PC.AN_TYPE_PC_BUD
Prompt Table: %EDITTABLE

12 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID
Default Value: 1

13 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

14 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

15 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
4	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.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
6	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.
7	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
10	TRANS_DT	Date(10)	DATE	Transaction Date
11	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Default Value: INSTALLATION_PC.AN_TYPE_PC_BUD Prompt Table: %EDITTABLE
12	PC_BUDGET_ID	Number(3,0)	SMALLINT NOT NULL	Budget Plan ID Default Value: 1
13	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
14	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
15	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