PJT_PROJECT_PLAN_XFACE
This is an interface table for PJT Project Plan.
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJT_PROJECT_PLAN_XFACE_PK |
PROJECT_PLAN_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJECT_PLAN_INTERFACE_ID | NUMBER | 18 | Yes | System-generated interface interface of the project plan. | |
| PROJECT_NAME | VARCHAR2 | 240 | Yes | Name of the project. | |
| PROJECT_DESCRIPTION | VARCHAR2 | 2000 | Description of the project. | ||
| PROJECT_NUMBER | VARCHAR2 | 100 | Identifier of the project from the source application. | ||
| PROJECT_START_DATE | DATE | Planned or actual start date of the project. | |||
| PROJECT_COMPLETION_DATE | DATE | Planned or actual completion date of the project. | |||
| SCHEDULE_NAME | VARCHAR2 | 240 | Name of the calendar used for planning the project. | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code for all financial amounts recorded in the project plan. If not specified, it is defaulted to the default project currency code configured through application setup. | ||
| PROJECT_MANAGER_EMAIL_ID | VARCHAR2 | 240 | E-mail address of the project manager. | ||
| PROJECT_EXTERNAL_ID | VARCHAR2 | 240 | Identifier of the project from the source application. | ||
| PROJECT_STATUS | VARCHAR2 | 240 | Staus of the project.Valid values are Active,Draft,Closed. | ||
| EPS_NAME | VARCHAR2 | 240 | Name of Enterprise structure node associated to the project. | ||
| TASK_SEQUENCE_NUMBER | NUMBER | 18 | Sequence in which tasks are created. For example, the sequence number of sub tasks must be greater than the sequence number of related summary tasks. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Task number from the source application. | ||
| TASK_EXTERNAL_ID | VARCHAR2 | 240 | Yes | Identifier of the task from the source application. | |
| PARENT_TASK_EXTERNAL_ID | VARCHAR2 | 240 | Identifier of the immediate summary task of this task from the source application. | ||
| TASK_NAME | VARCHAR2 | 255 | Name of the task. | ||
| EFFORT | NUMBER | Planned effort for the task. | |||
| EFFORT_UNIT | VARCHAR2 | 30 | Unit of measure for valid effort values are DAYS and HOURS. | ||
| START_DATE | DATE | Planned start date of the task. | |||
| FINISH_DATE | DATE | Planned finish date of the task. | |||
| ACTUAL_START_DATE | DATE | Actual start date of the task. | |||
| ACTUAL_FINISH_DATE | DATE | Actual finish date of the task. | |||
| ACTUAL_EFFORT | NUMBER | Actual effort spent on the task. | |||
| REMAINING_EFFORT | NUMBER | Effort remaining on the task. | |||
| DURATION | NUMBER | Number of calendar days from the task start date to the task finish date. | |||
| HOURS_PER_DAY | NUMBER | Number of hours in a working day. | |||
| MILESTONE_FLAG | VARCHAR2 | 20 | Indicates if the task is milestone. | ||
| PROGRESS_STATUS | VARCHAR2 | 20 | Progress status of the task. Valid values are NOT_STARTED, IN_PROGRESS, and COMPLETE. | ||
| HEALTH_STATUS | VARCHAR2 | 30 | Health status of the task. Valid values are ON_TRACK, AT_RISK, or IN_TROUBLE. | ||
| PERCENT_COMPLETE | NUMBER | Percent of work complete on a task. | |||
| SPRINT | VARCHAR2 | 30 | Sprint in which the task is completed or expected to be complete. Valid values are configured during application setup. | ||
| PHYSICAL_PERCENT_COMPLETE | NUMBER | Percentage of physical work completed. | |||
| PRIORITY | NUMBER | Priority of the task. | |||
| RESOURCE_TYPE | VARCHAR2 | 20 | Type of the resource assigned to the task. Valid values are LABOR and EXPENSE. | ||
| RESOURCE_NAME | VARCHAR2 | 240 | Name of the expense resource assigned to the task. Required if the Resource Type is EXPENSE. | ||
| RESOURCE_EMAIL_ID | VARCHAR2 | 240 | E-mail ID of the labor resource assigned to the task. Required if the Resource Type is LABOR. | ||
| LABOR_RES_ALLOC_PERCENT | NUMBER | Allocation percentage for the labor resource assigned to the task. | |||
| EXP_PLANNED_COST_AMOUNT | NUMBER | Planned expense cost for the specific expense resource assigned to the task. | |||
| EXP_ACTUAL_COST_AMOUNT | NUMBER | Actual expense cost for the specific expense resource assigned to the task. | |||
| EXP_REMAINING_COST_AMOUNT | NUMBER | Remaining expense cost for the specific expense resource assigned to the task. | |||
| VALUE_PROJECT_CODE_LOV01 | VARCHAR2 | 80 | Value for user defined project attribute value set 01. | ||
| VALUE_PROJECT_CODE_LOV02 | VARCHAR2 | 80 | Value for user defined project attribute value set 02. | ||
| VALUE_PROJECT_CODE_LOV03 | VARCHAR2 | 80 | Value for user defined project attribute value set 03. | ||
| VALUE_PROJECT_CODE_LOV04 | VARCHAR2 | 80 | Value for user defined project attribute value set 04. | ||
| VALUE_PROJECT_CODE_LOV05 | VARCHAR2 | 80 | Value for user defined project attribute value set 05. | ||
| VALUE_PROJECT_CODE_LOV06 | VARCHAR2 | 80 | Value for user defined project attribute value set 06. | ||
| VALUE_PROJECT_CODE_LOV07 | VARCHAR2 | 80 | Value for user defined project attribute value set 07. | ||
| VALUE_PROJECT_CODE_LOV08 | VARCHAR2 | 80 | Value for user defined project attribute value set 08. | ||
| VALUE_PROJECT_CODE_LOV09 | VARCHAR2 | 80 | Value for user defined project attribute value set 09. | ||
| VALUE_PROJECT_CODE_LOV10 | VARCHAR2 | 80 | Value for user defined project attribute value set 10. | ||
| VALUE_PROJECT_CODE_LOV11 | VARCHAR2 | 80 | Value for user defined project attribute value set 11. | ||
| VALUE_PROJECT_CODE_LOV12 | VARCHAR2 | 80 | Value for user defined project attribute value set 12. | ||
| VALUE_PROJECT_CODE_LOV13 | VARCHAR2 | 80 | Value for user defined project attribute value set 13. | ||
| VALUE_PROJECT_CODE_LOV14 | VARCHAR2 | 80 | Value for user defined project attribute value set 14. | ||
| VALUE_PROJECT_CODE_LOV15 | VARCHAR2 | 80 | Value for user defined project attribute value set 15. | ||
| VALUE_PROJECT_CODE_LOV16 | VARCHAR2 | 80 | Value for user defined project attribute value set 16. | ||
| VALUE_PROJECT_CODE_LOV17 | VARCHAR2 | 80 | Value for user defined project attribute value set 17. | ||
| VALUE_PROJECT_CODE_LOV18 | VARCHAR2 | 80 | Value for user defined project attribute value set 18. | ||
| VALUE_PROJECT_CODE_LOV19 | VARCHAR2 | 80 | Value for user defined project attribute value set 19. | ||
| VALUE_PROJECT_CODE_LOV20 | VARCHAR2 | 80 | Value for user defined project attribute value set 20. | ||
| VALUE_PROJECT_CODE_LOV21 | VARCHAR2 | 80 | Value for user defined project attribute value set 21. | ||
| VALUE_PROJECT_CODE_LOV22 | VARCHAR2 | 80 | Value for user defined project attribute value set 22. | ||
| VALUE_PROJECT_CODE_LOV23 | VARCHAR2 | 80 | Value for user defined project attribute value set 23. | ||
| VALUE_PROJECT_CODE_LOV24 | VARCHAR2 | 80 | Value for user defined project attribute value set 24. | ||
| VALUE_PROJECT_CODE_LOV25 | VARCHAR2 | 80 | Value for user defined project attribute value set 25. | ||
| VALUE_PROJECT_CODE_LOV26 | VARCHAR2 | 80 | Value for user defined project attribute value set 26. | ||
| VALUE_PROJECT_CODE_LOV27 | VARCHAR2 | 80 | Value for user defined project attribute value set 27. | ||
| VALUE_PROJECT_CODE_LOV28 | VARCHAR2 | 80 | Value for user defined project attribute value set 28. | ||
| VALUE_PROJECT_CODE_LOV29 | VARCHAR2 | 80 | Value for user defined project attribute value set 29. | ||
| VALUE_PROJECT_CODE_LOV30 | VARCHAR2 | 80 | Value for user defined project attribute value set 30. | ||
| VALUE_PROJECT_CODE_LOV31 | VARCHAR2 | 80 | Value for user defined project attribute value set 31. | ||
| VALUE_PROJECT_CODE_LOV32 | VARCHAR2 | 80 | Value for user defined project attribute value set 32. | ||
| VALUE_PROJECT_CODE_LOV33 | VARCHAR2 | 80 | Value for user defined project attribute value set 33. | ||
| VALUE_PROJECT_CODE_LOV34 | VARCHAR2 | 80 | Value for user defined project attribute value set 34. | ||
| VALUE_PROJECT_CODE_LOV35 | VARCHAR2 | 80 | Value for user defined project attribute value set 35. | ||
| VALUE_PROJECT_CODE_LOV36 | VARCHAR2 | 80 | Value for user defined project attribute value set 36. | ||
| VALUE_PROJECT_CODE_LOV37 | VARCHAR2 | 80 | Value for user defined project attribute value set 37. | ||
| VALUE_PROJECT_CODE_LOV38 | VARCHAR2 | 80 | Value for user defined project attribute value set 38. | ||
| VALUE_PROJECT_CODE_LOV39 | VARCHAR2 | 80 | Value for user defined project attribute value set 39. | ||
| VALUE_PROJECT_CODE_LOV40 | VARCHAR2 | 80 | Value for user defined project attribute value set 40. | ||
| VALUE_PROJECT_CODE_NUMBER01 | NUMBER | Value for user defined project numeric attribute 01. | |||
| VALUE_PROJECT_CODE_NUMBER02 | NUMBER | Value for user defined project numeric attribute 02. | |||
| VALUE_PROJECT_CODE_NUMBER03 | NUMBER | Value for user defined project numeric attribute 03. | |||
| VALUE_PROJECT_CODE_NUMBER04 | NUMBER | Value for user defined project numeric attribute 04. | |||
| VALUE_PROJECT_CODE_NUMBER05 | NUMBER | Value for user defined project numeric attribute 05. | |||
| VALUE_PROJECT_CODE_NUMBER06 | NUMBER | Value for user defined project numeric attribute 06. | |||
| VALUE_PROJECT_CODE_NUMBER07 | NUMBER | Value for user defined project numeric attribute 07. | |||
| VALUE_PROJECT_CODE_NUMBER08 | NUMBER | Value for user defined project numeric attribute 08. | |||
| VALUE_PROJECT_CODE_NUMBER09 | NUMBER | Value for user defined project numeric attribute 09. | |||
| VALUE_PROJECT_CODE_NUMBER10 | NUMBER | Value for user defined project numeric attribute 10. | |||
| VALUE_PROJECT_CODE_TEXT01 | VARCHAR2 | 200 | Value for user defined project free form text attribute 01. | ||
| VALUE_PROJECT_CODE_TEXT02 | VARCHAR2 | 200 | Value for user defined project free form text attribute 02. | ||
| VALUE_PROJECT_CODE_TEXT03 | VARCHAR2 | 200 | Value for user defined project free form text attribute 03. | ||
| VALUE_PROJECT_CODE_TEXT04 | VARCHAR2 | 200 | Value for user defined project free form text attribute 04. | ||
| VALUE_PROJECT_CODE_TEXT05 | VARCHAR2 | 200 | Value for user defined project free form text attribute 05. | ||
| VALUE_PROJECT_CODE_TEXT06 | VARCHAR2 | 200 | Value for user defined project free form text attribute 06. | ||
| VALUE_PROJECT_CODE_TEXT07 | VARCHAR2 | 200 | Value for user defined project free form text attribute 07. | ||
| VALUE_PROJECT_CODE_TEXT08 | VARCHAR2 | 200 | Value for user defined project free form text attribute 08. | ||
| VALUE_PROJECT_CODE_TEXT09 | VARCHAR2 | 200 | Value for user defined project free form text attribute 09. | ||
| VALUE_PROJECT_CODE_TEXT10 | VARCHAR2 | 200 | Value for user defined project free form text attribute 10. | ||
| VALUE_PROJECT_CODE_TEXT11 | VARCHAR2 | 200 | Value for user defined project free form text attribute 11. | ||
| VALUE_PROJECT_CODE_TEXT12 | VARCHAR2 | 200 | Value for user defined project free form text attribute 12. | ||
| VALUE_PROJECT_CODE_TEXT13 | VARCHAR2 | 200 | Value for user defined project free form text attribute 13. | ||
| VALUE_PROJECT_CODE_TEXT14 | VARCHAR2 | 200 | Value for user defined project free form text attribute 14. | ||
| VALUE_PROJECT_CODE_TEXT15 | VARCHAR2 | 200 | Value for user defined project free form text attribute 15. | ||
| VALUE_PROJECT_CODE_TEXT16 | VARCHAR2 | 200 | Value for user defined project free form text attribute 16. | ||
| VALUE_PROJECT_CODE_TEXT17 | VARCHAR2 | 200 | Value for user defined project free form text attribute 17. | ||
| VALUE_PROJECT_CODE_TEXT18 | VARCHAR2 | 200 | Value for user defined project free form text attribute 18. | ||
| VALUE_PROJECT_CODE_TEXT19 | VARCHAR2 | 200 | Value for user defined project free form text attribute 19. | ||
| VALUE_PROJECT_CODE_TEXT20 | VARCHAR2 | 200 | Value for user defined project free form text attribute 20. | ||
| VALUE_TASK_CODE_LOV01 | VARCHAR2 | 80 | Value for user defined task attribute value set 01. | ||
| VALUE_TASK_CODE_LOV02 | VARCHAR2 | 80 | Value for user defined task attribute value set 02. | ||
| VALUE_TASK_CODE_LOV03 | VARCHAR2 | 80 | Value for user defined task attribute value set 03. | ||
| VALUE_TASK_CODE_LOV04 | VARCHAR2 | 80 | Value for user defined task attribute value set 04. | ||
| VALUE_TASK_CODE_LOV05 | VARCHAR2 | 80 | Value for user defined task attribute value set 05. | ||
| VALUE_TASK_CODE_LOV06 | VARCHAR2 | 80 | Value for user defined task attribute value set 06. | ||
| VALUE_TASK_CODE_LOV07 | VARCHAR2 | 80 | Value for user defined task attribute value set 07. | ||
| VALUE_TASK_CODE_LOV08 | VARCHAR2 | 80 | Value for user defined task attribute value set 08. | ||
| VALUE_TASK_CODE_LOV09 | VARCHAR2 | 80 | Value for user defined task attribute value set 09. | ||
| VALUE_TASK_CODE_LOV10 | VARCHAR2 | 80 | Value for user defined task attribute value set 10. | ||
| VALUE_TASK_CODE_LOV11 | VARCHAR2 | 80 | Value for user defined task attribute value set 11. | ||
| VALUE_TASK_CODE_LOV12 | VARCHAR2 | 80 | Value for user defined task attribute value set 12. | ||
| VALUE_TASK_CODE_LOV13 | VARCHAR2 | 80 | Value for user defined task attribute value set 13. | ||
| VALUE_TASK_CODE_LOV14 | VARCHAR2 | 80 | Value for user defined task attribute value set 14. | ||
| VALUE_TASK_CODE_LOV15 | VARCHAR2 | 80 | Value for user defined task attribute value set 15. | ||
| VALUE_TASK_CODE_LOV16 | VARCHAR2 | 80 | Value for user defined task attribute value set 16. | ||
| VALUE_TASK_CODE_LOV17 | VARCHAR2 | 80 | Value for user defined task attribute value set 17. | ||
| VALUE_TASK_CODE_LOV18 | VARCHAR2 | 80 | Value for user defined task attribute value set 18. | ||
| VALUE_TASK_CODE_LOV19 | VARCHAR2 | 80 | Value for user defined task attribute value set 19. | ||
| VALUE_TASK_CODE_LOV20 | VARCHAR2 | 80 | Value for user defined task attribute value set 20. | ||
| VALUE_TASK_CODE_LOV21 | VARCHAR2 | 80 | Value for user defined task attribute value set 21. | ||
| VALUE_TASK_CODE_LOV22 | VARCHAR2 | 80 | Value for user defined task attribute value set 22. | ||
| VALUE_TASK_CODE_LOV23 | VARCHAR2 | 80 | Value for user defined task attribute value set 23. | ||
| VALUE_TASK_CODE_LOV24 | VARCHAR2 | 80 | Value for user defined task attribute value set 24. | ||
| VALUE_TASK_CODE_LOV25 | VARCHAR2 | 80 | Value for user defined task attribute value set 25. | ||
| VALUE_TASK_CODE_LOV26 | VARCHAR2 | 80 | Value for user defined task attribute value set 26. | ||
| VALUE_TASK_CODE_LOV27 | VARCHAR2 | 80 | Value for user defined task attribute value set 27. | ||
| VALUE_TASK_CODE_LOV28 | VARCHAR2 | 80 | Value for user defined task attribute value set 28. | ||
| VALUE_TASK_CODE_LOV29 | VARCHAR2 | 80 | Value for user defined task attribute value set 29. | ||
| VALUE_TASK_CODE_LOV30 | VARCHAR2 | 80 | Value for user defined task attribute value set 30. | ||
| VALUE_TASK_CODE_LOV31 | VARCHAR2 | 80 | Value for user defined task attribute value set 31. | ||
| VALUE_TASK_CODE_LOV32 | VARCHAR2 | 80 | Value for user defined task attribute value set 32. | ||
| VALUE_TASK_CODE_LOV33 | VARCHAR2 | 80 | Value for user defined task attribute value set 33. | ||
| VALUE_TASK_CODE_LOV34 | VARCHAR2 | 80 | Value for user defined task attribute value set 34. | ||
| VALUE_TASK_CODE_LOV35 | VARCHAR2 | 80 | Value for user defined task attribute value set 35. | ||
| VALUE_TASK_CODE_LOV36 | VARCHAR2 | 80 | Value for user defined task attribute value set 36. | ||
| VALUE_TASK_CODE_LOV37 | VARCHAR2 | 80 | Value for user defined task attribute value set 37. | ||
| VALUE_TASK_CODE_LOV38 | VARCHAR2 | 80 | Value for user defined task attribute value set 38. | ||
| VALUE_TASK_CODE_LOV39 | VARCHAR2 | 80 | Value for user defined task attribute value set 39. | ||
| VALUE_TASK_CODE_LOV40 | VARCHAR2 | 80 | Value for user defined task attribute value set 40. | ||
| VALUE_TASK_CODE_NUMBER01 | NUMBER | Value for user defined task numeric attribute 01. | |||
| VALUE_TASK_CODE_NUMBER02 | NUMBER | Value for user defined task numeric attribute 02. | |||
| VALUE_TASK_CODE_NUMBER03 | NUMBER | Value for user defined task numeric attribute 03. | |||
| VALUE_TASK_CODE_NUMBER04 | NUMBER | Value for user defined task numeric attribute 04. | |||
| VALUE_TASK_CODE_NUMBER05 | NUMBER | Value for user defined task numeric attribute 05. | |||
| VALUE_TASK_CODE_NUMBER06 | NUMBER | Value for user defined task numeric attribute 06. | |||
| VALUE_TASK_CODE_NUMBER07 | NUMBER | Value for user defined task numeric attribute 07. | |||
| VALUE_TASK_CODE_NUMBER08 | NUMBER | Value for user defined task numeric attribute 08. | |||
| VALUE_TASK_CODE_NUMBER09 | NUMBER | Value for user defined task numeric attribute 09. | |||
| VALUE_TASK_CODE_NUMBER10 | NUMBER | Value for user defined task numeric attribute 10. | |||
| VALUE_TASK_CODE_TEXT01 | VARCHAR2 | 200 | Value for user defined task free form text attribute 01. | ||
| VALUE_TASK_CODE_TEXT02 | VARCHAR2 | 200 | Value for user defined task free form text attribute 02. | ||
| VALUE_TASK_CODE_TEXT03 | VARCHAR2 | 200 | Value for user defined task free form text attribute 03. | ||
| VALUE_TASK_CODE_TEXT04 | VARCHAR2 | 200 | Value for user defined task free form text attribute 04. | ||
| VALUE_TASK_CODE_TEXT05 | VARCHAR2 | 200 | Value for user defined task free form text attribute 05. | ||
| VALUE_TASK_CODE_TEXT06 | VARCHAR2 | 200 | Value for user defined task free form text attribute 06. | ||
| VALUE_TASK_CODE_TEXT07 | VARCHAR2 | 200 | Value for user defined task free form text attribute 07. | ||
| VALUE_TASK_CODE_TEXT08 | VARCHAR2 | 200 | Value for user defined task free form text attribute 08. | ||
| VALUE_TASK_CODE_TEXT09 | VARCHAR2 | 200 | Value for user defined task free form text attribute 09. | ||
| VALUE_TASK_CODE_TEXT10 | VARCHAR2 | 200 | Value for user defined task free form text attribute 10. | ||
| VALUE_TASK_CODE_TEXT11 | VARCHAR2 | 200 | Value for user defined task free form text attribute 11. | ||
| VALUE_TASK_CODE_TEXT12 | VARCHAR2 | 200 | Value for user defined task free form text attribute 12. | ||
| VALUE_TASK_CODE_TEXT13 | VARCHAR2 | 200 | Value for user defined task free form text attribute 13. | ||
| VALUE_TASK_CODE_TEXT14 | VARCHAR2 | 200 | Value for user defined task free form text attribute 14. | ||
| VALUE_TASK_CODE_TEXT15 | VARCHAR2 | 200 | Value for user defined task free form text attribute 15. | ||
| VALUE_TASK_CODE_TEXT16 | VARCHAR2 | 200 | Value for user defined task free form text attribute 16. | ||
| VALUE_TASK_CODE_TEXT17 | VARCHAR2 | 200 | Value for user defined task free form text attribute 17. | ||
| VALUE_TASK_CODE_TEXT18 | VARCHAR2 | 200 | Value for user defined task free form text attribute 18. | ||
| VALUE_TASK_CODE_TEXT19 | VARCHAR2 | 200 | Value for user defined task free form text attribute 19. | ||
| VALUE_TASK_CODE_TEXT20 | VARCHAR2 | 200 | Value for user defined task free form text attribute 20. | ||
| TASK_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| TASK_ATTRIBUTE1_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE2_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE3_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE4_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE5_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE6_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE7_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE8_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE9_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE10_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE11_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE12_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE13_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE14_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE15_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE1_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE2_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE3_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE4_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE5_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE6_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE7_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE8_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE9_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE10_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE11_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE12_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE13_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE14_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TASK_ATTRIBUTE15_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PROJECT_ATTRIBUTE1_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE2_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE3_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE4_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE5_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE6_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE7_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE8_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE9_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE10_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE11_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE12_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE13_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE14_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE15_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE1_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE2_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE3_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE4_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE5_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE6_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE7_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE8_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE9_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE10_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE11_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE12_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE13_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE14_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROJECT_ATTRIBUTE15_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the scheduled process that populates the interface table from user uploaded data. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| STATUS | VARCHAR2 | 20 | Processing status of the record. Valid values are QUEUED, PROCESSING, SUCCESS, and FAILURE. | ||
| XFACE_FILE_PROCESS_ID | NUMBER | 18 | ID of the process that populated the interface table from a file | ||
| XFACE_LAST_PROCESS_ID | NUMBER | 18 | The request ID of the ESS job that populated DB from an interface table | ||
| XFACE_LAST_STATUS_CODE | VARCHAR2 | 20 | Interface to DB load status code??? PROCESSING, SUCCESS, ERROR | ||
| XFACE_ELEMENT_ID | NUMBER | 18 | Unique ID of each interface table row, used as a FK to Messages table. | ||
| OPPORTUNITY_ID | NUMBER | 18 | Identifier of the opportunity in the opportunity management application. | ||
| OPPORTUNITY_NUMBER | VARCHAR2 | 240 | Opportunity Number. | ||
| OPPORTUNITY_CUSTOMER_NUMBER | VARCHAR2 | 240 | Public Identifier of the customer in the opportunity management application. | ||
| OPPORTUNITY_CUSTOMER_ID | NUMBER | 18 | Identifier of the customer in the opportunity management application. | ||
| OPPORTUNITY_AMOUNT | NUMBER | Total amount of a customer deal in the opportunity management application. | |||
| OPPORTUNITY_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the deal amount of the opportunity in the opportunity management application. | ||
| OPPORTUNITY_WIN_CONF_PERCENT | NUMBER | Percentage probability of winning an opportunity in the opportunity management application. | |||
| OPPORTUNITY_NAME | VARCHAR2 | 240 | Name of the opportunity associated to the project. | ||
| OPPORTUNITY_DESCRIPTION | VARCHAR2 | 1000 | Description of the opportunity associated to the project. | ||
| OPPORTUNITY_CUSTOMER_NAME | VARCHAR2 | 900 | Name of the customer with whom the deal is made for the opportunity. | ||
| OPPORTUNITY_STATUS | VARCHAR2 | 240 | Status of the opportunity in the opportunity management application. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJT_PROJECT_PLAN_XFACE_U1 | Unique | Default | PROJECT_PLAN_INTERFACE_ID |