Field Map for Primavera P6 Reporting Database

This documents the mapping from the Primavera P6 Reporting Database persisted fields to the fields in the database from whence they are derived.

W_DAY_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_DAY_Dbigint
DAY_DTW_DAY_Ddate
DAY_NAMEW_DAY_Dstring
SHORT_DAY_NAMEW_DAY_Dstring
CAL_YEARW_DAY_Dsmallint
CAL_WEEKW_DAY_Dsmallint
CAL_MONTHW_DAY_Dsmallint
CAL_QTRW_DAY_Dtinyint
CAL_HALFW_DAY_Dtinyint
MONTH_NAMEW_DAY_Dstring
WEEK_NAMEW_DAY_Dstring
QUARTER_NAMEW_DAY_Dstring
HALF_NAMEW_DAY_Dstring
YEAR_NAMEW_DAY_Dstring
DAY_OF_MONTHW_DAY_Dtinyint
DAY_OF_WEEKW_DAY_Dtinyint
DAY_OF_YEARW_DAY_Dsmallint
FISCAL_YEARW_DAY_Dsmallint
FIN_PERIOD_1W_DAY_Dstring
FIN_PERIOD_2W_DAY_Dstring
FIN_PERIOD_3W_DAY_Dstring
CUSTOM_1W_DAY_Dstring
CUSTOM_2W_DAY_Dstring
CUSTOM_3W_DAY_Dstring
CUSTOM_4W_DAY_Dstring
CUSTOM_5W_DAY_Dstring
W_UPDATE_DTW_DAY_Ddate
W_CREATE_DTW_DAY_Ddate
DELETE_FLAGW_DAY_Dstring
DATASOURCE_IDW_DAY_Dbigint
W_RESOURCE_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_RESOURCE_Dbigint
RESOURCE_OBJECT_IDW_RESOURCE_Dbigint
ACTIVE_FLAGW_RESOURCE_Dstring
RESOURCE_TYPEW_RESOURCE_Dstring
RESOURCE_IDW_RESOURCE_Dstring
RESOURCE_NAMEW_RESOURCE_Dstring
EMPLOYEE_CODEW_RESOURCE_Dstring
RESOURCE_TITLEW_RESOURCE_Dstring
CALENDAR_OBJECT_IDW_RESOURCE_Dbigint
CALENDAR_NAMEW_RESOURCE_Dstring
CURRENCY_NAMEW_RESOURCE_Dstring
PRIMARY_ROLE_NAMEW_RESOURCE_Dstring
TIMESHEET_APPROVAL_MANAGERW_RESOURCE_Dstring
USER_NAMEW_RESOURCE_Dstring
CUSTOM_1W_RESOURCE_Dstring
CUSTOM_2W_RESOURCE_Dstring
CUSTOM_3W_RESOURCE_Dstring
CUSTOM_4W_RESOURCE_Dstring
CUSTOM_5W_RESOURCE_Dstring
W_UPDATE_DTW_RESOURCE_Ddate
W_CREATE_DTW_RESOURCE_Ddate
DELETE_FLAGW_RESOURCE_Dstring
DATASOURCE_IDW_RESOURCE_Dbigint
CODE_VALUE_01W_RESOURCE_Dstring
CODE_DESCR_01W_RESOURCE_Dstring
CODE_VALUE_02W_RESOURCE_Dstring
CODE_DESCR_02W_RESOURCE_Dstring
CODE_VALUE_03W_RESOURCE_Dstring
CODE_DESCR_03W_RESOURCE_Dstring
CODE_VALUE_04W_RESOURCE_Dstring
CODE_DESCR_04W_RESOURCE_Dstring
CODE_VALUE_05W_RESOURCE_Dstring
CODE_DESCR_05W_RESOURCE_Dstring
CODE_VALUE_06W_RESOURCE_Dstring
CODE_DESCR_06W_RESOURCE_Dstring
CODE_VALUE_07W_RESOURCE_Dstring
CODE_DESCR_07W_RESOURCE_Dstring
CODE_VALUE_08W_RESOURCE_Dstring
CODE_DESCR_08W_RESOURCE_Dstring
CODE_VALUE_09W_RESOURCE_Dstring
CODE_DESCR_09W_RESOURCE_Dstring
CODE_VALUE_10W_RESOURCE_Dstring
CODE_DESCR_10W_RESOURCE_Dstring
CODE_VALUE_11W_RESOURCE_Dstring
CODE_DESCR_11W_RESOURCE_Dstring
CODE_VALUE_12W_RESOURCE_Dstring
CODE_DESCR_12W_RESOURCE_Dstring
CODE_VALUE_13W_RESOURCE_Dstring
CODE_DESCR_13W_RESOURCE_Dstring
CODE_VALUE_14W_RESOURCE_Dstring
CODE_DESCR_14W_RESOURCE_Dstring
CODE_VALUE_15W_RESOURCE_Dstring
CODE_DESCR_15W_RESOURCE_Dstring
CODE_VALUE_16W_RESOURCE_Dstring
CODE_DESCR_16W_RESOURCE_Dstring
CODE_VALUE_17W_RESOURCE_Dstring
CODE_DESCR_17W_RESOURCE_Dstring
CODE_VALUE_18W_RESOURCE_Dstring
CODE_DESCR_18W_RESOURCE_Dstring
CODE_VALUE_19W_RESOURCE_Dstring
CODE_DESCR_19W_RESOURCE_Dstring
CODE_VALUE_20W_RESOURCE_Dstring
CODE_DESCR_20W_RESOURCE_Dstring
W_PROJECT_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_PROJECT_Dbigint
EPS_WIDW_PROJECT_Dbigint
PROJECT_IDW_PROJECT_Dstring
PROJECT_NAMEW_PROJECT_Dstring
PROJECT_OBJECT_IDW_PROJECT_Dbigint
EPS_OBJECT_IDW_PROJECT_Dbigint
PROJECT_PRIORITYW_PROJECT_Dinteger
PROJECT_STRATEGIC_PRIORITYW_PROJECT_Dinteger
CRITICAL_ACTIVITY_FLOAT_LIMITW_PROJECT_Ddouble
PLANNED_START_DATEW_PROJECT_Ddate
PLANNED_FINISH_DATEW_PROJECT_Ddate
SCHEDULED_FINISH_DATEW_PROJECT_Ddate
ADD_DATEW_PROJECT_Ddate
PROJECT_START_DATEW_PROJECT_Ddate
PROJECT_FINISH_DATEW_PROJECT_Ddate
ADDED_BY_NAMEW_PROJECT_Dstring
ANNUAL_DISCOUNT_RATEW_PROJECT_Dnumber
ANTICIPATED_FINISH_DATEW_PROJECT_Ddate
ANTICIPATED_START_DATEW_PROJECT_Ddate
CURRENT_BUDGETW_PROJECT_Dnumber
CURRENT_VARIANCEW_PROJECT_Dnumber
DATA_DATEW_PROJECT_Ddate
DISTRIBUTED_CURRENT_BUDGETW_PROJECT_Dnumber
FORECAST_START_DATEW_PROJECT_Ddate
FORECAST_FINISH_DATEW_PROJECT_Ddate
ORIGINAL_BUDGETW_PROJECT_Dnumber
OVERALL_PROJECT_SCOREW_PROJECT_Dnumber
PROPOSED_BUDGETW_PROJECT_Dnumber
PROJECT_RISK_LEVELW_PROJECT_Dstring
PROJECT_STATUSW_PROJECT_Dstring
TOTAL_BENEFIT_PLANW_PROJECT_Dnumber
TOTAL_BENEFIT_PLAN_TALLYW_PROJECT_Dnumber
TOTAL_FUNDINGW_PROJECT_Dnumber
TOTAL_SPENDING_PLANW_PROJECT_Dnumber
TOTAL_SPENDING_PLAN_TALLYW_PROJECT_Dnumber
UNALLOCATED_BUDGETW_PROJECT_Dnumber
UNDISTRIBUTED_CURRENT_VARIANCEW_PROJECT_Dnumber
CUSTOM_1W_PROJECT_Dstring
CUSTOM_2W_PROJECT_Dstring
CUSTOM_3W_PROJECT_Dstring
CUSTOM_4W_PROJECT_Dstring
CUSTOM_5W_PROJECT_Dstring
W_UPDATE_DTW_PROJECT_Ddate
W_CREATE_DTW_PROJECT_Ddate
DELETE_FLAGW_PROJECT_Dstring
DATASOURCE_IDW_PROJECT_Dbigint
CODE_VALUE_01W_PROJECT_Dstring
CODE_DESCR_01W_PROJECT_Dstring
CODE_VALUE_02W_PROJECT_Dstring
CODE_DESCR_02W_PROJECT_Dstring
CODE_VALUE_03W_PROJECT_Dstring
CODE_DESCR_03W_PROJECT_Dstring
CODE_VALUE_04W_PROJECT_Dstring
CODE_DESCR_04W_PROJECT_Dstring
CODE_VALUE_05W_PROJECT_Dstring
CODE_DESCR_05W_PROJECT_Dstring
CODE_VALUE_06W_PROJECT_Dstring
CODE_DESCR_06W_PROJECT_Dstring
CODE_VALUE_07W_PROJECT_Dstring
CODE_DESCR_07W_PROJECT_Dstring
CODE_VALUE_08W_PROJECT_Dstring
CODE_DESCR_08W_PROJECT_Dstring
CODE_VALUE_09W_PROJECT_Dstring
CODE_DESCR_09W_PROJECT_Dstring
CODE_VALUE_10W_PROJECT_Dstring
CODE_DESCR_10W_PROJECT_Dstring
CODE_VALUE_11W_PROJECT_Dstring
CODE_DESCR_11W_PROJECT_Dstring
CODE_VALUE_12W_PROJECT_Dstring
CODE_DESCR_12W_PROJECT_Dstring
CODE_VALUE_13W_PROJECT_Dstring
CODE_DESCR_13W_PROJECT_Dstring
CODE_VALUE_14W_PROJECT_Dstring
CODE_DESCR_14W_PROJECT_Dstring
CODE_VALUE_15W_PROJECT_Dstring
CODE_DESCR_15W_PROJECT_Dstring
CODE_VALUE_16W_PROJECT_Dstring
CODE_DESCR_16W_PROJECT_Dstring
CODE_VALUE_17W_PROJECT_Dstring
CODE_DESCR_17W_PROJECT_Dstring
CODE_VALUE_18W_PROJECT_Dstring
CODE_DESCR_18W_PROJECT_Dstring
CODE_VALUE_19W_PROJECT_Dstring
CODE_DESCR_19W_PROJECT_Dstring
CODE_VALUE_20W_PROJECT_Dstring
CODE_DESCR_20W_PROJECT_Dstring
W_OBS_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_OBS_Dbigint
OBS_NAMEW_OBS_Dstring
OBS_OBJECT_IDW_OBS_Dinteger
CUSTOM_1W_OBS_Dstring
CUSTOM_2W_OBS_Dstring
CUSTOM_3W_OBS_Dstring
CUSTOM_4W_OBS_Dstring
CUSTOM_5W_OBS_Dstring
W_UPDATE_DTW_OBS_Ddate
W_CREATE_DTW_OBS_Ddate
DELETE_FLAGW_OBS_Dstring
DATASOURCE_IDW_OBS_Dbigint
W_WBS_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_WBS_Dbigint
WBS_OBJECT_IDW_WBS_Dbigint
PROJECT_OBJECT_IDW_WBS_Dbigint
PARENT_OBJECT_IDW_WBS_Dbigint
WBS_SHORT_NAMEW_WBS_Dstring
WBS_NAMEW_WBS_Dstring
OBS_OBJECT_IDW_WBS_Dinteger
SEQ_NUMW_WBS_Dinteger
SUM_DATA_FLAGW_WBS_Dstring
PROJECT_WBS_FLAGW_WBS_Dstring
STATUS_CODEW_WBS_Dstring
EV_USER_PCTW_WBS_Ddouble
EV_ETC_USER_VALUEW_WBS_Ddouble
ORIG_COSTW_WBS_Ddouble
INDEP_REMAIN_TOTAL_COSTW_WBS_Ddouble
INDEP_REMAIN_WORK_QTYW_WBS_Ddouble
ANTICIP_START_DATEW_WBS_Ddate
ANTICIP_END_DATEW_WBS_Ddate
EV_COMPUTE_TYPEW_WBS_Dstring
EV_ETC_COMPUTE_TYPEW_WBS_Dstring
CURRENTBUDGETW_WBS_Dnumber
CURRENTVARIANCEW_WBS_Dnumber
DISTRIBUTEDCURRENTBUDGETW_WBS_Dnumber
FINISHDATEW_WBS_Ddate
FORECASTFINISHDATEW_WBS_Ddate
FORECASTSTARTDATEW_WBS_Ddate
FULLNAMEW_WBS_Dstring
OBSNAMEW_WBS_Dstring
PROJECTIDW_WBS_Dstring
PROPOSEDBUDGETW_WBS_Dnumber
STARTDATEW_WBS_Ddate
TOTALBENEFITPLANW_WBS_Dnumber
TOTALBENEFITPLANTALLYW_WBS_Dnumber
TOTALSPENDINGPLANW_WBS_Dnumber
TOTALSPENDINGPLANTALLYW_WBS_Dnumber
UNALLOCATEDBUDGETW_WBS_Dnumber
UNDISTRIBUTEDCURRENTVARIANCEW_WBS_Dnumber
CUSTOM_1W_WBS_Dstring
CUSTOM_2W_WBS_Dstring
CUSTOM_3W_WBS_Dstring
CUSTOM_4W_WBS_Dstring
CUSTOM_5W_WBS_Dstring
W_UPDATE_DTW_WBS_Ddate
W_CREATE_DTW_WBS_Ddate
DELETE_FLAGW_WBS_Dstring
DATASOURCE_IDW_WBS_Dbigint
W_EPS_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_EPS_Dbigint
WBS_OBJECT_IDW_EPS_Dbigint
PARENT_OBJECT_IDW_EPS_Dbigint
PROJECT_OBJECT_IDW_EPS_Dbigint
WBS_SHORT_NAMEW_EPS_Dstring
WBS_NAMEW_EPS_Dstring
OBS_OBJECT_IDW_EPS_Dinteger
SEQ_NUMW_EPS_Dinteger
SUM_DATA_FLAGW_EPS_Dstring
STATUS_CODEW_EPS_Dstring
EV_USER_PCTW_EPS_Ddouble
EV_ETC_USER_VALUEW_EPS_Ddouble
ORIG_COSTW_EPS_Ddouble
INDEP_REMAIN_TOTAL_COSTW_EPS_Ddouble
INDEP_REMAIN_WORK_QTYW_EPS_Ddouble
ANTICIP_START_DATEW_EPS_Ddate
ANTICIP_END_DATEW_EPS_Ddate
EV_COMPUTE_TYPEW_EPS_Dstring
EV_ETC_COMPUTE_TYPEW_EPS_Dstring
CURRENTBUDGETW_EPS_Dnumber
CURRENTVARIANCEW_EPS_Dnumber
DISTRIBUTEDCURRENTBUDGETW_EPS_Dnumber
FINISHDATEW_EPS_Ddate
FORECASTFINISHDATEW_EPS_Ddate
FORECASTSTARTDATEW_EPS_Ddate
FULLNAMEW_EPS_Dstring
OBSNAMEW_EPS_Dstring
PROJECTIDW_EPS_Dstring
PROPOSEDBUDGETW_EPS_Dnumber
STARTDATEW_EPS_Ddate
TOTALBENEFITPLANW_EPS_Dnumber
TOTALBENEFITPLANTALLYW_EPS_Dnumber
TOTALSPENDINGPLANW_EPS_Dnumber
TOTALSPENDINGPLANTALLYW_EPS_Dnumber
UNALLOCATEDBUDGETW_EPS_Dnumber
UNDISTRIBUTEDCURRENTVARIANCEW_EPS_Dnumber
CUSTOM_1W_EPS_Dstring
CUSTOM_2W_EPS_Dstring
CUSTOM_3W_EPS_Dstring
CUSTOM_4W_EPS_Dstring
CUSTOM_5W_EPS_Dstring
W_UPDATE_DTW_EPS_Ddate
W_CREATE_DTW_EPS_Ddate
DELETE_FLAGW_EPS_Dstring
DATASOURCE_IDW_EPS_Dbigint
W_ACTIVITY_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_ACTIVITY_Dbigint
ACTIVITY_IDW_ACTIVITY_Dstring
ACTIVITY_NAMEW_ACTIVITY_Dstring
ACTIVITY_OBJECT_IDW_ACTIVITY_Dbigint
PROJECT_OBJECT_IDW_ACTIVITY_Dbigint
WBS_OBJECT_IDW_ACTIVITY_Dbigint
REVIEW_FEEDBACK_FLAGW_ACTIVITY_Dstring
AUTO_COMPUTE_ACTUALS_FLAGW_ACTIVITY_Dstring
COMPLETE_PCT_TYPEW_ACTIVITY_Dstring
ACTIVITY_TYPEW_ACTIVITY_Dstring
DURATION_TYPEW_ACTIVITY_Dstring
REVIEW_TYPEW_ACTIVITY_Dstring
ACTIVITY_STATUSW_ACTIVITY_Dstring
TOTAL_FLOATW_ACTIVITY_Ddouble
FREE_FLOATW_ACTIVITY_Ddouble
REMAINING_DURATIONW_ACTIVITY_Ddouble
PLANNED_DURATIONW_ACTIVITY_Ddouble
PRIMARY_CONSTRAINT_DATEW_ACTIVITY_Ddate
ACTUAL_START_DATEW_ACTIVITY_Ddate
ACTUAL_FINISH_DATEW_ACTIVITY_Ddate
LATE_START_DATEW_ACTIVITY_Ddate
LATE_FINISH_DATEW_ACTIVITY_Ddate
EXPECT_FINISH_DATEW_ACTIVITY_Ddate
EARLY_START_DATEW_ACTIVITY_Ddate
EARLY_FINISH_DATEW_ACTIVITY_Ddate
REMAINING_START_DATEW_ACTIVITY_Ddate
REMAINING_FINISH_DATEW_ACTIVITY_Ddate
PLANNED_START_DATEW_ACTIVITY_Ddate
PLANNED_FINISH_DATEW_ACTIVITY_Ddate
REVIEW_FINISH_DATEW_ACTIVITY_Ddate
REMAINING_LATE_START_DATEW_ACTIVITY_Ddate
REMAINING_LATE_FINISH_DATEW_ACTIVITY_Ddate
SUSPEND_DATEW_ACTIVITY_Ddate
RESUME_DATEW_ACTIVITY_Ddate
EXTERNAL_EARLY_START_DATEW_ACTIVITY_Ddate
EXTERNAL_LATE_FINISH_DATEW_ACTIVITY_Ddate
SECONDARY_CONSTRAINT_DATEW_ACTIVITY_Ddate
BASELINE_FINISH_DATEW_ACTIVITY_Ddate
BASELINE_START_DATEW_ACTIVITY_Ddate
DATA_DATEW_ACTIVITY_Ddate
FINISH_DATEW_ACTIVITY_Ddate
START_DATEW_ACTIVITY_Ddate
PRIMARY_CONSTRAINT_TYPEW_ACTIVITY_Dstring
LEVELING_PRIORITYW_ACTIVITY_Dstring
SECONDARY_CONSTRAINT_TYPEW_ACTIVITY_Dstring
FLOAT_PATHW_ACTIVITY_Dinteger
FLOAT_PATH_ORDERW_ACTIVITY_Dinteger
IS_LONGEST_PATHW_ACTIVITY_Dstring
ACTUAL_DURATIONW_ACTIVITY_Dnumber
AT_COMPLETION_DURATIONW_ACTIVITY_Dnumber
BASELINE_DURATIONW_ACTIVITY_Dnumber
BASELINE_PLANNED_DURATIONW_ACTIVITY_Dnumber
CALENDAR_NAMEW_ACTIVITY_Dstring
COST_PERFORMANCE_INDEXW_ACTIVITY_Dnumber
DURATION_1_VARIANCEW_ACTIVITY_Dnumber
DURATION_PCT_COMPLETEW_ACTIVITY_Dnumber
DURATION_PCT_OF_PLANNEDW_ACTIVITY_Dnumber
DURATION_VARIANCEW_ACTIVITY_Dnumber
EST_TO_COMPLETEW_ACTIVITY_Dnumber
EXPENSE_COST_PCT_COMPLETEW_ACTIVITY_Dnumber
FINISH_DATE_1_VARIANCEW_ACTIVITY_Dnumber
FINISH_DATE_VARIANCEW_ACTIVITY_Dnumber
IS_CRITICALW_ACTIVITY_Dstring
LABOR_UNITS_PCT_COMPLETEW_ACTIVITY_Dnumber
NONLABOR_COST_PCT_COMPLETEW_ACTIVITY_Dnumber
NONLABOR_UNITS_PCT_COMPLETEW_ACTIVITY_Dnumber
PERCENT_COMPLETEW_ACTIVITY_Dnumber
PERFORMANCE_PCT_COMPLETEW_ACTIVITY_Dnumber
PHYSICAL_PCT_COMPLETEW_ACTIVITY_Dnumber
PRIMARY_RESOURCE_NAMEW_ACTIVITY_Dstring
REMAINING_FLOATW_ACTIVITY_Dnumber
SCHEDULE_PCT_COMPLETEW_ACTIVITY_Dnumber
SCHEDULE_PERFORMANCE_INDEXW_ACTIVITY_Dnumber
SCHEDULE_VARIANCE_INDEXW_ACTIVITY_Dnumber
START_DATE_1_VARIANCEW_ACTIVITY_Dnumber
START_DATE_VARIANCEW_ACTIVITY_Dnumber
TO_COMPLETE_PERFORMANCE_INDEXW_ACTIVITY_Dnumber
UNITS_PCT_COMPLETEW_ACTIVITY_Dnumber
WBS_CODEW_ACTIVITY_Dstring
WBS_NAMEW_ACTIVITY_Dstring
PRIMARY_RESOURCE_OBJECT_IDW_ACTIVITY_Dinteger
ACTIVITY_OWNERW_ACTIVITY_Dstring
CUSTOM_1W_ACTIVITY_Dstring
CUSTOM_2W_ACTIVITY_Dstring
CUSTOM_3W_ACTIVITY_Dstring
CUSTOM_4W_ACTIVITY_Dstring
CUSTOM_5W_ACTIVITY_Dstring
W_UPDATE_DTW_ACTIVITY_Ddate
W_CREATE_DTW_ACTIVITY_Ddate
DELETE_FLAGW_ACTIVITY_Dstring
DATASOURCE_IDW_ACTIVITY_Dbigint
CODE_VALUE_01W_ACTIVITY_Dstring
CODE_DESCR_01W_ACTIVITY_Dstring
CODE_VALUE_02W_ACTIVITY_Dstring
CODE_DESCR_02W_ACTIVITY_Dstring
CODE_VALUE_03W_ACTIVITY_Dstring
CODE_DESCR_03W_ACTIVITY_Dstring
CODE_VALUE_04W_ACTIVITY_Dstring
CODE_DESCR_04W_ACTIVITY_Dstring
CODE_VALUE_05W_ACTIVITY_Dstring
CODE_DESCR_05W_ACTIVITY_Dstring
CODE_VALUE_06W_ACTIVITY_Dstring
CODE_DESCR_06W_ACTIVITY_Dstring
CODE_VALUE_07W_ACTIVITY_Dstring
CODE_DESCR_07W_ACTIVITY_Dstring
CODE_VALUE_08W_ACTIVITY_Dstring
CODE_DESCR_08W_ACTIVITY_Dstring
CODE_VALUE_09W_ACTIVITY_Dstring
CODE_DESCR_09W_ACTIVITY_Dstring
CODE_VALUE_10W_ACTIVITY_Dstring
CODE_DESCR_10W_ACTIVITY_Dstring
CODE_VALUE_11W_ACTIVITY_Dstring
CODE_DESCR_11W_ACTIVITY_Dstring
CODE_VALUE_12W_ACTIVITY_Dstring
CODE_DESCR_12W_ACTIVITY_Dstring
CODE_VALUE_13W_ACTIVITY_Dstring
CODE_DESCR_13W_ACTIVITY_Dstring
CODE_VALUE_14W_ACTIVITY_Dstring
CODE_DESCR_14W_ACTIVITY_Dstring
CODE_VALUE_15W_ACTIVITY_Dstring
CODE_DESCR_15W_ACTIVITY_Dstring
CODE_VALUE_16W_ACTIVITY_Dstring
CODE_DESCR_16W_ACTIVITY_Dstring
CODE_VALUE_17W_ACTIVITY_Dstring
CODE_DESCR_17W_ACTIVITY_Dstring
CODE_VALUE_18W_ACTIVITY_Dstring
CODE_DESCR_18W_ACTIVITY_Dstring
CODE_VALUE_19W_ACTIVITY_Dstring
CODE_DESCR_19W_ACTIVITY_Dstring
CODE_VALUE_20W_ACTIVITY_Dstring
CODE_DESCR_20W_ACTIVITY_Dstring
W_COST_ACCOUNT_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_COST_ACCOUNT_Dbigint
ACCT_SHORT_NAMEW_COST_ACCOUNT_Dstring
ACCT_NAMEW_COST_ACCOUNT_Dstring
ACCOUNT_OBJECT_IDW_COST_ACCOUNT_Dinteger
CUSTOM_1W_COST_ACCOUNT_Dstring
CUSTOM_2W_COST_ACCOUNT_Dstring
CUSTOM_3W_COST_ACCOUNT_Dstring
CUSTOM_4W_COST_ACCOUNT_Dstring
CUSTOM_5W_COST_ACCOUNT_Dstring
W_UPDATE_DTW_COST_ACCOUNT_Ddate
W_CREATE_DTW_COST_ACCOUNT_Ddate
DELETE_FLAGW_COST_ACCOUNT_Dstring
DATASOURCE_IDW_COST_ACCOUNT_Dbigint
W_ROLE_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_ROLE_Dbigint
ROLE_SHORT_NAMEW_ROLE_Dstring
ROLE_NAMEW_ROLE_Dstring
ROLE_OBJECT_IDW_ROLE_Dinteger
CUSTOM_1W_ROLE_Dstring
CUSTOM_2W_ROLE_Dstring
CUSTOM_3W_ROLE_Dstring
CUSTOM_4W_ROLE_Dstring
CUSTOM_5W_ROLE_Dstring
W_UPDATE_DTW_ROLE_Ddate
W_CREATE_DTW_ROLE_Ddate
DELETE_FLAGW_ROLE_Dstring
DATASOURCE_IDW_ROLE_Dbigint
W_RESOURCE_TEAM_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_WIDW_RESOURCE_TEAM_Dbigint
RESOURCE_TEAM_NAMEW_RESOURCE_TEAM_Dstring
RESOURCE_TEAM_DESCRW_RESOURCE_TEAM_Dstring
CUSTOM_1W_RESOURCE_TEAM_Dstring
CUSTOM_2W_RESOURCE_TEAM_Dstring
CUSTOM_3W_RESOURCE_TEAM_Dstring
CUSTOM_4W_RESOURCE_TEAM_Dstring
CUSTOM_5W_RESOURCE_TEAM_Dstring
W_UPDATE_DTW_RESOURCE_TEAM_Ddate
W_CREATE_DTW_RESOURCE_TEAM_Ddate
DELETE_FLAGW_RESOURCE_TEAM_Dstring
DATASOURCE_IDW_RESOURCE_TEAM_Dbigint
W_RESOURCE_ROLE_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_WIDW_RESOURCE_ROLE_Dbigint
ROLE_SHORT_NAMEW_RESOURCE_ROLE_Dstring
ROLE_NAMEW_RESOURCE_ROLE_Dstring
IS_PRIMARY_ROLEW_RESOURCE_ROLE_Dstring
CUSTOM_1W_RESOURCE_ROLE_Dstring
CUSTOM_2W_RESOURCE_ROLE_Dstring
CUSTOM_3W_RESOURCE_ROLE_Dstring
CUSTOM_4W_RESOURCE_ROLE_Dstring
CUSTOM_5W_RESOURCE_ROLE_Dstring
W_UPDATE_DTW_RESOURCE_ROLE_Ddate
W_CREATE_DTW_RESOURCE_ROLE_Ddate
DELETE_FLAGW_RESOURCE_ROLE_Dstring
DATASOURCE_IDW_RESOURCE_ROLE_Dbigint
W_PROJECT_PORTFOLIO_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_WIDW_PROJECT_PORTFOLIO_Dbigint
PROJECT_PORTFOLIO_NAMEW_PROJECT_PORTFOLIO_Dstring
PROJECT_PORTFOLIO_DESCRW_PROJECT_PORTFOLIO_Dstring
CUSTOM_1W_PROJECT_PORTFOLIO_Dstring
CUSTOM_2W_PROJECT_PORTFOLIO_Dstring
CUSTOM_3W_PROJECT_PORTFOLIO_Dstring
CUSTOM_4W_PROJECT_PORTFOLIO_Dstring
CUSTOM_5W_PROJECT_PORTFOLIO_Dstring
W_UPDATE_DTW_PROJECT_PORTFOLIO_Ddate
W_CREATE_DTW_PROJECT_PORTFOLIO_Ddate
DELETE_FLAGW_PROJECT_PORTFOLIO_Dstring
DATASOURCE_IDW_PROJECT_PORTFOLIO_Dbigint
W_WBS_HIERARCHY_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_WBS_HIERARCHY_Dbigint
WBS_OBJECT_IDW_WBS_HIERARCHY_Dbigint
WBS_SHORT_NAMEW_WBS_HIERARCHY_Dstring
WBS_NAMEW_WBS_HIERARCHY_Dstring
PROJ_LEVEL_SHORT_NAMEW_WBS_HIERARCHY_Dstring
PROJ_LEVEL_NAMEW_WBS_HIERARCHY_Dstring
PROJ_LEVEL_WBS_OBJECT_IDW_WBS_HIERARCHY_Dbigint
WBS_ID_LV1W_WBS_HIERARCHY_Dstring
WBS_NAME_LV1W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV1W_WBS_HIERARCHY_Dbigint
WBS_ID_LV2W_WBS_HIERARCHY_Dstring
WBS_NAME_LV2W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV2W_WBS_HIERARCHY_Dbigint
WBS_ID_LV3W_WBS_HIERARCHY_Dstring
WBS_NAME_LV3W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV3W_WBS_HIERARCHY_Dbigint
WBS_ID_LV4W_WBS_HIERARCHY_Dstring
WBS_NAME_LV4W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV4W_WBS_HIERARCHY_Dbigint
WBS_ID_LV5W_WBS_HIERARCHY_Dstring
WBS_NAME_LV5W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV5W_WBS_HIERARCHY_Dbigint
WBS_ID_LV6W_WBS_HIERARCHY_Dstring
WBS_NAME_LV6W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV6W_WBS_HIERARCHY_Dbigint
WBS_ID_LV7W_WBS_HIERARCHY_Dstring
WBS_NAME_LV7W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV7W_WBS_HIERARCHY_Dbigint
WBS_ID_LV8W_WBS_HIERARCHY_Dstring
WBS_NAME_LV8W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV8W_WBS_HIERARCHY_Dbigint
WBS_ID_LV9W_WBS_HIERARCHY_Dstring
WBS_NAME_LV9W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV9W_WBS_HIERARCHY_Dbigint
WBS_ID_LV10W_WBS_HIERARCHY_Dstring
WBS_NAME_LV10W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV10W_WBS_HIERARCHY_Dbigint
WBS_ID_LV11W_WBS_HIERARCHY_Dstring
WBS_NAME_LV11W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV11W_WBS_HIERARCHY_Dbigint
WBS_ID_LV12W_WBS_HIERARCHY_Dstring
WBS_NAME_LV12W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV12W_WBS_HIERARCHY_Dbigint
WBS_ID_LV13W_WBS_HIERARCHY_Dstring
WBS_NAME_LV13W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV13W_WBS_HIERARCHY_Dbigint
WBS_ID_LV14W_WBS_HIERARCHY_Dstring
WBS_NAME_LV14W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV14W_WBS_HIERARCHY_Dbigint
WBS_ID_LV15W_WBS_HIERARCHY_Dstring
WBS_NAME_LV15W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV15W_WBS_HIERARCHY_Dbigint
WBS_ID_LV16W_WBS_HIERARCHY_Dstring
WBS_NAME_LV16W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV16W_WBS_HIERARCHY_Dbigint
WBS_ID_LV17W_WBS_HIERARCHY_Dstring
WBS_NAME_LV17W_WBS_HIERARCHY_Dstring
WBS_OBJECT_ID_LV17W_WBS_HIERARCHY_Dbigint
CUSTOM_1W_WBS_HIERARCHY_Dstring
CUSTOM_2W_WBS_HIERARCHY_Dstring
CUSTOM_3W_WBS_HIERARCHY_Dstring
CUSTOM_4W_WBS_HIERARCHY_Dstring
CUSTOM_5W_WBS_HIERARCHY_Dstring
W_UPDATE_DTW_WBS_HIERARCHY_Ddate
W_CREATE_DTW_WBS_HIERARCHY_Ddate
DELETE_FLAGW_WBS_HIERARCHY_Dstring
DATASOURCE_IDW_WBS_HIERARCHY_Dbigint
W_WBS_HIERARCHY_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyW_WBS_HIERARCHY_DSbigint
parentobjectidW_WBS_HIERARCHY_DSinteger
parentprojectidW_WBS_HIERARCHY_DSinteger
parentsequencenumberW_WBS_HIERARCHY_DSinteger
parentnameW_WBS_HIERARCHY_DSstring
parentidW_WBS_HIERARCHY_DSstring
childobjectidW_WBS_HIERARCHY_DSinteger
childprojectidW_WBS_HIERARCHY_DSinteger
childsequencenumberW_WBS_HIERARCHY_DSinteger
childnameW_WBS_HIERARCHY_DSstring
childidW_WBS_HIERARCHY_DSstring
parentlevelsbelowrootW_WBS_HIERARCHY_DSinteger
childlevelsbelowrootW_WBS_HIERARCHY_DSinteger
levelsbetweenW_WBS_HIERARCHY_DSinteger
childhaschildrenW_WBS_HIERARCHY_DSstring
fullpathnameW_WBS_HIERARCHY_DSstring
currentprocesscycledateW_WBS_HIERARCHY_DSdate
snapshotidW_WBS_HIERARCHY_DSinteger
etlprocessW_WBS_HIERARCHY_DSdate
W_EPS_HIERARCHY_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_EPS_HIERARCHY_Dbigint
EPS_OBJECT_IDW_EPS_HIERARCHY_Dbigint
EPS_SHORT_NAMEW_EPS_HIERARCHY_Dstring
EPS_NAMEW_EPS_HIERARCHY_Dstring
ROOT_LEVEL_SHORT_NAMEW_EPS_HIERARCHY_Dstring
ROOT_LEVEL_NAMEW_EPS_HIERARCHY_Dstring
ROOT_LEVEL_EPS_OBJECT_IDW_EPS_HIERARCHY_Dbigint
EPS_ID_LV1W_EPS_HIERARCHY_Dstring
EPS_NAME_LV1W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV1W_EPS_HIERARCHY_Dbigint
EPS_ID_LV2W_EPS_HIERARCHY_Dstring
EPS_NAME_LV2W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV2W_EPS_HIERARCHY_Dbigint
EPS_ID_LV3W_EPS_HIERARCHY_Dstring
EPS_NAME_LV3W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV3W_EPS_HIERARCHY_Dbigint
EPS_ID_LV4W_EPS_HIERARCHY_Dstring
EPS_NAME_LV4W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV4W_EPS_HIERARCHY_Dbigint
EPS_ID_LV5W_EPS_HIERARCHY_Dstring
EPS_NAME_LV5W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV5W_EPS_HIERARCHY_Dbigint
EPS_ID_LV6W_EPS_HIERARCHY_Dstring
EPS_NAME_LV6W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV6W_EPS_HIERARCHY_Dbigint
EPS_ID_LV7W_EPS_HIERARCHY_Dstring
EPS_NAME_LV7W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV7W_EPS_HIERARCHY_Dbigint
EPS_ID_LV8W_EPS_HIERARCHY_Dstring
EPS_NAME_LV8W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV8W_EPS_HIERARCHY_Dbigint
EPS_ID_LV9W_EPS_HIERARCHY_Dstring
EPS_NAME_LV9W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV9W_EPS_HIERARCHY_Dbigint
EPS_ID_LV10W_EPS_HIERARCHY_Dstring
EPS_NAME_LV10W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV10W_EPS_HIERARCHY_Dbigint
EPS_ID_LV11W_EPS_HIERARCHY_Dstring
EPS_NAME_LV11W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV11W_EPS_HIERARCHY_Dbigint
EPS_ID_LV12W_EPS_HIERARCHY_Dstring
EPS_NAME_LV12W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV12W_EPS_HIERARCHY_Dbigint
EPS_ID_LV13W_EPS_HIERARCHY_Dstring
EPS_NAME_LV13W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV13W_EPS_HIERARCHY_Dbigint
EPS_ID_LV14W_EPS_HIERARCHY_Dstring
EPS_NAME_LV14W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV14W_EPS_HIERARCHY_Dbigint
EPS_ID_LV15W_EPS_HIERARCHY_Dstring
EPS_NAME_LV15W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV15W_EPS_HIERARCHY_Dbigint
EPS_ID_LV16W_EPS_HIERARCHY_Dstring
EPS_NAME_LV16W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV16W_EPS_HIERARCHY_Dbigint
EPS_ID_LV17W_EPS_HIERARCHY_Dstring
EPS_NAME_LV17W_EPS_HIERARCHY_Dstring
EPS_OBJECT_ID_LV17W_EPS_HIERARCHY_Dbigint
CUSTOM_1W_EPS_HIERARCHY_Dstring
CUSTOM_2W_EPS_HIERARCHY_Dstring
CUSTOM_3W_EPS_HIERARCHY_Dstring
CUSTOM_4W_EPS_HIERARCHY_Dstring
CUSTOM_5W_EPS_HIERARCHY_Dstring
W_UPDATE_DTW_EPS_HIERARCHY_Ddate
W_CREATE_DTW_EPS_HIERARCHY_Ddate
DELETE_FLAGW_EPS_HIERARCHY_Dstring
DATASOURCE_IDW_EPS_HIERARCHY_Dbigint
W_EPS_HIERARCHY_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ParentObjectIdW_EPS_HIERARCHY_DSinteger
ParentProjectIdW_EPS_HIERARCHY_DSinteger
ParentSequenceNumberW_EPS_HIERARCHY_DSinteger
ParentNameW_EPS_HIERARCHY_DSstring
ParentIdW_EPS_HIERARCHY_DSstring
ParentOriginalBudgetW_EPS_HIERARCHY_DSdouble
ParentIndependentETCTotalCostW_EPS_HIERARCHY_DSdouble
ParentIndependentETCLaborUnitsW_EPS_HIERARCHY_DSdouble
ParentCurrentBudgetW_EPS_HIERARCHY_DSdouble
ParentCurrentVarianceW_EPS_HIERARCHY_DSdouble
ParentDistributedCurrentBudgetW_EPS_HIERARCHY_DSdouble
ParentProposedBudgetW_EPS_HIERARCHY_DSdouble
ParentStartDateW_EPS_HIERARCHY_DSdate
ParentFinishDateW_EPS_HIERARCHY_DSdate
ParentAnticipatedStartDateW_EPS_HIERARCHY_DSdate
ParentAnticipatedFinishDateW_EPS_HIERARCHY_DSdate
ParentLastSummarizedDateW_EPS_HIERARCHY_DSdate
ParentPlannedStartDateW_EPS_HIERARCHY_DSdate
ParentOBSObjectIdW_EPS_HIERARCHY_DSinteger
ParentOBSNameW_EPS_HIERARCHY_DSstring
ChildObjectIdW_EPS_HIERARCHY_DSinteger
ChildProjectIdW_EPS_HIERARCHY_DSinteger
ChildSequenceNumberW_EPS_HIERARCHY_DSinteger
ChildNameW_EPS_HIERARCHY_DSstring
ChildIdW_EPS_HIERARCHY_DSstring
ChildOriginalBudgetW_EPS_HIERARCHY_DSdouble
ChildIndependentETCTotalCostW_EPS_HIERARCHY_DSdouble
ChildIndependentETCLaborUnitsW_EPS_HIERARCHY_DSdouble
ChildCurrentBudgetW_EPS_HIERARCHY_DSdouble
ChildCurrentVarianceW_EPS_HIERARCHY_DSdouble
ChildDistributedCurrentBudgetW_EPS_HIERARCHY_DSdouble
ChildProposedBudgetW_EPS_HIERARCHY_DSdouble
ChildStartDateW_EPS_HIERARCHY_DSdate
ChildFinishDateW_EPS_HIERARCHY_DSdate
ChildAnticipatedStartDateW_EPS_HIERARCHY_DSdate
ChildAnticipatedFinishDateW_EPS_HIERARCHY_DSdate
ChildLastSummarizedDateW_EPS_HIERARCHY_DSdate
ChildPlannedStartDateW_EPS_HIERARCHY_DSdate
ChildOBSObjectIdW_EPS_HIERARCHY_DSint
ChildOBSNameW_EPS_HIERARCHY_DSstring
ParentLevelsBelowRootW_EPS_HIERARCHY_DSinteger
ChildLevelsBelowRootW_EPS_HIERARCHY_DSinteger
LevelsBetweenW_EPS_HIERARCHY_DSinteger
ChildHasChildrenW_EPS_HIERARCHY_DSstring
FullPathNameW_EPS_HIERARCHY_DSstring
SKeyW_EPS_HIERARCHY_DSint
W_ACTIVITY_SPREAD_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_WIDW_ACTIVITY_SPREAD_Fbigint
ACTIVITY_WIDW_ACTIVITY_SPREAD_Fbigint
WBS_WIDW_ACTIVITY_SPREAD_Fbigint
OBS_WIDW_ACTIVITY_SPREAD_Fbigint
DAY_WIDW_ACTIVITY_SPREAD_Fbigint
EPS_WIDW_ACTIVITY_SPREAD_Fbigint
RESOURCE_WIDW_ACTIVITY_SPREAD_Fbigint
ACTIVITY_OBJECT_IDW_ACTIVITY_SPREAD_Fbigint
RESOURCE_OBJECT_IDW_ACTIVITY_SPREAD_Finteger
PROJECT_OBJECT_IDW_ACTIVITY_SPREAD_Finteger
WBS_OBJECT_IDW_ACTIVITY_SPREAD_Finteger
ACTUAL_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
EARNED_VALUE_COSTW_ACTIVITY_SPREAD_Fnumber
EST_AT_COMPLETION_COSTW_ACTIVITY_SPREAD_Fnumber
EST_TO_COMPLETE_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
PLANNED_VALUE_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
REMAINING_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
ACTUAL_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
ACTUAL_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
AT_COMPLETION_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
EARNED_VALUE_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
EST_AT_COMPLETION_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
EST_TO_COMPLETE_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
PLANNED_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
PLANNED_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
PLANNED_VALUE_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
REMAINING_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
REMAINING_LATE_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
REMAINING_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL_PLANNED_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL_ACTUAL_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_LABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_NONLABOR_UNITSW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_PLANNED_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_EXPENSE_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_LABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_MATERIAL_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_NONLABOR_COSTW_ACTIVITY_SPREAD_Fnumber
BL1_ACTUAL_TOTAL_COSTW_ACTIVITY_SPREAD_Fnumber
START_DATEW_ACTIVITY_SPREAD_Fdate
END_DATEW_ACTIVITY_SPREAD_Fdate
W_UPDATE_DTW_ACTIVITY_SPREAD_Fdate
W_CREATE_DTW_ACTIVITY_SPREAD_Fdate
DELETE_FLAGW_ACTIVITY_SPREAD_Fstring
DATASOURCE_IDW_ACTIVITY_SPREAD_Fbigint
CHANGE_SKEYW_ACTIVITY_SPREAD_Fbigint
W_PROJECT_HISTORY_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_WIDW_PROJECT_HISTORY_Fbigint
DAY_WIDW_PROJECT_HISTORY_Fbigint
EPS_WIDW_PROJECT_HISTORY_Fbigint
PROJECT_OBJECT_IDW_PROJECT_HISTORY_Finteger
ACTUAL_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_LABOR_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_LABOR_COSTW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_COSTW_PROJECT_HISTORY_Fnumber
EST_AT_COMPLETION_COSTW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_LABOR_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
PLANNED_VALUE_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
EST_AT_COMPLETION_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
PLANNED_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
PLANNED_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
BL_PLANNED_LABOR_COSTW_PROJECT_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
BL_PLANNED_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_LABOR_COSTW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_LABOR_COSTW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
BL1_PLANNED_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_LABOR_COSTW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
BL1_ACTUAL_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
W_UPDATE_DTW_PROJECT_HISTORY_Fdate
W_CREATE_DTW_PROJECT_HISTORY_Fdate
DELETE_FLAGW_PROJECT_HISTORY_Fstring
DATASOURCE_IDW_PROJECT_HISTORY_Fbigint
W_RESOURCE_LIMIT_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_WIDW_RESOURCE_LIMIT_Fbigint
DAY_WIDW_RESOURCE_LIMIT_Fbigint
RESOURCE_OBJECT_IDW_RESOURCE_LIMIT_Fint
DAY_DTW_RESOURCE_LIMIT_Fdate
PLANNED_UNITSW_RESOURCE_LIMIT_Fnumber
ACTUAL_UNITSW_RESOURCE_LIMIT_Fnumber
REMAINING_UNITSW_RESOURCE_LIMIT_Fnumber
LIMITW_RESOURCE_LIMIT_Fnumber
AVAILABLE_UNITSW_RESOURCE_LIMIT_Fnumber
W_UPDATE_DTW_RESOURCE_LIMIT_Fdate
W_CREATE_DTW_RESOURCE_LIMIT_Fdate
DELETE_FLAGW_RESOURCE_LIMIT_Fstring
DATASOURCE_IDW_RESOURCE_LIMIT_Fbigint
CHANGE_SKEYW_RESOURCE_LIMIT_Fbigint
W_RESOURCE_LIMIT_SUM_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_WIDW_RESOURCE_LIMIT_SUM_Fbigint
DAY_WIDW_RESOURCE_LIMIT_SUM_Fbigint
RESOURCE_OBJECT_IDW_RESOURCE_LIMIT_SUM_Fint
DAY_DTW_RESOURCE_LIMIT_SUM_Fdate
PLANNED_UNITSW_RESOURCE_LIMIT_SUM_Fnumber
ACTUAL_UNITSW_RESOURCE_LIMIT_SUM_Fnumber
REMAINING_UNITSW_RESOURCE_LIMIT_SUM_Fnumber
LIMITW_RESOURCE_LIMIT_SUM_Fnumber
AVAILABLE_UNITSW_RESOURCE_LIMIT_SUM_Fnumber
W_UPDATE_DTW_RESOURCE_LIMIT_SUM_Fdate
W_CREATE_DTW_RESOURCE_LIMIT_SUM_Fdate
DELETE_FLAGW_RESOURCE_LIMIT_SUM_Fstring
DATASOURCE_IDW_RESOURCE_LIMIT_SUM_Fbigint
W_RESOURCE_ASSIGNMENT_SPREAD_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
ROLE_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
PROJECT_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
ACTIVITY_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
WBS_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
EPS_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
DAY_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
COST_ACCOUNT_WIDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
RESOURCE_ASSIGNMENT_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
START_DATEW_RESOURCE_ASSIGNMENT_SPREAD_Fdate
END_DATEW_RESOURCE_ASSIGNMENT_SPREAD_Fdate
RESOURCE_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
ROLE_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
ACTIVITY_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
WBS_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
PROJECT_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
COST_ACCOUNT_OBJECT_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fint
ACTUAL_REGULAR_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
ACTUAL_OVERTIME_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
ACTUAL_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
AT_COMPLETION_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
PLANNED_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
REMAINING_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
REMAINING_LATE_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
STAFFED_REMAINING_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
STAFFED_REMAINING_LATE_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
UNSTAFFED_REMAINING_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
UNSTAFFED_REMAINING_LATE_UNITSW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
ACTUAL_REGULAR_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
ACTUAL_OVERTIME_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
ACTUAL_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
AT_COMPLETION_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
PLANNED_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
REMAINING_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
REMAINING_LATE_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
STAFFED_REMAINING_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
STAFFED_REMAINING_LATE_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
UNSTAFFED_REMAINING_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
UNSTAFFED_REMAINING_LATE_COSTW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
CAPACITYW_RESOURCE_ASSIGNMENT_SPREAD_Fnumber
W_UPDATE_DTW_RESOURCE_ASSIGNMENT_SPREAD_Fdate
W_CREATE_DTW_RESOURCE_ASSIGNMENT_SPREAD_Fdate
DELETE_FLAGW_RESOURCE_ASSIGNMENT_SPREAD_Fstring
DATASOURCE_IDW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
CHANGE_SKEYW_RESOURCE_ASSIGNMENT_SPREAD_Fbigint
W_ACTIVITY_SPREAD_FSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ActivityObjectIdW_ACTIVITY_SPREAD_FSint
StartDateW_ACTIVITY_SPREAD_FSdate
EndDateW_ACTIVITY_SPREAD_FSdate
ActivityCodeW_ACTIVITY_SPREAD_FSstring
ActivityNameW_ACTIVITY_SPREAD_FSstring
WBSObjectIdW_ACTIVITY_SPREAD_FSint
ProjectObjectIdW_ACTIVITY_SPREAD_FSint
ActualLaborUnitsW_ACTIVITY_SPREAD_FSnumber
ActualNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
AtCompletionLaborUnitsW_ACTIVITY_SPREAD_FSnumber
AtCompletionNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
BaselineActualLaborUnitsW_ACTIVITY_SPREAD_FSnumber
BaselineActualNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedLaborUnitsW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualLaborUnitsW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedLaborUnitsW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
EarnedValueLaborUnitsW_ACTIVITY_SPREAD_FSnumber
EstimateAtCompletionLaborUnitsW_ACTIVITY_SPREAD_FSnumber
EstimateToCompleteLaborUnitsW_ACTIVITY_SPREAD_FSnumber
PlannedLaborUnitsW_ACTIVITY_SPREAD_FSnumber
PlannedNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
PlannedValueLaborUnitsW_ACTIVITY_SPREAD_FSnumber
RemainingLaborUnitsW_ACTIVITY_SPREAD_FSnumber
RemainingLateLaborUnitsW_ACTIVITY_SPREAD_FSnumber
RemainingLateNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
RemainingNonLaborUnitsW_ACTIVITY_SPREAD_FSnumber
ActualCostW_ACTIVITY_SPREAD_FSnumber
ActualExpenseCostW_ACTIVITY_SPREAD_FSnumber
ActualLaborCostW_ACTIVITY_SPREAD_FSnumber
ActualMaterialCostW_ACTIVITY_SPREAD_FSnumber
ActualNonLaborCostW_ACTIVITY_SPREAD_FSnumber
ActualTotalCostW_ACTIVITY_SPREAD_FSnumber
AtCompletionExpenseCostW_ACTIVITY_SPREAD_FSnumber
AtCompletionLaborCostW_ACTIVITY_SPREAD_FSnumber
AtCompletionMaterialCostW_ACTIVITY_SPREAD_FSnumber
AtCompletionNonLaborCostW_ACTIVITY_SPREAD_FSnumber
AtCompletionTotalCostW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedExpenseCostW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedLaborCostW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedMaterialCostW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedNonLaborCostW_ACTIVITY_SPREAD_FSnumber
BaselinePlannedTotalCostW_ACTIVITY_SPREAD_FSnumber
BaselineActualExpenseCostW_ACTIVITY_SPREAD_FSnumber
BaselineActualLaborCostW_ACTIVITY_SPREAD_FSnumber
BaselineActualMaterialCostW_ACTIVITY_SPREAD_FSnumber
BaselineActualNonLaborCostW_ACTIVITY_SPREAD_FSnumber
BaselineActualTotalCostW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualExpenseCostW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualLaborCostW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualMaterialCostW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualNonLaborCostW_ACTIVITY_SPREAD_FSnumber
Baseline1ActualTotalCostW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedExpenseCostW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedLaborCostW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedMaterialCostW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedNonLaborCostW_ACTIVITY_SPREAD_FSnumber
Baseline1PlannedTotalCostW_ACTIVITY_SPREAD_FSnumber
EarnedValueCostW_ACTIVITY_SPREAD_FSnumber
EstimateAtCompletionCostW_ACTIVITY_SPREAD_FSnumber
EstimateToCompleteCostW_ACTIVITY_SPREAD_FSnumber
PlannedExpenseCostW_ACTIVITY_SPREAD_FSnumber
PlannedLaborCostW_ACTIVITY_SPREAD_FSnumber
PlannedMaterialCostW_ACTIVITY_SPREAD_FSnumber
PlannedNonLaborCostW_ACTIVITY_SPREAD_FSnumber
PlannedTotalCostW_ACTIVITY_SPREAD_FSnumber
PlannedValueCostW_ACTIVITY_SPREAD_FSnumber
RemainingExpenseCostW_ACTIVITY_SPREAD_FSnumber
RemainingLaborCostW_ACTIVITY_SPREAD_FSnumber
RemainingLateExpenseCostW_ACTIVITY_SPREAD_FSnumber
RemainingLateLaborCostW_ACTIVITY_SPREAD_FSnumber
RemainingLateMaterialCostW_ACTIVITY_SPREAD_FSnumber
RemainingLateNonLaborCostW_ACTIVITY_SPREAD_FSnumber
RemainingLateTotalCostW_ACTIVITY_SPREAD_FSnumber
RemainingMaterialCostW_ACTIVITY_SPREAD_FSnumber
RemainingNonLaborCostW_ACTIVITY_SPREAD_FSnumber
RemainingTotalCostW_ACTIVITY_SPREAD_FSnumber
change_skeyW_ACTIVITY_SPREAD_FSnumber
W_RESOURCE_ASSIGNMENT_SPRD_FSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ResourceAssignmentObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
StartDateW_RESOURCE_ASSIGNMENT_SPRD_FSdate
EndDateW_RESOURCE_ASSIGNMENT_SPRD_FSdate
ResourceObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
RoleObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
ActivityObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
WBSObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
ProjectObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
CostAccountObjectIdW_RESOURCE_ASSIGNMENT_SPRD_FSint
ActualRegularUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
ActualOvertimeUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
ActualUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
AtCompletionUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
PlannedUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
RemainingUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
RemainingLateUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
StaffedRemainingUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
StaffedRemainingLateUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
UnstaffedRemainingUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
UnstaffedRemainingLateUnitsW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
ActualRegularCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
ActualOvertimeCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
ActualCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
AtCompletionCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
PlannedCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
RemainingCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
RemainingLateCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
StaffedRemainingCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
StaffedRemainingLateCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
UnstaffedRemainingCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
UnstaffedRemainingLateCostW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
change_skeyW_RESOURCE_ASSIGNMENT_SPRD_FSnumber
W_USER_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_USER_Sbigint
USER_NAMEW_USER_Sstring
PROJECT_SEC_KEYW_USER_Sbigint
RESOURCE_SEC_KEYW_USER_Sbigint
USER_OBJECT_IDW_USER_Sbigint
DATASOURCE_IDW_USER_Sbigint
W_OBI_EVENT_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
UPDATE_TYPEW_OBI_EVENT_Sint
UPDATE_TIMEW_OBI_EVENT_Sdate
DB_NAMEW_OBI_EVENT_Sstring
CATALOG_NAMEW_OBI_EVENT_Sstring
SCHEMA_NAMEW_OBI_EVENT_Sstring
TABLE_NAMEW_OBI_EVENT_Sstring
OTHERW_OBI_EVENT_Sstring
W_PROJECT_SECURITY_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_SEC_KEYW_PROJECT_SECURITY_Sbigint
SECURITY_TYPEW_PROJECT_SECURITY_Sstring
COST_FLAGW_PROJECT_SECURITY_Sstring
PROJECT_WIDW_PROJECT_SECURITY_Sbigint
PROJECT_OBJECT_IDW_PROJECT_SECURITY_Sbigint
DATASOURCE_IDW_PROJECT_SECURITY_Sbigint
W_RESOURCE_SECURITY_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_SEC_KEYW_RESOURCE_SECURITY_Sbigint
SECURITY_TYPEW_RESOURCE_SECURITY_Sstring
RESOURCE_WIDW_RESOURCE_SECURITY_Sbigint
RESOURCE_OBJECT_IDW_RESOURCE_SECURITY_Sbigint
DATASOURCE_IDW_RESOURCE_SECURITY_Sbigint
W_CODE_ASSIGNMENTS_ACTV_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
TASK_IDW_CODE_ASSIGNMENTS_ACTV_Sint
CODE_VALUE_01W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_01W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_02W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_02W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_03W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_03W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_04W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_04W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_05W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_05W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_06W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_06W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_07W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_07W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_08W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_08W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_09W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_09W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_10W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_10W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_11W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_11W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_12W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_12W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_13W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_13W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_14W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_14W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_15W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_15W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_16W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_16W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_17W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_17W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_18W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_18W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_19W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_19W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_VALUE_20W_CODE_ASSIGNMENTS_ACTV_Sstring
CODE_DESCR_20W_CODE_ASSIGNMENTS_ACTV_Sstring
W_CODE_ASSIGNMENTS_PROJ_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJ_IDW_CODE_ASSIGNMENTS_PROJ_Sint
CODE_VALUE_01W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_01W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_02W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_02W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_03W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_03W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_04W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_04W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_05W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_05W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_06W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_06W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_07W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_07W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_08W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_08W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_09W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_09W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_10W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_10W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_11W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_11W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_12W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_12W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_13W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_13W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_14W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_14W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_15W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_15W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_16W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_16W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_17W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_17W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_18W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_18W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_19W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_19W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_VALUE_20W_CODE_ASSIGNMENTS_PROJ_Sstring
CODE_DESCR_20W_CODE_ASSIGNMENTS_PROJ_Sstring
W_CODE_ASSIGNMENTS_RSRC_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RSRC_IDW_CODE_ASSIGNMENTS_RSRC_Sint
CODE_VALUE_01W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_01W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_02W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_02W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_03W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_03W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_04W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_04W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_05W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_05W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_06W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_06W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_07W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_07W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_08W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_08W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_09W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_09W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_10W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_10W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_11W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_11W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_12W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_12W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_13W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_13W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_14W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_14W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_15W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_15W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_16W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_16W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_17W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_17W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_18W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_18W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_19W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_19W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_VALUE_20W_CODE_ASSIGNMENTS_RSRC_Sstring
CODE_DESCR_20W_CODE_ASSIGNMENTS_RSRC_Sstring
W_XLAT_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
LANG_IDW_XLAT_Sstring
DISPLAY_NAMEW_XLAT_Sstring
TRANSLATION_NAMEW_XLAT_Sstring
DYNAMIC_CODE_FLAGW_XLAT_Sstring
W_RESOURCE_RATE_FSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ResourceObjectIdW_RESOURCE_RATE_FSbigint
StartDateW_RESOURCE_RATE_FSdate
EndDateW_RESOURCE_RATE_FSdate
MaxUnitsPerTimeW_RESOURCE_RATE_FSnumber
etl_process_dateW_RESOURCE_RATE_FSdate
W_RESOURCE_LIMIT_FSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ResourceObjectIdW_RESOURCE_LIMIT_FSbigint
DayDateW_RESOURCE_LIMIT_FSdate
TotalWorkHoursW_RESOURCE_LIMIT_FSnumber
MaxUnitsPerTimeW_RESOURCE_LIMIT_FSnumber
STG_RESOURCELIMITTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ResourceObjectIdSTG_RESOURCELIMITbigint
DayDateSTG_RESOURCELIMITdate
TotalWorkHoursSTG_RESOURCELIMITnumber
MaxUnitsPerTimeSTG_RESOURCELIMITnumber
STG_RESOURCERATETop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ResourceObjectIdSTG_RESOURCERATEbigint
StartDateSTG_RESOURCERATEdate
MaxUnitsPerTimeSTG_RESOURCERATEnumber
W_CALENDAR_FSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_CALENDAR_FSintegerCalendar - ObjectId maps to CALENDAR.clndr_id
isdefaultW_CALENDAR_FSstringCalendar - IsDefault maps to CALENDAR.default_flag
nameW_CALENDAR_FSstringCalendar - Name maps to CALENDAR.clndr_name
projectobjectidW_CALENDAR_FSintegerCalendar - ProjectObjectId maps to CALENDAR.proj_id
basecalendarobjectidW_CALENDAR_FSintegerCalendar - BaseCalendarObjectId maps to CALENDAR.base_clndr_id
lastchangedateW_CALENDAR_FSdateCalendar - lastchangedate maps to PSTG_CALENDARFULL.lastchangedate
typeW_CALENDAR_FSstringCalendar - Type maps to CALENDAR.clndr_type
daydateW_CALENDAR_FSdateCalendar - daydate maps to PSTG_CALENDARFULL.daydate
WeekdayNumberW_CALENDAR_FSintegerCalendar - WeekdayNumber maps to PSTG_CALENDARFULL.WeekdayNumber
WorkDayFlagW_CALENDAR_FSstring
TotalWorkHoursW_CALENDAR_FSdouble
WorkHoursByHalfHourW_CALENDAR_FSstring
WorkDayStartTimeW_CALENDAR_FSdateCalendar - WorkDayStartTime maps to PSTG_CALENDARFULL.WorkDayStartTime
WorkDayFinishTimeW_CALENDAR_FSdateCalendar - WorkDayFinishTime maps to PSTG_CALENDARFULL.WorkDayFinishTime
isbaselineW_CALENDAR_FSstringCalendar - IsBaseline maps to CALENDAR.IsBaseline
skeyW_CALENDAR_FSidentitySKey generated key on Calendar
TMP_RSRC_LIMITTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_OBJECT_IDbigint
START_DATEdate
PLANNEDUNITS_Tdouble
ACTUALUNITS_Tdouble
REMAININGUNITS_Tdouble