MSP_TASKS |
Default Table Name | MSP_TASKS |
Definition |
MSP_TASKS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
RECORDID![]() |
VARCHAR2(36) | NO | ||
UPLOAD_ID | VARCHAR2(36) | YES | ||
ROW_UID | VARCHAR2(255) | YES | ||
ID | VARCHAR2(255) | YES | ||
NAME | VARCHAR2(255) | YES | ||
TYPE | VARCHAR2(255) | YES | ||
IS_NULL | VARCHAR2(255) | YES | ||
CREATEDATE | VARCHAR2(255) | YES | ||
WBS | VARCHAR2(255) | YES | ||
OUTLINENUMBER | VARCHAR2(255) | YES | ||
OUTLINELEVEL | VARCHAR2(255) | YES | ||
PRIORITY | VARCHAR2(255) | YES | ||
START_DT | VARCHAR2(255) | YES | ||
FINISH | VARCHAR2(255) | YES | ||
DURATION | VARCHAR2(255) | YES | ||
DURATIONFORMAT | VARCHAR2(255) | YES | ||
WORK | VARCHAR2(255) | YES | ||
RESUMEVALID | VARCHAR2(255) | YES | ||
EFFORTDRIVEN | VARCHAR2(255) | YES | ||
RECURRING | VARCHAR2(255) | YES | ||
OVERALLOCATED | VARCHAR2(255) | YES | ||
ESTIMATED | VARCHAR2(255) | YES | ||
MILESTONE | VARCHAR2(255) | YES | ||
SUMMARY | VARCHAR2(255) | YES | ||
CRITICAL | VARCHAR2(255) | YES | ||
ISSUBPROJECT | VARCHAR2(255) | YES | ||
ISSUBPROJECTREADONLY | VARCHAR2(255) | YES | ||
EXTERNALTASK | VARCHAR2(255) | YES | ||
EARLYSTART | VARCHAR2(255) | YES | ||
EARLYFINISH | VARCHAR2(255) | YES | ||
LATESTART | VARCHAR2(255) | YES | ||
LATEFINISH | VARCHAR2(255) | YES | ||
STARTVARIANCE | VARCHAR2(255) | YES | ||
FINISHVARIANCE | VARCHAR2(255) | YES | ||
WORKVARIANCE | VARCHAR2(255) | YES | ||
FREESLACK | VARCHAR2(255) | YES | ||
TOTALSLACK | VARCHAR2(255) | YES | ||
FIXEDCOST | VARCHAR2(255) | YES | ||
FIXEDCOSTACCRUAL | VARCHAR2(255) | YES | ||
PERCENTCOMPLETE | VARCHAR2(255) | YES | ||
PERCENTWORKCOMPLETE | VARCHAR2(255) | YES | ||
COST | VARCHAR2(255) | YES | ||
OVERTIMECOST | VARCHAR2(255) | YES | ||
OVERTIMEWORK | VARCHAR2(255) | YES | ||
ACTUALDURATION | VARCHAR2(255) | YES | ||
ACTUALCOST | VARCHAR2(255) | YES | ||
ACTUALOVERTIMECOST | VARCHAR2(255) | YES | ||
ACTUALWORK | VARCHAR2(255) | YES | ||
ACTUALOVERTIMEWORK | VARCHAR2(255) | YES | ||
REGULARWORK | VARCHAR2(255) | YES | ||
REMAININGDURATION | VARCHAR2(255) | YES | ||
REMAININGCOST | VARCHAR2(255) | YES | ||
REMAININGWORK | VARCHAR2(255) | YES | ||
REMAININGOVERTIMECOST | VARCHAR2(255) | YES | ||
REMAININGOVERTIMEWORK | VARCHAR2(255) | YES | ||
ACWP | VARCHAR2(255) | YES | ||
CV | VARCHAR2(255) | YES | ||
CONSTRAINTTYPE | VARCHAR2(255) | YES | ||
CALENDARUID | VARCHAR2(255) | YES | ||
DEADLINE | VARCHAR2(255) | YES | ||
LEVELASSIGNMENTS | VARCHAR2(255) | YES | ||
LEVELINGCANSPLIT | VARCHAR2(255) | YES | ||
LEVELINGDELAY | VARCHAR2(255) | YES | ||
LEVELINGDELAYFORMAT | VARCHAR2(255) | YES | ||
IGNORERESOURCECALENDAR | VARCHAR2(255) | YES | ||
NOTES | VARCHAR2(255) | YES | ||
HIDEBAR | VARCHAR2(255) | YES | ||
ROLLUP | VARCHAR2(255) | YES | ||
BCWS | VARCHAR2(255) | YES | ||
BCWP | VARCHAR2(255) | YES | ||
PHYSICALPERCENTCOMPLETE | VARCHAR2(255) | YES | ||
EARNEDVALUEMETHOD | VARCHAR2(255) | YES | ||
PROJ_ID | VARCHAR2(50) | YES |
MSP_TASKS Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_MSP_TASKS | PrimaryKey | RECORDID |
MSP_TASKS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |