PJF_PROJ_ELEMENTS_B
PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJ_ELEMENTS_B_PK |
PROJ_ELEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PROJ_ELEMENT_ID | NUMBER | 18 | Yes | The unique identifier for the project element (uses the same sequence as PA_TASKS_S) | ||
| IS_INTEGRATED | VARCHAR2 | 1 | Flag that indicates if this task has been integrated with corresponding financial system. | |||
| LAST_SYNC_DATE | TIMESTAMP | Indicates date and time when this task has been last synced with corresponding financial system. | ||||
| RQMT_ID | NUMBER | 18 | Requirement identifier | |||
| SPRINT_ID | NUMBER | 18 | Sprint or Iteration identifier | |||
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project to which the element belongs | ||
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | The type of the object for the element. The value can be TASK or STRUCTURE. | ||
| ELEMENT_NUMBER | VARCHAR2 | 100 | User-defined number that uniquely identifies the element within a project or structure | |||
| DENORM_TOP_ELEMENT_ID | NUMBER | 18 | The identifier of the top task to which this tasks rolls up. If the task is a top task, the top_task_id is set to its own task_id. ***** | |||
| DENORM_WBS_LEVEL | NUMBER | 3 | Yes | The level of the task in the work breakdown structure ***** | ||
| DENORM_PARENT_ELEMENT_ID | NUMBER | 18 | The identifier of the task that is the parent of the task in the project work breakdown structure ***** | |||
| SERVICE_TYPE_CODE | VARCHAR2 | 30 | The type of work performed on the task ***** | |||
| CHARGEABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if expenditure items can be charged to the task. Only lowest level tasks can be chargeable ***** | |||
| BILLABLE_FLAG | VARCHAR2 | 1 | Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For capital projects this flag is used as capitalizable_flag. For indirect projects this flag is set to N and is not used. ***** | |||
| LIMIT_TO_TXN_CONTROLS_FLAG | VARCHAR2 | 1 | Flag that indicates if users can only charge expenditures to the task that are listed in task's transaction controls. If flag =Y, then only items listed in controls are allowed. If flag = 'N' or null, then items not listed are allowed ***** | |||
| START_DATE | DATE | The date on which the task starts; expenditure items with item dates before the start date cannot be entered for the task ***** | ||||
| COMPLETION_DATE | DATE | The date on which the task is completed; expenditure items with item dates after the task completion date cannot be entered for the task. You must enter a start date to enter a completion date. ***** | ||||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | 20 | The labor cost multiplier defined for the task of a premium project. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program ***** | |||
| COST_IND_RATE_SCH_ID | NUMBER | 18 | The identifier of default costing burden schedule ***** | |||
| COST_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm costing burden schedule ***** | ||||
| OVR_COST_IND_RATE_SCH_ID | NUMBER | 18 | Overridden identifier of costing burden schedule ***** | |||
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | 1 | Flag to indicate whether cross charge are allowed ***** | |||
| CC_PROCESS_LABOR_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date ***** | ||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | Identifier for transfer price schedule to use for cross charged labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_labor_flag is set to Y, this field is required ***** | |||
| LABOR_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date ***** | ||||
| CC_PROCESS_NL_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates cross charge processing is to be performed for non-labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date ***** | ||
| NL_TP_SCHEDULE_ID | NUMBER | 18 | Identifier for transfer price schedule to use for cross charged non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_nl_flag is set to Y, this field is required ***** | |||
| NL_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date ***** | ||||
| RECEIVE_PROJECT_INVOICE_FLAG | VARCHAR2 | 1 | Flag that indicates that the task may receive charges from internal supplies via inter-project billing ***** | |||
| WORK_TYPE_ID | NUMBER | 18 | Work Types are predefined types of work, for example, Vacation, Training, and Administration. ***** | |||
| RETIREMENT_COST_FLAG | VARCHAR2 | 1 | Flag to identify tasks for retirement cost collection. ***** | |||
| CINT_ELIGIBLE_FLAG | VARCHAR2 | 1 | Flag used to determine whether the project is eligible for capitalized interest. ***** | |||
| CINT_STOP_DATE | DATE | Stop date for capital interest calculation. ***** | ||||
| GEN_ETC_SOURCE_CODE | VARCHAR2 | 30 | Estimate to Complete Source. ***** | |||
| CLIN_ELEMENT_ID | NUMBER | 18 | The identifier of the parent task, which is directly linked to the contract line. ***** | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| PM_SOURCE_CODE | VARCHAR2 | 30 | The identifier of the source system from which the element version was created | |||
| PM_SOURCE_REFERENCE | VARCHAR2 | 100 | The identifier of the element version in the source system from which the element was imported | |||
| MANAGER_PERSON_ID | NUMBER | 18 | The identifier of the person who manages the task. This is a task-specific attribute. | |||
| CARRYING_OUT_ORGANIZATION_ID | NUMBER | 18 | Yes | The identifier of the organization that is responsible for the work. The task organization is copied from the project organization when the task is created. This is a task-specific attribute. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Task Structure Descriptive Flexfield (PJF_TASK_STRUCTURE_DFF) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE1_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE2_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE3_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE4_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE5_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE6_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE7_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE8_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE9_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE10_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE11_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE12_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE13_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE14_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE15_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE1_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE2_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE3_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE4_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE5_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE6_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE7_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE8_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE9_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE10_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE11_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE12_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE13_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE14_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE15_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| PARENT_STRUCTURE_ID | NUMBER | 18 | The identifier for the parent structure. | |||
| 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. | ||
| STRUCTURE_TYPE | VARCHAR2 | 30 | STRUCTURE_TYPE ***** | |||
| LEAF_NODE_FLAG | VARCHAR2 | 1 | LEAF_NODE_FLAG ***** | |||
| CREATED_FROM_SOURCE_ID | NUMBER | 18 | CREATED_FROM_SOURCE_ID ***** | |||
| PLANNING_START_DATE | DATE | PLANNING_START_DATE ***** | ||||
| PLANNING_END_DATE | DATE | PLANNING_END_DATE ***** | ||||
| BASELINE_START_DATE | DATE | Baseline start date for the task or the workplan. | ||||
| BASELINE_FINISH_DATE | DATE | Baseline finish date for the task or the workplan. | ||||
| SITE_USE_ID | NUMBER | 18 | SITE_USE_ID ***** | |||
| PERCENT_COMP_CALC_METHOD | VARCHAR2 | 30 | Overridden physical percent complete calculation method for tasks. Calculation method can be `Cost', `Effort' or `Manual Entry' ***** | |||
| ETC_CALC_METHOD | VARCHAR2 | 30 | Overridden ETC calculation method for resources and lowest level tasks without resources. ETC method can be `Remaining Plan' or `Manual Entry' ***** | |||
| PLANNING_DATES_ROLLUP_FLAG | VARCHAR2 | 1 | Flag to indicate change in project plan planning dates which will require triggering planning date's rollup. The flag will be reset to `N' once the rollup is completed. ***** | |||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | CAPITALIZABLE_FLAG ***** | |||
| DENORM_ELEM_VER_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | |||
| DENORM_PARENT_STRUCT_VER_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEM_VER_STRUCT ***** | |||
| DENORM_PARENT_ELEM_VER_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | |||
| DENORM_PARENT_OBJECT_TYPE | VARCHAR2 | 30 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | |||
| DENORM_WBS_NUMBER | VARCHAR2 | 240 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | |||
| DENORM_DISPLAY_SEQUENCE | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | |||
| IC_CLIN_ELEMENT_ID | NUMBER | 18 | Inter Company Contract Linkage Id ***** | |||
| CRITICAL_FLAG | VARCHAR2 | 1 | Flag that indicates if the task is part of the critical path,this is a task specific attribute ***** | |||
| MILESTONE_FLAG | VARCHAR2 | 1 | Flag that indicates if the task is a milestone,this is a task specific attribute ***** | |||
| PRIMARY_RESOURCE_ID | NUMBER | 18 | Resource ID of the primary resource on the task or primary project manager | |||
| TASK_TYPE_CODE | VARCHAR2 | 30 | Task type: Fixed Duration, Allocation or Effort | |||
| TASK_CODE01_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE02_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE03_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE04_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE05_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE06_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE07_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE08_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE09_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE10_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE11_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE12_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE13_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE14_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE15_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE16_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE17_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE18_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE19_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE20_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE21_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE22_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE23_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE24_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE25_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE26_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE27_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE28_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE29_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE30_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE31_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE32_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE33_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE34_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE35_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE36_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE37_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE38_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE39_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| TASK_CODE40_ID | NUMBER | 18 | System generated unique LOV identifier | |||
| NUMBER_ATTR01 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR02 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR03 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR04 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR05 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR06 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR07 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR08 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR09 | NUMBER | Number data type user defined attribute | ||||
| NUMBER_ATTR10 | NUMBER | Number data type user defined attribute | ||||
| TEXT_ATTR01 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR02 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR03 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR04 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR05 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR06 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR07 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR08 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR09 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR10 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR11 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR12 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR13 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR14 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR15 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR16 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR17 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR18 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR19 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| TEXT_ATTR20 | VARCHAR2 | 200 | Text data type user defined attribute | |||
| ISSUE_ID | NUMBER | 18 | Issue ID to which this task belongs. | |||
| TASK_STATUS_CODE | VARCHAR2 | 30 | Status of the task. | |||
| OBJECT_ASSOCIATION_BITMAP | NUMBER | A bitmap flag to indicate what objects are associated to this task (deliverables, issues, etc.) | ||||
| EXTERNAL_ID | VARCHAR2 | 240 | EXternal system identifier | |||
| LAST_VIEWED_DATE | TIMESTAMP | Indicates the last date and time when the primary owner of the task has viewed the row detail. | ||||
| DENORM_EXECUTION_DISP_SEQ | NUMBER | 18 | Identifies the display order of the task withtin an execution project. This is a task-specific attribute. | |||
| ELEMENT_TYPE | VARCHAR2 | 30 | Yes | Identifies the element type. FINANCIAL, EXECUTION or FIN_EXEC | ||
| USER_DEFINED_TASK_TYPE | VARCHAR2 | 30 | A code that identifies type of the task. | |||
| PROJ_ELEMENT_ID_META | NUMBER | 18 | This is a Meta column used while processign data | |||
| GATE_FLAG | VARCHAR2 | 1 | Flag that indicates if the task is a gate ,this is a task specific attribute. | |||
| CTRL_MS_DATES_FLAG | VARCHAR2 | 1 | Indicates whether milestone date changes are allowed in the project plan. Possible values are Y and N. Setting it to Y indicates that the milestone dates can be modified in the project plan. | |||
| CONTRACT_EVENT_ID | NUMBER | 18 | Unique identifier of the contract event, such as a milestone. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_PROJ_ELEMENTS_B | pjf_proj_elements_b | PARENT_STRUCTURE_ID |
| PJF_PROJ_ELEMENTS_B | pjf_projects_all_b | PROJECT_ID |
| fa_adj_src_lines_t | pjf_proj_elements_b | TASK_ID |
| fa_asset_invoices | pjf_proj_elements_b | TASK_ID |
| pjf_ind_rate_sch_b | pjf_proj_elements_b | TASK_ID |
| pjf_ind_rate_sch_b | pjf_proj_elements_b | AWARD_TASK_ID |
| pjc_cc_dist_lines_all | pjf_proj_elements_b | TASK_ID |
| pjb_cntrct_proj_links | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| pjf_proj_element_effs_b | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| zx_rec_nrec_dist | pjf_proj_elements_b | TASK_ID |
| pjf_proj_structure_attr | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| fa_mass_retirements | pjf_proj_elements_b | TASK_ID |
| pjf_proj_element_effs_tl | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| pjf_proj_elem_ver_struct | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| pjf_rate_overrides_int | pjf_proj_elements_b | TASK_ID |
| pjc_xcc_burden_dists | pjf_proj_elements_b | TASK_ID |
| pjc_bc_packets_t | pjf_proj_elements_b | TASK_ID |
| pjo_project_progress | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| fa_deleted_mass_additions | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_run_basis_det | pjf_proj_elements_b | TASK_ID |
| pjc_bc_packets_h | pjf_proj_elements_b | TASK_ID |
| pjt_proj_plan_task_cmnt | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| fa_mc_asset_invoices | pjf_proj_elements_b | TASK_ID |
| pjc_cap_exceptions | pjf_proj_elements_b | TASK_ID |
| pjo_xcc_ctrl_bdgt_segments | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_txn_details | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_txn_details | pjf_proj_elements_b | CINT_SOURCE_TASK_ID |
| pjc_commitment_txns | pjf_proj_elements_b | TASK_ID |
| pjf_proj_element_version | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| pjc_alloc_target_lines | pjf_proj_elements_b | TASK_ID |
| pjc_txn_mass_adjust | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_missing_costs | pjf_proj_elements_b | TASK_ID |
| pjc_exp_items_all | pjf_proj_elements_b | TASK_ID |
| pjf_proj_elements_b | pjf_proj_elements_b | PARENT_STRUCTURE_ID |
| fa_mass_additions | pjf_proj_elements_b | TASK_ID |
| pjc_txn_xface_audit_all | pjf_proj_elements_b | TASK_ID |
| pjf_rate_overrides | pjf_proj_elements_b | TASK_ID |
| pjo_planning_elements | pjf_proj_elements_b | TASK_ID |
| pjc_txn_xface_all | pjf_proj_elements_b | TASK_ID |
| pjf_comp_ot_defaults_all | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_source_lines | pjf_proj_elements_b | TASK_ID |
| pjc_cost_dist_lines_all | pjf_proj_elements_b | TASK_ID |
| pjc_transaction_controls | pjf_proj_elements_b | TASK_ID |
| pjb_billing_events | pjf_proj_elements_b | TASK_ID |
| jv_project_value_sets | pjf_proj_elements_b | TASK_ID |
| pjc_alloc_rules_all | pjf_proj_elements_b | OFFSET_TASK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJ_ELEMENTS_N1 | Non Unique | Default | MANAGER_PERSON_ID |
| PJF_PROJ_ELEMENTS_N2 | Non Unique | Default | ATTRIBUTE15 |
| PJF_PROJ_ELEMENTS_N3 | Non Unique | Default | CLIN_ELEMENT_ID |
| PJF_PROJ_ELEMENTS_N4 | Non Unique | Default | DENORM_PARENT_ELEMENT_ID, PROJ_ELEMENT_ID |
| PJF_PROJ_ELEMENTS_N5 | Non Unique | Default | PROJECT_ID, PROJ_ELEMENT_ID, ELEMENT_NUMBER |
| PJF_PROJ_ELEMENTS_N6 | Non Unique | Default | CARRYING_OUT_ORGANIZATION_ID |
| PJF_PROJ_ELEMENTS_N7 | Non Unique | Default | LAST_UPDATE_DATE |
| PJF_PROJ_ELEMENTS_N8 | Non Unique | Default | PROJECT_ID, PROJ_ELEMENT_ID_META |
| PJF_PROJ_ELEMENTS_N9 | Non Unique | Default | DENORM_TOP_ELEMENT_ID |
| PJF_PROJ_ELEMENTS_U1 | Unique | Default | PROJ_ELEMENT_ID |