PROJ_N_REQ_TBL (SQL Table)	Index Back
Projects and Requested Project This is table that is used to merge the data from BC_PROJ_REQUEST and PROJECTS_D00 to be used as the new Project Dimension used especially by Project Portfolio Management Product. The reason for this new dimension table is because PPM might have KPIs going against the requested projects and the projects in execution so that they can report or chart off one table i.e this new Project Dimension tbl. JDB comment added:3/4/03 The reason this physical table is used rather than a View is because DB2 does not allow outer joins or unions in a view. Since projects may exist in PROJECTS_D00 that do not exist in BC_PROJ_REQUEST, an outer join would be necessary.

PROJ_N_REQ_TBL

(SQL Table)

Projects and Requested Project

This is table that is used to merge the data from BC_PROJ_REQUEST and PROJECTS_D00 to be used as the new Project Dimension used especially by Project Portfolio Management Product. The reason for this new dimension table is because PPM might have KPIs going against the requested projects and the projects in execution so that they can report or chart off one table i.e this new Project Dimension tbl. JDB comment added:3/4/03 The reason this physical table is used rather than a View is because DB2 does not allow outer joins or unions in a view. Since projects may exist in PROJECTS_D00 that do not exist in BC_PROJ_REQUEST, an outer join would be necessary.

# 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 PPK_PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project ID

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

5 BC_PROJ_REQ_STATUS Character(2) VARCHAR2(2) NOT NULL Status of the Project Request.
01=Approved
02=Pending
03=Submitted
04=Canceled
05=Declined
06=Returned
07=Costing
08=Hold
09=Complete
10=Executed
11=Operationally Approved
Default Value: 02

6 BC_PRIORITY_REQSTR Number(3,0) SMALLINT NOT NULL Requester Priority
Default Value: 3
Prompt Table: BC_PRJ_PRTY_TBL

7 BC_PRIORITY_APPRVR Number(3,0) SMALLINT NOT NULL Approver Priority
Prompt Table: BC_PRJ_PRTY_TBL

8 BC_INVESTMENT_TYPE Character(2) VARCHAR2(2) NOT NULL Investment Type
01=Run Rate
02=Infrastructure
03=Transactional
04=Informational
05=Utilities

9 BC_SPONSOR Character(40) VARCHAR2(40) NOT NULL Business Sponsor of Project.

10 BC_REQUESTER Character(50) VARCHAR2(50) NOT NULL Requester of Project Request.
Prompt Table: PERSONAL_DATA

11 BC_APPROVER_ID Character(30) VARCHAR2(30) NOT NULL Operator ID for the approver
Prompt Table: PGM_OPR_NAME_VW

12 BC_APPROVER Character(50) VARCHAR2(50) NOT NULL Approver of Project Request.
Prompt Table: PERSONAL_DATA

13 BC_DEPTID_REQSTER Character(10) VARCHAR2(10) NOT NULL Department of the project requester.
Prompt Table: DEPTID_NB_VW
Set Control Field: BUSINESS_UNIT

14 BC_PROJECT_OWNER Character(40) VARCHAR2(40) NOT NULL Project Owner

15 BC_PROJ_DEPTID Character(10) VARCHAR2(10) NOT NULL Project Owning Deptid

16 BC_FINISH_DATE Date(10) DATE Desired Finish Date

17 BASELINE_START_DT Date(10) DATE Baseline Start Date

18 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date

19 CREATE_DATE Date(10) DATE Creation Date

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

21 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL

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

23 BC_ESTIMATED_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Cost used on Project Request page.

24 BC_MAINT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Maintenance Cost

25 PPK_MAINT_TRNS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Maintenance Cost

26 BC_FUNDING Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Funding Amount used on Project Request page.

27 BC_RISK Number(7,2) DECIMAL(6,2) NOT NULL Risk
01=1- High
02=2 - Medium
03=3 - Low

28 BC_KBO_SUPPORT Number(7,2) DECIMAL(6,2) NOT NULL KBO Support

29 BC_EST_BENEFITS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Benefits

30 BC_BENEFIT_TERM Number(4,0) SMALLINT NOT NULL Benefit Term

31 BC_BENEFIT_BEGIN Number(4,0) SMALLINT NOT NULL Benefit Begin

32 BC_NET_PRESENT_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Present Value

33 BC_PV_BENEFITS Number(27,3) DECIMAL(26,3) NOT NULL Net Present Value of Benefits

34 BC_ROI Signed Number(28,3) DECIMAL(26,3) NOT NULL Return on Investment

35 USER_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)

36 USER_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)

37 USER_AMT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)

38 KP_USER_FLD1 Character(10) VARCHAR2(10) NOT NULL Report Attribute field

39 KP_USER_FLD2 Character(30) VARCHAR2(30) NOT NULL Report Attribute field

40 KP_USER_FLD3 Character(30) VARCHAR2(30) NOT NULL Report Attribute field

41 KP_USER_FLD4 Character(10) VARCHAR2(10) NOT NULL Report Attribute field

42 KP_USER_FLD5 Character(10) VARCHAR2(10) NOT NULL Report Attribute field

43 KP_USER_FLD6 Character(30) VARCHAR2(30) NOT NULL Report Attribute field

44 KP_USER_FLD7 Character(30) VARCHAR2(30) NOT NULL Report Attribute field

45 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

46 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager

47 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed

48 START_DT Date(10) DATE Start Date

49 END_DT Date(10) DATE End Date

50 PROJECT_PRIORITY Number(3,0) SMALLINT NOT NULL Project Priority

51 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete

52 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

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

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

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

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

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

58 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

59 LASTUPDDTTM 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.

