Field Map for Primavera Enterprise Reporting

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

ETL_ACTV_CODE_MAPTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_ACTV_CODE_MAPint
proj_idETL_ACTV_CODE_MAPint
actv_code_type_idETL_ACTV_CODE_MAPint
ETL_ACTV_CODE_MAP_OPTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_ACTV_CODE_MAP_OPTint
scope_levelETL_ACTV_CODE_MAP_OPTstring
reg_exp_patternETL_ACTV_CODE_MAP_OPTstring
display_nameETL_ACTV_CODE_MAP_OPTstring
display_descrETL_ACTV_CODE_MAP_OPTstring
code_value_full_path_flagETL_ACTV_CODE_MAP_OPTstring
ETL_ACTV_CODE_VERTICALTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
task_idETL_ACTV_CODE_VERTICALint
proj_idETL_ACTV_CODE_VERTICALint
code_idETL_ACTV_CODE_VERTICALint
code_valueETL_ACTV_CODE_VERTICALstring
code_descrETL_ACTV_CODE_VERTICALstring
ETL_MAPPINGTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
source_versionETL_MAPPINGinteger
table_nameETL_MAPPINGstring
target_columnETL_MAPPINGstring
source_tableETL_MAPPINGstring
source_columnETL_MAPPINGstring
column_positionETL_MAPPINGinteger
ETL_PARAMETERTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
p_featureETL_PARAMETERstringETL_PARAMETER.p_feature
p_1ETL_PARAMETERstringETL_PARAMETER.p_1
p_2ETL_PARAMETERstringETL_PARAMETER.p_2
p_3ETL_PARAMETERstringETL_PARAMETER.p_3
p_4ETL_PARAMETERstringETL_PARAMETER.p_4
p_5ETL_PARAMETERstringETL_PARAMETER.p_5
ETL_PERF_PUBLIC_VARSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
step_nbrETL_PERF_PUBLIC_VARSinteger
step_cntETL_PERF_PUBLIC_VARSinteger
part_nbrETL_PERF_PUBLIC_VARSinteger
part_cntETL_PERF_PUBLIC_VARSinteger
action_nameETL_PERF_PUBLIC_VARSstring
process_nameETL_PERF_PUBLIC_VARSstring
step_nameETL_PERF_PUBLIC_VARSstring
step_descETL_PERF_PUBLIC_VARSstring
file_nameETL_PERF_PUBLIC_VARSstring
ETL_PERF_RAW_DETAILTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
processidETL_PERF_RAW_DETAILdouble
step_nbrETL_PERF_RAW_DETAILinteger
step_cntETL_PERF_RAW_DETAILinteger
part_nbrETL_PERF_RAW_DETAILinteger
part_cntETL_PERF_RAW_DETAILinteger
action_nameETL_PERF_RAW_DETAILstring
process_nameETL_PERF_RAW_DETAILstring
step_nameETL_PERF_RAW_DETAILstring
step_descETL_PERF_RAW_DETAILstring
file_nameETL_PERF_RAW_DETAILstring
stmt_name_1ETL_PERF_RAW_DETAILstring
stmt_name_2ETL_PERF_RAW_DETAILstring
stmt_name_3ETL_PERF_RAW_DETAILstring
stmt_name_4ETL_PERF_RAW_DETAILstring
start_timeETL_PERF_RAW_DETAILtimestamp
end_timeETL_PERF_RAW_DETAILtimestamp
rows_processedETL_PERF_RAW_DETAILinteger
elapsedETL_PERF_RAW_DETAILnumber
ETL_PROCESSEXCEPTIONTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
processidETL_PROCESSEXCEPTIONdoubleETL_PROCESSEXCEPTION.processid
exceptiondateETL_PROCESSEXCEPTIONdateETL_PROCESSEXCEPTION.exceptiondate
processnameETL_PROCESSEXCEPTIONstringETL_PROCESSEXCEPTION.processname
exceptiondescriptionETL_PROCESSEXCEPTIONstringETL_PROCESSEXCEPTION.exceptiondescription
exceptionlevelETL_PROCESSEXCEPTIONintegerETL_PROCESSEXCEPTION.exceptionlevel
pmdbtablenameETL_PROCESSEXCEPTIONstringETL_PROCESSEXCEPTION.pmdbtablename
odstablenameETL_PROCESSEXCEPTIONstringETL_PROCESSEXCEPTION.odstablename
pkeyETL_PROCESSEXCEPTIONstringETL_PROCESSEXCEPTION.pkey
projectidETL_PROCESSEXCEPTIONintegerETL_PROCESSEXCEPTION.projectid
ETL_PROCESSINFOTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
processidETL_PROCESSINFOdoubleETL_PROCESSINFO.processid
infodateETL_PROCESSINFOdateETL_PROCESSINFO.infodate
processnameETL_PROCESSINFOstringETL_PROCESSINFO.processname
infomsgETL_PROCESSINFOstringETL_PROCESSINFO.infomsg
infotypeETL_PROCESSINFOstringETL_PROCESSINFO.infotype
tablenameETL_PROCESSINFOstringETL_PROCESSINFO.tablename
rows_processedETL_PROCESSINFOintegerETL_PROCESSINFO.rows
ETL_PROCESSMASTERTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
processidETL_PROCESSMASTERdoubleETL_PROCESSMASTER.processid
processstartdateETL_PROCESSMASTERdateETL_PROCESSMASTER.processstartdate
processenddateETL_PROCESSMASTERdateETL_PROCESSMASTER.processenddate
processtypeETL_PROCESSMASTERstringETL_PROCESSMASTER.processtype
ETL_PROJ_CODE_MAPTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_PROJ_CODE_MAPint
proj_catg_type_idETL_PROJ_CODE_MAPint
ETL_PROJ_CODE_MAP_OPTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_PROJ_CODE_MAP_OPTint
reg_exp_patternETL_PROJ_CODE_MAP_OPTstring
display_nameETL_PROJ_CODE_MAP_OPTstring
display_descrETL_PROJ_CODE_MAP_OPTstring
code_value_full_path_flagETL_PROJ_CODE_MAP_OPTstring
ETL_PROJ_CODE_VERTICALTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
proj_idETL_PROJ_CODE_VERTICALint
code_idETL_PROJ_CODE_VERTICALint
code_valueETL_PROJ_CODE_VERTICALstring
code_descrETL_PROJ_CODE_VERTICALstring
ETL_PROJECTLISTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidETL_PROJECTLISTinteger
ETL_RSRC_CODE_MAPTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_RSRC_CODE_MAPint
rsrc_catg_type_idETL_RSRC_CODE_MAPint
ETL_RSRC_CODE_MAP_OPTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
code_idETL_RSRC_CODE_MAP_OPTint
reg_exp_patternETL_RSRC_CODE_MAP_OPTstring
display_nameETL_RSRC_CODE_MAP_OPTstring
display_descrETL_RSRC_CODE_MAP_OPTstring
code_value_full_path_flagETL_RSRC_CODE_MAP_OPTstring
ETL_RSRC_CODE_VERTICALTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
rsrc_idETL_RSRC_CODE_VERTICALint
code_idETL_RSRC_CODE_VERTICALint
code_valueETL_RSRC_CODE_VERTICALstring
code_descrETL_RSRC_CODE_VERTICALstring
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_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
ACTUAL_LABOR_UNITSW_ACTIVITY_Dnumber
ACTUAL_NONLABOR_UNITSW_ACTIVITY_Dnumber
AT_COMPLETION_LABOR_UNITSW_ACTIVITY_Dnumber
AT_COMPLETION_NONLABOR_UNITSW_ACTIVITY_Dnumber
EARNED_VALUE_LABOR_UNITSW_ACTIVITY_Dnumber
EST_AT_COMPLETION_LABOR_UNITSW_ACTIVITY_Dnumber
EST_TO_COMPLETE_LABOR_UNITSW_ACTIVITY_Dnumber
PLANNED_LABOR_UNITSW_ACTIVITY_Dnumber
PLANNED_NONLABOR_UNITSW_ACTIVITY_Dnumber
PLANNED_VALUE_LABOR_UNITSW_ACTIVITY_Dnumber
REMAINING_LABOR_UNITSW_ACTIVITY_Dnumber
REMAINING_NONLABOR_UNITSW_ACTIVITY_Dnumber
BL_PLANNED_LABOR_UNITSW_ACTIVITY_Dnumber
BL_PLANNED_NONLABOR_UNITSW_ACTIVITY_Dnumber
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
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
ACTUAL_COSTW_ACTIVITY_Dnumber
ACTUAL_EXPENSE_COSTW_ACTIVITY_Dnumber
ACTUAL_LABOR_COSTW_ACTIVITY_Dnumber
ACTUAL_MATERIAL_COSTW_ACTIVITY_Dnumber
ACTUAL_NONLABOR_COSTW_ACTIVITY_Dnumber
ACTUAL_TOTAL_COSTW_ACTIVITY_Dnumber
AT_COMPLETION_EXPENSE_COSTW_ACTIVITY_Dnumber
AT_COMPLETION_LABOR_COSTW_ACTIVITY_Dnumber
AT_COMPLETION_MATERIAL_COSTW_ACTIVITY_Dnumber
AT_COMPLETION_NONLABOR_COSTW_ACTIVITY_Dnumber
AT_COMPLETION_TOTAL_COSTW_ACTIVITY_Dnumber
EARNED_VALUE_COSTW_ACTIVITY_Dnumber
EST_AT_COMPLETION_COSTW_ACTIVITY_Dnumber
EST_TO_COMPLETE_COSTW_ACTIVITY_Dnumber
PLANNED_EXPENSE_COSTW_ACTIVITY_Dnumber
PLANNED_LABOR_COSTW_ACTIVITY_Dnumber
PLANNED_MATERIAL_COSTW_ACTIVITY_Dnumber
PLANNED_NONLABOR_COSTW_ACTIVITY_Dnumber
PLANNED_TOTAL_COSTW_ACTIVITY_Dnumber
PLANNED_VALUE_COSTW_ACTIVITY_Dnumber
REMAINING_EXPENSE_COSTW_ACTIVITY_Dnumber
REMAINING_LABOR_COSTW_ACTIVITY_Dnumber
REMAINING_MATERIAL_COSTW_ACTIVITY_Dnumber
REMAINING_NONLABOR_COSTW_ACTIVITY_Dnumber
REMAINING_TOTAL_COSTW_ACTIVITY_Dnumber
BL_PLANNED_EXPENSE_COSTW_ACTIVITY_Dnumber
BL_PLANNED_LABOR_COSTW_ACTIVITY_Dnumber
BL_PLANNED_MATERIAL_COSTW_ACTIVITY_Dnumber
BL_PLANNED_NONLABOR_COSTW_ACTIVITY_Dnumber
BL_PLANNED_TOTAL_COSTW_ACTIVITY_Dnumber
LOCATION_IDW_ACTIVITY_Dbigint
LOCATION_NAMEW_ACTIVITY_Dstring
LOCATION_TYPEW_ACTIVITY_Dstring
ADDRESS_LINE1W_ACTIVITY_Dstring
ADDRESS_LINE2W_ACTIVITY_Dstring
ADDRESS_LINE3W_ACTIVITY_Dstring
CITY_NAMEW_ACTIVITY_Dstring
MUNICIPALITY_NAMEW_ACTIVITY_Dstring
STATE_NAMEW_ACTIVITY_Dstring
STATE_CODEW_ACTIVITY_Dstring
COUNTRY_NAMEW_ACTIVITY_Dstring
COUNTRY_CODEW_ACTIVITY_Dstring
POSTAL_CODEW_ACTIVITY_Dstring
LONGITUDEW_ACTIVITY_Dnumber
LATITUDEW_ACTIVITY_Dnumber
W_ACTIVITY_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACTIVITY_IDW_ACTIVITY_DSstring
ACTIVITY_NAMEW_ACTIVITY_DSstring
ACTIVITY_OBJECT_IDW_ACTIVITY_DSbigint
PROJECT_OBJECT_IDW_ACTIVITY_DSbigint
WBS_OBJECT_IDW_ACTIVITY_DSbigint
ACTUAL_LABOR_UNITSW_ACTIVITY_DSnumber
ACTUAL_NONLABOR_UNITSW_ACTIVITY_DSnumber
AT_COMPLETION_LABOR_UNITSW_ACTIVITY_DSnumber
AT_COMPLETION_NONLABOR_UNITSW_ACTIVITY_DSnumber
EARNED_VALUE_LABOR_UNITSW_ACTIVITY_DSnumber
EST_AT_COMPLETION_LABOR_UNITSW_ACTIVITY_DSnumber
EST_TO_COMPLETE_LABOR_UNITSW_ACTIVITY_DSnumber
PLANNED_LABOR_UNITSW_ACTIVITY_DSnumber
PLANNED_NONLABOR_UNITSW_ACTIVITY_DSnumber
PLANNED_VALUE_LABOR_UNITSW_ACTIVITY_DSnumber
REMAINING_LABOR_UNITSW_ACTIVITY_DSnumber
REMAINING_NONLABOR_UNITSW_ACTIVITY_DSnumber
BL_PLANNED_LABOR_UNITSW_ACTIVITY_DSnumber
BL_PLANNED_NONLABOR_UNITSW_ACTIVITY_DSnumber
ACTUAL_COSTW_ACTIVITY_DSnumber
ACTUAL_EXPENSE_COSTW_ACTIVITY_DSnumber
ACTUAL_LABOR_COSTW_ACTIVITY_DSnumber
ACTUAL_MATERIAL_COSTW_ACTIVITY_DSnumber
ACTUAL_NONLABOR_COSTW_ACTIVITY_DSnumber
ACTUAL_TOTAL_COSTW_ACTIVITY_DSnumber
AT_COMPLETION_EXPENSE_COSTW_ACTIVITY_DSnumber
AT_COMPLETION_LABOR_COSTW_ACTIVITY_DSnumber
AT_COMPLETION_MATERIAL_COSTW_ACTIVITY_DSnumber
AT_COMPLETION_NONLABOR_COSTW_ACTIVITY_DSnumber
AT_COMPLETION_TOTAL_COSTW_ACTIVITY_DSnumber
EARNED_VALUE_COSTW_ACTIVITY_DSnumber
EST_AT_COMPLETION_COSTW_ACTIVITY_DSnumber
PLANNED_EXPENSE_COSTW_ACTIVITY_DSnumber
PLANNED_LABOR_COSTW_ACTIVITY_DSnumber
PLANNED_MATERIAL_COSTW_ACTIVITY_DSnumber
PLANNED_NONLABOR_COSTW_ACTIVITY_DSnumber
PLANNED_TOTAL_COSTW_ACTIVITY_DSnumber
PLANNED_VALUE_COSTW_ACTIVITY_DSnumber
REMAINING_EXPENSE_COSTW_ACTIVITY_DSnumber
REMAINING_LABOR_COSTW_ACTIVITY_DSnumber
REMAINING_MATERIAL_COSTW_ACTIVITY_DSnumber
REMAINING_NONLABOR_COSTW_ACTIVITY_DSnumber
REMAINING_TOTAL_COSTW_ACTIVITY_DSnumber
BL_PLANNED_EXPENSE_COSTW_ACTIVITY_DSnumber
BL_PLANNED_LABOR_COSTW_ACTIVITY_DSnumber
BL_PLANNED_MATERIAL_COSTW_ACTIVITY_DSnumber
BL_PLANNED_NONLABOR_COSTW_ACTIVITY_DSnumber
BL_PLANNED_TOTAL_COSTW_ACTIVITY_DSnumber
REVIEW_FEEDBACK_FLAGW_ACTIVITY_DSstring
AUTO_COMPUTE_ACTUALS_FLAGW_ACTIVITY_DSstring
COMPLETE_PCT_TYPEW_ACTIVITY_DSstring
ACTIVITY_TYPEW_ACTIVITY_DSstring
DURATION_TYPEW_ACTIVITY_DSstring
REVIEW_TYPEW_ACTIVITY_DSstring
ACTIVITY_STATUSW_ACTIVITY_DSstring
TOTAL_FLOATW_ACTIVITY_DSdouble
FREE_FLOATW_ACTIVITY_DSdouble
REMAINING_DURATIONW_ACTIVITY_DSdouble
PLANNED_DURATIONW_ACTIVITY_DSdouble
PRIMARY_CONSTRAINT_DATEW_ACTIVITY_DSdate
ACTUAL_START_DATEW_ACTIVITY_DSdate
ACTUAL_FINISH_DATEW_ACTIVITY_DSdate
LATE_START_DATEW_ACTIVITY_DSdate
LATE_FINISH_DATEW_ACTIVITY_DSdate
EXPECT_FINISH_DATEW_ACTIVITY_DSdate
EARLY_START_DATEW_ACTIVITY_DSdate
EARLY_FINISH_DATEW_ACTIVITY_DSdate
REMAINING_START_DATEW_ACTIVITY_DSdate
REMAINING_FINISH_DATEW_ACTIVITY_DSdate
PLANNED_START_DATEW_ACTIVITY_DSdate
PLANNED_FINISH_DATEW_ACTIVITY_DSdate
REVIEW_FINISH_DATEW_ACTIVITY_DSdate
REMAINING_LATE_START_DATEW_ACTIVITY_DSdate
REMAINING_LATE_FINISH_DATEW_ACTIVITY_DSdate
SUSPEND_DATEW_ACTIVITY_DSdate
RESUME_DATEW_ACTIVITY_DSdate
EXTERNAL_EARLY_START_DATEW_ACTIVITY_DSdate
EXTERNAL_LATE_FINISH_DATEW_ACTIVITY_DSdate
SECONDARY_CONSTRAINT_DATEW_ACTIVITY_DSdate
BASELINE_FINISH_DATEW_ACTIVITY_DSdate
BASELINE_START_DATEW_ACTIVITY_DSdate
DATA_DATEW_ACTIVITY_DSdate
FINISH_DATEW_ACTIVITY_DSdate
START_DATEW_ACTIVITY_DSdate
PRIMARY_CONSTRAINT_TYPEW_ACTIVITY_DSstring
LEVELING_PRIORITYW_ACTIVITY_DSstring
SECONDARY_CONSTRAINT_TYPEW_ACTIVITY_DSstring
FLOAT_PATHW_ACTIVITY_DSinteger
FLOAT_PATH_ORDERW_ACTIVITY_DSinteger
IS_LONGEST_PATHW_ACTIVITY_DSstring
ACTUAL_DURATIONW_ACTIVITY_DSnumber
AT_COMPLETION_DURATIONW_ACTIVITY_DSnumber
BASELINE_DURATIONW_ACTIVITY_DSnumber
BASELINE_PLANNED_DURATIONW_ACTIVITY_DSnumber
CALENDAR_NAMEW_ACTIVITY_DSstring
COST_PERFORMANCE_INDEXW_ACTIVITY_DSnumber
DURATION_1_VARIANCEW_ACTIVITY_DSnumber
DURATION_PCT_COMPLETEW_ACTIVITY_DSnumber
DURATION_PCT_OF_PLANNEDW_ACTIVITY_DSnumber
DURATION_VARIANCEW_ACTIVITY_DSnumber
EST_TO_COMPLETE_COSTW_ACTIVITY_DSnumber
EXPENSE_COST_PCT_COMPLETEW_ACTIVITY_DSnumber
FINISH_DATE_1_VARIANCEW_ACTIVITY_DSnumber
FINISH_DATE_VARIANCEW_ACTIVITY_DSnumber
IS_CRITICALW_ACTIVITY_DSstring
LABOR_UNITS_PCT_COMPLETEW_ACTIVITY_DSnumber
NONLABOR_COST_PCT_COMPLETEW_ACTIVITY_DSnumber
NONLABOR_UNITS_PCT_COMPLETEW_ACTIVITY_DSnumber
PERCENT_COMPLETEW_ACTIVITY_DSnumber
PERFORMANCE_PCT_COMPLETEW_ACTIVITY_DSnumber
PHYSICAL_PCT_COMPLETEW_ACTIVITY_DSnumber
PRIMARY_RESOURCE_NAMEW_ACTIVITY_DSstring
REMAINING_FLOATW_ACTIVITY_DSnumber
SCHEDULE_PCT_COMPLETEW_ACTIVITY_DSnumber
SCHEDULE_PERFORMANCE_INDEXW_ACTIVITY_DSnumber
SCHEDULE_VARIANCE_INDEXW_ACTIVITY_DSnumber
START_DATE_1_VARIANCEW_ACTIVITY_DSnumber
START_DATE_VARIANCEW_ACTIVITY_DSnumber
TO_COMPLETE_PERFORMANCE_INDEXW_ACTIVITY_DSnumber
UNITS_PCT_COMPLETEW_ACTIVITY_DSnumber
WBS_CODEW_ACTIVITY_DSstring
WBS_NAMEW_ACTIVITY_DSstring
PRIMARY_RESOURCE_OBJECT_IDW_ACTIVITY_DSinteger
ACTIVITY_OWNERW_ACTIVITY_DSstring
LOCATION_IDW_ACTIVITY_DSbigint
W_ACTIVITY_HIERARCHY_PCTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
MEMBER_KEYW_ACTIVITY_HIERARCHY_PCbigint
ANCESTOR_KEYW_ACTIVITY_HIERARCHY_PCbigint
DISTANCEW_ACTIVITY_HIERARCHY_PCbigint
IS_LEAFW_ACTIVITY_HIERARCHY_PCbigint
DATASOURCE_IDW_ACTIVITY_HIERARCHY_PCbigint
W_ACTIVITY_HISTORY_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACTIVITY_WIDW_ACTIVITY_HISTORY_Fbigint
WBS_WIDW_ACTIVITY_HISTORY_Fbigint
PROJECT_WIDW_ACTIVITY_HISTORY_Fbigint
DAY_WIDW_ACTIVITY_HISTORY_Fbigint
ACTIVITY_OBJECT_IDW_ACTIVITY_HISTORY_Fbigint
EPS_WIDW_ACTIVITY_HISTORY_Fbigint
PROJECT_OBJECT_IDW_ACTIVITY_HISTORY_Finteger
WBS_OBJECT_IDW_ACTIVITY_HISTORY_Finteger
PERIOD_START_DATEW_ACTIVITY_HISTORY_Fdate
PERIOD_END_DATEW_ACTIVITY_HISTORY_Fdate
PLANNED_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
PLANNED_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
ACTUAL_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
REMAINING_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
REMAINING_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
EST_AT_COMPLETION_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
PLANNED_START_DATEW_ACTIVITY_HISTORY_Fdate
PLANNED_FINISH_DATEW_ACTIVITY_HISTORY_Fdate
ACTUAL_START_DATEW_ACTIVITY_HISTORY_Fdate
ACTUAL_FINISH_DATEW_ACTIVITY_HISTORY_Fdate
REMAINING_START_DATEW_ACTIVITY_HISTORY_Fdate
REMAINING_FINISH_DATEW_ACTIVITY_HISTORY_Fdate
START_DATEW_ACTIVITY_HISTORY_Fdate
FINISH_DATEW_ACTIVITY_HISTORY_Fdate
BASELINE_START_DATEW_ACTIVITY_HISTORY_Fdate
BASELINE_FINISH_DATEW_ACTIVITY_HISTORY_Fdate
PLANNED_DURATIONW_ACTIVITY_HISTORY_Fdouble
ACTUAL_DURATIONW_ACTIVITY_HISTORY_Fnumber
REMAINING_DURATIONW_ACTIVITY_HISTORY_Fdouble
AT_COMPLETION_DURATIONW_ACTIVITY_HISTORY_Fnumber
BASELINE_DURATIONW_ACTIVITY_HISTORY_Fnumber
TOTAL_FLOATW_ACTIVITY_HISTORY_Fdouble
DURATION_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
DURATION_PCT_OF_PLANNEDW_ACTIVITY_HISTORY_Fnumber
DURATION_VARIANCEW_ACTIVITY_HISTORY_Fnumber
UNITS_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
LABOR_UNITS_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
NONLABOR_UNITS_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
SCHEDULE_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
PERFORMANCE_PCT_COMPLETEW_ACTIVITY_HISTORY_Fnumber
START_DATE_VARIANCEW_ACTIVITY_HISTORY_Fnumber
FINISH_DATE_VARIANCEW_ACTIVITY_HISTORY_Fnumber
PLANNED_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
PLANNED_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
PLANNED_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
PLANNED_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
PLANNED_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
EST_AT_COMPLETION_COSTW_ACTIVITY_HISTORY_Fnumber
EST_TO_COMPLETE_COSTW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COSTW_ACTIVITY_HISTORY_Fnumber
PLANNED_VALUE_COSTW_ACTIVITY_HISTORY_Fnumber
ACTUAL_COSTW_ACTIVITY_HISTORY_Fnumber
EARNED_VALUE_COSTW_ACTIVITY_HISTORY_Fnumber
PROJECT_RISK_SCOREW_ACTIVITY_HISTORY_Fnumber
PROJECT_RISK_EXPOSUREW_ACTIVITY_HISTORY_Fnumber
NOT_STARTED_ACTIVITY_COUNTW_ACTIVITY_HISTORY_Finteger
IN_PROGRESS_ACTIVITY_COUNTW_ACTIVITY_HISTORY_Finteger
COMPLETED_ACTIVITY_COUNTW_ACTIVITY_HISTORY_Finteger
NEW_ACTIVITY_COUNTW_ACTIVITY_HISTORY_Finteger
ACTUAL_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
EST_AT_COMPL_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
REM_LATE_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_COST_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
ACTUAL_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
EARNED_VALUE_COST_PW_ACTIVITY_HISTORY_Fnumber
EST_AT_COMPLETION_COST_PW_ACTIVITY_HISTORY_Fnumber
EST_TO_COMPLETE_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
PLANNED_VALUE_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
REMAINING_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_PLANNED_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COST_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_LABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_LABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_NONLABOR_UNITS_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_NONLABOR_COST_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_MATERIAL_COST_PW_ACTIVITY_HISTORY_Fnumber
NEXT_PER_EXPENSE_COST_PW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_LABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_LABOR_COSTW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_UNITSW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_COSTW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_MATERIAL_COSTW_ACTIVITY_HISTORY_Fnumber
PREV_THIS_PER_EXPENSE_COSTW_ACTIVITY_HISTORY_Fnumber
W_UPDATE_DTW_ACTIVITY_HISTORY_Fdate
W_CREATE_DTW_ACTIVITY_HISTORY_Fdate
DELETE_FLAGW_ACTIVITY_HISTORY_Fstring
DATASOURCE_IDW_ACTIVITY_HISTORY_Fbigint
W_ACTIVITY_RISK_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACTIVITY_WIDW_ACTIVITY_RISK_Dbigint
RISK_WIDW_ACTIVITY_RISK_Dbigint
PROJECT_WIDW_ACTIVITY_RISK_Dbigint
EPS_WIDW_ACTIVITY_RISK_Dbigint
OWNER_RESOURCE_WIDW_ACTIVITY_RISK_Dbigint
IDENTIFIED_BY_RESOURCE_WIDW_ACTIVITY_RISK_Dbigint
ACTIVITY_OBJECT_IDW_ACTIVITY_RISK_Dbigint
RISK_OBJECT_IDW_ACTIVITY_RISK_Dbigint
PROJECT_OBJECT_IDW_ACTIVITY_RISK_Dbigint
RISK_CATEGORY_OBJECT_IDW_ACTIVITY_RISK_Dbigint
RESOURCE_OBJECT_IDW_ACTIVITY_RISK_Dbigint
RISK_IDW_ACTIVITY_RISK_Dstring
RISK_NAMEW_ACTIVITY_RISK_Dstring
ACTIVITY_IDW_ACTIVITY_RISK_Dstring
ACTIVITY_NAMEW_ACTIVITY_RISK_Dstring
PROJECT_IDW_ACTIVITY_RISK_Dstring
PROJECT_NAMEW_ACTIVITY_RISK_Dstring
OWNERW_ACTIVITY_RISK_Dstring
RISK_TYPEW_ACTIVITY_RISK_Dstring
RISK_STATUSW_ACTIVITY_RISK_Dstring
CATEGORYW_ACTIVITY_RISK_Dstring
SCOREW_ACTIVITY_RISK_Dnumber
TOTAL_COSTW_ACTIVITY_RISK_Dnumber
ExposureW_ACTIVITY_RISK_Dnumber
IDENTIFIED_BY_RSRC_OBJECT_IDW_ACTIVITY_RISK_Dbigint
IDENTIFIED_BY_RESOURCE_IDW_ACTIVITY_RISK_Dstring
IDENTIFIED_BY_RESOURCE_NAMEW_ACTIVITY_RISK_Dstring
IDENTIFIED_DATEW_ACTIVITY_RISK_Ddate
W_UPDATE_DTW_ACTIVITY_RISK_Ddate
W_CREATE_DTW_ACTIVITY_RISK_Ddate
DELETE_FLAGW_ACTIVITY_RISK_Dstring
DATASOURCE_IDW_ACTIVITY_RISK_Dbigint
W_ACTIVITY_RISK_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACTIVITY_OBJECT_IDW_ACTIVITY_RISK_DSbigint
RISK_OBJECT_IDW_ACTIVITY_RISK_DSbigint
PROJECT_OBJECT_IDW_ACTIVITY_RISK_DSbigint
ACTIVITY_IDW_ACTIVITY_RISK_DSstring
ACTIVITY_NAMEW_ACTIVITY_RISK_DSstring
PROJECT_IDW_ACTIVITY_RISK_DSstring
PROJECT_NAMEW_ACTIVITY_RISK_DSstring
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_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
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
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
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_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
W_ACTIVITY_SPREAD_PER_TSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_WIDW_ACTIVITY_SPREAD_PER_TSbigint
ACTIVITY_WIDW_ACTIVITY_SPREAD_PER_TSbigint
WBS_WIDW_ACTIVITY_SPREAD_PER_TSbigint
PERIOD_START_DATEW_ACTIVITY_SPREAD_PER_TSdate
PERIOD_END_DATEW_ACTIVITY_SPREAD_PER_TSdate
ACTUAL_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
EARNED_VALUE_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
EST_AT_COMPLETION_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
EST_TO_COMPLETE_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_VALUE_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
ACTUAL_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
AT_COMPLETION_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
EARNED_VALUE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
EST_AT_COMPLETION_COSTW_ACTIVITY_SPREAD_PER_TSnumber
EST_TO_COMPLETE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PLANNED_VALUE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_LATE_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
REMAINING_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_PLANNED_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
BL_ACTUAL_TOTAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
NEXT_PER_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_LABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_LABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_NONLABOR_UNITSW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_NONLABOR_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_MATERIAL_COSTW_ACTIVITY_SPREAD_PER_TSnumber
PREV_THIS_PER_EXPENSE_COSTW_ACTIVITY_SPREAD_PER_TSnumber
NOT_STARTED_ACTIVITY_COUNTW_ACTIVITY_SPREAD_PER_TSinteger
IN_PROGRESS_ACTIVITY_COUNTW_ACTIVITY_SPREAD_PER_TSinteger
COMPLETED_ACTIVITY_COUNTW_ACTIVITY_SPREAD_PER_TSinteger
NEW_ACTIVITY_COUNTW_ACTIVITY_SPREAD_PER_TSinteger
W_ACTIVITYCODE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_ACTIVITYCODE_DSintegerActivityCode - ObjectId maps to ACTVCODE.actv_code_id
codetypeobjectidW_ACTIVITYCODE_DSintegerActivityCode - CodeTypeObjectId maps to ACTVCODE.actv_code_type_id
sequencenumberW_ACTIVITYCODE_DSintegerActivityCode - SequenceNumber maps to ACTVCODE.seq_num
codevalueW_ACTIVITYCODE_DSstringActivityCode - CodeValue maps to ACTVCODE.short_name
parentobjectidW_ACTIVITYCODE_DSintegerActivityCode - ParentObjectId maps to ACTVCODE.parent_actv_code_id
descriptionW_ACTIVITYCODE_DSstringActivityCode - Description maps to ACTVCODE.actv_code_name
codetypenameW_ACTIVITYCODE_DSstringActivityCode - CodeTypeName maps to actvcode.CodeTypeName
issecurecodeW_ACTIVITYCODE_DSstringActivityCodeType - IsSecureCode maps to ACTVTYPE.super_flag
projectobjectidW_ACTIVITYCODE_DSintegerActivityCodeType - ProjectObjectId maps to ACTVTYPE.proj_id
codetypescopeW_ACTIVITYCODE_DSstringActivityCodeType - Scope denormalized field
lastupdateuserW_ACTIVITYCODE_DSstringLast Update User
lastupdatedateW_ACTIVITYCODE_DSdateLast Update Date
createuserW_ACTIVITYCODE_DSstringCreate User
createdateW_ACTIVITYCODE_DSdateCreate Date
W_ACTIVITYCODEASSIGNMENT_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
activityobjectidW_ACTIVITYCODEASSIGNMENT_DSintegerActivityCodeAssignment - ActivityObjectId maps to TASKACTV.task_id
activitycodetypeobjectidW_ACTIVITYCODEASSIGNMENT_DSintegerActivityCodeAssignment - ActivityCodeTypeObjectId maps to TASKACTV.actv_code_type_id
activitycodeobjectidW_ACTIVITYCODEASSIGNMENT_DSintegerActivityCodeAssignment - ActivityCodeObjectId maps to TASKACTV.actv_code_id
projectobjectidW_ACTIVITYCODEASSIGNMENT_DSintegerActivityCodeAssignment - ProjectObjectId maps to TASKACTV.proj_id
activitycodedescriptionW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityCodeDescription maps to TASKACTV.ActivityCodeDescription
activitycodetypenameW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityCodeTypeName maps to TASKACTV.ActivityCodeTypeName
activitycodetypescopeW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityCodeTypeScope maps to TASKACTV.ActivityCodeTypeScope
activitycodevalueW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityCodeValue maps to TASKACTV.ActivityCodeValue
activityidW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityId maps to TASKACTV.ActivityId
activitynameW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - ActivityName maps to TASKACTV.ActivityName
issecurecodeW_ACTIVITYCODEASSIGNMENT_DSstringActivityCodeAssignment - IsSecureCode maps to TASKACTV.super_flag
lastupdateuserW_ACTIVITYCODEASSIGNMENT_DSstringLast Update User
lastupdatedateW_ACTIVITYCODEASSIGNMENT_DSdateLast Update Date
createuserW_ACTIVITYCODEASSIGNMENT_DSstringCreate User
createdateW_ACTIVITYCODEASSIGNMENT_DSdateCreate Date
W_ACTIVITYCODETYPE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_ACTIVITYCODETYPE_DSintegerActivityCodeType - ObjectId maps to ACTVTYPE.actv_code_type_id
lengthW_ACTIVITYCODETYPE_DSintegerActivityCodeType - Length maps to ACTVTYPE.actv_short_len
sequencenumberW_ACTIVITYCODETYPE_DSintegerActivityCodeType - SequenceNumber maps to ACTVTYPE.seq_num
nameW_ACTIVITYCODETYPE_DSstringActivityCodeType - Name maps to ACTVTYPE.actv_code_type
scopeW_ACTIVITYCODETYPE_DSstringActivityCodeType - Scope maps to ACTVTYPE.actv_code_type_scope
projectobjectidW_ACTIVITYCODETYPE_DSintegerActivityCodeType - ProjectObjectId maps to ACTVTYPE.proj_id
epsobjectidW_ACTIVITYCODETYPE_DSintegerActivityCodeType - EPSObjectId maps to ACTVTYPE.proj_id
issecurecodeW_ACTIVITYCODETYPE_DSstringActivityCodeType - IsSecureCode maps to ACTVTYPE.super_flag
lastupdateuserW_ACTIVITYCODETYPE_DSstringLast Update User
lastupdatedateW_ACTIVITYCODETYPE_DSdateLast Update Date
createuserW_ACTIVITYCODETYPE_DSstringCreate User
createdateW_ACTIVITYCODETYPE_DSdateCreate Date
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
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_COST_ACCOUNT_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACCT_SHORT_NAMEW_COST_ACCOUNT_DSstring
ACCT_NAMEW_COST_ACCOUNT_DSstring
ACCOUNT_OBJECT_IDW_COST_ACCOUNT_DSinteger
W_CURRENCY_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_CURRENCY_DSinteger
nameW_CURRENCY_DSstring
idW_CURRENCY_DSstring
exchangerateW_CURRENCY_DSnumber
isbasecurrencyW_CURRENCY_DSstring
decimalplacesW_CURRENCY_DSinteger
symbolW_CURRENCY_DSstring
decimalsymbolW_CURRENCY_DSstring
digitgroupingsymbolW_CURRENCY_DSstring
positivesymbolW_CURRENCY_DSstring
negativesymbolW_CURRENCY_DSstring
lastupdateuserW_CURRENCY_DSstringLast Update User
lastupdatedateW_CURRENCY_DSdateLast Update Date
createuserW_CURRENCY_DSstringCreate User
createdateW_CURRENCY_DSdateCreate Date
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
SORT_WEEK_NAMEW_DAY_Dstring
SORT_MONTH_NAMEW_DAY_Dstring
SORT_QUARTER_NAMEW_DAY_Dstring
SORT_HALF_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
PERIOD_WEEK_START_DATEW_DAY_Ddate
PERIOD_WEEK_END_DATEW_DAY_Ddate
PERIOD_DAY_START_DATEW_DAY_Ddate
PERIOD_DAY_END_DATEW_DAY_Ddate
PERIOD_MONTH_START_DATEW_DAY_Ddate
PERIOD_MONTH_END_DATEW_DAY_Ddate
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
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
PROJECTIDW_EPS_Dstring
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
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
FINISHDATEW_EPS_Ddate
FORECASTFINISHDATEW_EPS_Ddate
FORECASTSTARTDATEW_EPS_Ddate
FULLNAMEW_EPS_Dstring
OBSNAMEW_EPS_Dstring
ORIG_COSTW_EPS_Ddouble
INDEP_REMAIN_TOTAL_COSTW_EPS_Ddouble
CURRENTBUDGETW_EPS_Dnumber
CURRENTVARIANCEW_EPS_Dnumber
DISTRIBUTEDCURRENTBUDGETW_EPS_Dnumber
PROPOSEDBUDGETW_EPS_Dnumber
TOTALBENEFITPLANW_EPS_Dnumber
TOTALBENEFITPLANTALLYW_EPS_Dnumber
TOTALSPENDINGPLANW_EPS_Dnumber
TOTALSPENDINGPLANTALLYW_EPS_Dnumber
UNALLOCATEDBUDGETW_EPS_Dnumber
UNDISTRIBUTEDCURRENTVARIANCEW_EPS_Dnumber
STARTDATEW_EPS_Ddate
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_EPS_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
WBS_OBJECT_IDW_EPS_DSbigint
PARENT_OBJECT_IDW_EPS_DSbigint
PROJECT_OBJECT_IDW_EPS_DSbigint
WBS_SHORT_NAMEW_EPS_DSstring
WBS_NAMEW_EPS_DSstring
OBS_OBJECT_IDW_EPS_DSinteger
SEQ_NUMW_EPS_DSinteger
SUM_DATA_FLAGW_EPS_DSstring
STATUS_CODEW_EPS_DSstring
EV_USER_PCTW_EPS_DSdouble
EV_ETC_USER_VALUEW_EPS_DSdouble
ORIG_COSTW_EPS_DSdouble
INDEP_REMAIN_TOTAL_COSTW_EPS_DSdouble
INDEP_REMAIN_WORK_QTYW_EPS_DSdouble
ANTICIP_START_DATEW_EPS_DSdate
ANTICIP_END_DATEW_EPS_DSdate
EV_COMPUTE_TYPEW_EPS_DSstring
EV_ETC_COMPUTE_TYPEW_EPS_DSstring
CURRENTBUDGETW_EPS_DSnumber
CURRENTVARIANCEW_EPS_DSnumber
DISTRIBUTEDCURRENTBUDGETW_EPS_DSnumber
FINISHDATEW_EPS_DSdate
FORECASTFINISHDATEW_EPS_DSdate
FORECASTSTARTDATEW_EPS_DSdate
FULLNAMEW_EPS_DSstring
OBSNAMEW_EPS_DSstring
PROJECTIDW_EPS_DSstring
PROPOSEDBUDGETW_EPS_DSnumber
STARTDATEW_EPS_DSdate
TOTALBENEFITPLANW_EPS_DSnumber
TOTALBENEFITPLANTALLYW_EPS_DSnumber
TOTALSPENDINGPLANW_EPS_DSnumber
TOTALSPENDINGPLANTALLYW_EPS_DSnumber
UNALLOCATEDBUDGETW_EPS_DSnumber
UNDISTRIBUTEDCURRENTVARIANCEW_EPS_DSnumber
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
W_FINANCIAL_PERIOD_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_FINANCIAL_PERIOD_DSinteger
nameW_FINANCIAL_PERIOD_DSstring
startdateW_FINANCIAL_PERIOD_DSdate
enddateW_FINANCIAL_PERIOD_DSdate
W_LOCATION_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
LOCATION_IDW_LOCATION_DSbigint
LOCATION_NAMEW_LOCATION_DSstring
LOCATION_TYPEW_LOCATION_DSstring
ADDRESS_LINE1W_LOCATION_DSstring
ADDRESS_LINE2W_LOCATION_DSstring
ADDRESS_LINE3W_LOCATION_DSstring
CITY_NAMEW_LOCATION_DSstring
MUNICIPALITY_NAMEW_LOCATION_DSstring
STATE_NAMEW_LOCATION_DSstring
STATE_CODEW_LOCATION_DSstring
COUNTRY_NAMEW_LOCATION_DSstring
COUNTRY_CODEW_LOCATION_DSstring
POSTAL_CODEW_LOCATION_DSstring
LONGITUDEW_LOCATION_DSnumber
LATITUDEW_LOCATION_DSnumber
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_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_OBS_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
OBS_NAMEW_OBS_DSstring
OBS_OBJECT_IDW_OBS_DSinteger
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
PROJECT_PLANNED_START_DATEW_PROJECT_Ddate
PROJECT_PLANNED_FINISH_DATEW_PROJECT_Ddate
PLANNED_START_DATEW_PROJECT_Ddate
PLANNED_FINISH_DATEW_PROJECT_Ddate
PLANNED_DURATIONW_PROJECT_Dnumber
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
DATA_DATEW_PROJECT_Ddate
FORECAST_START_DATEW_PROJECT_Ddate
FORECAST_FINISH_DATEW_PROJECT_Ddate
OVERALL_PROJECT_SCOREW_PROJECT_Dnumber
PROJECT_RISK_SCOREW_PROJECT_Dnumber
PROJECT_RISK_EXPOSUREW_PROJECT_Dnumber
PROJECT_RISK_LEVELW_PROJECT_Dstring
PROJECT_STATUSW_PROJECT_Dstring
START_DATEW_PROJECT_Ddate
FINISH_DATEW_PROJECT_Ddate
ACTUAL_START_DATEW_PROJECT_Ddate
ACTUAL_FINISH_DATEW_PROJECT_Ddate
BASELINE_START_DATEW_PROJECT_Ddate
BASELINE_FINISH_DATEW_PROJECT_Ddate
PROGRESS_FINISH_DATEW_PROJECT_Ddate
REMAINING_START_DATEW_PROJECT_Ddate
REMAINING_FINISH_DATEW_PROJECT_Ddate
ACTUAL_DURATIONW_PROJECT_Dnumber
AT_COMPLETION_DURATIONW_PROJECT_Dnumber
BASELINE_DURATIONW_PROJECT_Dnumber
REMAINING_DURATIONW_PROJECT_Dnumber
DURATION_PERCENT_COMPLETEW_PROJECT_Dnumber
DURATION_PERCENT_OF_PLANNEDW_PROJECT_Dnumber
DURATION_VARIANCEW_PROJECT_Dnumber
ACTUAL_LABOR_UNITSW_PROJECT_Dnumber
ACTUAL_NONLABOR_UNITSW_PROJECT_Dnumber
AT_COMPLETION_LABOR_UNITSW_PROJECT_Dnumber
AT_COMPLETION_NONLABOR_UNITSW_PROJECT_Dnumber
EARNED_VALUE_LABOR_UNITSW_PROJECT_Dnumber
EST_AT_COMPLETION_LABOR_UNITSW_PROJECT_Dnumber
EST_TO_COMPLETE_LABOR_UNITSW_PROJECT_Dnumber
PLANNED_LABOR_UNITSW_PROJECT_Dnumber
PLANNED_NONLABOR_UNITSW_PROJECT_Dnumber
PLANNED_VALUE_LABOR_UNITSW_PROJECT_Dnumber
REMAINING_LABOR_UNITSW_PROJECT_Dnumber
REMAINING_NONLABOR_UNITSW_PROJECT_Dnumber
BL_PLANNED_LABOR_UNITSW_PROJECT_Dnumber
BL_PLANNED_NONLABOR_UNITSW_PROJECT_Dnumber
BL_ACTUAL_LABOR_UNITSW_PROJECT_Dnumber
BL_ACTUAL_NONLABOR_UNITSW_PROJECT_Dnumber
BL1_PLANNED_LABOR_UNITSW_PROJECT_Dnumber
BL1_PLANNED_NONLABOR_UNITSW_PROJECT_Dnumber
BL1_ACTUAL_LABOR_UNITSW_PROJECT_Dnumber
BL1_ACTUAL_NONLABOR_UNITSW_PROJECT_Dnumber
ACCOUNTING_VAR_BY_LABOR_UNITSW_PROJECT_Dnumber
BAC_BY_LABOR_UNITSW_PROJECT_Dnumber
LABOR_UNITS_PERCENT_COMPLETEW_PROJECT_Dnumber
ACTUAL_VALUE_BY_LABOR_UNITSW_PROJECT_Dnumber
FINISH_DATE_VARIANCEW_PROJECT_Dnumber
LABOR_UNITS_VARIANCEW_PROJECT_Dnumber
NONLABOR_UNITS_VARIANCEW_PROJECT_Dnumber
SCHEDULE_PERCENT_COMPLETEW_PROJECT_Dnumber
PERFORMANCE_PERCENT_COMPLETEW_PROJECT_Dnumber
START_DATE_VARIANCEW_PROJECT_Dnumber
TOTAL_FLOATW_PROJECT_Dnumber
UNITS_PERCENT_COMPLETEW_PROJECT_Dnumber
NONLABOR_UNITS_PCT_COMPLETEW_PROJECT_Dnumber
PERF_PCT_CMP_BY_LABOR_UNITSW_PROJECT_Dnumber
SCHD_PCT_CMP_BY_LABOR_UNITSW_PROJECT_Dnumber
SCHEDULE_VAR_BY_LABOR_UNITSW_PROJECT_Dnumber
VARIANCE_AT_CMP_BY_LABOR_UNITSW_PROJECT_Dnumber
COST_VARIANCE_BY_LABOR_UNITSW_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
CURRENT_BUDGETW_PROJECT_Dnumber
CURRENT_VARIANCEW_PROJECT_Dnumber
DISTRIBUTED_CURRENT_BUDGETW_PROJECT_Dnumber
ORIGINAL_BUDGETW_PROJECT_Dnumber
PROPOSED_BUDGETW_PROJECT_Dnumber
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
NET_PRESENT_VALUEW_PROJECT_Dnumber
RETURN_ON_INVESTMENTW_PROJECT_Dnumber
PAYBACK_PERIODW_PROJECT_Dnumber
ACCOUNTING_VARIANCE_BY_COSTW_PROJECT_Dnumber
BUDGET_AT_COMPLETION_BY_COSTW_PROJECT_Dnumber
EST_AT_COMPLETION_COSTW_PROJECT_Dnumber
EST_TO_COMPLETE_COSTW_PROJECT_Dnumber
PLANNED_EXPENSE_COSTW_PROJECT_Dnumber
PLANNED_LABOR_COSTW_PROJECT_Dnumber
PLANNED_MATERIAL_COSTW_PROJECT_Dnumber
PLANNED_NONLABOR_COSTW_PROJECT_Dnumber
PLANNED_TOTAL_COSTW_PROJECT_Dnumber
ACTUAL_EXPENSE_COSTW_PROJECT_Dnumber
ACTUAL_LABOR_COSTW_PROJECT_Dnumber
ACTUAL_MATERIAL_COSTW_PROJECT_Dnumber
ACTUAL_NONLABOR_COSTW_PROJECT_Dnumber
ACTUAL_TOTAL_COSTW_PROJECT_Dnumber
ACTUAL_COSTW_PROJECT_Dnumber
AT_COMPLETION_EXPENSE_COSTW_PROJECT_Dnumber
AT_COMPLETION_LABOR_COSTW_PROJECT_Dnumber
AT_COMPLETION_MATERIAL_COSTW_PROJECT_Dnumber
AT_COMPLETION_NONLABOR_COSTW_PROJECT_Dnumber
AT_COMPLETION_TOTAL_COSTW_PROJECT_Dnumber
BL_PLANNED_EXPENSE_COSTW_PROJECT_Dnumber
BL_PLANNED_LABOR_COSTW_PROJECT_Dnumber
BL_PLANNED_MATERIAL_COSTW_PROJECT_Dnumber
BL_PLANNED_NONLABOR_COSTW_PROJECT_Dnumber
BL_PLANNED_TOTAL_COSTW_PROJECT_Dnumber
BL_ACTUAL_EXPENSE_COSTW_PROJECT_Dnumber
BL_ACTUAL_LABOR_COSTW_PROJECT_Dnumber
BL_ACTUAL_MATERIAL_COSTW_PROJECT_Dnumber
BL_ACTUAL_NONLABOR_COSTW_PROJECT_Dnumber
BL_ACTUAL_TOTAL_COSTW_PROJECT_Dnumber
REMAINING_LABOR_COSTW_PROJECT_Dnumber
REMAINING_MATERIAL_COSTW_PROJECT_Dnumber
REMAINING_EXPENSE_COSTW_PROJECT_Dnumber
REMAINING_NONLABOR_COSTW_PROJECT_Dnumber
REMAINING_TOTAL_COSTW_PROJECT_Dnumber
EARNED_VALUE_COSTW_PROJECT_Dnumber
PLANNED_VALUE_COSTW_PROJECT_Dnumber
EXPENSE_COST_PERCENT_COMPLETEW_PROJECT_Dnumber
LABOR_COST_PERCENT_COMPLETEW_PROJECT_Dnumber
COST_PERCENT_COMPLETEW_PROJECT_Dnumber
COST_PCT_CMP_OF_PLANNEDW_PROJECT_Dnumber
MATERIAL_COST_PERCENT_COMPLETEW_PROJECT_Dnumber
NONLABOR_COST_PERCENT_COMPLETEW_PROJECT_Dnumber
COST_VARIANCEW_PROJECT_Dnumber
EXPENSE_COST_VARIANCEW_PROJECT_Dnumber
LABOR_COST_VARIANCEW_PROJECT_Dnumber
NONLABOR_COST_VARIANCEW_PROJECT_Dnumber
MATERIAL_COST_VARIANCEW_PROJECT_Dnumber
TOTAL_COST_VARIANCEW_PROJECT_Dnumber
SCHEDULE_VARIANCE_BY_COSTW_PROJECT_Dnumber
AT_COMPLETION_TOTAL_COST_VARW_PROJECT_Dnumber
LOCATION_IDW_PROJECT_Dbigint
LOCATION_NAMEW_PROJECT_Dstring
LOCATION_TYPEW_PROJECT_Dstring
ADDRESS_LINE1W_PROJECT_Dstring
ADDRESS_LINE2W_PROJECT_Dstring
ADDRESS_LINE3W_PROJECT_Dstring
CITY_NAMEW_PROJECT_Dstring
MUNICIPALITY_NAMEW_PROJECT_Dstring
STATE_NAMEW_PROJECT_Dstring
STATE_CODEW_PROJECT_Dstring
COUNTRY_NAMEW_PROJECT_Dstring
COUNTRY_CODEW_PROJECT_Dstring
POSTAL_CODEW_PROJECT_Dstring
LONGITUDEW_PROJECT_Dnumber
LATITUDEW_PROJECT_Dnumber
NOT_STARTED_ACTIVITY_COUNTW_PROJECT_Dinteger
IN_PROGRESS_ACTIVITY_COUNTW_PROJECT_Dinteger
COMPLETED_ACTIVITY_COUNTW_PROJECT_Dinteger
W_PROJECT_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_IDW_PROJECT_DSstring
PROJECT_NAMEW_PROJECT_DSstring
PROJECT_OBJECT_IDW_PROJECT_DSbigint
EPS_OBJECT_IDW_PROJECT_DSbigint
PROJECT_PRIORITYW_PROJECT_DSinteger
PROJECT_STRATEGIC_PRIORITYW_PROJECT_DSinteger
CRITICAL_ACTIVITY_FLOAT_LIMITW_PROJECT_DSdouble
PROJECT_PLANNED_START_DATEW_PROJECT_DSdate
PROJECT_PLANNED_FINISH_DATEW_PROJECT_DSdate
PLANNED_START_DATEW_PROJECT_DSdate
PLANNED_FINISH_DATEW_PROJECT_DSdate
PLANNED_DURATIONW_PROJECT_DSnumber
SCHEDULED_FINISH_DATEW_PROJECT_DSdate
ADD_DATEW_PROJECT_DSdate
PROJECT_START_DATEW_PROJECT_DSdate
PROJECT_FINISH_DATEW_PROJECT_DSdate
ADDED_BY_NAMEW_PROJECT_DSstring
ANNUAL_DISCOUNT_RATEW_PROJECT_DSnumber
ANTICIPATED_FINISH_DATEW_PROJECT_DSdate
ANTICIPATED_START_DATEW_PROJECT_DSdate
CURRENT_BUDGETW_PROJECT_DSnumber
CURRENT_VARIANCEW_PROJECT_DSnumber
DATA_DATEW_PROJECT_DSdate
DISTRIBUTED_CURRENT_BUDGETW_PROJECT_DSnumber
FORECAST_START_DATEW_PROJECT_DSdate
FORECAST_FINISH_DATEW_PROJECT_DSdate
ORIGINAL_BUDGETW_PROJECT_DSnumber
OVERALL_PROJECT_SCOREW_PROJECT_DSnumber
PROPOSED_BUDGETW_PROJECT_DSnumber
PROJECT_RISK_SCOREW_PROJECT_DSnumber
PROJECT_RISK_EXPOSUREW_PROJECT_DSnumber
PROJECT_RISK_LEVELW_PROJECT_DSstring
PROJECT_STATUSW_PROJECT_DSstring
TOTAL_BENEFIT_PLANW_PROJECT_DSnumber
TOTAL_BENEFIT_PLAN_TALLYW_PROJECT_DSnumber
TOTAL_FUNDINGW_PROJECT_DSnumber
TOTAL_SPENDING_PLANW_PROJECT_DSnumber
TOTAL_SPENDING_PLAN_TALLYW_PROJECT_DSnumber
UNALLOCATED_BUDGETW_PROJECT_DSnumber
UNDISTRIBUTED_CURRENT_VARIANCEW_PROJECT_DSnumber
NET_PRESENT_VALUEW_PROJECT_DSnumber
RETURN_ON_INVESTMENTW_PROJECT_DSnumber
PAYBACK_PERIODW_PROJECT_DSnumber
START_DATEW_PROJECT_DSdate
FINISH_DATEW_PROJECT_DSdate
ACTUAL_START_DATEW_PROJECT_DSdate
ACTUAL_FINISH_DATEW_PROJECT_DSdate
BASELINE_START_DATEW_PROJECT_DSdate
BASELINE_FINISH_DATEW_PROJECT_DSdate
PROGRESS_FINISH_DATEW_PROJECT_DSdate
REMAINING_START_DATEW_PROJECT_DSdate
REMAINING_FINISH_DATEW_PROJECT_DSdate
ACTUAL_DURATIONW_PROJECT_DSnumber
AT_COMPLETION_DURATIONW_PROJECT_DSnumber
BASELINE_DURATIONW_PROJECT_DSnumber
REMAINING_DURATIONW_PROJECT_DSnumber
DURATION_PERCENT_COMPLETEW_PROJECT_DSnumber
DURATION_PERCENT_OF_PLANNEDW_PROJECT_DSnumber
DURATION_VARIANCEW_PROJECT_DSnumber
ACTUAL_LABOR_UNITSW_PROJECT_DSnumber
ACTUAL_NONLABOR_UNITSW_PROJECT_DSnumber
AT_COMPLETION_LABOR_UNITSW_PROJECT_DSnumber
AT_COMPLETION_NONLABOR_UNITSW_PROJECT_DSnumber
EARNED_VALUE_LABOR_UNITSW_PROJECT_DSnumber
EST_AT_COMPLETION_LABOR_UNITSW_PROJECT_DSnumber
EST_TO_COMPLETE_LABOR_UNITSW_PROJECT_DSnumber
PLANNED_LABOR_UNITSW_PROJECT_DSnumber
PLANNED_NONLABOR_UNITSW_PROJECT_DSnumber
PLANNED_VALUE_LABOR_UNITSW_PROJECT_DSnumber
REMAINING_LABOR_UNITSW_PROJECT_DSnumber
REMAINING_NONLABOR_UNITSW_PROJECT_DSnumber
BL_PLANNED_LABOR_UNITSW_PROJECT_DSnumber
BL_PLANNED_NONLABOR_UNITSW_PROJECT_DSnumber
ACCOUNTING_VAR_BY_LABOR_UNITSW_PROJECT_DSnumber
BAC_BY_LABOR_UNITSW_PROJECT_DSnumber
LABOR_UNITS_PERCENT_COMPLETEW_PROJECT_DSnumber
ACTUAL_VALUE_BY_LABOR_UNITSW_PROJECT_DSnumber
FINISH_DATE_VARIANCEW_PROJECT_DSnumber
LABOR_UNITS_VARIANCEW_PROJECT_DSnumber
NONLABOR_UNITS_VARIANCEW_PROJECT_DSnumber
SCHEDULE_PERCENT_COMPLETEW_PROJECT_DSnumber
PERFORMANCE_PERCENT_COMPLETEW_PROJECT_DSnumber
START_DATE_VARIANCEW_PROJECT_DSnumber
TOTAL_FLOATW_PROJECT_DSnumber
UNITS_PERCENT_COMPLETEW_PROJECT_DSnumber
NONLABOR_UNITS_PCT_COMPLETEW_PROJECT_DSnumber
PERF_PCT_CMP_BY_LABOR_UNITSW_PROJECT_DSnumber
SCHD_PCT_CMP_BY_LABOR_UNITSW_PROJECT_DSnumber
SCHEDULE_VAR_BY_LABOR_UNITSW_PROJECT_DSnumber
VARIANCE_AT_CMP_BY_LABOR_UNITSW_PROJECT_DSnumber
COST_VARIANCE_BY_LABOR_UNITSW_PROJECT_DSnumber
ACCOUNTING_VARIANCE_BY_COSTW_PROJECT_DSnumber
BUDGET_AT_COMPLETION_BY_COSTW_PROJECT_DSnumber
EST_AT_COMPLETION_COSTW_PROJECT_DSnumber
EST_TO_COMPLETE_COSTW_PROJECT_DSnumber
ACTUAL_EXPENSE_COSTW_PROJECT_DSnumber
ACTUAL_LABOR_COSTW_PROJECT_DSnumber
ACTUAL_MATERIAL_COSTW_PROJECT_DSnumber
ACTUAL_NONLABOR_COSTW_PROJECT_DSnumber
ACTUAL_TOTAL_COSTW_PROJECT_DSnumber
ACTUAL_COSTW_PROJECT_DSnumber
AT_COMPLETION_EXPENSE_COSTW_PROJECT_DSnumber
AT_COMPLETION_LABOR_COSTW_PROJECT_DSnumber
AT_COMPLETION_MATERIAL_COSTW_PROJECT_DSnumber
AT_COMPLETION_NONLABOR_COSTW_PROJECT_DSnumber
AT_COMPLETION_TOTAL_COSTW_PROJECT_DSnumber
PLANNED_EXPENSE_COSTW_PROJECT_DSnumber
PLANNED_LABOR_COSTW_PROJECT_DSnumber
PLANNED_MATERIAL_COSTW_PROJECT_DSnumber
PLANNED_NONLABOR_COSTW_PROJECT_DSnumber
PLANNED_TOTAL_COSTW_PROJECT_DSnumber
BL_PLANNED_EXPENSE_COSTW_PROJECT_DSnumber
BL_PLANNED_LABOR_COSTW_PROJECT_DSnumber
BL_PLANNED_MATERIAL_COSTW_PROJECT_DSnumber
BL_PLANNED_NONLABOR_COSTW_PROJECT_DSnumber
BL_PLANNED_TOTAL_COSTW_PROJECT_DSnumber
REMAINING_LABOR_COSTW_PROJECT_DSnumber
REMAINING_MATERIAL_COSTW_PROJECT_DSnumber
REMAINING_EXPENSE_COSTW_PROJECT_DSnumber
REMAINING_NONLABOR_COSTW_PROJECT_DSnumber
REMAINING_TOTAL_COSTW_PROJECT_DSnumber
EARNED_VALUE_COSTW_PROJECT_DSnumber
PLANNED_VALUE_COSTW_PROJECT_DSnumber
EXPENSE_COST_PERCENT_COMPLETEW_PROJECT_DSnumber
LABOR_COST_PERCENT_COMPLETEW_PROJECT_DSnumber
COST_PERCENT_COMPLETEW_PROJECT_DSnumber
COST_PCT_CMP_OF_PLANNEDW_PROJECT_DSnumber
MATERIAL_COST_PERCENT_COMPLETEW_PROJECT_DSnumber
NONLABOR_COST_PERCENT_COMPLETEW_PROJECT_DSnumber
COST_VARIANCEW_PROJECT_DSnumber
EXPENSE_COST_VARIANCEW_PROJECT_DSnumber
LABOR_COST_VARIANCEW_PROJECT_DSnumber
NONLABOR_COST_VARIANCEW_PROJECT_DSnumber
MATERIAL_COST_VARIANCEW_PROJECT_DSnumber
TOTAL_COST_VARIANCEW_PROJECT_DSnumber
SCHEDULE_VARIANCE_BY_COSTW_PROJECT_DSnumber
AT_COMPLETION_TOTAL_COST_VARW_PROJECT_DSnumber
HISTORY_INTERVALW_PROJECT_DSstring
HISTORY_LEVELW_PROJECT_DSstring
LOCATION_IDW_PROJECT_DSbigint
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
EPS_OBJECT_IDW_PROJECT_HISTORY_Fbigint
PERIOD_START_DATEW_PROJECT_HISTORY_Fdate
PERIOD_END_DATEW_PROJECT_HISTORY_Fdate
PLANNED_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
PLANNED_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
ACTUAL_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
EST_AT_COMPLETION_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_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
PLANNED_VALUE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
PLANNED_START_DATEW_PROJECT_HISTORY_Fdate
PLANNED_FINISH_DATEW_PROJECT_HISTORY_Fdate
START_DATEW_PROJECT_HISTORY_Fdate
FINISH_DATEW_PROJECT_HISTORY_Fdate
ACTUAL_START_DATEW_PROJECT_HISTORY_Fdate
ACTUAL_FINISH_DATEW_PROJECT_HISTORY_Fdate
REMAINING_START_DATEW_PROJECT_HISTORY_Fdate
REMAINING_FINISH_DATEW_PROJECT_HISTORY_Fdate
BASELINE_START_DATEW_PROJECT_HISTORY_Fdate
BASELINE_FINISH_DATEW_PROJECT_HISTORY_Fdate
PLANNED_DURATIONW_PROJECT_HISTORY_Fnumber
ACTUAL_DURATIONW_PROJECT_HISTORY_Fnumber
REMAINING_DURATIONW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_DURATIONW_PROJECT_HISTORY_Fnumber
BASELINE_DURATIONW_PROJECT_HISTORY_Fnumber
TOTAL_FLOATW_PROJECT_HISTORY_Fnumber
DURATION_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
DURATION_PCT_OF_PLANNEDW_PROJECT_HISTORY_Fnumber
DURATION_VARIANCEW_PROJECT_HISTORY_Fnumber
UNITS_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
LABOR_UNITS_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
NONLABOR_UNITS_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
SCHEDULE_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
PERFORMANCE_PCT_COMPLETEW_PROJECT_HISTORY_Fnumber
START_DATE_VARIANCEW_PROJECT_HISTORY_Fnumber
FINISH_DATE_VARIANCEW_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
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
REMAINING_LABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_TOTAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COSTW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_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
EST_AT_COMPLETION_COSTW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_COSTW_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
PLANNED_VALUE_COSTW_PROJECT_HISTORY_Fnumber
ACTUAL_COSTW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_COSTW_PROJECT_HISTORY_Fnumber
PROJECT_RISK_SCOREW_PROJECT_HISTORY_Fnumber
PROJECT_RISK_EXPOSUREW_PROJECT_HISTORY_Fnumber
NOT_STARTED_ACTIVITY_COUNTW_PROJECT_HISTORY_Finteger
IN_PROGRESS_ACTIVITY_COUNTW_PROJECT_HISTORY_Finteger
COMPLETED_ACTIVITY_COUNTW_PROJECT_HISTORY_Finteger
NEW_ACTIVITY_COUNTW_PROJECT_HISTORY_Finteger
ACTUAL_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
EST_AT_COMPL_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
PLANNED_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
PLANNED_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
REMAINING_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
REM_LATE_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
ACTUAL_COST_PW_PROJECT_HISTORY_Fnumber
ACTUAL_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
ACTUAL_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
ACTUAL_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
ACTUAL_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
ACTUAL_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
EARNED_VALUE_COST_PW_PROJECT_HISTORY_Fnumber
EST_AT_COMPLETION_COST_PW_PROJECT_HISTORY_Fnumber
EST_TO_COMPLETE_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
PLANNED_VALUE_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
REMAINING_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
BL_PLANNED_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COST_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_LABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_LABOR_COST_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_NONLABOR_UNITS_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_NONLABOR_COST_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_MATERIAL_COST_PW_PROJECT_HISTORY_Fnumber
NEXT_PER_EXPENSE_COST_PW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_LABOR_UNITSW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_LABOR_COSTW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_UNITSW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_COSTW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_MATERIAL_COSTW_PROJECT_HISTORY_Fnumber
PREV_THIS_PER_EXPENSE_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_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_PROJECT_SECURITY_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
USER_NAMEW_PROJECT_SECURITY_Sstring
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_PROJECT_SECURITY_SSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
rdbmsuseridW_PROJECT_SECURITY_SSbigint
costflagW_PROJECT_SECURITY_SSstring
projectobjectidW_PROJECT_SECURITY_SSbigint
W_PROJECTCODE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_PROJECTCODE_DSintegerProjectCode - ObjectId maps to PCATVAL.proj_catg_id
codetypeobjectidW_PROJECTCODE_DSintegerProjectCode - CodeTypeObjectId maps to PCATVAL.proj_catg_type_id
sequencenumberW_PROJECTCODE_DSintegerProjectCode - SequenceNumber maps to PCATVAL.seq_num
codevalueW_PROJECTCODE_DSstringProjectCode - CodeValue maps to PCATVAL.proj_catg_short_name
parentobjectidW_PROJECTCODE_DSintegerProjectCode - ParentObjectId maps to PCATVAL.parent_proj_catg_id
descriptionW_PROJECTCODE_DSstringProjectCode - ParentObjectId maps to PCATVAL.proj_catg_name
codetypenameW_PROJECTCODE_DSstringProjectCode - CodeTypeName maps to PCATVAL.proj_catg_type_name
weightW_PROJECTCODE_DSdoubleProjectCodeType - Name maps to ProjectCodeType.proj_catg_type_wt
issecurecodeW_PROJECTCODE_DSstringProjectCode - IsSecureCode maps to PCATVAL.IsSecureCode
lastupdateuserW_PROJECTCODE_DSstringLast Update User
lastupdatedateW_PROJECTCODE_DSdateLast Update Date
createuserW_PROJECTCODE_DSstringCreate User
createdateW_PROJECTCODE_DSdateCreate Date
W_PROJECTCODEASSIGNMENT_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
projectobjectidW_PROJECTCODEASSIGNMENT_DSintegerProjectCodeAssignment - ProjectObjectId maps to PROJPCAT.proj_id
projectcodetypeobjectidW_PROJECTCODEASSIGNMENT_DSintegerProjectCodeAssignment - ProjectCodetypeObjectId maps to PROJPCAT.proj_catg_type_id
projectcodeobjectidW_PROJECTCODEASSIGNMENT_DSintegerProjectCodeAssignment - ProjectCodeObjectId maps to PROJPCAT.proj_catg_id
lastupdateuserW_PROJECTCODEASSIGNMENT_DSstringLast Update User
lastupdatedateW_PROJECTCODEASSIGNMENT_DSdateLast Update Date
createuserW_PROJECTCODEASSIGNMENT_DSstringCreate User
createdateW_PROJECTCODEASSIGNMENT_DSdateCreate Date
W_PROJECTCODETYPE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_PROJECTCODETYPE_DSintegerProjectCodeType - ObjectId maps to ProjectCodeType.proj_catg_type_id
lengthW_PROJECTCODETYPE_DSintegerProjectCodeType - Length maps to ProjectCodeType.proj_catg_short_len
sequencenumberW_PROJECTCODETYPE_DSintegerProjectCodeType - SequenceNumber maps to ProjectCodeType.seq_num
nameW_PROJECTCODETYPE_DSstringProjectCodeType - Name maps to ProjectCodeType.proj_catg_type
issecurecodeW_PROJECTCODETYPE_DSstringProjectCodeType - Name maps to ProjectCodeType.super_flag
weightW_PROJECTCODETYPE_DSdoubleProjectCodeType - Name maps to ProjectCodeType.proj_catg_type_wt
maxcodevalueweightW_PROJECTCODETYPE_DSdoubleProjectCodeType - Name maps to ProjectCodeType.max_proj_catg_wt
lastupdateuserW_PROJECTCODETYPE_DSstringLast Update User
lastupdatedateW_PROJECTCODETYPE_DSdateLast Update Date
createuserW_PROJECTCODETYPE_DSstringCreate User
createdateW_PROJECTCODETYPE_DSdateCreate Date
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
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
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_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
LOCATION_IDW_RESOURCE_Dbigint
LOCATION_NAMEW_RESOURCE_Dstring
LOCATION_TYPEW_RESOURCE_Dstring
ADDRESS_LINE1W_RESOURCE_Dstring
ADDRESS_LINE2W_RESOURCE_Dstring
ADDRESS_LINE3W_RESOURCE_Dstring
CITY_NAMEW_RESOURCE_Dstring
MUNICIPALITY_NAMEW_RESOURCE_Dstring
STATE_NAMEW_RESOURCE_Dstring
STATE_CODEW_RESOURCE_Dstring
COUNTRY_NAMEW_RESOURCE_Dstring
COUNTRY_CODEW_RESOURCE_Dstring
POSTAL_CODEW_RESOURCE_Dstring
LONGITUDEW_RESOURCE_Dnumber
LATITUDEW_RESOURCE_Dnumber
W_RESOURCE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_OBJECT_IDW_RESOURCE_DSbigint
ACTIVE_FLAGW_RESOURCE_DSstring
RESOURCE_TYPEW_RESOURCE_DSstring
RESOURCE_IDW_RESOURCE_DSstring
RESOURCE_NAMEW_RESOURCE_DSstring
EMPLOYEE_CODEW_RESOURCE_DSstring
RESOURCE_TITLEW_RESOURCE_DSstring
CALENDAR_OBJECT_IDW_RESOURCE_DSbigint
CALENDAR_NAMEW_RESOURCE_DSstring
CURRENCY_NAMEW_RESOURCE_DSstring
PRIMARY_ROLE_NAMEW_RESOURCE_DSstring
TIMESHEET_APPROVAL_MANAGERW_RESOURCE_DSstring
USER_NAMEW_RESOURCE_DSstring
LOCATION_IDW_RESOURCE_DSbigint
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_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
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_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
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_RESOURCE_SECURITY_STop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RESOURCE_SEC_KEYW_RESOURCE_SECURITY_Sbigint
USER_NAMEW_RESOURCE_SECURITY_Sstring
SECURITY_TYPEW_RESOURCE_SECURITY_Sstring
RESOURCE_WIDW_RESOURCE_SECURITY_Sbigint
RESOURCE_OBJECT_IDW_RESOURCE_SECURITY_Sbigint
DATASOURCE_IDW_RESOURCE_SECURITY_Sbigint
W_RESOURCE_SECURITY_SSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RDBMSUSERIDW_RESOURCE_SECURITY_SSbigint
RESOURCEOBJECTIDW_RESOURCE_SECURITY_SSbigint
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_RESOURCECODE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_RESOURCECODE_DSintegerResourceCode - ObjectId maps to RCATVAL.rsrc_catg_id
codetypeobjectidW_RESOURCECODE_DSintegerResourceCode - CodeTypeObjectId maps to RCATVAL.rsrc_catg_type_id
sequencenumberW_RESOURCECODE_DSintegerResourceCode - SequenceNumber maps to RCATVAL.seq_num
codevalueW_RESOURCECODE_DSstringResourceCode - CodeValue maps to RCATVAL.rsrc_catg_short_name
parentobjectidW_RESOURCECODE_DSintegerResourceCode - ParentObjectId maps to RCATVAL.parent_rsrc_catg_id
descriptionW_RESOURCECODE_DSstringResourceCode - ParentObjectId maps to RCATVAL.rsrc_catg_name
codetypenameW_RESOURCECODE_DSstringResourceCode - CodeTypeName maps to RCATVAL.rsrc_catg_type_name
issecurecodeW_RESOURCECODE_DSstringResourceCode - IsSecureCode maps to RCATVAL.IsSecureCode
lastupdateuserW_RESOURCECODE_DSstringLast Update User
lastupdatedateW_RESOURCECODE_DSdateLast Update Date
createuserW_RESOURCECODE_DSstringCreate User
createdateW_RESOURCECODE_DSdateCreate Date
W_RESOURCECODEASSIGNMENT_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
resourceobjectidW_RESOURCECODEASSIGNMENT_DSintegerResourceCodeAssignment - ResourceObjectId maps to RSRCRCAT.rsrc_id
resourcecodetypeobjectidW_RESOURCECODEASSIGNMENT_DSintegerResourceCodeAssignment - ResourceCodetypeObjectId maps to RSRCRCAT.rsrc_catg_type_id
resourcecodeobjectidW_RESOURCECODEASSIGNMENT_DSintegerResourceCodeAssignment - ResourceCodeObjectId maps to RSRCRCAT.rsrc_catg_id
lastupdateuserW_RESOURCECODEASSIGNMENT_DSstringLast Update User
lastupdatedateW_RESOURCECODEASSIGNMENT_DSdateLast Update Date
createuserW_RESOURCECODEASSIGNMENT_DSstringCreate User
createdateW_RESOURCECODEASSIGNMENT_DSdateCreate Date
W_RESOURCECODETYPE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_RESOURCECODETYPE_DSintegerResourceCodeType - ObjectId maps to ResourceCodeType.rsrc_catg_type_id
lengthW_RESOURCECODETYPE_DSintegerResourceCodeType - Length maps to ResourceCodeType.rsrc_catg_short_len
sequencenumberW_RESOURCECODETYPE_DSintegerResourceCodeType - SequenceNumber maps to ResourceCodeType.seq_num
nameW_RESOURCECODETYPE_DSstringResourceCodeType - Name maps to ResourceCodeType.rsrc_catg_type
issecurecodeW_RESOURCECODETYPE_DSstringResourceCodeType - Name maps to ResourceCodeType.super_flag
lastupdateuserW_RESOURCECODETYPE_DSstringLast Update User
lastupdatedateW_RESOURCECODETYPE_DSdateLast Update Date
createuserW_RESOURCECODETYPE_DSstringCreate User
createdateW_RESOURCECODETYPE_DSdateCreate Date
W_RISK_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_RISK_Dbigint
PROJECT_WIDW_RISK_Dbigint
EPS_WIDW_RISK_Dbigint
IDENTIFIED_BY_RESOURCE_WIDW_RISK_Dbigint
OWNER_RESOURCE_WIDW_RISK_Dbigint
RISK_OBJECT_IDW_RISK_Dbigint
PROJECT_OBJECT_IDW_RISK_Dbigint
RISK_CATEGORY_OBJECT_IDW_RISK_Dbigint
RESOURCE_OBJECT_IDW_RISK_Dbigint
RISK_IDW_RISK_Dstring
RISK_NAMEW_RISK_Dstring
OWNERW_RISK_Dstring
RISK_TYPEW_RISK_Dstring
RISK_STATUSW_RISK_Dstring
CATEGORYW_RISK_Dstring
SCOREW_RISK_Dnumber
TOTAL_COSTW_RISK_Dnumber
ExposureW_RISK_Dnumber
IDENTIFIED_BY_RSRC_OBJECT_IDW_RISK_Dbigint
IDENTIFIED_BY_RESOURCE_IDW_RISK_Dstring
IDENTIFIED_BY_RESOURCE_NAMEW_RISK_Dstring
IDENTIFIED_DATEW_RISK_Ddate
W_UPDATE_DTW_RISK_Ddate
W_CREATE_DTW_RISK_Ddate
DELETE_FLAGW_RISK_Dstring
DATASOURCE_IDW_RISK_Dbigint
W_RISK_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RISK_OBJECT_IDW_RISK_DSbigint
PROJECT_OBJECT_IDW_RISK_DSbigint
RISK_CATEGORY_OBJECT_IDW_RISK_DSbigint
RESOURCE_OBJECT_IDW_RISK_DSbigint
RISK_IDW_RISK_DSstring
RISK_NAMEW_RISK_DSstring
OWNERW_RISK_DSstring
RISK_TYPEW_RISK_DSstring
RISK_STATUSW_RISK_DSstring
CATEGORYW_RISK_DSstring
SCOREW_RISK_DSnumber
TOTAL_COSTW_RISK_DSnumber
ExposureW_RISK_DSnumber
IDENTIFIED_BY_RSRC_OBJECT_IDW_RISK_DSbigint
IDENTIFIED_BY_RESOURCE_IDW_RISK_DSstring
IDENTIFIED_BY_RESOURCE_NAMEW_RISK_DSstring
IDENTIFIED_DATEW_RISK_DSdate
W_UPDATE_DTW_RISK_DSdate
W_CREATE_DTW_RISK_DSdate
DELETE_FLAGW_RISK_DSstring
W_RISKTYPE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
RISKTYPE_OBJECT_IDW_RISKTYPE_DSbigint
RISK_TYPEW_RISKTYPE_DSstring
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_ROLE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROLE_SHORT_NAMEW_ROLE_DSstring
ROLE_NAMEW_ROLE_DSstring
ROLE_OBJECT_IDW_ROLE_DSinteger
W_UDF_ACTIVITY_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ACTIVITY_WIDW_UDF_ACTIVITY_Fbigint
DATASOURCE_IDW_UDF_ACTIVITY_Fbigint
ACTIVITY_OBJECT_IDW_UDF_ACTIVITY_Finteger
WBS_WIDW_UDF_ACTIVITY_Fbigint
EPS_WIDW_UDF_ACTIVITY_Fbigint
PROJECT_WIDW_UDF_ACTIVITY_Fbigint
UDF_NUMBER_1W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_2W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_3W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_4W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_5W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_6W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_7W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_8W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_9W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_10W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_11W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_12W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_13W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_14W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_15W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_16W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_17W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_18W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_19W_UDF_ACTIVITY_Fnumber
UDF_NUMBER_20W_UDF_ACTIVITY_Fnumber
UDF_COST_1W_UDF_ACTIVITY_Fnumber
UDF_COST_2W_UDF_ACTIVITY_Fnumber
UDF_COST_3W_UDF_ACTIVITY_Fnumber
UDF_COST_4W_UDF_ACTIVITY_Fnumber
UDF_COST_5W_UDF_ACTIVITY_Fnumber
UDF_COST_6W_UDF_ACTIVITY_Fnumber
UDF_COST_7W_UDF_ACTIVITY_Fnumber
UDF_COST_8W_UDF_ACTIVITY_Fnumber
UDF_COST_9W_UDF_ACTIVITY_Fnumber
UDF_COST_10W_UDF_ACTIVITY_Fnumber
UDF_COST_11W_UDF_ACTIVITY_Fnumber
UDF_COST_12W_UDF_ACTIVITY_Fnumber
UDF_COST_13W_UDF_ACTIVITY_Fnumber
UDF_COST_14W_UDF_ACTIVITY_Fnumber
UDF_COST_15W_UDF_ACTIVITY_Fnumber
UDF_COST_16W_UDF_ACTIVITY_Fnumber
UDF_COST_17W_UDF_ACTIVITY_Fnumber
UDF_COST_18W_UDF_ACTIVITY_Fnumber
UDF_COST_19W_UDF_ACTIVITY_Fnumber
UDF_COST_20W_UDF_ACTIVITY_Fnumber
W_UDF_PROJECT_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
PROJECT_WIDW_UDF_PROJECT_Fbigint
DATASOURCE_IDW_UDF_PROJECT_Fbigint
PROJECT_OBJECT_IDW_UDF_PROJECT_Finteger
EPS_WIDW_UDF_PROJECT_Fbigint
UDF_NUMBER_1W_UDF_PROJECT_Fnumber
UDF_NUMBER_2W_UDF_PROJECT_Fnumber
UDF_NUMBER_3W_UDF_PROJECT_Fnumber
UDF_NUMBER_4W_UDF_PROJECT_Fnumber
UDF_NUMBER_5W_UDF_PROJECT_Fnumber
UDF_NUMBER_6W_UDF_PROJECT_Fnumber
UDF_NUMBER_7W_UDF_PROJECT_Fnumber
UDF_NUMBER_8W_UDF_PROJECT_Fnumber
UDF_NUMBER_9W_UDF_PROJECT_Fnumber
UDF_NUMBER_10W_UDF_PROJECT_Fnumber
UDF_NUMBER_11W_UDF_PROJECT_Fnumber
UDF_NUMBER_12W_UDF_PROJECT_Fnumber
UDF_NUMBER_13W_UDF_PROJECT_Fnumber
UDF_NUMBER_14W_UDF_PROJECT_Fnumber
UDF_NUMBER_15W_UDF_PROJECT_Fnumber
UDF_NUMBER_16W_UDF_PROJECT_Fnumber
UDF_NUMBER_17W_UDF_PROJECT_Fnumber
UDF_NUMBER_18W_UDF_PROJECT_Fnumber
UDF_NUMBER_19W_UDF_PROJECT_Fnumber
UDF_NUMBER_20W_UDF_PROJECT_Fnumber
UDF_COST_1W_UDF_PROJECT_Fnumber
UDF_COST_2W_UDF_PROJECT_Fnumber
UDF_COST_3W_UDF_PROJECT_Fnumber
UDF_COST_4W_UDF_PROJECT_Fnumber
UDF_COST_5W_UDF_PROJECT_Fnumber
UDF_COST_6W_UDF_PROJECT_Fnumber
UDF_COST_7W_UDF_PROJECT_Fnumber
UDF_COST_8W_UDF_PROJECT_Fnumber
UDF_COST_9W_UDF_PROJECT_Fnumber
UDF_COST_10W_UDF_PROJECT_Fnumber
UDF_COST_11W_UDF_PROJECT_Fnumber
UDF_COST_12W_UDF_PROJECT_Fnumber
UDF_COST_13W_UDF_PROJECT_Fnumber
UDF_COST_14W_UDF_PROJECT_Fnumber
UDF_COST_15W_UDF_PROJECT_Fnumber
UDF_COST_16W_UDF_PROJECT_Fnumber
UDF_COST_17W_UDF_PROJECT_Fnumber
UDF_COST_18W_UDF_PROJECT_Fnumber
UDF_COST_19W_UDF_PROJECT_Fnumber
UDF_COST_20W_UDF_PROJECT_Fnumber
W_UDF_WBS_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
WBS_WIDW_UDF_WBS_Fbigint
DATASOURCE_IDW_UDF_WBS_Fbigint
WBS_OBJECT_IDW_UDF_WBS_Finteger
EPS_WIDW_UDF_WBS_Fbigint
PROJECT_WIDW_UDF_WBS_Fbigint
UDF_NUMBER_1W_UDF_WBS_Fnumber
UDF_NUMBER_2W_UDF_WBS_Fnumber
UDF_NUMBER_3W_UDF_WBS_Fnumber
UDF_NUMBER_4W_UDF_WBS_Fnumber
UDF_NUMBER_5W_UDF_WBS_Fnumber
UDF_NUMBER_6W_UDF_WBS_Fnumber
UDF_NUMBER_7W_UDF_WBS_Fnumber
UDF_NUMBER_8W_UDF_WBS_Fnumber
UDF_NUMBER_9W_UDF_WBS_Fnumber
UDF_NUMBER_10W_UDF_WBS_Fnumber
UDF_NUMBER_11W_UDF_WBS_Fnumber
UDF_NUMBER_12W_UDF_WBS_Fnumber
UDF_NUMBER_13W_UDF_WBS_Fnumber
UDF_NUMBER_14W_UDF_WBS_Fnumber
UDF_NUMBER_15W_UDF_WBS_Fnumber
UDF_NUMBER_16W_UDF_WBS_Fnumber
UDF_NUMBER_17W_UDF_WBS_Fnumber
UDF_NUMBER_18W_UDF_WBS_Fnumber
UDF_NUMBER_19W_UDF_WBS_Fnumber
UDF_NUMBER_20W_UDF_WBS_Fnumber
UDF_COST_1W_UDF_WBS_Fnumber
UDF_COST_2W_UDF_WBS_Fnumber
UDF_COST_3W_UDF_WBS_Fnumber
UDF_COST_4W_UDF_WBS_Fnumber
UDF_COST_5W_UDF_WBS_Fnumber
UDF_COST_6W_UDF_WBS_Fnumber
UDF_COST_7W_UDF_WBS_Fnumber
UDF_COST_8W_UDF_WBS_Fnumber
UDF_COST_9W_UDF_WBS_Fnumber
UDF_COST_10W_UDF_WBS_Fnumber
UDF_COST_11W_UDF_WBS_Fnumber
UDF_COST_12W_UDF_WBS_Fnumber
UDF_COST_13W_UDF_WBS_Fnumber
UDF_COST_14W_UDF_WBS_Fnumber
UDF_COST_15W_UDF_WBS_Fnumber
UDF_COST_16W_UDF_WBS_Fnumber
UDF_COST_17W_UDF_WBS_Fnumber
UDF_COST_18W_UDF_WBS_Fnumber
UDF_COST_19W_UDF_WBS_Fnumber
UDF_COST_20W_UDF_WBS_Fnumber
W_UDFTYPE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
objectidW_UDFTYPE_DSintegerUDFTYPE - ObjectId maps to UDFTYPE.udf_type_id
SubjectAreaW_UDFTYPE_DSstringUDFTYPE - SubjectArea maps to UDFTYPE.table_name
TitleW_UDFTYPE_DSstringUDFTYPE - Title maps to UDFTYPE.udf_type_label
DataTypeW_UDFTYPE_DSstringUDFTYPE - DataType maps to UDFTYPE.logical_data_type
issecurecodeW_UDFTYPE_DSstringUDFTYPE - IsSecureCode maps to UDFTYPE.super_flag
lastupdateuserW_UDFTYPE_DSstringLast Update User
lastupdatedateW_UDFTYPE_DSdateLast Update Date
createuserW_UDFTYPE_DSstringCreate User
createdateW_UDFTYPE_DSdateCreate Date
W_UDFVALUE_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
udftypeobjectidW_UDFVALUE_DSintegerUDFVALUE - UDFTypeObjectId maps to UDFVALUE.udf_type_id
foreignobjectidW_UDFVALUE_DSintegerUDFVALUE - ForeignObjectId maps to UDFVALUE.fk_id
projectobjectidW_UDFVALUE_DSintegerUDFVALUE - ProjectObjectId maps to UDFVALUE.proj_id
udfnumberW_UDFVALUE_DSnumberUDFVALUE - Title maps to UDFTYPE.udf_number
SubjectAreaW_UDFVALUE_DSstringUDFVALUE - SubjectArea maps to UDFTYPE.table_name
DataTypeW_UDFVALUE_DSstringUDFVALUE - DataType maps to UDFTYPE.logical_data_type
issecurecodeW_UDFVALUE_DSstringUDFVALUE - IsSecureCode maps to UDFTYPE.super_flag
lastupdateuserW_UDFVALUE_DSstringLast Update User
lastupdatedateW_UDFVALUE_DSdateLast Update Date
createuserW_UDFVALUE_DSstringCreate User
createdateW_UDFVALUE_DSdateCreate Date
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
ISRESOURCESUPERUSERW_USER_Sstring
ISPROJECTSUPERUSERW_USER_Sstring
ISSUPERUSERW_USER_Sstring
DATASOURCE_IDW_USER_Sbigint
W_USER_SSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
USER_IDW_USER_SSbigint
USER_NAMEW_USER_SSstring
PROF_IDW_USER_SSbigint
REPORTINGFLAGW_USER_SSstring
ALLRESOURCEACCESSFLAGW_USER_SSstring
ISSUPERUSERW_USER_SSstring
USER_WIDW_USER_SSbigint
W_USERMODULEACCESS_SSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
OBJECTIDW_USERMODULEACCESS_SSbigint
USEROBJECTIDW_USERMODULEACCESS_SSbigint
MODULETYPECODEW_USERMODULEACCESS_SSstring
W_WBS_DTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
ROW_WIDW_WBS_Dbigint
PARENT_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
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
FINISH_DATEW_WBS_Ddate
FORECAST_START_DATEW_WBS_Ddate
FORECAST_FINISH_DATEW_WBS_Ddate
FULLNAMEW_WBS_Dstring
OBSNAMEW_WBS_Dstring
PROJECTIDW_WBS_Dstring
START_DATEW_WBS_Ddate
CUSTOM_1W_WBS_Dstring
CUSTOM_2W_WBS_Dstring
CUSTOM_3W_WBS_Dstring
CUSTOM_4W_WBS_Dstring
CUSTOM_5W_WBS_Dstring
ACTUAL_START_DATEW_WBS_Ddate
ACTUAL_FINISH_DATEW_WBS_Ddate
BASELINE_START_DATEW_WBS_Ddate
BASELINE_FINISH_DATEW_WBS_Ddate
PLANNED_START_DATEW_WBS_Ddate
PLANNED_FINISH_DATEW_WBS_Ddate
PROGRESS_FINISH_DATEW_WBS_Ddate
REMAINING_START_DATEW_WBS_Ddate
REMAINING_FINISH_DATEW_WBS_Ddate
PLANNED_DURATIONW_WBS_Dnumber
ACTUAL_DURATIONW_WBS_Dnumber
AT_COMPLETION_DURATIONW_WBS_Dnumber
BASELINE_DURATIONW_WBS_Dnumber
REMAINING_DURATIONW_WBS_Dnumber
DURATION_PERCENT_COMPLETEW_WBS_Dnumber
DURATION_PERCENT_OF_PLANNEDW_WBS_Dnumber
DURATION_VARIANCEW_WBS_Dnumber
ACTUAL_LABOR_UNITSW_WBS_Dnumber
ACTUAL_NONLABOR_UNITSW_WBS_Dnumber
AT_COMPLETION_LABOR_UNITSW_WBS_Dnumber
AT_COMPLETION_NONLABOR_UNITSW_WBS_Dnumber
EARNED_VALUE_LABOR_UNITSW_WBS_Dnumber
EST_AT_COMPLETION_LABOR_UNITSW_WBS_Dnumber
EST_TO_COMPLETE_LABOR_UNITSW_WBS_Dnumber
PLANNED_LABOR_UNITSW_WBS_Dnumber
PLANNED_NONLABOR_UNITSW_WBS_Dnumber
PLANNED_VALUE_LABOR_UNITSW_WBS_Dnumber
REMAINING_LABOR_UNITSW_WBS_Dnumber
REMAINING_NONLABOR_UNITSW_WBS_Dnumber
BL_PLANNED_LABOR_UNITSW_WBS_Dnumber
BL_PLANNED_NONLABOR_UNITSW_WBS_Dnumber
ACCOUNTING_VAR_BY_LABOR_UNITSW_WBS_Dnumber
BAC_BY_LABOR_UNITSW_WBS_Dnumber
LABOR_UNITS_PERCENT_COMPLETEW_WBS_Dnumber
ACTUAL_VALUE_BY_LABOR_UNITSW_WBS_Dnumber
FINISH_DATE_VARIANCEW_WBS_Dnumber
LABOR_UNITS_VARIANCEW_WBS_Dnumber
NONLABOR_UNITS_VARIANCEW_WBS_Dnumber
SCHEDULE_PERCENT_COMPLETEW_WBS_Dnumber
PERFORMANCE_PERCENT_COMPLETEW_WBS_Dnumber
START_DATE_VARIANCEW_WBS_Dnumber
TOTAL_FLOATW_WBS_Dnumber
UNITS_PERCENT_COMPLETEW_WBS_Dnumber
NONLABOR_UNITS_PCT_COMPLETEW_WBS_Dnumber
PERF_PCT_CMP_BY_LABOR_UNITSW_WBS_Dnumber
SCHD_PCT_CMP_BY_LABOR_UNITSW_WBS_Dnumber
SCHEDULE_VAR_BY_LABOR_UNITSW_WBS_Dnumber
VARIANCE_AT_CMP_BY_LABOR_UNITSW_WBS_Dnumber
ORIG_COSTW_WBS_Ddouble
INDEP_REMAIN_TOTAL_COSTW_WBS_Ddouble
CURRENTBUDGETW_WBS_Dnumber
CURRENTVARIANCEW_WBS_Dnumber
DISTRIBUTEDCURRENTBUDGETW_WBS_Dnumber
PROPOSEDBUDGETW_WBS_Dnumber
TOTALBENEFITPLANW_WBS_Dnumber
TOTALBENEFITPLANTALLYW_WBS_Dnumber
TOTALSPENDINGPLANW_WBS_Dnumber
TOTALSPENDINGPLANTALLYW_WBS_Dnumber
UNALLOCATEDBUDGETW_WBS_Dnumber
UNDISTRIBUTEDCURRENTVARIANCEW_WBS_Dnumber
ACCOUNTING_VARIANCE_BY_COSTW_WBS_Dnumber
BUDGET_AT_COMPLETION_BY_COSTW_WBS_Dnumber
EST_AT_COMPLETION_COSTW_WBS_Dnumber
EST_TO_COMPLETE_COSTW_WBS_Dnumber
PLANNED_EXPENSE_COSTW_WBS_Dnumber
PLANNED_LABOR_COSTW_WBS_Dnumber
PLANNED_MATERIAL_COSTW_WBS_Dnumber
PLANNED_NONLABOR_COSTW_WBS_Dnumber
PLANNED_TOTAL_COSTW_WBS_Dnumber
ACTUAL_EXPENSE_COSTW_WBS_Dnumber
ACTUAL_LABOR_COSTW_WBS_Dnumber
ACTUAL_MATERIAL_COSTW_WBS_Dnumber
ACTUAL_NONLABOR_COSTW_WBS_Dnumber
ACTUAL_TOTAL_COSTW_WBS_Dnumber
ACTUAL_COSTW_WBS_Dnumber
AT_COMPLETION_EXPENSE_COSTW_WBS_Dnumber
AT_COMPLETION_LABOR_COSTW_WBS_Dnumber
AT_COMPLETION_MATERIAL_COSTW_WBS_Dnumber
AT_COMPLETION_NONLABOR_COSTW_WBS_Dnumber
AT_COMPLETION_TOTAL_COSTW_WBS_Dnumber
BL_PLANNED_EXPENSE_COSTW_WBS_Dnumber
BL_PLANNED_LABOR_COSTW_WBS_Dnumber
BL_PLANNED_MATERIAL_COSTW_WBS_Dnumber
BL_PLANNED_NONLABOR_COSTW_WBS_Dnumber
BL_PLANNED_TOTAL_COSTW_WBS_Dnumber
REMAINING_LABOR_COSTW_WBS_Dnumber
REMAINING_MATERIAL_COSTW_WBS_Dnumber
REMAINING_EXPENSE_COSTW_WBS_Dnumber
REMAINING_NONLABOR_COSTW_WBS_Dnumber
REMAINING_TOTAL_COSTW_WBS_Dnumber
EARNED_VALUE_COSTW_WBS_Dnumber
PLANNED_VALUE_COSTW_WBS_Dnumber
EXPENSE_COST_PERCENT_COMPLETEW_WBS_Dnumber
LABOR_COST_PERCENT_COMPLETEW_WBS_Dnumber
COST_PERCENT_COMPLETEW_WBS_Dnumber
COST_PCT_CMP_OF_PLANNEDW_WBS_Dnumber
MATERIAL_COST_PERCENT_COMPLETEW_WBS_Dnumber
NONLABOR_COST_PERCENT_COMPLETEW_WBS_Dnumber
COST_VARIANCEW_WBS_Dnumber
EXPENSE_COST_VARIANCEW_WBS_Dnumber
LABOR_COST_VARIANCEW_WBS_Dnumber
NONLABOR_COST_VARIANCEW_WBS_Dnumber
MATERIAL_COST_VARIANCEW_WBS_Dnumber
TOTAL_COST_VARIANCEW_WBS_Dnumber
SCHEDULE_VARIANCE_BY_COSTW_WBS_Dnumber
AT_COMPLETION_TOTAL_COST_VARW_WBS_Dnumber
W_UPDATE_DTW_WBS_Ddate
W_CREATE_DTW_WBS_Ddate
DELETE_FLAGW_WBS_Dstring
DATASOURCE_IDW_WBS_Dbigint
W_WBS_DSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
WBS_OBJECT_IDW_WBS_DSbigint
PROJECT_OBJECT_IDW_WBS_DSbigint
PARENT_OBJECT_IDW_WBS_DSbigint
WBS_SHORT_NAMEW_WBS_DSstring
WBS_NAMEW_WBS_DSstring
OBS_OBJECT_IDW_WBS_DSinteger
SEQ_NUMW_WBS_DSinteger
SUM_DATA_FLAGW_WBS_DSstring
PROJECT_WBS_FLAGW_WBS_DSstring
STATUS_CODEW_WBS_DSstring
EV_USER_PCTW_WBS_DSdouble
EV_ETC_USER_VALUEW_WBS_DSdouble
ORIG_COSTW_WBS_DSdouble
INDEP_REMAIN_TOTAL_COSTW_WBS_DSdouble
INDEP_REMAIN_WORK_QTYW_WBS_DSdouble
ANTICIP_START_DATEW_WBS_DSdate
ANTICIP_END_DATEW_WBS_DSdate
EV_COMPUTE_TYPEW_WBS_DSstring
EV_ETC_COMPUTE_TYPEW_WBS_DSstring
CURRENTBUDGETW_WBS_DSnumber
CURRENTVARIANCEW_WBS_DSnumber
DISTRIBUTEDCURRENTBUDGETW_WBS_DSnumber
FINISHDATEW_WBS_DSdate
FORECAST_FINISH_DATEW_WBS_DSdate
FORECAST_START_DATEW_WBS_DSdate
FULLNAMEW_WBS_DSstring
OBSNAMEW_WBS_DSstring
PROJECTIDW_WBS_DSstring
PROPOSEDBUDGETW_WBS_DSnumber
PLANNED_START_DATEW_WBS_DSdate
PLANNED_FINISH_DATEW_WBS_DSdate
PLANNED_DURATIONW_WBS_DSnumber
STARTDATEW_WBS_DSdate
ACTUAL_START_DATEW_WBS_DSdate
ACTUAL_FINISH_DATEW_WBS_DSdate
BASELINE_START_DATEW_WBS_DSdate
BASELINE_FINISH_DATEW_WBS_DSdate
PROGRESS_FINISH_DATEW_WBS_DSdate
REMAINING_START_DATEW_WBS_DSdate
REMAINING_FINISH_DATEW_WBS_DSdate
ACTUAL_DURATIONW_WBS_DSnumber
AT_COMPLETION_DURATIONW_WBS_DSnumber
BASELINE_DURATIONW_WBS_DSnumber
REMAINING_DURATIONW_WBS_DSnumber
DURATION_PERCENT_COMPLETEW_WBS_DSnumber
DURATION_PERCENT_OF_PLANNEDW_WBS_DSnumber
DURATION_VARIANCEW_WBS_DSnumber
ACTUAL_LABOR_UNITSW_WBS_DSnumber
ACTUAL_NONLABOR_UNITSW_WBS_DSnumber
AT_COMPLETION_LABOR_UNITSW_WBS_DSnumber
AT_COMPLETION_NONLABOR_UNITSW_WBS_DSnumber
EARNED_VALUE_LABOR_UNITSW_WBS_DSnumber
EST_AT_COMPLETION_LABOR_UNITSW_WBS_DSnumber
EST_TO_COMPLETE_LABOR_UNITSW_WBS_DSnumber
PLANNED_LABOR_UNITSW_WBS_DSnumber
PLANNED_NONLABOR_UNITSW_WBS_DSnumber
PLANNED_VALUE_LABOR_UNITSW_WBS_DSnumber
REMAINING_LABOR_UNITSW_WBS_DSnumber
REMAINING_NONLABOR_UNITSW_WBS_DSnumber
BL_PLANNED_LABOR_UNITSW_WBS_DSnumber
BL_PLANNED_NONLABOR_UNITSW_WBS_DSnumber
ACCOUNTING_VAR_BY_LABOR_UNITSW_WBS_DSnumber
BAC_BY_LABOR_UNITSW_WBS_DSnumber
LABOR_UNITS_PERCENT_COMPLETEW_WBS_DSnumber
ACTUAL_VALUE_BY_LABOR_UNITSW_WBS_DSnumber
FINISH_DATE_VARIANCEW_WBS_DSnumber
LABOR_UNITS_VARIANCEW_WBS_DSnumber
NONLABOR_UNITS_VARIANCEW_WBS_DSnumber
SCHEDULE_PERCENT_COMPLETEW_WBS_DSnumber
PERFORMANCE_PERCENT_COMPLETEW_WBS_DSnumber
START_DATEW_WBS_DSdate
FINISH_DATEW_WBS_DSdate
START_DATE_VARIANCEW_WBS_DSnumber
TOTAL_FLOATW_WBS_DSnumber
UNITS_PERCENT_COMPLETEW_WBS_DSnumber
NONLABOR_UNITS_PCT_COMPLETEW_WBS_DSnumber
PERF_PCT_CMP_BY_LABOR_UNITSW_WBS_DSnumber
SCHD_PCT_CMP_BY_LABOR_UNITSW_WBS_DSnumber
SCHEDULE_VAR_BY_LABOR_UNITSW_WBS_DSnumber
VARIANCE_AT_CMP_BY_LABOR_UNITSW_WBS_DSnumber
COST_VARIANCE_BY_LABOR_UNITSW_WBS_DSnumber
ACCOUNTING_VARIANCE_BY_COSTW_WBS_DSnumber
BUDGET_AT_COMPLETION_BY_COSTW_WBS_DSnumber
EST_AT_COMPLETION_COSTW_WBS_DSnumber
EST_TO_COMPLETE_COSTW_WBS_DSnumber
PLANNED_EXPENSE_COSTW_WBS_DSnumber
PLANNED_LABOR_COSTW_WBS_DSnumber
PLANNED_MATERIAL_COSTW_WBS_DSnumber
PLANNED_NONLABOR_COSTW_WBS_DSnumber
PLANNED_TOTAL_COSTW_WBS_DSnumber
ACTUAL_EXPENSE_COSTW_WBS_DSnumber
ACTUAL_LABOR_COSTW_WBS_DSnumber
ACTUAL_MATERIAL_COSTW_WBS_DSnumber
ACTUAL_NONLABOR_COSTW_WBS_DSnumber
ACTUAL_TOTAL_COSTW_WBS_DSnumber
ACTUAL_COSTW_WBS_DSnumber
AT_COMPLETION_EXPENSE_COSTW_WBS_DSnumber
AT_COMPLETION_LABOR_COSTW_WBS_DSnumber
AT_COMPLETION_MATERIAL_COSTW_WBS_DSnumber
AT_COMPLETION_NONLABOR_COSTW_WBS_DSnumber
AT_COMPLETION_TOTAL_COSTW_WBS_DSnumber
BL_PLANNED_EXPENSE_COSTW_WBS_DSnumber
BL_PLANNED_LABOR_COSTW_WBS_DSnumber
BL_PLANNED_MATERIAL_COSTW_WBS_DSnumber
BL_PLANNED_NONLABOR_COSTW_WBS_DSnumber
BL_PLANNED_TOTAL_COSTW_WBS_DSnumber
REMAINING_LABOR_COSTW_WBS_DSnumber
REMAINING_MATERIAL_COSTW_WBS_DSnumber
REMAINING_EXPENSE_COSTW_WBS_DSnumber
REMAINING_NONLABOR_COSTW_WBS_DSnumber
REMAINING_TOTAL_COSTW_WBS_DSnumber
EARNED_VALUE_COSTW_WBS_DSnumber
PLANNED_VALUE_COSTW_WBS_DSnumber
EXPENSE_COST_PERCENT_COMPLETEW_WBS_DSnumber
LABOR_COST_PERCENT_COMPLETEW_WBS_DSnumber
COST_PERCENT_COMPLETEW_WBS_DSnumber
COST_PCT_CMP_OF_PLANNEDW_WBS_DSnumber
MATERIAL_COST_PERCENT_COMPLETEW_WBS_DSnumber
NONLABOR_COST_PERCENT_COMPLETEW_WBS_DSnumber
COST_VARIANCEW_WBS_DSnumber
EXPENSE_COST_VARIANCEW_WBS_DSnumber
LABOR_COST_VARIANCEW_WBS_DSnumber
NONLABOR_COST_VARIANCEW_WBS_DSnumber
MATERIAL_COST_VARIANCEW_WBS_DSnumber
TOTAL_COST_VARIANCEW_WBS_DSnumber
SCHEDULE_VARIANCE_BY_COSTW_WBS_DSnumber
AT_COMPLETION_TOTAL_COST_VARW_WBS_DSnumber
TOTALBENEFITPLANW_WBS_DSnumber
TOTALBENEFITPLANTALLYW_WBS_DSnumber
TOTALSPENDINGPLANW_WBS_DSnumber
TOTALSPENDINGPLANTALLYW_WBS_DSnumber
UNALLOCATEDBUDGETW_WBS_DSnumber
UNDISTRIBUTEDCURRENTVARIANCEW_WBS_DSnumber
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
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
W_WBS_HISTORY_FTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
WBS_WIDW_WBS_HISTORY_Fbigint
DAY_WIDW_WBS_HISTORY_Fbigint
WBS_OBJECT_IDW_WBS_HISTORY_Fbigint
PROJECT_OBJECT_IDW_WBS_HISTORY_Fbigint
PROJECT_WIDW_WBS_HISTORY_Fbigint
EPS_WIDW_WBS_HISTORY_Fbigint
PERIOD_START_DATEW_WBS_HISTORY_Fdate
PERIOD_END_DATEW_WBS_HISTORY_Fdate
PLANNED_LABOR_UNITSW_WBS_HISTORY_Fnumber
PLANNED_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
ACTUAL_LABOR_UNITSW_WBS_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
REMAINING_LABOR_UNITSW_WBS_HISTORY_Fnumber
REMAINING_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITSW_WBS_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITSW_WBS_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
EST_AT_COMPLETION_LABOR_UNITSW_WBS_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITSW_WBS_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITSW_WBS_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITSW_WBS_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITSW_WBS_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITSW_WBS_HISTORY_Fnumber
PLANNED_START_DATEW_WBS_HISTORY_Fdate
PLANNED_FINISH_DATEW_WBS_HISTORY_Fdate
ACTUAL_START_DATEW_WBS_HISTORY_Fdate
ACTUAL_FINISH_DATEW_WBS_HISTORY_Fdate
REMAINING_START_DATEW_WBS_HISTORY_Fdate
REMAINING_FINISH_DATEW_WBS_HISTORY_Fdate
START_DATEW_WBS_HISTORY_Fdate
FINISH_DATEW_WBS_HISTORY_Fdate
BASELINE_START_DATEW_WBS_HISTORY_Fdate
BASELINE_FINISH_DATEW_WBS_HISTORY_Fdate
PLANNED_DURATIONW_WBS_HISTORY_Fnumber
ACTUAL_DURATIONW_WBS_HISTORY_Fnumber
REMAINING_DURATIONW_WBS_HISTORY_Fnumber
AT_COMPLETION_DURATIONW_WBS_HISTORY_Fnumber
BASELINE_DURATIONW_WBS_HISTORY_Fnumber
TOTAL_FLOATW_WBS_HISTORY_Fnumber
DURATION_PCT_COMPLETEW_WBS_HISTORY_Fnumber
DURATION_PCT_OF_PLANNEDW_WBS_HISTORY_Fnumber
DURATION_VARIANCEW_WBS_HISTORY_Fnumber
UNITS_PCT_COMPLETEW_WBS_HISTORY_Fnumber
LABOR_UNITS_PCT_COMPLETEW_WBS_HISTORY_Fnumber
NONLABOR_UNITS_PCT_COMPLETEW_WBS_HISTORY_Fnumber
SCHEDULE_PCT_COMPLETEW_WBS_HISTORY_Fnumber
PERFORMANCE_PCT_COMPLETEW_WBS_HISTORY_Fnumber
START_DATE_VARIANCEW_WBS_HISTORY_Fnumber
FINISH_DATE_VARIANCEW_WBS_HISTORY_Fnumber
PLANNED_EXPENSE_COSTW_WBS_HISTORY_Fnumber
PLANNED_LABOR_COSTW_WBS_HISTORY_Fnumber
PLANNED_MATERIAL_COSTW_WBS_HISTORY_Fnumber
PLANNED_NONLABOR_COSTW_WBS_HISTORY_Fnumber
PLANNED_TOTAL_COSTW_WBS_HISTORY_Fnumber
ACTUAL_EXPENSE_COSTW_WBS_HISTORY_Fnumber
ACTUAL_LABOR_COSTW_WBS_HISTORY_Fnumber
ACTUAL_MATERIAL_COSTW_WBS_HISTORY_Fnumber
ACTUAL_NONLABOR_COSTW_WBS_HISTORY_Fnumber
ACTUAL_TOTAL_COSTW_WBS_HISTORY_Fnumber
REMAINING_LABOR_COSTW_WBS_HISTORY_Fnumber
REMAINING_MATERIAL_COSTW_WBS_HISTORY_Fnumber
REMAINING_EXPENSE_COSTW_WBS_HISTORY_Fnumber
REMAINING_NONLABOR_COSTW_WBS_HISTORY_Fnumber
REMAINING_TOTAL_COSTW_WBS_HISTORY_Fnumber
REMAINING_LATE_LABOR_COSTW_WBS_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COSTW_WBS_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COSTW_WBS_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COSTW_WBS_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COSTW_WBS_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COSTW_WBS_HISTORY_Fnumber
AT_COMPLETION_LABOR_COSTW_WBS_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COSTW_WBS_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COSTW_WBS_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COSTW_WBS_HISTORY_Fnumber
EST_AT_COMPLETION_COSTW_WBS_HISTORY_Fnumber
EST_TO_COMPLETE_COSTW_WBS_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COSTW_WBS_HISTORY_Fnumber
BL_PLANNED_LABOR_COSTW_WBS_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COSTW_WBS_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COSTW_WBS_HISTORY_Fnumber
BL_PLANNED_TOTAL_COSTW_WBS_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COSTW_WBS_HISTORY_Fnumber
BL_ACTUAL_LABOR_COSTW_WBS_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COSTW_WBS_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COSTW_WBS_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COSTW_WBS_HISTORY_Fnumber
PLANNED_VALUE_COSTW_WBS_HISTORY_Fnumber
ACTUAL_COSTW_WBS_HISTORY_Fnumber
EARNED_VALUE_COSTW_WBS_HISTORY_Fnumber
PROJECT_RISK_SCOREW_WBS_HISTORY_Fnumber
PROJECT_RISK_EXPOSUREW_WBS_HISTORY_Fnumber
NOT_STARTED_ACTIVITY_COUNTW_WBS_HISTORY_Finteger
IN_PROGRESS_ACTIVITY_COUNTW_WBS_HISTORY_Finteger
COMPLETED_ACTIVITY_COUNTW_WBS_HISTORY_Finteger
NEW_ACTIVITY_COUNTW_WBS_HISTORY_Finteger
ACTUAL_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
ACTUAL_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
EARNED_VALUE_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
EST_AT_COMPL_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
EST_TO_COMPLETE_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
PLANNED_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
PLANNED_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
PLANNED_VALUE_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
REMAINING_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
REM_LATE_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
REMAINING_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
BL_PLANNED_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
BL_PLANNED_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
ACTUAL_COST_PW_WBS_HISTORY_Fnumber
ACTUAL_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
ACTUAL_LABOR_COST_PW_WBS_HISTORY_Fnumber
ACTUAL_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
ACTUAL_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
ACTUAL_TOTAL_COST_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_LABOR_COST_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
AT_COMPLETION_TOTAL_COST_PW_WBS_HISTORY_Fnumber
EARNED_VALUE_COST_PW_WBS_HISTORY_Fnumber
EST_AT_COMPLETION_COST_PW_WBS_HISTORY_Fnumber
EST_TO_COMPLETE_COST_PW_WBS_HISTORY_Fnumber
PLANNED_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
PLANNED_LABOR_COST_PW_WBS_HISTORY_Fnumber
PLANNED_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
PLANNED_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
PLANNED_TOTAL_COST_PW_WBS_HISTORY_Fnumber
PLANNED_VALUE_COST_PW_WBS_HISTORY_Fnumber
REMAINING_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LABOR_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_LABOR_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
REMAINING_LATE_TOTAL_COST_PW_WBS_HISTORY_Fnumber
REMAINING_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
REMAINING_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
REMAINING_TOTAL_COST_PW_WBS_HISTORY_Fnumber
BL_PLANNED_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
BL_PLANNED_LABOR_COST_PW_WBS_HISTORY_Fnumber
BL_PLANNED_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
BL_PLANNED_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
BL_PLANNED_TOTAL_COST_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_LABOR_COST_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
BL_ACTUAL_TOTAL_COST_PW_WBS_HISTORY_Fnumber
NEXT_PER_LABOR_UNITS_PW_WBS_HISTORY_Fnumber
NEXT_PER_LABOR_COST_PW_WBS_HISTORY_Fnumber
NEXT_PER_NONLABOR_UNITS_PW_WBS_HISTORY_Fnumber
NEXT_PER_NONLABOR_COST_PW_WBS_HISTORY_Fnumber
NEXT_PER_MATERIAL_COST_PW_WBS_HISTORY_Fnumber
NEXT_PER_EXPENSE_COST_PW_WBS_HISTORY_Fnumber
PREV_THIS_PER_LABOR_UNITSW_WBS_HISTORY_Fnumber
PREV_THIS_PER_LABOR_COSTW_WBS_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_UNITSW_WBS_HISTORY_Fnumber
PREV_THIS_PER_NONLABOR_COSTW_WBS_HISTORY_Fnumber
PREV_THIS_PER_MATERIAL_COSTW_WBS_HISTORY_Fnumber
PREV_THIS_PER_EXPENSE_COSTW_WBS_HISTORY_Fnumber
W_UPDATE_DTW_WBS_HISTORY_Fdate
W_CREATE_DTW_WBS_HISTORY_Fdate
DELETE_FLAGW_WBS_HISTORY_Fstring
DATASOURCE_IDW_WBS_HISTORY_Fbigint
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