PJO_CALC_AMT1

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Columns

Name
PLANNING_ELEMENT_IDNUMBERIdentifier of the source planning element. PLAN_VERSION_IDNUMBERIdentifier of the source plan version. PROJECT_IDNUMBERIdentifier of the project. TASK_IDNUMBERIdentifier of the task. RBS_ELEMENT_IDNUMBERIdentifier of the resource breakdown structure element. UNIT_OF_MEASUREVARCHAR230Unit of measure associated with the planning resource. TRACK_AS_LABOR_FLAGVARCHAR21Specifies that a planning resource is tracked as a labor resource. PLANNING_ELEMENT_TYPEVARCHAR230Specifies the planning element type. PLANNING_START_DATEDATEStart date of the planning element. PLANNING_END_DATEDATEEnd date of the planning element. RES_TYPE_CODEVARCHAR230Code identifying the resource type associated with the planning resource. FC_RES_TYPE_CODEVARCHAR230Code identifying the resource type associated with the planning resource. RESOURCE_CLASS_CODEVARCHAR230Code identifying the resource class associated with the planning resource. ORGANIZATION_IDNUMBERIdentifier of the organization. JOB_IDNUMBERIdentifier of the job associated with the planning resource. PERSON_IDNUMBERIdentifier of the labor resource. EXPENDITURE_TYPEVARCHAR230Specifies the expenditure type. EXPENDITURE_CATEGORYVARCHAR230Specifies the expenditure category. REVENUE_CATEGORY_CODEVARCHAR230Code of the revenue category. EVENT_TYPEVARCHAR230Specifies the event type. SUPPLIER_IDNUMBERIdentifier of the supplier. PROJECT_ROLE_IDNUMBERIdentifier of the project role. PERSON_TYPE_CODEVARCHAR230Code identifying the person type. NON_LABOR_RESOURCEVARCHAR220Name of the nonlabor resource. BOM_RESOURCE_IDNUMBERIdentifier of the bill-of-material resource. INVENTORY_ITEM_IDNUMBERIdentifier of the inventory item. ITEM_CATEGORY_IDNUMBERIdentifier of the item category. TRANSACTION_SOURCE_CODEVARCHAR230Code identifying the transaction source. MFC_COST_TYPE_IDNUMBERIdentifier of the cost type. PROCURE_RESOURCE_FLAGVARCHAR21Procure resource indicator. INCURRED_BY_RES_FLAGVARCHAR21Incurred by resource indicator. RATE_EXPENDITURE_TYPEVARCHAR230Name of the rate expenditure type. RATE_EXPENDITURE_TYPE_IDNUMBERIdentifier of the rate expenditure type. RATE_BASED_FLAGVARCHAR21Specifies whether a resource is rate based. RATE_EXP_FUNC_CURR_CODEVARCHAR230Code identifying rate expenditure ledger currency. RATE_EXPENDITURE_ORG_IDNUMBERIdentifier of the rate expenditure organization. INCUR_BY_RES_CLASS_CODEVARCHAR230Code identifying the resource class of the planning resource incurring the expense. INCUR_BY_ROLE_IDNUMBERIdentifier of the role associated with the planning resource incurring the expense. RESOURCE_CLASS_FLAGVARCHAR21Specifies whether a resource class is directly assigned to a task. NAMED_ROLEVARCHAR280Named role associated with the planning resource. ETC_METHOD_CODEVARCHAR230Code identifying the estimate to complete calculation method. TARGET_REM_IDNUMBERIdentifier of the target resource breakdown structure element. TARGET_PLAN_ELEMENT_IDNUMBERIdentifier of the target planning element. TOP_TASK_IDNUMBERIdentifier of the top task associated with the task for the planning element. MAPPED_FIN_TASK_IDNUMBERIdentifier of the mapped financial task.

Name

PLANNING_ELEMENT_IDNUMBERIdentifier of the source planning element.

PLAN_VERSION_IDNUMBERIdentifier of the source plan version.

PROJECT_IDNUMBERIdentifier of the project.

