PJF_TASK_XFACE
PJF_TASK_XFACE stores the common non-versioned information related to tasks and structures.for interface
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_TASK_XFACE_PK |
TASK_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TASK_INTERFACE_ID | NUMBER | 18 | Yes | TASK_INTERFACE_ID | |
| 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. | ||
| PARENT_TASK_NUMBER | VARCHAR2 | 100 | Task number of the parent task. | ||
| PROJECT_NAME | VARCHAR2 | 240 | PROJECT_NAME | ||
| TASK_ID | NUMBER | 18 | The unique identifier for the project element ***** | ||
| PROJECT_ID | NUMBER | 18 | The identifier of the project to which the element belongs ***** | ||
| PM_PROJECT_SRC_REFERENCE | VARCHAR2 | 25 | Project reference number for external system ***** | ||
| OBJECT_TYPE | VARCHAR2 | 30 | The type of the object for the element. The value can be TASK or STRUCTURE. ***** | ||
| TASK_NUMBER | VARCHAR2 | 100 | User-defined number that uniquely identifies the element within a project or structure ***** | ||
| TASK_NAME | VARCHAR2 | 255 | Task Name ***** | ||
| TASK_DESCRIPTION | VARCHAR2 | 2000 | Task Description ***** | ||
| TOP_TASK_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. ***** | ||
| WBS_LEVEL | NUMBER | 3 | The level of the task in the work breakdown structure ***** | ||
| PARENT_TASK_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 | 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 | 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. ***** | ||
| 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_TASK_SOURCE_REFERENCE | VARCHAR2 | 100 | The identifier of the task in the source system from which the task was imported ***** | ||
| PM_PARENT_TASK_SRC_REF | VARCHAR2 | 100 | The identifier of the task in the source system from which the task 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 | 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. ***** | ||
| ORGANIZATION_NAME | VARCHAR2 | 360 | ORGANIZATION_NAME | ||
| 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. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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 ***** | ||
| PLANNING_START_DATE | DATE | PLANNING_START_DATE ***** | |||
| PLANNING_END_DATE | DATE | PLANNING_END_DATE ***** | |||
| 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' ***** | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | CAPITALIZABLE_FLAG ***** | ||
| DN_TASK_VERSION_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | ||
| DN_PARENT_STRUCT_VER_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEM_VER_STRUCT ***** | ||
| DN_PARENT_TASK_VER_ID | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | ||
| DN_PARENT_OBJECT_TYPE | VARCHAR2 | 30 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | ||
| DN_WBS_NUMBER | VARCHAR2 | 240 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | ||
| DN_DISPLAY_SEQUENCE | NUMBER | 18 | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** | ||
| 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 ***** | ||
| ERROR_FLAG | VARCHAR2 | 1 | validation flag, value or "Y" for error. otherwise is 'N' ***** | ||
| RECORD_STATUS | VARCHAR2 | 1 | "C" for create, "U" for update ***** | ||
| PLANNED_EFFORT | NUMBER | PLANNED_EFFORT ***** | |||
| SUBTASKS_COUNT | NUMBER | SUBTASKS_COUNT |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_TASK_XFACE_N1 | Non Unique | Default | TASK_ID |
| PJF_TASK_XFACE_N2 | Non Unique | Default | PROJECT_ID |
| PJF_TASK_XFACE_N3 | Non Unique | Default | PARENT_TASK_ID |
| PJF_TASK_XFACE_U1 | Unique | FUSION_TS_INTERFACE | TASK_INTERFACE_ID |