1 |
MAIN_PROJECT_ID |
|
RPM_TV_EXTID |
|
CHAR |
24 |
0 |
ID |
|
2 |
MAIN_DESCRIPTION |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|
3 |
EXTERNAL_ID |
|
RPM_TV_EXTID |
|
CHAR |
24 |
0 |
ID |
|
4 |
PROJ_DESCRIPTION |
|
CGPL_TEXT1 |
TEXT40 |
CHAR |
40 |
0 |
Language-Dependent Short Text |
|
5 |
CATEGORY |
|
RPM_PROJECT_CATEGORY |
RPM_PROJECT_CATEGORY |
NUMC |
4 |
0 |
Category |
* |
6 |
SUBCATEGORY |
|
RPM_PROJ_SUBCATEGORY |
RPM_SUBCATEGORY |
NUMC |
4 |
0 |
Subcategory |
* |
7 |
.INCLUDE |
|
|
|
|
0 |
0 |
Project attributes |
|
8 |
PTYPE |
|
RPM_PROJECTTYPE |
RPM_PROJECTTYPE |
NUMC |
4 |
0 |
Group |
* |
9 |
TTYPE |
|
RPM_PROJECT_TECHTYPE |
RPM_PROJECT_TECHTYPE |
NUMC |
4 |
0 |
Technology Type |
* |
10 |
.INCLUDE |
|
|
|
|
0 |
0 |
Project attributes |
|
11 |
APSTAT |
|
RPM_PROJECT_APPST |
RPM_PROJECT_APPST |
NUMC |
4 |
0 |
Project Approval Status |
RPM_PROJ_APST |
12 |
PPRIO |
|
RPM_PROJECT_PRIORITY |
NUMC4 |
NUMC |
4 |
0 |
Project Priority |
|
13 |
RISKA |
|
RPM_PROJECT_RISK_ASSESED |
NUMC3 |
NUMC |
3 |
0 |
Assessed Project Risk |
|
14 |
PROBT |
|
RPM_PROJECT_PROB_TECH |
NUMC3 |
NUMC |
3 |
0 |
Probability of Technical Success |
|
15 |
PROBC |
|
RPM_PROJECT_PROB_COMM |
NUMC3 |
NUMC |
3 |
0 |
Probability of Commercial Success |
|
16 |
HEADC |
|
RPM_PROJECT_HEADCOUNT_PLAN |
|
DEC |
10 |
2 |
Project Planned Headcount |
|
17 |
BUDGT |
|
RPM_PROJECT_BUDGET_PLAN |
CURR16 |
CURR |
16 |
2 |
Budget |
|
18 |
COSTD |
|
RPM_PROJECT_COST_DEVELOPMENT |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Development Cost |
|
19 |
COSTL |
|
RPM_PROJECT_COST_LAUNCH |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Launch Cost |
|
20 |
NPV |
|
RPM_PROJECT_NPV |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Net Present Value (manual) |
|
21 |
CURRENCY |
|
RPM_TV_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency key |
TCURC |
22 |
LOCATION |
|
RPM_TV_PROJECT_LOCATION |
RPM_PROJECT_LOCATION |
CHAR |
4 |
0 |
Project Location |
RPM_PROJ_LOCAT |
23 |
GEOGRAPHY |
|
RPM_TV_PROJECT_GEOGRAPHY |
RPM_PROJECT_GEOGRAPHY |
CHAR |
4 |
0 |
Project Geography |
RPM_PROJ_GEOGR |
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
Project attributes |
|
25 |
PHASE |
|
RPM_PROJECT_PHASE |
RPM_PROJECT_PHASE |
NUMC |
4 |
0 |
Stage |
* |
26 |
EXSTAT |
|
RPM_PROJECT_EXECSTAT |
RPM_PROJECT_EXECSTAT |
NUMC |
4 |
0 |
Project Execution Status |
RPM_PROJ_EXST |
27 |
COSTF |
|
RPM_PROJECT_COST_FORECAST |
CURR16 |
CURR |
16 |
2 |
Planned Cost |
|
28 |
COSTA |
|
RPM_PROJECT_COST_ACTUAL |
CURR16 |
CURR |
16 |
2 |
Actual Cost |
|
29 |
RPM_CHANGED_ON |
|
RPM_TV_TIMESTAMP |
RPM_BCOS_TSTMP |
DEC |
15 |
0 |
Time Stamp |
|
30 |
ACTUAL_WORK |
|
RPM_TV_ACTUAL_WORK |
|
DEC |
10 |
2 |
Actual Work |
|
31 |
PLANNED_WORK |
|
RPM_TV_PLANNED_WORK |
|
DEC |
10 |
2 |
Planned Work |
|
32 |
WORK_UNITS |
|
RPM_TV_ALLOCATION_UNIT |
RPM_ALLOCATION_UNIT |
CHAR |
3 |
0 |
Assignment Unit |
|
33 |
BASELINE_START |
|
RPM_TV_BASELINE_START |
|
DATS |
8 |
0 |
Baseline Start |
|
34 |
BASELINE_FINISH |
|
RPM_TV_BASELINE_FINISH |
|
DATS |
8 |
0 |
Baseline Finish |
|
35 |
COSTF_TD |
|
RPM_PROJECT_COST_FORECAST |
CURR16 |
CURR |
16 |
2 |
Planned Cost |
|
36 |
COSTA_TD |
|
RPM_PROJECT_COST_ACTUAL |
CURR16 |
CURR |
16 |
2 |
Actual Cost |
|
37 |
ANNUAL_BUDGET |
|
RPM_PROJECT_BUDGET_PLAN |
CURR16 |
CURR |
16 |
2 |
Budget |
|
38 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
39 |
.INCLUDE |
|
|
|
|
0 |
0 |
RPM: Proj atts derived from externally modifiable attributes |
|
40 |
D_PLANSTART |
|
RPM_TV_PLANNED_BEGDA |
DATUM |
DATS |
8 |
0 |
Planned Start Date |
|
41 |
D_PLANFINISH |
|
RPM_TV_PLANNED_ENDDA |
DATUM |
DATS |
8 |
0 |
Planned Finish Date |
|
42 |
D_ACTUALSTART |
|
RPM_TV_ACTUAL_BEGDA |
DATUM |
DATS |
8 |
0 |
Actual Start Date |
|
43 |
D_ACTUALFINISH |
|
RPM_TV_ACTUAL_ENDDA |
DATUM |
DATS |
8 |
0 |
Actual Finish Date |
|
44 |
.INCLUDE |
|
|
|
|
0 |
0 |
RPM: Proj atts derived from externally modifiable attributes |
|
45 |
RISK_PRCNT |
|
RPM_RISK_LIMIT_HIGH |
NUMC3 |
NUMC |
3 |
0 |
Risk Group - Upper Limit |
|
46 |
RISK_GROUP |
|
RPM_RISK_GROUP |
RPM_RISK_GROUP |
NUMC |
2 |
0 |
Risk Group Assessed |
* |
47 |
RISK_ICON |
|
RPM_TV_RISK_ICON |
ICON |
CHAR |
4 |
0 |
Project Risk |
* |
48 |
ECV |
|
RPM_TV_ECV |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Expected Commercial Value (manual) |
|
49 |
DERIVED_RISK |
|
RPM_TV_RISK_DERIVED |
NUMC3 |
NUMC |
3 |
0 |
Derived Risk |
|
50 |
HEADC_ACTUAL |
|
RPM_PROJECT_HEADCOUNT |
/RPM/DEC_10_2 |
DEC |
10 |
2 |
Actual Headcount |
|
51 |
LOC_GEOGRAPHY |
|
RPM_TV_PROJECT_GEOGRAPHY |
RPM_PROJECT_GEOGRAPHY |
CHAR |
4 |
0 |
Project Geography |
* |
52 |
DEPENDENCY_COUNT |
|
RPM_TV_DEPENDENCY_COUNT |
NUMC3 |
NUMC |
3 |
0 |
Number of Project Dependencies. |
|
53 |
DEPENDENCY_GROUP |
|
RPM_TV_DEPENDENCY_STATUS |
RPM_DEPENDENCY_STATUS |
NUMC |
4 |
0 |
Dependency Status |
|
54 |
DEPENDENCY_ICON |
|
ICON_D |
ICON |
CHAR |
4 |
0 |
Icon in text fields (substitute display, alias) |
* |
55 |
DEPEND_ICONNAME |
|
ICONNAME |
ICONNAME |
CHAR |
30 |
0 |
Name of an Icon |
|
56 |
DEPENDENCY_TEXT |
|
RPM_TV_DP_STATGRP_T |
TEXT30 |
CHAR |
30 |
0 |
Dependency:Status Indicator Text |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
RPM: Proj atts derived from externally modifiable attributes |
|
58 |
PRIORITY_PRCNT |
|
RPM_PRIORITY_LIMIT_HIGH |
NUMC4 |
NUMC |
4 |
0 |
Project Priority: Upper Limit |
|
59 |
PRIORITY_GROUP |
|
RPM_PRIORITY_GROUP |
RPM_PRIORITY_GROUP |
NUMC |
2 |
0 |
Priority Group |
* |
60 |
PRIORITY_ICON |
|
RPM_TV_PRIORITY_ICON |
ICON |
CHAR |
4 |
0 |
Priority |
* |
61 |
BUDGET_PRCNT |
|
RPM_TV_BUDGET_LIMIT_HIGH |
DECV03 |
DEC |
3 |
0 |
Project Budget Status: Upper Limit |
|
62 |
BUDGET_GROUP |
|
RPM_TV_BUDGET_GROUP |
RPM_BUDGET_GROUP |
NUMC |
2 |
0 |
Budget Status Group |
* |
63 |
BUDGET_ICON |
|
RPM_TV_BUDGET_ICON |
ICON |
CHAR |
4 |
0 |
Project Budget |
* |
64 |
SCHEDULE_PRCNT |
|
RPM_TV_SCHEDULE_LIMIT_HIGH |
NUMC3 |
NUMC |
3 |
0 |
Project Schedule Status: Upper Limit |
|
65 |
SCHEDULE_GROUP |
|
RPM_TV_SCHEDULE_GROUP |
RPM_SCHEDULE_GROUP |
NUMC |
2 |
0 |
Schedule Status Group |
* |
66 |
SCHEDULE_ICON |
|
RPM_TV_SCHEDULE_ICON |
ICON |
CHAR |
4 |
0 |
Project Schedule |
* |
67 |
STAFFING_PRCNT |
|
RPM_TV_SCHEDULE_LIMIT_HIGH |
NUMC3 |
NUMC |
3 |
0 |
Project Schedule Status: Upper Limit |
|
68 |
STAFFING_GROUP |
|
RPM_TV_STAFFING_GROUP |
RPM_STAFFING_GROUP |
NUMC |
2 |
0 |
Staffing Status Group |
* |
69 |
STAFFING_ICON |
|
RPM_TV_STAFFING_ICON |
ICON |
CHAR |
4 |
0 |
Project Staffing |
* |
70 |
PHASE_ICON |
|
RPM_TV_PHASE_ICON |
ICON |
CHAR |
4 |
0 |
Stage |
* |
71 |
PHASE_COLOR |
|
RPM_TV_STATUS_COLOR |
RPM_HTML_COLOR |
CHAR |
7 |
0 |
Alert Object Color Status |
|
72 |
VAR_COST |
|
RPM_PROJ_VARIANCE_COST |
CURR16 |
CURR |
16 |
2 |
Total Variance of Project Planned Cost to Actual Cost |
|
73 |
VAR_WORK |
|
RPM_TV_ACTUAL_WORK |
|
DEC |
10 |
2 |
Actual Work |
|
74 |
VAR_HEADCOUNT |
|
RPM_PROJ_VARIANCE_HEADCOUNT |
|
DEC |
10 |
2 |
Variance of Project Planned and Actual Headcount |
|
75 |
VAR_STARTDATE |
|
RPM_PROJ_VAR_DAYS |
|
DEC |
8 |
0 |
Variance Start Date in Days |
|
76 |
VAR_FINISHDATE |
|
RPM_PROJ_VAR_DAYS_FINISH |
|
DEC |
8 |
0 |
Variance Finish Date in Days |
|
77 |
VAR_COST_TD |
|
RPM_PROJ_VARIANCE_COST_TD |
CURR16 |
CURR |
16 |
2 |
YTD Variance of Project Planned Cost to Actual Cost |
|
78 |
MASTER_PROJECT |
|
RPM_TV_IS_MASTER_PROJECT |
CHAR1 |
CHAR |
1 |
0 |
Master Project Flag |
|
79 |
.INCLUDE |
|
|
|
|
0 |
0 |
Node neighbor IDs |
|
80 |
PARENT_ID |
|
RPM_TV_PARENT_EXTID |
|
CHAR |
24 |
0 |
Parent ID |
|
81 |
LEFT_ID |
|
RPM_TV_LEFT_EXTID |
|
CHAR |
24 |
0 |
Left ID |
|
82 |
RIGHT_ID |
|
RPM_TV_RIGHT_EXTID |
|
CHAR |
24 |
0 |
Right ID |
|
83 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
84 |
.INCLUDE |
|
|
|
|
0 |
0 |
Master Project Summary Fields |
|
85 |
SUM_HEADC |
|
RPM_PROJECT_HEADCOUNT |
/RPM/DEC_10_2 |
DEC |
10 |
2 |
Actual Headcount |
|
86 |
SUM_BUDGT |
|
RPM_PROJECT_BUDGET_PLAN |
CURR16 |
CURR |
16 |
2 |
Budget |
|
87 |
SUM_COSTF |
|
RPM_PROJECT_COST_FORECAST |
CURR16 |
CURR |
16 |
2 |
Planned Cost |
|
88 |
SUM_COSTA |
|
RPM_PROJECT_COST_ACTUAL |
CURR16 |
CURR |
16 |
2 |
Actual Cost |
|
89 |
SUM_COSTD |
|
RPM_PROJECT_COST_DEVELOPMENT |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Development Cost |
|
90 |
SUM_COSTL |
|
RPM_PROJECT_COST_LAUNCH |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Launch Cost |
|
91 |
SUM_NPV |
|
RPM_PROJECT_NPV |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Net Present Value (manual) |
|
92 |
SUM_CURRENCY |
|
RPM_TV_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency key |
* |
93 |
SUM_A_HEADCOUNT |
|
RPM_PROJECT_HEADCOUNT |
/RPM/DEC_10_2 |
DEC |
10 |
2 |
Actual Headcount |
|
94 |
SUM_A_WORK |
|
RPM_TV_ACTUAL_WORK |
|
DEC |
10 |
2 |
Actual Work |
|
95 |
SUM_P_WORK |
|
RPM_TV_PLANNED_WORK |
|
DEC |
10 |
2 |
Planned Work |
|
96 |
SUM_WORK_UNITS |
|
RPM_TV_ALLOCATION_UNIT |
RPM_ALLOCATION_UNIT |
CHAR |
3 |
0 |
Assignment Unit |
|
97 |
SUM_COSTF_TD |
|
RPM_PROJECT_COST_FORECAST |
CURR16 |
CURR |
16 |
2 |
Planned Cost |
|
98 |
SUM_COSTA_TD |
|
RPM_PROJECT_COST_ACTUAL |
CURR16 |
CURR |
16 |
2 |
Actual Cost |
|
99 |
SUM_A_BUDGET |
|
RPM_PROJECT_BUDGET_PLAN |
CURR16 |
CURR |
16 |
2 |
Budget |
|
100 |
SUM_V_COST |
|
RPM_PROJ_VARIANCE_COST |
CURR16 |
CURR |
16 |
2 |
Total Variance of Project Planned Cost to Actual Cost |
|
101 |
SUM_V_HEADCOUNT |
|
RPM_PROJ_VARIANCE_HEADCOUNT |
|
DEC |
10 |
2 |
Variance of Project Planned and Actual Headcount |
|
102 |
SUM_V_WORK |
|
RPM_TV_ACTUAL_WORK |
|
DEC |
10 |
2 |
Actual Work |
|
103 |
SUM_V_COST_TD |
|
RPM_PROJ_VARIANCE_COST_TD |
CURR16 |
CURR |
16 |
2 |
YTD Variance of Project Planned Cost to Actual Cost |
|
104 |
SUM_ECV |
|
RPM_TV_ECV |
/RPM/CURR_16_2 |
CURR |
16 |
2 |
Expected Commercial Value (manual) |
|
105 |
AVG_PROBT |
|
RPM_PROJECT_PROB_TECH |
NUMC3 |
NUMC |
3 |
0 |
Probability of Technical Success |
|
106 |
AVG_PROBC |
|
RPM_PROJECT_PROB_COMM |
NUMC3 |
NUMC |
3 |
0 |
Probability of Commercial Success |
|