60 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

61 PPK_PROJ_VERSION Character(15) VARCHAR2(15) NOT NULL An identifier that represents a version of the Project Request.

62 BC_INDUSTRY_TYPE Character(1) VARCHAR2(1) NOT NULL Industry Type - Commercial C Edu. and Govt. E
C=Commercial
E=Education & Government

63 PPK_PG_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Communication Status with Program Management

#	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	PPK_PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	BC_PROJ_REQ_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Status of the Project Request. 01=Approved 02=Pending 03=Submitted 04=Canceled 05=Declined 06=Returned 07=Costing 08=Hold 09=Complete 10=Executed 11=Operationally Approved Default Value: 02
6	BC_PRIORITY_REQSTR	Number(3,0)	SMALLINT NOT NULL	Requester Priority Default Value: 3 Prompt Table: BC_PRJ_PRTY_TBL
7	BC_PRIORITY_APPRVR	Number(3,0)	SMALLINT NOT NULL	Approver Priority Prompt Table: BC_PRJ_PRTY_TBL
8	BC_INVESTMENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Investment Type 01=Run Rate 02=Infrastructure 03=Transactional 04=Informational 05=Utilities
9	BC_SPONSOR	Character(40)	VARCHAR2(40) NOT NULL	Business Sponsor of Project.
10	BC_REQUESTER	Character(50)	VARCHAR2(50) NOT NULL	Requester of Project Request. Prompt Table: PERSONAL_DATA
11	BC_APPROVER_ID	Character(30)	VARCHAR2(30) NOT NULL	Operator ID for the approver Prompt Table: PGM_OPR_NAME_VW
12	BC_APPROVER	Character(50)	VARCHAR2(50) NOT NULL	Approver of Project Request. Prompt Table: PERSONAL_DATA
13	BC_DEPTID_REQSTER	Character(10)	VARCHAR2(10) NOT NULL	Department of the project requester. Prompt Table: DEPTID_NB_VW Set Control Field: BUSINESS_UNIT
14	BC_PROJECT_OWNER	Character(40)	VARCHAR2(40) NOT NULL	Project Owner
15	BC_PROJ_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Project Owning Deptid
16	BC_FINISH_DATE	Date(10)	DATE	Desired Finish Date
17	BASELINE_START_DT	Date(10)	DATE	Baseline Start Date
18	BASELINE_FINISH_DT	Date(10)	DATE	Baseline Finish Date
19	CREATE_DATE	Date(10)	DATE	Creation Date
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
21	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Prompt Table: CURRENCY_CD_TBL
22	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.
23	BC_ESTIMATED_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Cost used on Project Request page.
24	BC_MAINT_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Maintenance Cost
25	PPK_MAINT_TRNS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Maintenance Cost
26	BC_FUNDING	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Funding Amount used on Project Request page.
27	BC_RISK	Number(7,2)	DECIMAL(6,2) NOT NULL	Risk 01=1- High 02=2 - Medium 03=3 - Low
28	BC_KBO_SUPPORT	Number(7,2)	DECIMAL(6,2) NOT NULL	KBO Support
29	BC_EST_BENEFITS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Benefits
30	BC_BENEFIT_TERM	Number(4,0)	SMALLINT NOT NULL	Benefit Term
31	BC_BENEFIT_BEGIN	Number(4,0)	SMALLINT NOT NULL	Benefit Begin
32	BC_NET_PRESENT_VAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Present Value
33	BC_PV_BENEFITS	Number(27,3)	DECIMAL(26,3) NOT NULL	Net Present Value of Benefits
34	BC_ROI	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Return on Investment
35	USER_AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
36	USER_AMT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
37	USER_AMT3	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
38	KP_USER_FLD1	Character(10)	VARCHAR2(10) NOT NULL	Report Attribute field
39	KP_USER_FLD2	Character(30)	VARCHAR2(30) NOT NULL	Report Attribute field
40	KP_USER_FLD3	Character(30)	VARCHAR2(30) NOT NULL	Report Attribute field
41	KP_USER_FLD4	Character(10)	VARCHAR2(10) NOT NULL	Report Attribute field
42	KP_USER_FLD5	Character(10)	VARCHAR2(10) NOT NULL	Report Attribute field
43	KP_USER_FLD6	Character(30)	VARCHAR2(30) NOT NULL	Report Attribute field
44	KP_USER_FLD7	Character(30)	VARCHAR2(30) NOT NULL	Report Attribute field
45	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration
46	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager
47	PROJECT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Project Status B=Budgeted C=Closed H=Hold O=Open P=Proposed
48	START_DT	Date(10)	DATE	Start Date
49	END_DT	Date(10)	DATE	End Date
50	PROJECT_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Project Priority
51	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
52	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
53	PROJECT_USER1	Character(10)	VARCHAR2(10) NOT NULL	Project User 1
54	PROJECT_USER3	Character(10)	VARCHAR2(10) NOT NULL	Project User 3
55	PROJECT_USER2	Character(10)	VARCHAR2(10) NOT NULL	Project User 2
56	PROJECT_USER4	Character(10)	VARCHAR2(10) NOT NULL	Project User 4
57	PROJECT_USER5	Character(10)	VARCHAR2(10) NOT NULL	Project User 5
58	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
59	LASTUPDDTTM	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.
60	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
61	PPK_PROJ_VERSION	Character(15)	VARCHAR2(15) NOT NULL	An identifier that represents a version of the Project Request.
62	BC_INDUSTRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Industry Type - Commercial C Edu. and Govt. E C=Commercial E=Education & Government
63	PPK_PG_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Communication Status with Program Management