PC_EE_TRANS (SQL View)	Index Back
Entry Event Transaction View Prompt for Entry Events Run Control

PC_EE_TRANS

(SQL View)

Entry Event Transaction View

Prompt for Entry Events Run Control

SELECT DISTINCT B.BUSINESS_UNIT , B.PROJECT_ID , B.PC_BUDGET_ID , C.ACTIVITY_ID , C.RESOURCE_ID , C.EE_PROC_STATUS FROM PS_PROJECT A , PS_PC_BUD_PLAN B , PS_PC_BUD_DETAIL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND B.PC_BUDGET_ID = C.PC_BUDGET_ID AND A.GRANT_FLG <> 'Y' AND (C.ENTRY_EVENT <> ' ' OR C.KK_DEFAULT_EE = 'Y') AND C.JOURNAL_ID <> ' ' AND C.KK_DISTRIB_STATUS = 'D'

# 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
Prompt Table: PROJECT_VW

3 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID

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

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

6 EE_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL Entry Event Line Status

#	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 Prompt Table: PROJECT_VW
3	PC_BUDGET_ID	Number(3,0)	SMALLINT NOT NULL	Budget Plan ID
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	EE_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Entry Event Line Status