DW_NS_projectTask_D
This table stores information about tasks that are associated to a project.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| actualwork | NUMBER | Actual Work | |||||
| calculatedwork | NUMBER | Calculated Work | |||||
| constrainttype | VARCHAR2 | 32 | Constraint Type | DW_NS_projectTaskConstraintType_D | key | ||
| enddate | TIMESTAMP | End Date | |||||
| eventid | NUMBER | 38 | 0 | Project Task ID | |||
| finishbydate | TIMESTAMP | Finish No Later Than | |||||
| fullname | VARCHAR2 | 999 | Full Name | ||||
| ismilestone | VARCHAR2 | 16 | Milestone | ||||
| issummarytask | VARCHAR2 | 16 | Summary Task | ||||
| message | VARCHAR2 | 999 | Message | ||||
| nonbillabletask | VARCHAR2 | 16 | Non-billable | ||||
| owner | NUMBER | 38 | 0 | Owner | DW_NS_employee_D | id | |
| parent | NUMBER | 38 | 0 | Parent Task | DW_NS_projectTask_D | id | |
| percenttimecomplete | NUMBER | Percent Complete (Time) | |||||
| plannedwork | NUMBER | Planned Work | |||||
| priority | VARCHAR2 | 32 | Priority | DW_NS_EventPriority_D | id | ||
| project | NUMBER | 38 | 0 | Project | DW_NS_job_D | id | |
| remainingwork | NUMBER | Remaining Work | |||||
| startdatetime | TIMESTAMP | Start Date | |||||
| status | VARCHAR2 | 32 | Status | ||||
| title | VARCHAR2 | 512 | Title |