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 | |
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 | |
EST_TO_COMPLETE | 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 | |
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_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 | |
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 | |
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 | |
BL1_PLANNED_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_LABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_NONLABOR_UNITS | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_PLANNED_TOTAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_EXPENSE_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_LABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_MATERIAL_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_ACTUAL_NONLABOR_COST | W_ACTIVITY_SPREAD_F | | | | | number | |
BL1_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 |
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 | |
ACTUAL_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 | |
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 | |
EARNED_VALUE_COST | W_PROJECT_HISTORY_F | | | | | number | |
EST_AT_COMPLETION_COST | W_PROJECT_HISTORY_F | | | | | number | |
EST_TO_COMPLETE_COST | 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 | |
PLANNED_VALUE_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
ACTUAL_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 | |
EARNED_VALUE_LABOR_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 | |
PLANNED_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
PLANNED_VALUE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_LATE_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
REMAINING_NONLABOR_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 | |
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 | |
BL1_PLANNED_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_LABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_NONLABOR_UNITS | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_PLANNED_TOTAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_EXPENSE_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_LABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_MATERIAL_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_NONLABOR_COST | W_PROJECT_HISTORY_F | | | | | number | |
BL1_ACTUAL_TOTAL_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 |
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 | |
CAPACITY | 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 |
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 | |
change_skey | 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 |
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 | |
change_skey | 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 |
TASK_ID | W_CODE_ASSIGNMENTS_ACTV_S | | | | | int | |
CODE_VALUE_01 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_01 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_02 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_02 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_03 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_03 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_04 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_04 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_05 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_05 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_06 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_06 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_07 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_07 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_08 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_08 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_09 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_09 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_10 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_10 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_11 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_11 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_12 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_12 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_13 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_13 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_14 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_14 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_15 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_15 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_16 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_16 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_17 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_17 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_18 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_18 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_19 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_19 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_VALUE_20 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
CODE_DESCR_20 | W_CODE_ASSIGNMENTS_ACTV_S | | | | | string | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
PROJ_ID | W_CODE_ASSIGNMENTS_PROJ_S | | | | | int | |
CODE_VALUE_01 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_01 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_02 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_02 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_03 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_03 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_04 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_04 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_05 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_05 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_06 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_06 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_07 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_07 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_08 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_08 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_09 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_09 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_10 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_10 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_11 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_11 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_12 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_12 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_13 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_13 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_14 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_14 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_15 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_15 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_16 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_16 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_17 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_17 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_18 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_18 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_19 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_19 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_VALUE_20 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
CODE_DESCR_20 | W_CODE_ASSIGNMENTS_PROJ_S | | | | | string | |
STAR Field Name | STAR Table Name | API Table Name | API Field Name | PMDB Table Name | PMDB Field Name | Data Type | Description |
RSRC_ID | W_CODE_ASSIGNMENTS_RSRC_S | | | | | int | |
CODE_VALUE_01 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_01 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_02 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_02 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_03 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_03 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_04 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_04 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_05 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_05 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_06 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_06 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_07 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_07 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_08 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_08 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_09 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_09 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_10 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_10 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_11 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_11 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_12 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_12 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_13 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_13 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_14 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_14 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_15 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_15 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_16 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_16 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_17 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_17 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_18 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_18 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_19 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_19 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_VALUE_20 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
CODE_DESCR_20 | W_CODE_ASSIGNMENTS_RSRC_S | | | | | string | |
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 |
isbaseline | W_CALENDAR_FS | | | | | string | Calendar - IsBaseline maps to CALENDAR.IsBaseline |
skey | W_CALENDAR_FS | | | | | identity | SKey generated key on Calendar |