PC_PRQ_PROJECT (SQL Table)	Index Back
Project Request

PC_PRQ_PROJECT

(SQL Table)

Project Request

Related Language Record: PC_PRQ_PROJ_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL Request Id

2 PC_REQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Request Type
Prompt Table: PC_REQUEST_TYPE

3 PC_REQUEST_DESCR Character(254) VARCHAR2(254) NOT NULL Request Description

4 PC_REQUESTOR Character(30) VARCHAR2(30) NOT NULL Requester

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Default Value: NEXT

7 PROJECT_ID_FROM Character(15) VARCHAR2(15) NOT NULL From Project ID
Prompt Table: SP_PROJPT_NONVW

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

9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

11 START_DT Date(10) DATE Start Date

12 END_DT Date(10) DATE End Date

13 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
Prompt Table: PC_PROJROLE_VW
Set Control Field: BUSINESS_UNIT

14 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
Prompt Table: PC_ALLEMP_VW
Set Control Field: BUSINESS_UNIT

15 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table: PROJ_TYPE_TBL
Set Control Field: BUSINESS_UNIT

16 BUDGETED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Budgeted Assets

17 PROJECT_USER1 Character(10) VARCHAR2(10) NOT NULL Project User 1

18 PROJECT_USER2 Character(10) VARCHAR2(10) NOT NULL Project User 2

19 PROJECT_USER3 Character(10) VARCHAR2(10) NOT NULL Project User 3

20 PROJECT_USER4 Character(10) VARCHAR2(10) NOT NULL Project User 4

21 PROJECT_USER5 Character(10) VARCHAR2(10) NOT NULL Project User 5

22 PROJECT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1

23 PROJECT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2

24 PROJECT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3

25 PROJECT_USER_DT1 Date(10) DATE Date 1

26 PROJECT_USER_DT2 Date(10) DATE Date 2

27 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency
Prompt Table: CURRENCY_CD_TBL

28 PC_GRANTS_FLG Character(1) VARCHAR2(1) NOT NULL Grants Project
Y/N Table Edit

29 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL
Prompt Table: PC_INT_TMPL
Set Control Field: BUSINESS_UNIT

30 PC_REQ_ACT_OPTION Character(1) VARCHAR2(1) NOT NULL Standard Activities
F=Free Form Activity
P=Activity by Project Type
Y/N Table Edit
Default Value: N

31 CATEGORY_IND Character(10) VARCHAR2(10) NOT NULL An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.
Prompt Table: PGM_CATEGORY_AC

32 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: PC_NO_EPT_VW

33 TREE_EFFDT Date(10) DATE Effective date of the Tree
Prompt Table: PC_TREE_EFDT_VW

34 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node
Prompt Table: PC_TREENODE_DVW

35 EFFDT Date(10) DATE Effective Date
Default Value: %DATE

36 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

37 RATE_SELECT Character(1) VARCHAR2(1) NOT NULL This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set
2=Rate Plan

38 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
Prompt Table: PC_PRQ_RATE_VW2

39 RATE_PLAN Character(15) VARCHAR2(15) NOT NULL Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
Prompt Table: PC_PRQ_RTPL_VW

40 PRJ_LEVEL1_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 1 Chartfield
Prompt Table: SP_BU_GL_NONVW

41 PRJ_LEVEL2_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 2 Chartfield
Prompt Table: %EDITTABLE2

42 PRJ_LEVEL3_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 3 Chartfield
Prompt Table: %EDITTABLE3

43 PRJ_LEVEL4_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 4 Chartfield
Prompt Table: %EDITTABLE4

44 PRJ_LEVEL5_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 5 Chartfield
Prompt Table: %EDITTABLE5

45 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_REQUEST_ID	Character(15)	VARCHAR2(15) NOT NULL	Request Id
2	PC_REQUEST_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Request Type Prompt Table: PC_REQUEST_TYPE
3	PC_REQUEST_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Request Description
4	PC_REQUESTOR	Character(30)	VARCHAR2(30) NOT NULL	Requester
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
6	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: NEXT
7	PROJECT_ID_FROM	Character(15)	VARCHAR2(15) NOT NULL	From Project ID Prompt Table: SP_PROJPT_NONVW
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
11	START_DT	Date(10)	DATE	Start Date
12	END_DT	Date(10)	DATE	End Date
13	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: PC_PROJROLE_VW Set Control Field: BUSINESS_UNIT
14	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager Prompt Table: PC_ALLEMP_VW Set Control Field: BUSINESS_UNIT
15	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment Prompt Table: PROJ_TYPE_TBL Set Control Field: BUSINESS_UNIT
16	BUDGETED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Budgeted Assets
17	PROJECT_USER1	Character(10)	VARCHAR2(10) NOT NULL	Project User 1
18	PROJECT_USER2	Character(10)	VARCHAR2(10) NOT NULL	Project User 2
19	PROJECT_USER3	Character(10)	VARCHAR2(10) NOT NULL	Project User 3
20	PROJECT_USER4	Character(10)	VARCHAR2(10) NOT NULL	Project User 4
21	PROJECT_USER5	Character(10)	VARCHAR2(10) NOT NULL	Project User 5
22	PROJECT_USERAMT1	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 1
23	PROJECT_USERAMT2	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 2
24	PROJECT_USERAMT3	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 3
25	PROJECT_USER_DT1	Date(10)	DATE	Date 1
26	PROJECT_USER_DT2	Date(10)	DATE	Date 2
27	PC_USER_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	User Currency Prompt Table: CURRENCY_CD_TBL
28	PC_GRANTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Grants Project Y/N Table Edit
29	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL Prompt Table: PC_INT_TMPL Set Control Field: BUSINESS_UNIT
30	PC_REQ_ACT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Standard Activities F=Free Form Activity P=Activity by Project Type Y/N Table Edit Default Value: N
31	CATEGORY_IND	Character(10)	VARCHAR2(10) NOT NULL	An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc. Prompt Table: PGM_CATEGORY_AC
32	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: PC_NO_EPT_VW
33	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree Prompt Table: PC_TREE_EFDT_VW
34	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node Prompt Table: PC_TREENODE_DVW
35	EFFDT	Date(10)	DATE	Effective Date Default Value: %DATE
36	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
37	RATE_SELECT	Character(1)	VARCHAR2(1) NOT NULL	This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity. 1=Rate Set 2=Rate Plan
38	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID Prompt Table: PC_PRQ_RATE_VW2
39	RATE_PLAN	Character(15)	VARCHAR2(15) NOT NULL	Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line. Prompt Table: PC_PRQ_RTPL_VW
40	PRJ_LEVEL1_CF_VAL	Character(30)	VARCHAR2(30) NOT NULL	Level 1 Chartfield Prompt Table: SP_BU_GL_NONVW
41	PRJ_LEVEL2_CF_VAL	Character(30)	VARCHAR2(30) NOT NULL	Level 2 Chartfield Prompt Table: %EDITTABLE2
42	PRJ_LEVEL3_CF_VAL	Character(30)	VARCHAR2(30) NOT NULL	Level 3 Chartfield Prompt Table: %EDITTABLE3
43	PRJ_LEVEL4_CF_VAL	Character(30)	VARCHAR2(30) NOT NULL	Level 4 Chartfield Prompt Table: %EDITTABLE4
44	PRJ_LEVEL5_CF_VAL	Character(30)	VARCHAR2(30) NOT NULL	Level 5 Chartfield Prompt Table: %EDITTABLE5
45	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.