PC_BUD_COMP

(SQL View)

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_BUDGET_ID , B.EFF_STATUS , B.GRANT_FLG , B.PROJ_TMPL_FILTER FROM PS_PC_BUD_PLAN A , PS_PROJECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.GRANT_FLG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

2 PROJECT_ID_2 Character(15) VARCHAR2(15) NOT NULL Project

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

4 PC_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
A=Active
I=Inactive
P=Pending
T=Template

5 GRANT_FLG Character(1) VARCHAR2(1) NOT NULL Grants Management Used for designating whether or not an object is for Grants or for Projects.
N=Projects Object
Y=Grants Object

6 PROJ_TMPL_FILTER Character(30) VARCHAR2(30) NOT NULL Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
2	PROJECT_ID_2	Character(15)	VARCHAR2(15) NOT NULL	Project
3	PC_BUDGET_ID_TMP	Number(3,0)	SMALLINT NOT NULL	Budget Plan ID
4	PC_PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The processing state of a project. A=Active I=Inactive P=Pending T=Template
5	GRANT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Grants Management Used for designating whether or not an object is for Grants or for Projects. N=Projects Object Y=Grants Object
6	PROJ_TMPL_FILTER	Character(30)	VARCHAR2(30) NOT NULL	Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.