| Assignments |
This table will store the details of the resource assignments made for a task. Each assignment of a resource to a task is identified by an uniqueID |
RESERVED_DATA |
char(1) |
|
No |
No |
| |
|
PROJ_ID |
decimal |
|
|
|
| |
|
ASSN_ACT_FINISH |
datetime |
|
|
|
| |
|
ASSN_ACT_START |
|
|
|
|
| |
|
ASSN_ACWP |
float |
|
|
|
| |
|
ASSN_BCWP |
|
|
|
|
| |
|
ASSN_BCWS |
|
|
|
|
| |
|
ASSN_RES_TYPE |
numeric(2) |
|
|
|
| |
|
ASSN_IS_OVERALLOCATED |
|
|
|
|
| |
|
ASSN_WORK_CONTOUR |
numeric(6) |
|
|
|
| |
|
ASSN_START_VAR |
decimal |
|
|
|
| |
|
ASSN_FINISH_VAR |
|
|
|
|
| |
|
ASSN_UPDATE_NEEDED |
numeric(2) |
|
|
|
| |
|
EXT_EDIT_REF_DATA |
varchar(255) |
|
|
|
| |
|
ASSN_UID |
decimal |
|
|
|
| |
|
ASSN_HAS_LINKED_FIELDS |
numeric(2) |
|
|
|
| |
|
ASSN_IS_CONFIRMED |
|
|
|
|
| |
|
ASSN_RESPONSE_PENDING |
|
|
|
|
| |
|
ASSN_HAS_NOTES |
|
|
|
|
| |
|
ASSN_TEAM_STATUS_PENDING |
|
|
|
|
| |
|
TASK_UID |
decimal |
|
|
|
| |
|
RES_UID |
|
|
|
|
| |
|
ASSN_START_DATE |
datetime |
|
|
|
| |
|
ASSN_FINISH_DATE |
|
|
|
|
| |
|
ASSN_DELAY |
decimal |
|
|
|
| |
|
ASSN_DELAY_FMT |
numeric(6) |
|
|
|
| |
|
ASSN_LEVELING_DELAY |
decimal |
|
|
|
| |
|
ASSN_COST_RATE_TABLE |
numeric(6) |
|
|
|
| |
|
ASSN_BASE_START |
datetime |
|
|
|
| |
|
ASSN_BASE_FINISH |
|
|
|
|
| |
|
ASSN_MATERIAL_RATE_FMT |
numeric(6) |
|
|
|
| |
|
ASSN_UNITS |
float |
|
|
|
| |
|
ASSN_WORK |
|
|
|
|
| |
|
ASSN_ACT_WORK |
|
|
|
|
| |
|
ASSN_REG_WORK |
|
|
|
|
| |
|
ASSN_REM_WORK |
|
|
|
|
| |
|
ASSN_BASE_WORK |
|
|
|
|
| |
|
ASSN_COST |
|
|
|
|
| |
|
ASSN_ACT_COST |
|
|
|
|
| |
|
ASSN_REM_COST |
|
|
|
|
| |
|
ASSN_BASE_COST |
|
|
|
|
| |
|
ASSN_BASE_COST_PER_USE |
|
|
|
|
| |
|
ASSN_OVT_WORK |
|
|
|
|
| |
|
ASSN_ACT_OVT_WORK |
|
|
|
|
| |
|
ASSN_REM_OVT_WORK |
|
|
|
|
| |
|
ASSN_ACT_OVT_COST |
|
|
|
|
| |
|
ASSN_REM_OVT_COST |
|
|
|
|
| |
|
ASSN_RTF_NOTES |
image |
|
|
|
| Attribute_Strings |
|
PROJ_ID |
numeric(18) |
|
Yes |
|
| |
|
AS_ID |
decimal |
|
No |
|
| |
|
AS_POSITION |
|
|
|
|
| |
|
RESERVED_DATA |
char(1) |
|
|
|
| |
|
AS_VALUE |
varchar(255) |
|
|
|
| Calendar_Data |
This table stores the details of the calendars like weekday shift timings, exceptional working and non working days etc |
CD_UID |
decimal |
|
|
|
| |
|
RESERVED_DATA |
char(1) |
|
|
|
| |
|
CD_DAY_OR_EXCEPTION |
numeric(6) |
|
|
|
| |
|
CD_WORKING |
|
|
|
|
| |
|
CD_FROM_DATE |
datetime |
|
|
|
| |
|
CD_TO_DATE |
|
|
|
|
| |
|
CD_FROM_TIME1 |
|
|
|
|
| |
|
CD_TO_TIME1 |
|
|
|
|
| |
|
CD_FROM_TIME2 |
|
|
|
|
| |
|
CD_TO_TIME2 |
|
|
|
|
| |
|
CD_FROM_TIME3 |
|
|
|
|
| |
|
CD_TO_TIME3 |
|
|
|
|
| |
|
CD_FROM_TIME4 |
|
|
|
|
| |
|
CD_TO_TIME4 |
|
|
|
|
| |
|
CD_FROM_TIME5 |
|
|
|
|
| |
|
CD_TO_TIME5 |
|
|
|
|
| CALENDAR_DATA_TMP |
|
Cal_Uid |
decimal |
|
|
|
| |
|
Cal_Name |
varchar(255) |
|
|
|
| |
|
day_or_exception |
numeric(6) |
|
|
|
| |
|
working |
|
|
|
|
| |
|
From_Date |
datetime |
|
|
|
| |
|
To_Date |
|
|
|
|
| |
|
From_time1 |
|
|
|
|
| |
|
To_Time1 |
|
|
|
|
| |
|
From_time2 |
|
|
|
|
| |
|
To_Time2 |
|
|
|
|
| |
|
From_time3 |
|
|
|
|
| |
|
To_Time3 |
|
|
|
|
| |
|
From_time4 |
|
|
|
|
| |
|
To_Time4 |
|
|
|
|
| |
|
From_time5 |
|
|
|
|
| |
|
To_Time5 |
|
|
|
|
| Calendars |
This table stores all the calendars which can be of Type : Resource calendar or Task calendar or Project calendar |
CAL_UID |
decimal |
|
|
|
| |
|
RES_UID |
|
|
|
Yes |
| |
|
RESERVED_DATA |
char(1) |
|
|
No |
| |
|
CAL_BASE_UID |
decimal |
|
|
|
| |
|
CAL_IS_BASE_CAL |
numeric(2) |
|
|
|
| |
|
CAL_NAME |
varchar(255) |
|
|
|
| Conversions |
|
STRING_TYPE_ID |
decimal |
|
|
|
| |
|
CONV_VALUE |
|
|
|
|
| |
|
CONV_LANG_ID |
|
|
|
|
| |
|
CONV_STRING |
varchar(200) |
|
|
|
| EPIN_EMPLOYEE_PEND |
|
MASTER_OU_CODE |
decimal(17) |
|
|
|
| |
|
_unknown_ |
char(18) |
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
EMPLOYMENT_START_DATE |
datetime |
|
|
|
| |
|
REQUEST_FOR_DELETION |
decimal(17) |
|
|
|
| |
|
AUTHORIZE_FLAG |
varchar(1) |
|
|
|
| |
|
REJECTION_REASON |
varchar(255) |
|
|
|
| |
|
COMMENTS |
varchar(2000) |
|
|
|
| |
|
DOC_STATUS |
varchar(20) |
|
|
|
| |
|
CREATEDBY |
varchar(60) |
|
|
|
| |
|
CREATEDDATE |
datetime |
|
|
|
| |
|
MODIFIEDBY |
varchar(60) |
|
|
|
| |
|
MODIFIEDDATE |
datetime |
|
|
|
| |
|
TIMESTAMP |
decimal(9) |
|
|
|
| Field_Attributes |
|
PROJ_ID |
decimal |
|
|
|
| |
|
ATTRIB_FIELD_ID |
|
|
|
|
| |
|
ATTRIB_ID |
|
|
|
|
| |
|
RESERVED_DATA |
char(1) |
|
|
|
| |
|
ATTRIB_VALUE |
decimal |
|
|
|
| |
|
AS_ID |
|
|
|
|
| |
|
ATTRIB_EXT_EDITED |
numeric(2) |
|
|
|
| Links |
This table stores the relationships between different tasks. |
LINK_UID |
decimal |
|
|
|
| |
|
RESERVED_DATA |
char(1) |
|
|
|
| |
|
EXT_EDIT_REF_DATA |
varchar(255) |
|
|
|
| |
|
LINK_IS_CROSS_PROJ |
numeric(2) |
|
|
|
| |
|
LINK_PRED_UID |
decimal |
|
|
|
| |
|
LINK_SUCC_UID |
|
|
|
|
| |
|
LINK_TYPE |
numeric(6) |
|
|
|
| |
|
LINK_LAG_FMT |
|
|
|
|
| |
|
LINK_LAG |
decimal |
|
|
|
| Projects |
This table stores the Projects and it’s properties, created in MSP. The unique ID of the project is referenced by all other tables in MSP |
PROJ_ID |
|
|
|
|
| |
|
PROJ_NAME |
varchar(255) |
|
|
|
| |
|
PROJ_PROP_AUTHOR |
|
|
|
|
| |
|
PROJ_OPT_CALC_ACT_COSTS |
numeric(2) |
|
|
|
| |
|
PROJ_PROP_CATEGORY |
varchar(255) |
|
|
|
| |
|
PROJ_PROP_COMPANY |
|
|
|
|
| |
|
PROJ_OPT_CRITICAL_SLACK_LIMIT |
decimal |
|
|
|
| |
|
PROJ_OPT_CURRENCY_DIGITS |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_CURRENCY_POSITION |
|
|
|
|
| |
|
PROJ_OPT_CURRENCY_SYMBOL |
varchar(20) |
|
|
|
| |
|
PROJ_OPT_NEW_ARE_EFFORT_DRIVEN |
numeric(2) |
|
|
|
| |
|
PROJ_INFO_CURRENT_DATE |
datetime |
|
|
|
| |
|
PROJ_OPT_DEF_FINISH_TIME |
|
|
|
|
| |
|
PROJ_OPT_DEF_FIX_COST_ACCRUAL |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_MINUTES_PER_DAY |
decimal |
|
|
|
| |
|
PROJ_OPT_MINUTES_PER_WEEK |
|
|
|
|
| |
|
PROJ_OPT_DEF_OVT_RATE |
float |
|
|
|
| |
|
PROJ_OPT_DEF_STD_RATE |
|
|
|
|
| |
|
PROJ_OPT_DEF_START_TIME |
datetime |
|
|
|
| |
|
PROJ_OPT_DEF_TASK_TYPE |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_DUR_ENTRY_FMT |
|
|
|
|
| |
|
PROJ_INFO_FINISH_DATE |
datetime |
|
|
|
| |
|
PROJ_OPT_HONOR_CONSTRAINTS |
numeric(2) |
|
|
|
| |
|
PROJ_PROP_KEYWORDS |
varchar(255) |
|
|
|
| |
|
PROJ_LAST_SAVED |
datetime |
|
|
|
| |
|
PROJ_PROP_MANAGER |
varchar(255) |
|
|
|
| |
|
PROJ_OPT_MULT_CRITICAL_PATHS |
numeric(2) |
|
|
|
| |
|
PROJ_CREATION_DATE |
datetime |
|
|
|
| |
|
PROJ_POOL_ATTACHED_TO |
varchar(255) |
|
|
|
| |
|
PROJ_INFO_CAL_NAME |
|
|
|
|
| |
|
PROJ_IS_RES_POOL |
numeric(2) |
|
|
|
| |
|
PROJ_INFO_SCHED_FROM |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_SPLIT_IN_PROGRESS |
numeric(2) |
|
|
|
| |
|
PROJ_OPT_SPREAD_ACT_COSTS |
|
|
|
|
| |
|
PROJ_OPT_SPREAD_PCT_COMP |
|
|
|
|
| |
|
PROJ_INFO_START_DATE |
datetime |
|
|
|
| |
|
PROJ_INFO_STATUS_DATE |
|
|
|
|
| |
|
PROJ_PROP_SUBJECT |
varchar(255) |
|
|
|
| |
|
PROJ_PROP_TITLE |
|
|
|
|
| |
|
PROJ_OPT_TASK_UPDATES_RES |
numeric(2) |
|
|
|
| |
|
PROJ_OPT_WORK_ENTRY_FMT |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_CALC_SUB_AS_SUMMARY |
numeric(2) |
|
|
|
| |
|
PROJ_OPT_WEEK_START_DAY |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_FY_START_MONTH |
|
|
|
|
| |
|
PROJ_OPT_FY_USE_START_YR |
numeric(2) |
|
|
|
| |
|
PROJ_OPT_DAYS_PER_MONTH |
numeric(6) |
|
|
|
| |
|
PROJ_OPT_NEW_TASK_EST |
numeric(2) |
|
|
|
| |
|
PROJ_OPT_SHOW_EST_DUR |
|
|
|
|
| |
|
PROJ_OPT_EXPAND_TIMEPHASED |
|
|
|
|
| |
|
PROJ_EXT_EDITED_DATE |
|
|
|
|
| |
|
PROJ_EXT_EDITED_DUR |
|
|
|
|
| |
|
PROJ_EXT_EDITED_NUM |
|
|
|
|
| |
|
PROJ_EXT_EDITED_FLAG |
|
|
|
|
| |
|
PROJ_EXT_EDITED_CODE |
|
|
|
|
| |
|
PROJ_EXT_EDITED_TEXT |
|
|
|
|
| |
|
PROJ_EXT_EDITED |
|
|
|
|
| |
|
PROJ_DATA_SOURCE |
varchar(128) |
|
|
|
| |
|
PROJ_READ_ONLY |
varchar(10) |
|
|
|
| |
|
PROJ_READ_WRITE |
varchar(4) |
|
|
|
| |
|
PROJ_READ_COUNT |
varchar(10) |
|
|
|
| |
|
PROJ_LOCKED |
varchar(4) |
|
|
|
| |
|
PROJ_MACHINE_ID |
varchar(100) |
|
|
|
| |
|
RESERVED_BINARY_DATA |
image |
|
|
|
| |
|
PROJ_TIMESTAMP |
numeric(10) |
|
|
|
| |
|
PROJ_APP_TIMESTAMP |
|
|
|
|
| |
|
COMPONENT_NAME |
varchar(60) |
|
|
|
| |
|
IMPORT_SRVCE_NAME |
|
|
|
|
| |
|
PROJ_REF1 |
varchar(128) |
|
|
|
| |
|
PROJ_REF2 |
|
|
|
|
| |
|
PROJ_REF3 |
|
|
|
|
| |
|
PROJ_REF4 |
|
|
|
|
| |
|
PROJ_REF5 |
|
|
|
|
| |
|
PROJ_REF6 |
numeric(6) |
|
|
|
| |
|
PROJ_REF7 |
|
|
|
|
| |
|
PROJ_REF8 |
|
|
|
|
| |
|
PROJ_REF9 |
|
|
|
|
| |
|
PROJ_REF10 |
|
|
|
|
| RESOURCE_DET_TMP |
|
res_uid |
decimal |
|
|
|
| |
|
res_name |
varchar(255) |
|
|
|
| |
|
res_initials |
|
|
|
|
| |
|
res_type |
numeric(2) |
|
|
|
| |
|
res_max_units |
float |
|
|
|
| |
|
res_can_level |
numeric(2) |
|
|
|
| |
|
res_cal_uid |
decimal |
|
|
|
| |
|
cal_base_uid |
|
|
|
|
| |
|
cal_name |
varchar(255) |
|
|
|
| Resources |
This table stores all the resource details that are part of the project |
RES_UID |
numeric(18) |
|
Yes |
|
| |
|
RESERVED_DATA |
char(1) |
|
No |
|
| |
|
RES_ACWP |
float |
|
|
|
| |
|
RES_BCWP |
|
|
|
|
| |
|
RES_BCWS |
|
|
|
|
| |
|
RES_NUM_OBJECTS |
numeric(18) |
|
|
|
| |
|
EXT_EDIT_REF_DATA |
varchar(255) |
|
|
|
| |
|
RES_ID |
numeric(18) |
|
|
|
| |
|
RES_HAS_LINKED_FIELDS |
numeric(2) |
|
|
|
| |
|
RES_IS_OVERALLOCATED |
|
|
|
|
| |
|
RES_TYPE |
|
|
|
|
| |
|
RES_HAS_NOTES |
|
|
|
|
| |
|
RES_CAN_LEVEL |
|
|
|
|
| |
|
RES_STD_RATE_FMT |
numeric(6) |
|
|
|
| |
|
RES_OVT_RATE_FMT |
|
|
|
|
| |
|
RES_ACCRUE_AT |
|
|
|
|
| |
|
RES_WORKGROUP_MESSAGING |
|
|
|
|
| |
|
RES_CAL_UID |
numeric(18) |
|
|
|
| |
|
RES_AVAIL_FROM |
datetime |
|
|
|
| |
|
RES_AVAIL_TO |
|
|
|
|
| |
|
RES_STD_RATE |
float |
|
|
|
| |
|
RES_OVT_RATE |
|
|
|
|
| |
|
RES_MAX_UNITS |
|
|
|
|
| |
|
RES_WORK |
|
|
|
|
| |
|
RES_ACT_WORK |
|
|
|
|
| |
|
RES_BASE_WORK |
|
|
|
|
| |
|
RES_OVT_WORK |
|
|
|
|
| |
|
RES_COST_PER_USE |
|
|
|
|
| |
|
RES_REM_WORK |
|
|
|
|
| |
|
RES_REG_WORK |
|
|
|
|
| |
|
RES_ACT_OVT_WORK |
|
|
|
|
| |
|
RES_REM_OVT_WORK |
|
|
|
|
| |
|
RES_PEAK |
|
|
|
|
| |
|
RES_ACT_COST |
|
|
|
|
| |
|
RES_COST |
|
|
|
|
| |
|
RES_BASE_COST |
|
|
|
|
| |
|
RES_REM_COST |
|
|
|
|
| |
|
RES_OVT_COST |
|
|
|
|
| |
|
RES_ACT_OVT_COST |
|
|
|
|
| |
|
RES_REM_OVT_COST |
|
|
|
|
| |
|
RES_NAME |
varchar(255) |
|
|
|
| |
|
RES_INITIALS |
|
|
|
|
| |
|
RES_PHONETICS |
|
|
|
|
| |
|
RES_MATERIAL_LABEL |
|
|
|
|
| |
|
RES_RTF_NOTES |
image |
|
|
|
| |
|
RES_REF1 |
varchar(128) |
|
|
|
| |
|
RES_REF2 |
|
|
|
|
| |
|
RES_REF3 |
|
|
|
|
| |
|
RES_REF4 |
|
|
|
|
| |
|
RES_REF5 |
|
|
|
|
| |
|
RES_REF6 |
numeric(6) |
|
|
|
| |
|
RES_REF7 |
|
|
|
|
| |
|
RES_REF8 |
|
|
|
|
| |
|
RES_REF9 |
|
|
|
|
| |
|
RES_REF10 |
|
|
|
|
| String_Types |
|
STRING_TYPE_ID |
decimal |
|
|
|
| |
|
STRING_LANG_ID |
|
|
|
|
| |
|
STRING_TYPE |
varchar(200) |
|
|
|
| Tasks |
This table stores the tasks details that are part of the project. For every project created there will be a corresponding entry in this table with 0 as the unique ID |
RESERVED_DATA |
char(1) |
|
|
|
| |
|
TASK_ACWP |
float |
|
|
|
| |
|
TASK_BCWP |
|
|
|
|
| |
|
TASK_BCWS |
|
|
|
|
| |
|
TASK_DUR_VAR |
decimal |
|
|
|
| |
|
TASK_FINISH_VAR |
|
|
|
|
| |
|
TASK_OUTLINE_NUM |
varchar(255) |
|
|
|
| |
|
TASK_START_VAR |
decimal |
|
|
|
| |
|
TASK_IS_OVERALLOCATED |
numeric(2) |
|
|
|
| |
|
TASK_OVT_WORK |
float |
|
|
|
| |
|
TASK_VAC |
|
|
|
|
| |
|
TASK_REG_WORK |
|
|
|
|
| |
|
TASK_NUM_OBJECTS |
decimal |
|
|
|
| |
|
TASK_TOTAL_SLACK |
|
|
|
|
| |
|
EXT_EDIT_REF_DATA |
varchar(255) |
|
|
|
| |
|
TASK_UID |
decimal |
|
|
|
| |
|
TASK_ID |
|
|
|
|
| |
|
TASK_HAS_LINKED_FIELDS |
numeric(2) |
|
|
|
| |
|
TASK_IS_MILESTONE |
|
|
|
|
| |
|
TASK_IS_CRITICAL |
|
|
|
|
| |
|
TASK_IS_SUMMARY |
|
|
|
|
| |
|
TASK_IS_SUBPROJ |
|
|
|
|
| |
|
TASK_IS_MARKED |
|
|
|
|
| |
|
TASK_IGNORES_RES_CAL |
|
|
|
|
| |
|
TASK_IS_ROLLED_UP |
|
|
|
|
| |
|
TASK_IS_FROM_FINISH_SUBPROJ |
|
|
|
|
| |
|
TASK_BAR_IS_HIDDEN |
|
|
|
|
| |
|
TASK_IS_RECURRING |
|
|
|
|
| |
|
TASK_IS_RECURRING_SUMMARY |
|
|
|
|
| |
|
TASK_IS_EXTERNAL |
|
|
|
|
| |
|
TASK_IS_EFFORT_DRIVEN |
|
|
|
|
| |
|
TASK_IS_COLLAPSED |
|
|
|
|
| |
|
TASK_HAS_NOTES |
|
|
|
|
| |
|
TASK_IS_READONLY_SUBPROJ |
|
|
|
|
| |
|
TASK_LEVELING_CAN_SPLIT |
|
|
|
|
| |
|
TASK_LEVELING_ADJUSTS_ASSN |
|
|
|
|
| |
|
TASK_DUR_IS_EST |
|
|
|
|
| |
|
TASK_EARLY_FINISH |
datetime |
|
|
|
| |
|
TASK_LATE_START |
|
|
|
|
| |
|
TASK_STOP_DATE |
|
|
|
|
| |
|
TASK_RESUME_DATE |
|
|
|
|
| |
|
TASK_FREE_SLACK |
decimal |
|
|
|
| |
|
TASK_OUTLINE_LEVEL |
numeric(6) |
|
|
|
| |
|
TASK_DUR |
decimal |
|
|
|
| |
|
TASK_DUR_FMT |
numeric(6) |
|
|
|
| |
|
TASK_ACT_DUR |
decimal |
|
|
|
| |
|
TASK_REM_DUR |
|
|
|
|
| |
|
TASK_BASE_DUR |
|
|
|
|
| |
|
TASK_BASE_DUR_FMT |
numeric(6) |
|
|
|
| |
|
TASK_CONSTRAINT_TYPE |
|
|
|
|
| |
|
TASK_LEVELING_DELAY |
decimal |
|
|
|
| |
|
TASK_LEVELING_DELAY_FMT |
numeric(6) |
|
|
|
| |
|
TASK_START_DATE |
datetime |
|
|
|
| |
|
TASK_FINISH_DATE |
|
|
|
|
| |
|
TASK_ACT_START |
|
|
|
|
| |
|
TASK_ACT_FINISH |
|
|
|
|
| |
|
TASK_BASE_START |
|
|
|
|
| |
|
TASK_BASE_FINISH |
|
|
|
|
| |
|
TASK_CONSTRAINT_DATE |
|
|
|
|
| |
|
TASK_PRIORITY |
numeric(6) |
|
|
|
| |
|
TASK_PCT_COMP |
|
|
|
|
| |
|
TASK_PCT_WORK_COMP |
|
|
|
|
| |
|
TASK_TYPE |
|
|
|
|
| |
|
TASK_FIXED_COST_ACCRUAL |
|
|
|
|
| |
|
TASK_CREATION_DATE |
datetime |
|
|
|
| |
|
TASK_PRELEVELED_START |
|
|
|
|
| |
|
TASK_PRELEVELED_FINISH |
|
|
|
|
| |
|
TASK_EARLY_START |
|
|
|
|
| |
|
TASK_LATE_FINISH |
|
|
|
|
| |
|
TASK_CAL_UID |
decimal |
|
|
|
| |
|
TASK_DEADLINE |
datetime |
|
|
|
| |
|
TASK_WORK |
float |
|
|
|
| |
|
TASK_BASE_WORK |
|
|
|
|
| |
|
TASK_ACT_WORK |
|
|
|
|
| |
|
TASK_REM_WORK |
|
|
|
|
| |
|
TASK_COST |
|
|
|
|
| |
|
TASK_FIXED_COST |
|
|
|
|
| |
|
TASK_ACT_COST |
|
|
|
|
| |
|
TASK_REM_COST |
|
|
|
|
| |
|
TASK_BASE_COST |
|
|
|
|
| |
|
TASK_ACT_OVT_WORK |
|
|
|
|
| |
|
TASK_REM_OVT_WORK |
|
|
|
|
| |
|
TASK_OVT_COST |
|
|
|
|
| |
|
TASK_ACT_OVT_COST |
|
|
|
|
| |
|
TASK_REM_OVT_COST |
|
|
|
|
| |
|
TASK_WBS |
varchar(255) |
|
|
|
| |
|
TASK_NAME |
|
|
|
|
| |
|
TASK_WBS_RIGHTMOST_LEVEL |
|
|
|
|
| |
|
TASK_RTF_NOTES |
image |
|
|
|
| |
|
TASK_REF1 |
varchar(128) |
|
|
|
| |
|
TASK_REF2 |
|
|
|
|
| |
|
TASK_REF3 |
|
|
|
|
| |
|
TASK_REF4 |
|
|
|
|
| |
|
TASK_REF5 |
|
|
|
|
| |
|
TASK_REF6 |
numeric(6) |
|
|
|
| |
|
TASK_REF7 |
|
|
|
|
| |
|
TASK_REF8 |
|
|
|
|
| |
|
TASK_REF9 |
|
|
|
|
| |
|
TASK_REF10 |
|
|
|
|
| |
|
TASK_DOCTYPE |
sql_variant |
|
|
|
| |
|
TASK_WORKCENTER |
|
|
|
|
| |
|
TASK_NO |
|
|
|
|
| Text_Fields |
This table stores the custom(text field) values upto 30 for each task of project |
TEXT_CATEGORY |
decimal |
|
|
|
| |
|
_unknown_ |
char(18) |
|
|
|
| |
|
TEXT_FIELD_ID |
decimal |
|
|
|
| |
|
TEXT_VALUE |
varchar(255) |
|
|
|