TASK_IDNUMBERIdentifier of the task.

RBS_ELEMENT_IDNUMBERIdentifier of the resource breakdown structure element.

UNIT_OF_MEASUREVARCHAR230Unit of measure associated with the planning resource.

TRACK_AS_LABOR_FLAGVARCHAR21Specifies that a planning resource is tracked as a labor resource.

PLANNING_ELEMENT_TYPEVARCHAR230Specifies the planning element type.

PLANNING_START_DATEDATEStart date of the planning element.

PLANNING_END_DATEDATEEnd date of the planning element.

RES_TYPE_CODEVARCHAR230Code identifying the resource type associated with the planning resource.

FC_RES_TYPE_CODEVARCHAR230Code identifying the resource type associated with the planning resource.

RESOURCE_CLASS_CODEVARCHAR230Code identifying the resource class associated with the planning resource.

ORGANIZATION_IDNUMBERIdentifier of the organization.

JOB_IDNUMBERIdentifier of the job associated with the planning resource.

PERSON_IDNUMBERIdentifier of the labor resource.

EXPENDITURE_TYPEVARCHAR230Specifies the expenditure type.

EXPENDITURE_CATEGORYVARCHAR230Specifies the expenditure category.

REVENUE_CATEGORY_CODEVARCHAR230Code of the revenue category.

EVENT_TYPEVARCHAR230Specifies the event type.

SUPPLIER_IDNUMBERIdentifier of the supplier.

PROJECT_ROLE_IDNUMBERIdentifier of the project role.

PERSON_TYPE_CODEVARCHAR230Code identifying the person type.

NON_LABOR_RESOURCEVARCHAR220Name of the nonlabor resource.

BOM_RESOURCE_IDNUMBERIdentifier of the bill-of-material resource.

INVENTORY_ITEM_IDNUMBERIdentifier of the inventory item.

ITEM_CATEGORY_IDNUMBERIdentifier of the item category.

TRANSACTION_SOURCE_CODEVARCHAR230Code identifying the transaction source.

MFC_COST_TYPE_IDNUMBERIdentifier of the cost type.

PROCURE_RESOURCE_FLAGVARCHAR21Procure resource indicator.

INCURRED_BY_RES_FLAGVARCHAR21Incurred by resource indicator.

RATE_EXPENDITURE_TYPEVARCHAR230Name of the rate expenditure type.

RATE_EXPENDITURE_TYPE_IDNUMBERIdentifier of the rate expenditure type.

RATE_BASED_FLAGVARCHAR21Specifies whether a resource is rate based.

RATE_EXP_FUNC_CURR_CODEVARCHAR230Code identifying rate expenditure ledger currency.

RATE_EXPENDITURE_ORG_IDNUMBERIdentifier of the rate expenditure organization.

INCUR_BY_RES_CLASS_CODEVARCHAR230Code identifying the resource class of the planning resource incurring the expense.

INCUR_BY_ROLE_IDNUMBERIdentifier of the role associated with the planning resource incurring the expense.

RESOURCE_CLASS_FLAGVARCHAR21Specifies whether a resource class is directly assigned to a task.

NAMED_ROLEVARCHAR280Named role associated with the planning resource.

ETC_METHOD_CODEVARCHAR230Code identifying the estimate to complete calculation method.

TARGET_REM_IDNUMBERIdentifier of the target resource breakdown structure element.

TARGET_PLAN_ELEMENT_IDNUMBERIdentifier of the target planning element.

TOP_TASK_IDNUMBERIdentifier of the top task associated with the task for the planning element.

MAPPED_FIN_TASK_IDNUMBERIdentifier of the mapped financial task.

Indexes

Index	Uniqueness	Columns
PJO_CALC_AMT1_GT_N1	Non Unique	TARGET_PLAN_ELEMENT_ID
PJO_CALC_AMT1_GT_N2	Non Unique	PLANNING_ELEMENT_ID
PJO_CALC_AMT1_GT_N3	Non Unique	MAPPED_FIN_TASK_ID, TARGET_REM_ID