STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ROW_WID | W_ACTIVITY_D | | | | | bigint | |
ACTIVITY_ID | W_ACTIVITY_D | | | | | string | |
ACTIVITY_NAME | W_ACTIVITY_D | | | | | string | |
ACTIVITY_OBJECT_ID | W_ACTIVITY_D | | | | | bigint | |
PROJECT_OBJECT_ID | W_ACTIVITY_D | | | | | bigint | |
WBS_OBJECT_ID | W_ACTIVITY_D | | | | | bigint | |
ACTUAL_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_ACTIVITY_D | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
PLANNED_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
PLANNED_NONLABOR_UNITS | W_ACTIVITY_D | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
REMAINING_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
REMAINING_NONLABOR_UNITS | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_ACTIVITY_D | | | | | number | |
REVIEW_FEEDBACK_FLAG | W_ACTIVITY_D | | | | | string | |
AUTO_COMPUTE_ACTUALS_FLAG | W_ACTIVITY_D | | | | | string | |
COMPLETE_PCT_TYPE | W_ACTIVITY_D | | | | | string | |
ACTIVITY_TYPE | W_ACTIVITY_D | | | | | string | |
DURATION_TYPE | W_ACTIVITY_D | | | | | string | |
REVIEW_TYPE | W_ACTIVITY_D | | | | | string | |
ACTIVITY_STATUS | W_ACTIVITY_D | | | | | string | |
TOTAL_FLOAT | W_ACTIVITY_D | | | | | double | |
FREE_FLOAT | W_ACTIVITY_D | | | | | double | |
REMAINING_DURATION | W_ACTIVITY_D | | | | | double | |
PLANNED_DURATION | W_ACTIVITY_D | | | | | double | |
PRIMARY_CONSTRAINT_DATE | W_ACTIVITY_D | | | | | date | |
ACTUAL_START_DATE | W_ACTIVITY_D | | | | | date | |
ACTUAL_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
LATE_START_DATE | W_ACTIVITY_D | | | | | date | |
LATE_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
EXPECT_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
EARLY_START_DATE | W_ACTIVITY_D | | | | | date | |
EARLY_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
REMAINING_START_DATE | W_ACTIVITY_D | | | | | date | |
REMAINING_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
PLANNED_START_DATE | W_ACTIVITY_D | | | | | date | |
PLANNED_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
REVIEW_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
REMAINING_LATE_START_DATE | W_ACTIVITY_D | | | | | date | |
REMAINING_LATE_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
SUSPEND_DATE | W_ACTIVITY_D | | | | | date | |
RESUME_DATE | W_ACTIVITY_D | | | | | date | |
EXTERNAL_EARLY_START_DATE | W_ACTIVITY_D | | | | | date | |
EXTERNAL_LATE_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
SECONDARY_CONSTRAINT_DATE | W_ACTIVITY_D | | | | | date | |
BASELINE_FINISH_DATE | W_ACTIVITY_D | | | | | date | |
BASELINE_START_DATE | W_ACTIVITY_D | | | | | date | |
DATA_DATE | W_ACTIVITY_D | | | | | date | |
FINISH_DATE | W_ACTIVITY_D | | | | | date | |
START_DATE | W_ACTIVITY_D | | | | | date | |
PRIMARY_CONSTRAINT_TYPE | W_ACTIVITY_D | | | | | string | |
LEVELING_PRIORITY | W_ACTIVITY_D | | | | | string | |
SECONDARY_CONSTRAINT_TYPE | W_ACTIVITY_D | | | | | string | |
FLOAT_PATH | W_ACTIVITY_D | | | | | integer | |
FLOAT_PATH_ORDER | W_ACTIVITY_D | | | | | integer | |
IS_LONGEST_PATH | W_ACTIVITY_D | | | | | string | |
ACTUAL_DURATION | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_DURATION | W_ACTIVITY_D | | | | | number | |
BASELINE_DURATION | W_ACTIVITY_D | | | | | number | |
BASELINE_PLANNED_DURATION | W_ACTIVITY_D | | | | | number | |
CALENDAR_NAME | W_ACTIVITY_D | | | | | string | |
COST_PERFORMANCE_INDEX | W_ACTIVITY_D | | | | | number | |
DURATION_1_VARIANCE | W_ACTIVITY_D | | | | | number | |
DURATION_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
DURATION_PCT_OF_PLANNED | W_ACTIVITY_D | | | | | number | |
DURATION_VARIANCE | W_ACTIVITY_D | | | | | number | |
EXPENSE_COST_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
FINISH_DATE_1_VARIANCE | W_ACTIVITY_D | | | | | number | |
FINISH_DATE_VARIANCE | W_ACTIVITY_D | | | | | number | |
IS_CRITICAL | W_ACTIVITY_D | | | | | string | |
LABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
NONLABOR_COST_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
PERCENT_COMPLETE | W_ACTIVITY_D | | | | | number | |
PERFORMANCE_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
PHYSICAL_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
PRIMARY_RESOURCE_NAME | W_ACTIVITY_D | | | | | string | |
REMAINING_FLOAT | W_ACTIVITY_D | | | | | number | |
SCHEDULE_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
SCHEDULE_PERFORMANCE_INDEX | W_ACTIVITY_D | | | | | number | |
SCHEDULE_VARIANCE_INDEX | W_ACTIVITY_D | | | | | number | |
START_DATE_1_VARIANCE | W_ACTIVITY_D | | | | | number | |
START_DATE_VARIANCE | W_ACTIVITY_D | | | | | number | |
TO_COMPLETE_PERFORMANCE_INDEX | W_ACTIVITY_D | | | | | number | |
UNITS_PCT_COMPLETE | W_ACTIVITY_D | | | | | number | |
WBS_CODE | W_ACTIVITY_D | | | | | string | |
WBS_NAME | W_ACTIVITY_D | | | | | string | |
PRIMARY_RESOURCE_OBJECT_ID | W_ACTIVITY_D | | | | | integer | |
ACTIVITY_OWNER | W_ACTIVITY_D | | | | | string | |
CUSTOM_1 | W_ACTIVITY_D | | | | | string | |
CUSTOM_2 | W_ACTIVITY_D | | | | | string | |
CUSTOM_3 | W_ACTIVITY_D | | | | | string | |
CUSTOM_4 | W_ACTIVITY_D | | | | | string | |
CUSTOM_5 | W_ACTIVITY_D | | | | | string | |
W_UPDATE_DT | W_ACTIVITY_D | | | | | date | |
W_CREATE_DT | W_ACTIVITY_D | | | | | date | |
DELETE_FLAG | W_ACTIVITY_D | | | | | string | |
DATASOURCE_ID | W_ACTIVITY_D | | | | | bigint | |
CODE_VALUE_01 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_01 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_02 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_02 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_03 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_03 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_04 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_04 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_05 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_05 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_06 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_06 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_07 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_07 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_08 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_08 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_09 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_09 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_10 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_10 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_11 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_11 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_12 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_12 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_13 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_13 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_14 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_14 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_15 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_15 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_16 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_16 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_17 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_17 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_18 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_18 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_19 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_19 | W_ACTIVITY_D | | | | | string | |
CODE_VALUE_20 | W_ACTIVITY_D | | | | | string | |
CODE_DESCR_20 | W_ACTIVITY_D | | | | | string | |
ACTUAL_COST | W_ACTIVITY_D | | | | | number | |
ACTUAL_EXPENSE_COST | W_ACTIVITY_D | | | | | number | |
ACTUAL_LABOR_COST | W_ACTIVITY_D | | | | | number | |
ACTUAL_MATERIAL_COST | W_ACTIVITY_D | | | | | number | |
ACTUAL_NONLABOR_COST | W_ACTIVITY_D | | | | | number | |
ACTUAL_TOTAL_COST | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_LABOR_COST | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_ACTIVITY_D | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_ACTIVITY_D | | | | | number | |
EARNED_VALUE_COST | W_ACTIVITY_D | | | | | number | |
EST_AT_COMPLETION_COST | W_ACTIVITY_D | | | | | number | |
EST_TO_COMPLETE_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_EXPENSE_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_LABOR_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_MATERIAL_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_NONLABOR_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_TOTAL_COST | W_ACTIVITY_D | | | | | number | |
PLANNED_VALUE_COST | W_ACTIVITY_D | | | | | number | |
REMAINING_EXPENSE_COST | W_ACTIVITY_D | | | | | number | |
REMAINING_LABOR_COST | W_ACTIVITY_D | | | | | number | |
REMAINING_MATERIAL_COST | W_ACTIVITY_D | | | | | number | |
REMAINING_NONLABOR_COST | W_ACTIVITY_D | | | | | number | |
REMAINING_TOTAL_COST | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_LABOR_COST | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_ACTIVITY_D | | | | | number | |
BL_PLANNED_TOTAL_COST | W_ACTIVITY_D | | | | | number | |
LOCATION_ID | W_ACTIVITY_D | | | | | bigint | |
LOCATION_NAME | W_ACTIVITY_D | | | | | string | |
LOCATION_TYPE | W_ACTIVITY_D | | | | | string | |
ADDRESS_LINE1 | W_ACTIVITY_D | | | | | string | |
ADDRESS_LINE2 | W_ACTIVITY_D | | | | | string | |
ADDRESS_LINE3 | W_ACTIVITY_D | | | | | string | |
CITY_NAME | W_ACTIVITY_D | | | | | string | |
MUNICIPALITY_NAME | W_ACTIVITY_D | | | | | string | |
STATE_NAME | W_ACTIVITY_D | | | | | string | |
STATE_CODE | W_ACTIVITY_D | | | | | string | |
COUNTRY_NAME | W_ACTIVITY_D | | | | | string | |
COUNTRY_CODE | W_ACTIVITY_D | | | | | string | |
POSTAL_CODE | W_ACTIVITY_D | | | | | string | |
LONGITUDE | W_ACTIVITY_D | | | | | number | |
LATITUDE | W_ACTIVITY_D | | | | | number | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ACTIVITY_ID | W_ACTIVITY_DS | | | | | string | |
ACTIVITY_NAME | W_ACTIVITY_DS | | | | | string | |
ACTIVITY_OBJECT_ID | W_ACTIVITY_DS | | | | | bigint | |
PROJECT_OBJECT_ID | W_ACTIVITY_DS | | | | | bigint | |
WBS_OBJECT_ID | W_ACTIVITY_DS | | | | | bigint | |
ACTUAL_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
PLANNED_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
PLANNED_NONLABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
REMAINING_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
REMAINING_NONLABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_ACTIVITY_DS | | | | | number | |
ACTUAL_COST | W_ACTIVITY_DS | | | | | number | |
ACTUAL_EXPENSE_COST | W_ACTIVITY_DS | | | | | number | |
ACTUAL_LABOR_COST | W_ACTIVITY_DS | | | | | number | |
ACTUAL_MATERIAL_COST | W_ACTIVITY_DS | | | | | number | |
ACTUAL_NONLABOR_COST | W_ACTIVITY_DS | | | | | number | |
ACTUAL_TOTAL_COST | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_LABOR_COST | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_ACTIVITY_DS | | | | | number | |
EARNED_VALUE_COST | W_ACTIVITY_DS | | | | | number | |
EST_AT_COMPLETION_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_EXPENSE_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_LABOR_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_MATERIAL_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_NONLABOR_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_TOTAL_COST | W_ACTIVITY_DS | | | | | number | |
PLANNED_VALUE_COST | W_ACTIVITY_DS | | | | | number | |
REMAINING_EXPENSE_COST | W_ACTIVITY_DS | | | | | number | |
REMAINING_LABOR_COST | W_ACTIVITY_DS | | | | | number | |
REMAINING_MATERIAL_COST | W_ACTIVITY_DS | | | | | number | |
REMAINING_NONLABOR_COST | W_ACTIVITY_DS | | | | | number | |
REMAINING_TOTAL_COST | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_LABOR_COST | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_ACTIVITY_DS | | | | | number | |
BL_PLANNED_TOTAL_COST | W_ACTIVITY_DS | | | | | number | |
REVIEW_FEEDBACK_FLAG | W_ACTIVITY_DS | | | | | string | |
AUTO_COMPUTE_ACTUALS_FLAG | W_ACTIVITY_DS | | | | | string | |
COMPLETE_PCT_TYPE | W_ACTIVITY_DS | | | | | string | |
ACTIVITY_TYPE | W_ACTIVITY_DS | | | | | string | |
DURATION_TYPE | W_ACTIVITY_DS | | | | | string | |
REVIEW_TYPE | W_ACTIVITY_DS | | | | | string | |
ACTIVITY_STATUS | W_ACTIVITY_DS | | | | | string | |
TOTAL_FLOAT | W_ACTIVITY_DS | | | | | double | |
FREE_FLOAT | W_ACTIVITY_DS | | | | | double | |
REMAINING_DURATION | W_ACTIVITY_DS | | | | | double | |
PLANNED_DURATION | W_ACTIVITY_DS | | | | | double | |
PRIMARY_CONSTRAINT_DATE | W_ACTIVITY_DS | | | | | date | |
ACTUAL_START_DATE | W_ACTIVITY_DS | | | | | date | |
ACTUAL_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
LATE_START_DATE | W_ACTIVITY_DS | | | | | date | |
LATE_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
EXPECT_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
EARLY_START_DATE | W_ACTIVITY_DS | | | | | date | |
EARLY_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
REMAINING_START_DATE | W_ACTIVITY_DS | | | | | date | |
REMAINING_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
PLANNED_START_DATE | W_ACTIVITY_DS | | | | | date | |
PLANNED_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
REVIEW_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
REMAINING_LATE_START_DATE | W_ACTIVITY_DS | | | | | date | |
REMAINING_LATE_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
SUSPEND_DATE | W_ACTIVITY_DS | | | | | date | |
RESUME_DATE | W_ACTIVITY_DS | | | | | date | |
EXTERNAL_EARLY_START_DATE | W_ACTIVITY_DS | | | | | date | |
EXTERNAL_LATE_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
SECONDARY_CONSTRAINT_DATE | W_ACTIVITY_DS | | | | | date | |
BASELINE_FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
BASELINE_START_DATE | W_ACTIVITY_DS | | | | | date | |
DATA_DATE | W_ACTIVITY_DS | | | | | date | |
FINISH_DATE | W_ACTIVITY_DS | | | | | date | |
START_DATE | W_ACTIVITY_DS | | | | | date | |
PRIMARY_CONSTRAINT_TYPE | W_ACTIVITY_DS | | | | | string | |
LEVELING_PRIORITY | W_ACTIVITY_DS | | | | | string | |
SECONDARY_CONSTRAINT_TYPE | W_ACTIVITY_DS | | | | | string | |
FLOAT_PATH | W_ACTIVITY_DS | | | | | integer | |
FLOAT_PATH_ORDER | W_ACTIVITY_DS | | | | | integer | |
IS_LONGEST_PATH | W_ACTIVITY_DS | | | | | string | |
ACTUAL_DURATION | W_ACTIVITY_DS | | | | | number | |
AT_COMPLETION_DURATION | W_ACTIVITY_DS | | | | | number | |
BASELINE_DURATION | W_ACTIVITY_DS | | | | | number | |
BASELINE_PLANNED_DURATION | W_ACTIVITY_DS | | | | | number | |
CALENDAR_NAME | W_ACTIVITY_DS | | | | | string | |
COST_PERFORMANCE_INDEX | W_ACTIVITY_DS | | | | | number | |
DURATION_1_VARIANCE | W_ACTIVITY_DS | | | | | number | |
DURATION_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
DURATION_PCT_OF_PLANNED | W_ACTIVITY_DS | | | | | number | |
DURATION_VARIANCE | W_ACTIVITY_DS | | | | | number | |
EST_TO_COMPLETE_COST | W_ACTIVITY_DS | | | | | number | |
EXPENSE_COST_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
FINISH_DATE_1_VARIANCE | W_ACTIVITY_DS | | | | | number | |
FINISH_DATE_VARIANCE | W_ACTIVITY_DS | | | | | number | |
IS_CRITICAL | W_ACTIVITY_DS | | | | | string | |
LABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
NONLABOR_COST_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
PERCENT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
PERFORMANCE_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
PHYSICAL_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
PRIMARY_RESOURCE_NAME | W_ACTIVITY_DS | | | | | string | |
REMAINING_FLOAT | W_ACTIVITY_DS | | | | | number | |
SCHEDULE_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
SCHEDULE_PERFORMANCE_INDEX | W_ACTIVITY_DS | | | | | number | |
SCHEDULE_VARIANCE_INDEX | W_ACTIVITY_DS | | | | | number | |
START_DATE_1_VARIANCE | W_ACTIVITY_DS | | | | | number | |
START_DATE_VARIANCE | W_ACTIVITY_DS | | | | | number | |
TO_COMPLETE_PERFORMANCE_INDEX | W_ACTIVITY_DS | | | | | number | |
UNITS_PCT_COMPLETE | W_ACTIVITY_DS | | | | | number | |
WBS_CODE | W_ACTIVITY_DS | | | | | string | |
WBS_NAME | W_ACTIVITY_DS | | | | | string | |
PRIMARY_RESOURCE_OBJECT_ID | W_ACTIVITY_DS | | | | | integer | |
ACTIVITY_OWNER | W_ACTIVITY_DS | | | | | string | |
LOCATION_ID | W_ACTIVITY_DS | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ACTIVITY_WID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
WBS_WID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
PROJECT_WID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
DAY_WID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
ACTIVITY_OBJECT_ID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
EPS_WID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
PROJECT_OBJECT_ID | W_ACTIVITY_HISTORY_F | | | | | integer | |
WBS_OBJECT_ID | W_ACTIVITY_HISTORY_F | | | | | integer | |
PERIOD_START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
PERIOD_END_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
PLANNED_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
PLANNED_FINISH_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
ACTUAL_START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
ACTUAL_FINISH_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
REMAINING_START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
REMAINING_FINISH_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
FINISH_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
BASELINE_START_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
BASELINE_FINISH_DATE | W_ACTIVITY_HISTORY_F | | | | | date | |
PLANNED_DURATION | W_ACTIVITY_HISTORY_F | | | | | double | |
ACTUAL_DURATION | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_DURATION | W_ACTIVITY_HISTORY_F | | | | | double | |
AT_COMPLETION_DURATION | W_ACTIVITY_HISTORY_F | | | | | number | |
BASELINE_DURATION | W_ACTIVITY_HISTORY_F | | | | | number | |
TOTAL_FLOAT | W_ACTIVITY_HISTORY_F | | | | | double | |
DURATION_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
DURATION_PCT_OF_PLANNED | W_ACTIVITY_HISTORY_F | | | | | number | |
DURATION_VARIANCE | W_ACTIVITY_HISTORY_F | | | | | number | |
UNITS_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
LABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
SCHEDULE_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
PERFORMANCE_PCT_COMPLETE | W_ACTIVITY_HISTORY_F | | | | | number | |
START_DATE_VARIANCE | W_ACTIVITY_HISTORY_F | | | | | number | |
FINISH_DATE_VARIANCE | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
EARNED_VALUE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PROJECT_RISK_SCORE | W_ACTIVITY_HISTORY_F | | | | | number | |
PROJECT_RISK_EXPOSURE | W_ACTIVITY_HISTORY_F | | | | | number | |
NOT_STARTED_ACTIVITY_COUNT | W_ACTIVITY_HISTORY_F | | | | | integer | |
IN_PROGRESS_ACTIVITY_COUNT | W_ACTIVITY_HISTORY_F | | | | | integer | |
COMPLETED_ACTIVITY_COUNT | W_ACTIVITY_HISTORY_F | | | | | integer | |
NEW_ACTIVITY_COUNT | W_ACTIVITY_HISTORY_F | | | | | integer | |
ACTUAL_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_AT_COMPL_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REM_LATE_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EARNED_VALUE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_UNITS_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_MATERIAL_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
NEXT_PER_EXPENSE_COST_P | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_UNITS | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_MATERIAL_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
PREV_THIS_PER_EXPENSE_COST | W_ACTIVITY_HISTORY_F | | | | | number | |
W_UPDATE_DT | W_ACTIVITY_HISTORY_F | | | | | date | |
W_CREATE_DT | W_ACTIVITY_HISTORY_F | | | | | date | |
DELETE_FLAG | W_ACTIVITY_HISTORY_F | | | | | string | |
DATASOURCE_ID | W_ACTIVITY_HISTORY_F | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
PROJECT_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
ACTIVITY_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
WBS_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
OBS_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
DAY_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
EPS_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
RESOURCE_WID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
ACTIVITY_OBJECT_ID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
RESOURCE_OBJECT_ID | W_ACTIVITY_SPREAD_F | | | | | integer | |
PROJECT_OBJECT_ID | W_ACTIVITY_SPREAD_F | | | | | integer | |
WBS_OBJECT_ID | W_ACTIVITY_SPREAD_F | | | | | integer | |
ACTUAL_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
ACTUAL_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
EARNED_VALUE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
EST_AT_COMPLETION_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
EST_TO_COMPLETE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
PLANNED_VALUE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
REMAINING_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_PLANNED_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
START_DATE | W_ACTIVITY_SPREAD_F | | | | | date | |
END_DATE | W_ACTIVITY_SPREAD_F | | | | | date | |
W_UPDATE_DT | W_ACTIVITY_SPREAD_F | | | | | date | |
W_CREATE_DT | W_ACTIVITY_SPREAD_F | | | | | date | |
DELETE_FLAG | W_ACTIVITY_SPREAD_F | | | | | string | |
DATASOURCE_ID | W_ACTIVITY_SPREAD_F | | | | | bigint | |
CHANGE_SKEY | W_ACTIVITY_SPREAD_F | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ActivityObjectId | W_ACTIVITY_SPREAD_FS | | | | | int | |
StartDate | W_ACTIVITY_SPREAD_FS | | | | | date | |
EndDate | W_ACTIVITY_SPREAD_FS | | | | | date | |
ActivityCode | W_ACTIVITY_SPREAD_FS | | | | | string | |
ActivityName | W_ACTIVITY_SPREAD_FS | | | | | string | |
WBSObjectId | W_ACTIVITY_SPREAD_FS | | | | | int | |
ProjectObjectId | W_ACTIVITY_SPREAD_FS | | | | | int | |
ActualLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
EarnedValueLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
EstimateAtCompletionLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
EstimateToCompleteLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedValueLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingNonLaborUnits | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
ActualTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
AtCompletionTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselinePlannedTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
BaselineActualTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1ActualTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
Baseline1PlannedTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
EarnedValueCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
EstimateAtCompletionCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
EstimateToCompleteCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
PlannedValueCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateExpenseCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingLateTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingMaterialCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingNonLaborCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
RemainingTotalCost | W_ACTIVITY_SPREAD_FS | | | | | number | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
PROJECT_WID | W_ACTIVITY_SPREAD_PER_TS | | | | | bigint | |
ACTIVITY_WID | W_ACTIVITY_SPREAD_PER_TS | | | | | bigint | |
WBS_WID | W_ACTIVITY_SPREAD_PER_TS | | | | | bigint | |
PERIOD_START_DATE | W_ACTIVITY_SPREAD_PER_TS | | | | | date | |
PERIOD_END_DATE | W_ACTIVITY_SPREAD_PER_TS | | | | | date | |
ACTUAL_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
ACTUAL_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EARNED_VALUE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EST_AT_COMPLETION_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
EST_TO_COMPLETE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PLANNED_VALUE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
REMAINING_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_PLANNED_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NEXT_PER_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_LABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_LABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_NONLABOR_UNITS | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_NONLABOR_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_MATERIAL_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
PREV_THIS_PER_EXPENSE_COST | W_ACTIVITY_SPREAD_PER_TS | | | | | number | |
NOT_STARTED_ACTIVITY_COUNT | W_ACTIVITY_SPREAD_PER_TS | | | | | integer | |
IN_PROGRESS_ACTIVITY_COUNT | W_ACTIVITY_SPREAD_PER_TS | | | | | integer | |
COMPLETED_ACTIVITY_COUNT | W_ACTIVITY_SPREAD_PER_TS | | | | | integer | |
NEW_ACTIVITY_COUNT | W_ACTIVITY_SPREAD_PER_TS | | | | | integer | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
objectid | W_ACTIVITYCODE_DS | | | | | integer | ActivityCode - ObjectId maps to ACTVCODE.actv_code_id |
codetypeobjectid | W_ACTIVITYCODE_DS | | | | | integer | ActivityCode - CodeTypeObjectId maps to ACTVCODE.actv_code_type_id |
sequencenumber | W_ACTIVITYCODE_DS | | | | | integer | ActivityCode - SequenceNumber maps to ACTVCODE.seq_num |
codevalue | W_ACTIVITYCODE_DS | | | | | string | ActivityCode - CodeValue maps to ACTVCODE.short_name |
parentobjectid | W_ACTIVITYCODE_DS | | | | | integer | ActivityCode - ParentObjectId maps to ACTVCODE.parent_actv_code_id |
description | W_ACTIVITYCODE_DS | | | | | string | ActivityCode - Description maps to ACTVCODE.actv_code_name |
codetypename | W_ACTIVITYCODE_DS | | | | | string | ActivityCode - CodeTypeName maps to actvcode.CodeTypeName |
issecurecode | W_ACTIVITYCODE_DS | | | | | string | ActivityCodeType - IsSecureCode maps to ACTVTYPE.super_flag |
projectobjectid | W_ACTIVITYCODE_DS | | | | | integer | ActivityCodeType - ProjectObjectId maps to ACTVTYPE.proj_id |
codetypescope | W_ACTIVITYCODE_DS | | | | | string | ActivityCodeType - Scope denormalized field |
lastupdateuser | W_ACTIVITYCODE_DS | | | | | string | Last Update User |
lastupdatedate | W_ACTIVITYCODE_DS | | | | | date | Last Update Date |
createuser | W_ACTIVITYCODE_DS | | | | | string | Create User |
createdate | W_ACTIVITYCODE_DS | | | | | date | Create Date |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
activityobjectid | W_ACTIVITYCODEASSIGNMENT_DS | | | | | integer | ActivityCodeAssignment - ActivityObjectId maps to TASKACTV.task_id |
activitycodetypeobjectid | W_ACTIVITYCODEASSIGNMENT_DS | | | | | integer | ActivityCodeAssignment - ActivityCodeTypeObjectId maps to TASKACTV.actv_code_type_id |
activitycodeobjectid | W_ACTIVITYCODEASSIGNMENT_DS | | | | | integer | ActivityCodeAssignment - ActivityCodeObjectId maps to TASKACTV.actv_code_id |
projectobjectid | W_ACTIVITYCODEASSIGNMENT_DS | | | | | integer | ActivityCodeAssignment - ProjectObjectId maps to TASKACTV.proj_id |
activitycodedescription | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityCodeDescription maps to TASKACTV.ActivityCodeDescription |
activitycodetypename | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityCodeTypeName maps to TASKACTV.ActivityCodeTypeName |
activitycodetypescope | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityCodeTypeScope maps to TASKACTV.ActivityCodeTypeScope |
activitycodevalue | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityCodeValue maps to TASKACTV.ActivityCodeValue |
activityid | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityId maps to TASKACTV.ActivityId |
activityname | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - ActivityName maps to TASKACTV.ActivityName |
issecurecode | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | ActivityCodeAssignment - IsSecureCode maps to TASKACTV.super_flag |
lastupdateuser | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | Last Update User |
lastupdatedate | W_ACTIVITYCODEASSIGNMENT_DS | | | | | date | Last Update Date |
createuser | W_ACTIVITYCODEASSIGNMENT_DS | | | | | string | Create User |
createdate | W_ACTIVITYCODEASSIGNMENT_DS | | | | | date | Create Date |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
objectid | W_CALENDAR_FS | | | | | integer | Calendar - ObjectId maps to CALENDAR.clndr_id |
isdefault | W_CALENDAR_FS | | | | | string | Calendar - IsDefault maps to CALENDAR.default_flag |
name | W_CALENDAR_FS | | | | | string | Calendar - Name maps to CALENDAR.clndr_name |
projectobjectid | W_CALENDAR_FS | | | | | integer | Calendar - ProjectObjectId maps to CALENDAR.proj_id |
basecalendarobjectid | W_CALENDAR_FS | | | | | integer | Calendar - BaseCalendarObjectId maps to CALENDAR.base_clndr_id |
lastchangedate | W_CALENDAR_FS | | | | | date | Calendar - lastchangedate maps to PSTG_CALENDARFULL.lastchangedate |
type | W_CALENDAR_FS | | | | | string | Calendar - Type maps to CALENDAR.clndr_type |
daydate | W_CALENDAR_FS | | | | | date | Calendar - daydate maps to PSTG_CALENDARFULL.daydate |
WeekdayNumber | W_CALENDAR_FS | | | | | integer | Calendar - WeekdayNumber maps to PSTG_CALENDARFULL.WeekdayNumber |
WorkDayFlag | W_CALENDAR_FS | | | | | string | |
TotalWorkHours | W_CALENDAR_FS | | | | | double | |
WorkHoursByHalfHour | W_CALENDAR_FS | | | | | string | |
WorkDayStartTime | W_CALENDAR_FS | | | | | date | Calendar - WorkDayStartTime maps to PSTG_CALENDARFULL.WorkDayStartTime |
WorkDayFinishTime | W_CALENDAR_FS | | | | | date | Calendar - WorkDayFinishTime maps to PSTG_CALENDARFULL.WorkDayFinishTime |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ROW_WID | W_PROJECT_D | | | | | bigint | |
EPS_WID | W_PROJECT_D | | | | | bigint | |
PROJECT_ID | W_PROJECT_D | | | | | string | |
PROJECT_NAME | W_PROJECT_D | | | | | string | |
PROJECT_OBJECT_ID | W_PROJECT_D | | | | | bigint | |
EPS_OBJECT_ID | W_PROJECT_D | | | | | bigint | |
PROJECT_PRIORITY | W_PROJECT_D | | | | | integer | |
PROJECT_STRATEGIC_PRIORITY | W_PROJECT_D | | | | | integer | |
CRITICAL_ACTIVITY_FLOAT_LIMIT | W_PROJECT_D | | | | | double | |
PROJECT_PLANNED_START_DATE | W_PROJECT_D | | | | | date | |
PROJECT_PLANNED_FINISH_DATE | W_PROJECT_D | | | | | date | |
PLANNED_START_DATE | W_PROJECT_D | | | | | date | |
PLANNED_FINISH_DATE | W_PROJECT_D | | | | | date | |
PLANNED_DURATION | W_PROJECT_D | | | | | number | |
SCHEDULED_FINISH_DATE | W_PROJECT_D | | | | | date | |
ADD_DATE | W_PROJECT_D | | | | | date | |
PROJECT_START_DATE | W_PROJECT_D | | | | | date | |
PROJECT_FINISH_DATE | W_PROJECT_D | | | | | date | |
ADDED_BY_NAME | W_PROJECT_D | | | | | string | |
ANNUAL_DISCOUNT_RATE | W_PROJECT_D | | | | | number | |
ANTICIPATED_FINISH_DATE | W_PROJECT_D | | | | | date | |
ANTICIPATED_START_DATE | W_PROJECT_D | | | | | date | |
DATA_DATE | W_PROJECT_D | | | | | date | |
FORECAST_START_DATE | W_PROJECT_D | | | | | date | |
FORECAST_FINISH_DATE | W_PROJECT_D | | | | | date | |
OVERALL_PROJECT_SCORE | W_PROJECT_D | | | | | number | |
PROJECT_RISK_SCORE | W_PROJECT_D | | | | | number | |
PROJECT_RISK_EXPOSURE | W_PROJECT_D | | | | | number | |
PROJECT_RISK_LEVEL | W_PROJECT_D | | | | | string | |
PROJECT_STATUS | W_PROJECT_D | | | | | string | |
START_DATE | W_PROJECT_D | | | | | date | |
FINISH_DATE | W_PROJECT_D | | | | | date | |
ACTUAL_START_DATE | W_PROJECT_D | | | | | date | |
ACTUAL_FINISH_DATE | W_PROJECT_D | | | | | date | |
BASELINE_START_DATE | W_PROJECT_D | | | | | date | |
BASELINE_FINISH_DATE | W_PROJECT_D | | | | | date | |
PROGRESS_FINISH_DATE | W_PROJECT_D | | | | | date | |
REMAINING_START_DATE | W_PROJECT_D | | | | | date | |
REMAINING_FINISH_DATE | W_PROJECT_D | | | | | date | |
ACTUAL_DURATION | W_PROJECT_D | | | | | number | |
AT_COMPLETION_DURATION | W_PROJECT_D | | | | | number | |
BASELINE_DURATION | W_PROJECT_D | | | | | number | |
REMAINING_DURATION | W_PROJECT_D | | | | | number | |
DURATION_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
DURATION_PERCENT_OF_PLANNED | W_PROJECT_D | | | | | number | |
DURATION_VARIANCE | W_PROJECT_D | | | | | number | |
ACTUAL_LABOR_UNITS | W_PROJECT_D | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_PROJECT_D | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_PROJECT_D | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_PROJECT_D | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_PROJECT_D | | | | | number | |
PLANNED_LABOR_UNITS | W_PROJECT_D | | | | | number | |
PLANNED_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_PROJECT_D | | | | | number | |
REMAINING_LABOR_UNITS | W_PROJECT_D | | | | | number | |
REMAINING_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_PROJECT_D | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_PROJECT_D | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
BL1_PLANNED_LABOR_UNITS | W_PROJECT_D | | | | | number | |
BL1_PLANNED_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
BL1_ACTUAL_LABOR_UNITS | W_PROJECT_D | | | | | number | |
BL1_ACTUAL_NONLABOR_UNITS | W_PROJECT_D | | | | | number | |
ACCOUNTING_VAR_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
BAC_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
LABOR_UNITS_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
ACTUAL_VALUE_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
FINISH_DATE_VARIANCE | W_PROJECT_D | | | | | number | |
LABOR_UNITS_VARIANCE | W_PROJECT_D | | | | | number | |
NONLABOR_UNITS_VARIANCE | W_PROJECT_D | | | | | number | |
SCHEDULE_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
PERFORMANCE_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
START_DATE_VARIANCE | W_PROJECT_D | | | | | number | |
TOTAL_FLOAT | W_PROJECT_D | | | | | number | |
UNITS_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_PROJECT_D | | | | | number | |
PERF_PCT_CMP_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
SCHD_PCT_CMP_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
SCHEDULE_VAR_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
VARIANCE_AT_CMP_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
COST_VARIANCE_BY_LABOR_UNITS | W_PROJECT_D | | | | | number | |
CUSTOM_1 | W_PROJECT_D | | | | | string | |
CUSTOM_2 | W_PROJECT_D | | | | | string | |
CUSTOM_3 | W_PROJECT_D | | | | | string | |
CUSTOM_4 | W_PROJECT_D | | | | | string | |
CUSTOM_5 | W_PROJECT_D | | | | | string | |
W_UPDATE_DT | W_PROJECT_D | | | | | date | |
W_CREATE_DT | W_PROJECT_D | | | | | date | |
DELETE_FLAG | W_PROJECT_D | | | | | string | |
DATASOURCE_ID | W_PROJECT_D | | | | | bigint | |
CODE_VALUE_01 | W_PROJECT_D | | | | | string | |
CODE_DESCR_01 | W_PROJECT_D | | | | | string | |
CODE_VALUE_02 | W_PROJECT_D | | | | | string | |
CODE_DESCR_02 | W_PROJECT_D | | | | | string | |
CODE_VALUE_03 | W_PROJECT_D | | | | | string | |
CODE_DESCR_03 | W_PROJECT_D | | | | | string | |
CODE_VALUE_04 | W_PROJECT_D | | | | | string | |
CODE_DESCR_04 | W_PROJECT_D | | | | | string | |
CODE_VALUE_05 | W_PROJECT_D | | | | | string | |
CODE_DESCR_05 | W_PROJECT_D | | | | | string | |
CODE_VALUE_06 | W_PROJECT_D | | | | | string | |
CODE_DESCR_06 | W_PROJECT_D | | | | | string | |
CODE_VALUE_07 | W_PROJECT_D | | | | | string | |
CODE_DESCR_07 | W_PROJECT_D | | | | | string | |
CODE_VALUE_08 | W_PROJECT_D | | | | | string | |
CODE_DESCR_08 | W_PROJECT_D | | | | | string | |
CODE_VALUE_09 | W_PROJECT_D | | | | | string | |
CODE_DESCR_09 | W_PROJECT_D | | | | | string | |
CODE_VALUE_10 | W_PROJECT_D | | | | | string | |
CODE_DESCR_10 | W_PROJECT_D | | | | | string | |
CODE_VALUE_11 | W_PROJECT_D | | | | | string | |
CODE_DESCR_11 | W_PROJECT_D | | | | | string | |
CODE_VALUE_12 | W_PROJECT_D | | | | | string | |
CODE_DESCR_12 | W_PROJECT_D | | | | | string | |
CODE_VALUE_13 | W_PROJECT_D | | | | | string | |
CODE_DESCR_13 | W_PROJECT_D | | | | | string | |
CODE_VALUE_14 | W_PROJECT_D | | | | | string | |
CODE_DESCR_14 | W_PROJECT_D | | | | | string | |
CODE_VALUE_15 | W_PROJECT_D | | | | | string | |
CODE_DESCR_15 | W_PROJECT_D | | | | | string | |
CODE_VALUE_16 | W_PROJECT_D | | | | | string | |
CODE_DESCR_16 | W_PROJECT_D | | | | | string | |
CODE_VALUE_17 | W_PROJECT_D | | | | | string | |
CODE_DESCR_17 | W_PROJECT_D | | | | | string | |
CODE_VALUE_18 | W_PROJECT_D | | | | | string | |
CODE_DESCR_18 | W_PROJECT_D | | | | | string | |
CODE_VALUE_19 | W_PROJECT_D | | | | | string | |
CODE_DESCR_19 | W_PROJECT_D | | | | | string | |
CODE_VALUE_20 | W_PROJECT_D | | | | | string | |
CODE_DESCR_20 | W_PROJECT_D | | | | | string | |
CURRENT_BUDGET | W_PROJECT_D | | | | | number | |
CURRENT_VARIANCE | W_PROJECT_D | | | | | number | |
DISTRIBUTED_CURRENT_BUDGET | W_PROJECT_D | | | | | number | |
ORIGINAL_BUDGET | W_PROJECT_D | | | | | number | |
PROPOSED_BUDGET | W_PROJECT_D | | | | | number | |
TOTAL_BENEFIT_PLAN | W_PROJECT_D | | | | | number | |
TOTAL_BENEFIT_PLAN_TALLY | W_PROJECT_D | | | | | number | |
TOTAL_FUNDING | W_PROJECT_D | | | | | number | |
TOTAL_SPENDING_PLAN | W_PROJECT_D | | | | | number | |
TOTAL_SPENDING_PLAN_TALLY | W_PROJECT_D | | | | | number | |
UNALLOCATED_BUDGET | W_PROJECT_D | | | | | number | |
UNDISTRIBUTED_CURRENT_VARIANCE | W_PROJECT_D | | | | | number | |
NET_PRESENT_VALUE | W_PROJECT_D | | | | | number | |
RETURN_ON_INVESTMENT | W_PROJECT_D | | | | | number | |
PAYBACK_PERIOD | W_PROJECT_D | | | | | number | |
ACCOUNTING_VARIANCE_BY_COST | W_PROJECT_D | | | | | number | |
BUDGET_AT_COMPLETION_BY_COST | W_PROJECT_D | | | | | number | |
EST_AT_COMPLETION_COST | W_PROJECT_D | | | | | number | |
EST_TO_COMPLETE_COST | W_PROJECT_D | | | | | number | |
PLANNED_EXPENSE_COST | W_PROJECT_D | | | | | number | |
PLANNED_LABOR_COST | W_PROJECT_D | | | | | number | |
PLANNED_MATERIAL_COST | W_PROJECT_D | | | | | number | |
PLANNED_NONLABOR_COST | W_PROJECT_D | | | | | number | |
PLANNED_TOTAL_COST | W_PROJECT_D | | | | | number | |
ACTUAL_EXPENSE_COST | W_PROJECT_D | | | | | number | |
ACTUAL_LABOR_COST | W_PROJECT_D | | | | | number | |
ACTUAL_MATERIAL_COST | W_PROJECT_D | | | | | number | |
ACTUAL_NONLABOR_COST | W_PROJECT_D | | | | | number | |
ACTUAL_TOTAL_COST | W_PROJECT_D | | | | | number | |
ACTUAL_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_LABOR_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_PROJECT_D | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_PROJECT_D | | | | | number | |
BL_PLANNED_LABOR_COST | W_PROJECT_D | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_PROJECT_D | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_PROJECT_D | | | | | number | |
BL_PLANNED_TOTAL_COST | W_PROJECT_D | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_PROJECT_D | | | | | number | |
BL_ACTUAL_LABOR_COST | W_PROJECT_D | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_PROJECT_D | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_PROJECT_D | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_PROJECT_D | | | | | number | |
REMAINING_LABOR_COST | W_PROJECT_D | | | | | number | |
REMAINING_MATERIAL_COST | W_PROJECT_D | | | | | number | |
REMAINING_EXPENSE_COST | W_PROJECT_D | | | | | number | |
REMAINING_NONLABOR_COST | W_PROJECT_D | | | | | number | |
REMAINING_TOTAL_COST | W_PROJECT_D | | | | | number | |
EARNED_VALUE_COST | W_PROJECT_D | | | | | number | |
PLANNED_VALUE_COST | W_PROJECT_D | | | | | number | |
EXPENSE_COST_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
LABOR_COST_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
COST_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
COST_PCT_CMP_OF_PLANNED | W_PROJECT_D | | | | | number | |
MATERIAL_COST_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
NONLABOR_COST_PERCENT_COMPLETE | W_PROJECT_D | | | | | number | |
COST_VARIANCE | W_PROJECT_D | | | | | number | |
EXPENSE_COST_VARIANCE | W_PROJECT_D | | | | | number | |
LABOR_COST_VARIANCE | W_PROJECT_D | | | | | number | |
NONLABOR_COST_VARIANCE | W_PROJECT_D | | | | | number | |
MATERIAL_COST_VARIANCE | W_PROJECT_D | | | | | number | |
TOTAL_COST_VARIANCE | W_PROJECT_D | | | | | number | |
SCHEDULE_VARIANCE_BY_COST | W_PROJECT_D | | | | | number | |
AT_COMPLETION_TOTAL_COST_VAR | W_PROJECT_D | | | | | number | |
LOCATION_ID | W_PROJECT_D | | | | | bigint | |
LOCATION_NAME | W_PROJECT_D | | | | | string | |
LOCATION_TYPE | W_PROJECT_D | | | | | string | |
ADDRESS_LINE1 | W_PROJECT_D | | | | | string | |
ADDRESS_LINE2 | W_PROJECT_D | | | | | string | |
ADDRESS_LINE3 | W_PROJECT_D | | | | | string | |
CITY_NAME | W_PROJECT_D | | | | | string | |
MUNICIPALITY_NAME | W_PROJECT_D | | | | | string | |
STATE_NAME | W_PROJECT_D | | | | | string | |
STATE_CODE | W_PROJECT_D | | | | | string | |
COUNTRY_NAME | W_PROJECT_D | | | | | string | |
COUNTRY_CODE | W_PROJECT_D | | | | | string | |
POSTAL_CODE | W_PROJECT_D | | | | | string | |
LONGITUDE | W_PROJECT_D | | | | | number | |
LATITUDE | W_PROJECT_D | | | | | number | |
NOT_STARTED_ACTIVITY_COUNT | W_PROJECT_D | | | | | integer | |
IN_PROGRESS_ACTIVITY_COUNT | W_PROJECT_D | | | | | integer | |
COMPLETED_ACTIVITY_COUNT | W_PROJECT_D | | | | | integer | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
PROJECT_ID | W_PROJECT_DS | | | | | string | |
PROJECT_NAME | W_PROJECT_DS | | | | | string | |
PROJECT_OBJECT_ID | W_PROJECT_DS | | | | | bigint | |
EPS_OBJECT_ID | W_PROJECT_DS | | | | | bigint | |
PROJECT_PRIORITY | W_PROJECT_DS | | | | | integer | |
PROJECT_STRATEGIC_PRIORITY | W_PROJECT_DS | | | | | integer | |
CRITICAL_ACTIVITY_FLOAT_LIMIT | W_PROJECT_DS | | | | | double | |
PROJECT_PLANNED_START_DATE | W_PROJECT_DS | | | | | date | |
PROJECT_PLANNED_FINISH_DATE | W_PROJECT_DS | | | | | date | |
PLANNED_START_DATE | W_PROJECT_DS | | | | | date | |
PLANNED_FINISH_DATE | W_PROJECT_DS | | | | | date | |
PLANNED_DURATION | W_PROJECT_DS | | | | | number | |
SCHEDULED_FINISH_DATE | W_PROJECT_DS | | | | | date | |
ADD_DATE | W_PROJECT_DS | | | | | date | |
PROJECT_START_DATE | W_PROJECT_DS | | | | | date | |
PROJECT_FINISH_DATE | W_PROJECT_DS | | | | | date | |
ADDED_BY_NAME | W_PROJECT_DS | | | | | string | |
ANNUAL_DISCOUNT_RATE | W_PROJECT_DS | | | | | number | |
ANTICIPATED_FINISH_DATE | W_PROJECT_DS | | | | | date | |
ANTICIPATED_START_DATE | W_PROJECT_DS | | | | | date | |
CURRENT_BUDGET | W_PROJECT_DS | | | | | number | |
CURRENT_VARIANCE | W_PROJECT_DS | | | | | number | |
DATA_DATE | W_PROJECT_DS | | | | | date | |
DISTRIBUTED_CURRENT_BUDGET | W_PROJECT_DS | | | | | number | |
FORECAST_START_DATE | W_PROJECT_DS | | | | | date | |
FORECAST_FINISH_DATE | W_PROJECT_DS | | | | | date | |
ORIGINAL_BUDGET | W_PROJECT_DS | | | | | number | |
OVERALL_PROJECT_SCORE | W_PROJECT_DS | | | | | number | |
PROPOSED_BUDGET | W_PROJECT_DS | | | | | number | |
PROJECT_RISK_SCORE | W_PROJECT_DS | | | | | number | |
PROJECT_RISK_EXPOSURE | W_PROJECT_DS | | | | | number | |
PROJECT_RISK_LEVEL | W_PROJECT_DS | | | | | string | |
PROJECT_STATUS | W_PROJECT_DS | | | | | string | |
TOTAL_BENEFIT_PLAN | W_PROJECT_DS | | | | | number | |
TOTAL_BENEFIT_PLAN_TALLY | W_PROJECT_DS | | | | | number | |
TOTAL_FUNDING | W_PROJECT_DS | | | | | number | |
TOTAL_SPENDING_PLAN | W_PROJECT_DS | | | | | number | |
TOTAL_SPENDING_PLAN_TALLY | W_PROJECT_DS | | | | | number | |
UNALLOCATED_BUDGET | W_PROJECT_DS | | | | | number | |
UNDISTRIBUTED_CURRENT_VARIANCE | W_PROJECT_DS | | | | | number | |
NET_PRESENT_VALUE | W_PROJECT_DS | | | | | number | |
RETURN_ON_INVESTMENT | W_PROJECT_DS | | | | | number | |
PAYBACK_PERIOD | W_PROJECT_DS | | | | | number | |
START_DATE | W_PROJECT_DS | | | | | date | |
FINISH_DATE | W_PROJECT_DS | | | | | date | |
ACTUAL_START_DATE | W_PROJECT_DS | | | | | date | |
ACTUAL_FINISH_DATE | W_PROJECT_DS | | | | | date | |
BASELINE_START_DATE | W_PROJECT_DS | | | | | date | |
BASELINE_FINISH_DATE | W_PROJECT_DS | | | | | date | |
PROGRESS_FINISH_DATE | W_PROJECT_DS | | | | | date | |
REMAINING_START_DATE | W_PROJECT_DS | | | | | date | |
REMAINING_FINISH_DATE | W_PROJECT_DS | | | | | date | |
ACTUAL_DURATION | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_DURATION | W_PROJECT_DS | | | | | number | |
BASELINE_DURATION | W_PROJECT_DS | | | | | number | |
REMAINING_DURATION | W_PROJECT_DS | | | | | number | |
DURATION_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
DURATION_PERCENT_OF_PLANNED | W_PROJECT_DS | | | | | number | |
DURATION_VARIANCE | W_PROJECT_DS | | | | | number | |
ACTUAL_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_PROJECT_DS | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
PLANNED_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
PLANNED_NONLABOR_UNITS | W_PROJECT_DS | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
REMAINING_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
REMAINING_NONLABOR_UNITS | W_PROJECT_DS | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_PROJECT_DS | | | | | number | |
ACCOUNTING_VAR_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
BAC_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
LABOR_UNITS_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
ACTUAL_VALUE_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
FINISH_DATE_VARIANCE | W_PROJECT_DS | | | | | number | |
LABOR_UNITS_VARIANCE | W_PROJECT_DS | | | | | number | |
NONLABOR_UNITS_VARIANCE | W_PROJECT_DS | | | | | number | |
SCHEDULE_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
PERFORMANCE_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
START_DATE_VARIANCE | W_PROJECT_DS | | | | | number | |
TOTAL_FLOAT | W_PROJECT_DS | | | | | number | |
UNITS_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_PROJECT_DS | | | | | number | |
PERF_PCT_CMP_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
SCHD_PCT_CMP_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
SCHEDULE_VAR_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
VARIANCE_AT_CMP_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
COST_VARIANCE_BY_LABOR_UNITS | W_PROJECT_DS | | | | | number | |
ACCOUNTING_VARIANCE_BY_COST | W_PROJECT_DS | | | | | number | |
BUDGET_AT_COMPLETION_BY_COST | W_PROJECT_DS | | | | | number | |
EST_AT_COMPLETION_COST | W_PROJECT_DS | | | | | number | |
EST_TO_COMPLETE_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_EXPENSE_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_LABOR_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_MATERIAL_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_NONLABOR_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_TOTAL_COST | W_PROJECT_DS | | | | | number | |
ACTUAL_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_LABOR_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_PROJECT_DS | | | | | number | |
PLANNED_EXPENSE_COST | W_PROJECT_DS | | | | | number | |
PLANNED_LABOR_COST | W_PROJECT_DS | | | | | number | |
PLANNED_MATERIAL_COST | W_PROJECT_DS | | | | | number | |
PLANNED_NONLABOR_COST | W_PROJECT_DS | | | | | number | |
PLANNED_TOTAL_COST | W_PROJECT_DS | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_PROJECT_DS | | | | | number | |
BL_PLANNED_LABOR_COST | W_PROJECT_DS | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_PROJECT_DS | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_PROJECT_DS | | | | | number | |
BL_PLANNED_TOTAL_COST | W_PROJECT_DS | | | | | number | |
REMAINING_LABOR_COST | W_PROJECT_DS | | | | | number | |
REMAINING_MATERIAL_COST | W_PROJECT_DS | | | | | number | |
REMAINING_EXPENSE_COST | W_PROJECT_DS | | | | | number | |
REMAINING_NONLABOR_COST | W_PROJECT_DS | | | | | number | |
REMAINING_TOTAL_COST | W_PROJECT_DS | | | | | number | |
EARNED_VALUE_COST | W_PROJECT_DS | | | | | number | |
PLANNED_VALUE_COST | W_PROJECT_DS | | | | | number | |
EXPENSE_COST_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
LABOR_COST_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
COST_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
COST_PCT_CMP_OF_PLANNED | W_PROJECT_DS | | | | | number | |
MATERIAL_COST_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
NONLABOR_COST_PERCENT_COMPLETE | W_PROJECT_DS | | | | | number | |
COST_VARIANCE | W_PROJECT_DS | | | | | number | |
EXPENSE_COST_VARIANCE | W_PROJECT_DS | | | | | number | |
LABOR_COST_VARIANCE | W_PROJECT_DS | | | | | number | |
NONLABOR_COST_VARIANCE | W_PROJECT_DS | | | | | number | |
MATERIAL_COST_VARIANCE | W_PROJECT_DS | | | | | number | |
TOTAL_COST_VARIANCE | W_PROJECT_DS | | | | | number | |
SCHEDULE_VARIANCE_BY_COST | W_PROJECT_DS | | | | | number | |
AT_COMPLETION_TOTAL_COST_VAR | W_PROJECT_DS | | | | | number | |
HISTORY_INTERVAL | W_PROJECT_DS | | | | | string | |
HISTORY_LEVEL | W_PROJECT_DS | | | | | string | |
LOCATION_ID | W_PROJECT_DS | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
PROJECT_WID | W_PROJECT_HISTORY_F | | | | | bigint | |
DAY_WID | W_PROJECT_HISTORY_F | | | | | bigint | |
EPS_WID | W_PROJECT_HISTORY_F | | | | | bigint | |
PROJECT_OBJECT_ID | W_PROJECT_HISTORY_F | | | | | integer | |
EPS_OBJECT_ID | W_PROJECT_HISTORY_F | | | | | bigint | |
PERIOD_START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
PERIOD_END_DATE | W_PROJECT_HISTORY_F | | | | | date | |
PLANNED_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
PLANNED_FINISH_DATE | W_PROJECT_HISTORY_F | | | | | date | |
START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
FINISH_DATE | W_PROJECT_HISTORY_F | | | | | date | |
ACTUAL_START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
ACTUAL_FINISH_DATE | W_PROJECT_HISTORY_F | | | | | date | |
REMAINING_START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
REMAINING_FINISH_DATE | W_PROJECT_HISTORY_F | | | | | date | |
BASELINE_START_DATE | W_PROJECT_HISTORY_F | | | | | date | |
BASELINE_FINISH_DATE | W_PROJECT_HISTORY_F | | | | | date | |
PLANNED_DURATION | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_DURATION | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_DURATION | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_DURATION | W_PROJECT_HISTORY_F | | | | | number | |
BASELINE_DURATION | W_PROJECT_HISTORY_F | | | | | number | |
TOTAL_FLOAT | W_PROJECT_HISTORY_F | | | | | number | |
DURATION_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
DURATION_PCT_OF_PLANNED | W_PROJECT_HISTORY_F | | | | | number | |
DURATION_VARIANCE | W_PROJECT_HISTORY_F | | | | | number | |
UNITS_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
LABOR_UNITS_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
SCHEDULE_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
PERFORMANCE_PCT_COMPLETE | W_PROJECT_HISTORY_F | | | | | number | |
START_DATE_VARIANCE | W_PROJECT_HISTORY_F | | | | | number | |
FINISH_DATE_VARIANCE | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST | W_PROJECT_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
EARNED_VALUE_COST | W_PROJECT_HISTORY_F | | | | | number | |
PROJECT_RISK_SCORE | W_PROJECT_HISTORY_F | | | | | number | |
PROJECT_RISK_EXPOSURE | W_PROJECT_HISTORY_F | | | | | number | |
NOT_STARTED_ACTIVITY_COUNT | W_PROJECT_HISTORY_F | | | | | integer | |
IN_PROGRESS_ACTIVITY_COUNT | W_PROJECT_HISTORY_F | | | | | integer | |
COMPLETED_ACTIVITY_COUNT | W_PROJECT_HISTORY_F | | | | | integer | |
NEW_ACTIVITY_COUNT | W_PROJECT_HISTORY_F | | | | | integer | |
ACTUAL_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
EST_AT_COMPL_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
REM_LATE_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
EARNED_VALUE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_UNITS_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_MATERIAL_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
NEXT_PER_EXPENSE_COST_P | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
PREV_THIS_PER_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
W_UPDATE_DT | W_PROJECT_HISTORY_F | | | | | date | |
W_CREATE_DT | W_PROJECT_HISTORY_F | | | | | date | |
DELETE_FLAG | W_PROJECT_HISTORY_F | | | | | string | |
DATASOURCE_ID | W_PROJECT_HISTORY_F | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ResourceAssignmentObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
StartDate | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | date | |
EndDate | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | date | |
ResourceObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
RoleObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
ActivityObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
WBSObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
ProjectObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
CostAccountObjectId | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | int | |
ActualRegularUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
ActualOvertimeUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
ActualUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
AtCompletionUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
PlannedUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
RemainingUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
RemainingLateUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
StaffedRemainingUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
StaffedRemainingLateUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
UnstaffedRemainingUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
UnstaffedRemainingLateUnits | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
ActualRegularCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
ActualOvertimeCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
ActualCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
AtCompletionCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
PlannedCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
RemainingCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
RemainingLateCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
StaffedRemainingCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
StaffedRemainingLateCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
UnstaffedRemainingCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
UnstaffedRemainingLateCost | W_RESOURCE_ASSIGNMENT_SPRD_FS | | | | | number | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
RESOURCE_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
ROLE_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
PROJECT_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
ACTIVITY_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
WBS_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
EPS_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
DAY_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
COST_ACCOUNT_WID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
RESOURCE_ASSIGNMENT_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
START_DATE | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | date | |
END_DATE | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | date | |
RESOURCE_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
ROLE_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
ACTIVITY_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
WBS_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
PROJECT_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
COST_ACCOUNT_OBJECT_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | int | |
ACTUAL_REGULAR_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
ACTUAL_OVERTIME_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
ACTUAL_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
AT_COMPLETION_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
PLANNED_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
REMAINING_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
REMAINING_LATE_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
STAFFED_REMAINING_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
STAFFED_REMAINING_LATE_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
UNSTAFFED_REMAINING_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
UNSTAFFED_REMAINING_LATE_UNITS | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
ACTUAL_REGULAR_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
ACTUAL_OVERTIME_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
ACTUAL_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
AT_COMPLETION_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
PLANNED_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
REMAINING_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
REMAINING_LATE_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
STAFFED_REMAINING_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
STAFFED_REMAINING_LATE_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
UNSTAFFED_REMAINING_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
UNSTAFFED_REMAINING_LATE_COST | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | number | |
W_UPDATE_DT | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | date | |
W_CREATE_DT | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | date | |
DELETE_FLAG | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | string | |
DATASOURCE_ID | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
CHANGE_SKEY | W_RESOURCE_ASSIGNMENT_SPREAD_F | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
resourceobjectid | W_RESOURCECODEASSIGNMENT_DS | | | | | integer | ResourceCodeAssignment - ResourceObjectId maps to RSRCRCAT.rsrc_id |
resourcecodetypeobjectid | W_RESOURCECODEASSIGNMENT_DS | | | | | integer | ResourceCodeAssignment - ResourceCodetypeObjectId maps to RSRCRCAT.rsrc_catg_type_id |
resourcecodeobjectid | W_RESOURCECODEASSIGNMENT_DS | | | | | integer | ResourceCodeAssignment - ResourceCodeObjectId maps to RSRCRCAT.rsrc_catg_id |
lastupdateuser | W_RESOURCECODEASSIGNMENT_DS | | | | | string | Last Update User |
lastupdatedate | W_RESOURCECODEASSIGNMENT_DS | | | | | date | Last Update Date |
createuser | W_RESOURCECODEASSIGNMENT_DS | | | | | string | Create User |
createdate | W_RESOURCECODEASSIGNMENT_DS | | | | | date | Create Date |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
ROW_WID | W_WBS_D | | | | | bigint | |
PARENT_ROW_WID | W_WBS_D | | | | | bigint | |
WBS_OBJECT_ID | W_WBS_D | | | | | bigint | |
PROJECT_OBJECT_ID | W_WBS_D | | | | | bigint | |
PARENT_OBJECT_ID | W_WBS_D | | | | | bigint | |
WBS_SHORT_NAME | W_WBS_D | | | | | string | |
WBS_NAME | W_WBS_D | | | | | string | |
OBS_OBJECT_ID | W_WBS_D | | | | | integer | |
SEQ_NUM | W_WBS_D | | | | | integer | |
SUM_DATA_FLAG | W_WBS_D | | | | | string | |
PROJECT_WBS_FLAG | W_WBS_D | | | | | string | |
STATUS_CODE | W_WBS_D | | | | | string | |
EV_USER_PCT | W_WBS_D | | | | | double | |
EV_ETC_USER_VALUE | W_WBS_D | | | | | double | |
INDEP_REMAIN_WORK_QTY | W_WBS_D | | | | | double | |
ANTICIP_START_DATE | W_WBS_D | | | | | date | |
ANTICIP_END_DATE | W_WBS_D | | | | | date | |
EV_COMPUTE_TYPE | W_WBS_D | | | | | string | |
EV_ETC_COMPUTE_TYPE | W_WBS_D | | | | | string | |
FINISH_DATE | W_WBS_D | | | | | date | |
FORECAST_START_DATE | W_WBS_D | | | | | date | |
FORECAST_FINISH_DATE | W_WBS_D | | | | | date | |
FULLNAME | W_WBS_D | | | | | string | |
OBSNAME | W_WBS_D | | | | | string | |
PROJECTID | W_WBS_D | | | | | string | |
START_DATE | W_WBS_D | | | | | date | |
CUSTOM_1 | W_WBS_D | | | | | string | |
CUSTOM_2 | W_WBS_D | | | | | string | |
CUSTOM_3 | W_WBS_D | | | | | string | |
CUSTOM_4 | W_WBS_D | | | | | string | |
CUSTOM_5 | W_WBS_D | | | | | string | |
ACTUAL_START_DATE | W_WBS_D | | | | | date | |
ACTUAL_FINISH_DATE | W_WBS_D | | | | | date | |
BASELINE_START_DATE | W_WBS_D | | | | | date | |
BASELINE_FINISH_DATE | W_WBS_D | | | | | date | |
PLANNED_START_DATE | W_WBS_D | | | | | date | |
PLANNED_FINISH_DATE | W_WBS_D | | | | | date | |
PROGRESS_FINISH_DATE | W_WBS_D | | | | | date | |
REMAINING_START_DATE | W_WBS_D | | | | | date | |
REMAINING_FINISH_DATE | W_WBS_D | | | | | date | |
PLANNED_DURATION | W_WBS_D | | | | | number | |
ACTUAL_DURATION | W_WBS_D | | | | | number | |
AT_COMPLETION_DURATION | W_WBS_D | | | | | number | |
BASELINE_DURATION | W_WBS_D | | | | | number | |
REMAINING_DURATION | W_WBS_D | | | | | number | |
DURATION_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
DURATION_PERCENT_OF_PLANNED | W_WBS_D | | | | | number | |
DURATION_VARIANCE | W_WBS_D | | | | | number | |
ACTUAL_LABOR_UNITS | W_WBS_D | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_WBS_D | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_WBS_D | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_WBS_D | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_WBS_D | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_WBS_D | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_WBS_D | | | | | number | |
PLANNED_LABOR_UNITS | W_WBS_D | | | | | number | |
PLANNED_NONLABOR_UNITS | W_WBS_D | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_WBS_D | | | | | number | |
REMAINING_LABOR_UNITS | W_WBS_D | | | | | number | |
REMAINING_NONLABOR_UNITS | W_WBS_D | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_WBS_D | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_WBS_D | | | | | number | |
ACCOUNTING_VAR_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
BAC_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
LABOR_UNITS_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
ACTUAL_VALUE_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
FINISH_DATE_VARIANCE | W_WBS_D | | | | | number | |
LABOR_UNITS_VARIANCE | W_WBS_D | | | | | number | |
NONLABOR_UNITS_VARIANCE | W_WBS_D | | | | | number | |
SCHEDULE_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
PERFORMANCE_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
START_DATE_VARIANCE | W_WBS_D | | | | | number | |
TOTAL_FLOAT | W_WBS_D | | | | | number | |
UNITS_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_WBS_D | | | | | number | |
PERF_PCT_CMP_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
SCHD_PCT_CMP_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
SCHEDULE_VAR_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
VARIANCE_AT_CMP_BY_LABOR_UNITS | W_WBS_D | | | | | number | |
ORIG_COST | W_WBS_D | | | | | double | |
INDEP_REMAIN_TOTAL_COST | W_WBS_D | | | | | double | |
CURRENTBUDGET | W_WBS_D | | | | | number | |
CURRENTVARIANCE | W_WBS_D | | | | | number | |
DISTRIBUTEDCURRENTBUDGET | W_WBS_D | | | | | number | |
PROPOSEDBUDGET | W_WBS_D | | | | | number | |
TOTALBENEFITPLAN | W_WBS_D | | | | | number | |
TOTALBENEFITPLANTALLY | W_WBS_D | | | | | number | |
TOTALSPENDINGPLAN | W_WBS_D | | | | | number | |
TOTALSPENDINGPLANTALLY | W_WBS_D | | | | | number | |
UNALLOCATEDBUDGET | W_WBS_D | | | | | number | |
UNDISTRIBUTEDCURRENTVARIANCE | W_WBS_D | | | | | number | |
ACCOUNTING_VARIANCE_BY_COST | W_WBS_D | | | | | number | |
BUDGET_AT_COMPLETION_BY_COST | W_WBS_D | | | | | number | |
EST_AT_COMPLETION_COST | W_WBS_D | | | | | number | |
EST_TO_COMPLETE_COST | W_WBS_D | | | | | number | |
PLANNED_EXPENSE_COST | W_WBS_D | | | | | number | |
PLANNED_LABOR_COST | W_WBS_D | | | | | number | |
PLANNED_MATERIAL_COST | W_WBS_D | | | | | number | |
PLANNED_NONLABOR_COST | W_WBS_D | | | | | number | |
PLANNED_TOTAL_COST | W_WBS_D | | | | | number | |
ACTUAL_EXPENSE_COST | W_WBS_D | | | | | number | |
ACTUAL_LABOR_COST | W_WBS_D | | | | | number | |
ACTUAL_MATERIAL_COST | W_WBS_D | | | | | number | |
ACTUAL_NONLABOR_COST | W_WBS_D | | | | | number | |
ACTUAL_TOTAL_COST | W_WBS_D | | | | | number | |
ACTUAL_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_LABOR_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_WBS_D | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_WBS_D | | | | | number | |
BL_PLANNED_LABOR_COST | W_WBS_D | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_WBS_D | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_WBS_D | | | | | number | |
BL_PLANNED_TOTAL_COST | W_WBS_D | | | | | number | |
REMAINING_LABOR_COST | W_WBS_D | | | | | number | |
REMAINING_MATERIAL_COST | W_WBS_D | | | | | number | |
REMAINING_EXPENSE_COST | W_WBS_D | | | | | number | |
REMAINING_NONLABOR_COST | W_WBS_D | | | | | number | |
REMAINING_TOTAL_COST | W_WBS_D | | | | | number | |
EARNED_VALUE_COST | W_WBS_D | | | | | number | |
PLANNED_VALUE_COST | W_WBS_D | | | | | number | |
EXPENSE_COST_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
LABOR_COST_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
COST_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
COST_PCT_CMP_OF_PLANNED | W_WBS_D | | | | | number | |
MATERIAL_COST_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
NONLABOR_COST_PERCENT_COMPLETE | W_WBS_D | | | | | number | |
COST_VARIANCE | W_WBS_D | | | | | number | |
EXPENSE_COST_VARIANCE | W_WBS_D | | | | | number | |
LABOR_COST_VARIANCE | W_WBS_D | | | | | number | |
NONLABOR_COST_VARIANCE | W_WBS_D | | | | | number | |
MATERIAL_COST_VARIANCE | W_WBS_D | | | | | number | |
TOTAL_COST_VARIANCE | W_WBS_D | | | | | number | |
SCHEDULE_VARIANCE_BY_COST | W_WBS_D | | | | | number | |
AT_COMPLETION_TOTAL_COST_VAR | W_WBS_D | | | | | number | |
W_UPDATE_DT | W_WBS_D | | | | | date | |
W_CREATE_DT | W_WBS_D | | | | | date | |
DELETE_FLAG | W_WBS_D | | | | | string | |
DATASOURCE_ID | W_WBS_D | | | | | bigint | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
WBS_OBJECT_ID | W_WBS_DS | | | | | bigint | |
PROJECT_OBJECT_ID | W_WBS_DS | | | | | bigint | |
PARENT_OBJECT_ID | W_WBS_DS | | | | | bigint | |
WBS_SHORT_NAME | W_WBS_DS | | | | | string | |
WBS_NAME | W_WBS_DS | | | | | string | |
OBS_OBJECT_ID | W_WBS_DS | | | | | integer | |
SEQ_NUM | W_WBS_DS | | | | | integer | |
SUM_DATA_FLAG | W_WBS_DS | | | | | string | |
PROJECT_WBS_FLAG | W_WBS_DS | | | | | string | |
STATUS_CODE | W_WBS_DS | | | | | string | |
EV_USER_PCT | W_WBS_DS | | | | | double | |
EV_ETC_USER_VALUE | W_WBS_DS | | | | | double | |
ORIG_COST | W_WBS_DS | | | | | double | |
INDEP_REMAIN_TOTAL_COST | W_WBS_DS | | | | | double | |
INDEP_REMAIN_WORK_QTY | W_WBS_DS | | | | | double | |
ANTICIP_START_DATE | W_WBS_DS | | | | | date | |
ANTICIP_END_DATE | W_WBS_DS | | | | | date | |
EV_COMPUTE_TYPE | W_WBS_DS | | | | | string | |
EV_ETC_COMPUTE_TYPE | W_WBS_DS | | | | | string | |
CURRENTBUDGET | W_WBS_DS | | | | | number | |
CURRENTVARIANCE | W_WBS_DS | | | | | number | |
DISTRIBUTEDCURRENTBUDGET | W_WBS_DS | | | | | number | |
FINISHDATE | W_WBS_DS | | | | | date | |
FORECAST_FINISH_DATE | W_WBS_DS | | | | | date | |
FORECAST_START_DATE | W_WBS_DS | | | | | date | |
FULLNAME | W_WBS_DS | | | | | string | |
OBSNAME | W_WBS_DS | | | | | string | |
PROJECTID | W_WBS_DS | | | | | string | |
PROPOSEDBUDGET | W_WBS_DS | | | | | number | |
PLANNED_START_DATE | W_WBS_DS | | | | | date | |
PLANNED_FINISH_DATE | W_WBS_DS | | | | | date | |
PLANNED_DURATION | W_WBS_DS | | | | | number | |
STARTDATE | W_WBS_DS | | | | | date | |
ACTUAL_START_DATE | W_WBS_DS | | | | | date | |
ACTUAL_FINISH_DATE | W_WBS_DS | | | | | date | |
BASELINE_START_DATE | W_WBS_DS | | | | | date | |
BASELINE_FINISH_DATE | W_WBS_DS | | | | | date | |
PROGRESS_FINISH_DATE | W_WBS_DS | | | | | date | |
REMAINING_START_DATE | W_WBS_DS | | | | | date | |
REMAINING_FINISH_DATE | W_WBS_DS | | | | | date | |
ACTUAL_DURATION | W_WBS_DS | | | | | number | |
AT_COMPLETION_DURATION | W_WBS_DS | | | | | number | |
BASELINE_DURATION | W_WBS_DS | | | | | number | |
REMAINING_DURATION | W_WBS_DS | | | | | number | |
DURATION_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
DURATION_PERCENT_OF_PLANNED | W_WBS_DS | | | | | number | |
DURATION_VARIANCE | W_WBS_DS | | | | | number | |
ACTUAL_LABOR_UNITS | W_WBS_DS | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_WBS_DS | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_WBS_DS | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_WBS_DS | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_WBS_DS | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_WBS_DS | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_WBS_DS | | | | | number | |
PLANNED_LABOR_UNITS | W_WBS_DS | | | | | number | |
PLANNED_NONLABOR_UNITS | W_WBS_DS | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_WBS_DS | | | | | number | |
REMAINING_LABOR_UNITS | W_WBS_DS | | | | | number | |
REMAINING_NONLABOR_UNITS | W_WBS_DS | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_WBS_DS | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_WBS_DS | | | | | number | |
ACCOUNTING_VAR_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
BAC_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
LABOR_UNITS_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
ACTUAL_VALUE_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
FINISH_DATE_VARIANCE | W_WBS_DS | | | | | number | |
LABOR_UNITS_VARIANCE | W_WBS_DS | | | | | number | |
NONLABOR_UNITS_VARIANCE | W_WBS_DS | | | | | number | |
SCHEDULE_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
PERFORMANCE_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
START_DATE | W_WBS_DS | | | | | date | |
FINISH_DATE | W_WBS_DS | | | | | date | |
START_DATE_VARIANCE | W_WBS_DS | | | | | number | |
TOTAL_FLOAT | W_WBS_DS | | | | | number | |
UNITS_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_WBS_DS | | | | | number | |
PERF_PCT_CMP_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
SCHD_PCT_CMP_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
SCHEDULE_VAR_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
VARIANCE_AT_CMP_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
COST_VARIANCE_BY_LABOR_UNITS | W_WBS_DS | | | | | number | |
ACCOUNTING_VARIANCE_BY_COST | W_WBS_DS | | | | | number | |
BUDGET_AT_COMPLETION_BY_COST | W_WBS_DS | | | | | number | |
EST_AT_COMPLETION_COST | W_WBS_DS | | | | | number | |
EST_TO_COMPLETE_COST | W_WBS_DS | | | | | number | |
PLANNED_EXPENSE_COST | W_WBS_DS | | | | | number | |
PLANNED_LABOR_COST | W_WBS_DS | | | | | number | |
PLANNED_MATERIAL_COST | W_WBS_DS | | | | | number | |
PLANNED_NONLABOR_COST | W_WBS_DS | | | | | number | |
PLANNED_TOTAL_COST | W_WBS_DS | | | | | number | |
ACTUAL_EXPENSE_COST | W_WBS_DS | | | | | number | |
ACTUAL_LABOR_COST | W_WBS_DS | | | | | number | |
ACTUAL_MATERIAL_COST | W_WBS_DS | | | | | number | |
ACTUAL_NONLABOR_COST | W_WBS_DS | | | | | number | |
ACTUAL_TOTAL_COST | W_WBS_DS | | | | | number | |
ACTUAL_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_LABOR_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_WBS_DS | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_WBS_DS | | | | | number | |
BL_PLANNED_LABOR_COST | W_WBS_DS | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_WBS_DS | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_WBS_DS | | | | | number | |
BL_PLANNED_TOTAL_COST | W_WBS_DS | | | | | number | |
REMAINING_LABOR_COST | W_WBS_DS | | | | | number | |
REMAINING_MATERIAL_COST | W_WBS_DS | | | | | number | |
REMAINING_EXPENSE_COST | W_WBS_DS | | | | | number | |
REMAINING_NONLABOR_COST | W_WBS_DS | | | | | number | |
REMAINING_TOTAL_COST | W_WBS_DS | | | | | number | |
EARNED_VALUE_COST | W_WBS_DS | | | | | number | |
PLANNED_VALUE_COST | W_WBS_DS | | | | | number | |
EXPENSE_COST_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
LABOR_COST_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
COST_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
COST_PCT_CMP_OF_PLANNED | W_WBS_DS | | | | | number | |
MATERIAL_COST_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
NONLABOR_COST_PERCENT_COMPLETE | W_WBS_DS | | | | | number | |
COST_VARIANCE | W_WBS_DS | | | | | number | |
EXPENSE_COST_VARIANCE | W_WBS_DS | | | | | number | |
LABOR_COST_VARIANCE | W_WBS_DS | | | | | number | |
NONLABOR_COST_VARIANCE | W_WBS_DS | | | | | number | |
MATERIAL_COST_VARIANCE | W_WBS_DS | | | | | number | |
TOTAL_COST_VARIANCE | W_WBS_DS | | | | | number | |
SCHEDULE_VARIANCE_BY_COST | W_WBS_DS | | | | | number | |
AT_COMPLETION_TOTAL_COST_VAR | W_WBS_DS | | | | | number | |
TOTALBENEFITPLAN | W_WBS_DS | | | | | number | |
TOTALBENEFITPLANTALLY | W_WBS_DS | | | | | number | |
TOTALSPENDINGPLAN | W_WBS_DS | | | | | number | |
TOTALSPENDINGPLANTALLY | W_WBS_DS | | | | | number | |
UNALLOCATEDBUDGET | W_WBS_DS | | | | | number | |
UNDISTRIBUTEDCURRENTVARIANCE | W_WBS_DS | | | | | number | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
WBS_WID | W_WBS_HISTORY_F | | | | | bigint | |
DAY_WID | W_WBS_HISTORY_F | | | | | bigint | |
WBS_OBJECT_ID | W_WBS_HISTORY_F | | | | | bigint | |
PROJECT_OBJECT_ID | W_WBS_HISTORY_F | | | | | bigint | |
PROJECT_WID | W_WBS_HISTORY_F | | | | | bigint | |
EPS_WID | W_WBS_HISTORY_F | | | | | bigint | |
PERIOD_START_DATE | W_WBS_HISTORY_F | | | | | date | |
PERIOD_END_DATE | W_WBS_HISTORY_F | | | | | date | |
PLANNED_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
PLANNED_START_DATE | W_WBS_HISTORY_F | | | | | date | |
PLANNED_FINISH_DATE | W_WBS_HISTORY_F | | | | | date | |
ACTUAL_START_DATE | W_WBS_HISTORY_F | | | | | date | |
ACTUAL_FINISH_DATE | W_WBS_HISTORY_F | | | | | date | |
REMAINING_START_DATE | W_WBS_HISTORY_F | | | | | date | |
REMAINING_FINISH_DATE | W_WBS_HISTORY_F | | | | | date | |
START_DATE | W_WBS_HISTORY_F | | | | | date | |
FINISH_DATE | W_WBS_HISTORY_F | | | | | date | |
BASELINE_START_DATE | W_WBS_HISTORY_F | | | | | date | |
BASELINE_FINISH_DATE | W_WBS_HISTORY_F | | | | | date | |
PLANNED_DURATION | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_DURATION | W_WBS_HISTORY_F | | | | | number | |
REMAINING_DURATION | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_DURATION | W_WBS_HISTORY_F | | | | | number | |
BASELINE_DURATION | W_WBS_HISTORY_F | | | | | number | |
TOTAL_FLOAT | W_WBS_HISTORY_F | | | | | number | |
DURATION_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
DURATION_PCT_OF_PLANNED | W_WBS_HISTORY_F | | | | | number | |
DURATION_VARIANCE | W_WBS_HISTORY_F | | | | | number | |
UNITS_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
LABOR_UNITS_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
NONLABOR_UNITS_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
SCHEDULE_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
PERFORMANCE_PCT_COMPLETE | W_WBS_HISTORY_F | | | | | number | |
START_DATE_VARIANCE | W_WBS_HISTORY_F | | | | | number | |
FINISH_DATE_VARIANCE | W_WBS_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST | W_WBS_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST | W_WBS_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_COST | W_WBS_HISTORY_F | | | | | number | |
EARNED_VALUE_COST | W_WBS_HISTORY_F | | | | | number | |
PROJECT_RISK_SCORE | W_WBS_HISTORY_F | | | | | number | |
PROJECT_RISK_EXPOSURE | W_WBS_HISTORY_F | | | | | number | |
NOT_STARTED_ACTIVITY_COUNT | W_WBS_HISTORY_F | | | | | integer | |
IN_PROGRESS_ACTIVITY_COUNT | W_WBS_HISTORY_F | | | | | integer | |
COMPLETED_ACTIVITY_COUNT | W_WBS_HISTORY_F | | | | | integer | |
NEW_ACTIVITY_COUNT | W_WBS_HISTORY_F | | | | | integer | |
ACTUAL_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
EARNED_VALUE_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
EST_AT_COMPL_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
REM_LATE_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
ACTUAL_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
AT_COMPLETION_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
EARNED_VALUE_COST_P | W_WBS_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST_P | W_WBS_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
PLANNED_VALUE_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_PLANNED_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
BL_ACTUAL_TOTAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_LABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_UNITS_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_NONLABOR_COST_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_MATERIAL_COST_P | W_WBS_HISTORY_F | | | | | number | |
NEXT_PER_EXPENSE_COST_P | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_LABOR_COST | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_UNITS | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_NONLABOR_COST | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_MATERIAL_COST | W_WBS_HISTORY_F | | | | | number | |
PREV_THIS_PER_EXPENSE_COST | W_WBS_HISTORY_F | | | | | number | |
W_UPDATE_DT | W_WBS_HISTORY_F | | | | | date | |
W_CREATE_DT | W_WBS_HISTORY_F | | | | | date | |
DELETE_FLAG | W_WBS_HISTORY_F | | | | | string | |
DATASOURCE_ID | W_WBS_HISTORY_F | | | | | bigint | |