PJO_PLAN_ROLLUP

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Columns

Name
ROLLUP_IDNUMBERIdentifier of the table row. PLAN_LINE_DETAIL_IDNUMBERIdentifier of the plan line details row. PLANNING_ELEMENT_IDNUMBERYesIdentifier of the planning element. TXN_CURRENCY_CODEVARCHAR215Code identifying the transaction currency associated with the plan line. START_DATEDATEStart date of the period. END_DATEDATEEnd date of the period. PERIOD_NAMEVARCHAR230Name of the period. PARENT_PLAN_ELEMENT_IDNUMBERIdentifier of the planning element from which this planning element was created. PLAN_VERSION_IDNUMBERIdentifier of the plan version. QUANTITYNUMBERQuantity associated with the planning element. TC_RAW_COSTNUMBERRaw cost in transaction currency associated with the planning element. TC_BRDND_COSTNUMBERBurdened cost in transaction currency associated with the planning element. TC_REVENUENUMBERRevenue in transaction currency associated with the planning element. PFC_CODEVARCHAR215Code identifying the project ledger currency. PFC_RAW_COSTNUMBERRaw cost in project ledger currency associated with the planning element. PFC_BRDND_COSTNUMBERBurdened cost in project ledger currency associated with the planning element. PFC_REVENUENUMBERRevenue in project ledger currency associated with the planning element. PC_RAW_COSTNUMBERRaw cost in project currency associated with the planning element. PC_CODEVARCHAR215Code identifying the project currency. PC_BRDND_COSTNUMBERBurdened cost in project currency associated with the planning element. PC_REVENUENUMBERRevenue in project currency associated with the planning element. ACT_QUANTITYNUMBERActual quantity associated with the planning element. TC_ACT_RAW_COSTNUMBERActual raw cost in transaction currency associated with the planning element. TC_ACT_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with the planning element. TC_ACT_REVENUENUMBERActual revenue in transaction currency associated with the planning element. PFC_ACT_RAW_COSTNUMBERActual raw cost in project ledger currency associated with the planning element. PFC_ACT_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with the planning element. PFC_ACT_REVENUENUMBERActual revenue in project ledger currency associated with the planning element. PC_ACT_RAW_COSTNUMBERActual raw cost in project currency associated with the planning element. PC_ACT_BRDND_COSTNUMBERActual burdened cost in project currency associated with the planning element. PC_ACT_REVENUENUMBERActual revenue in project currency associated with the planning element. TC_STD_RAW_COST_RATENUMBERStandard raw cost rate in transaction currency. TC_RAW_COST_RATE_OVERRIDENUMBEROverride raw cost rate in transaction currency. TC_STD_BRDND_COST_RATENUMBERStandard burdened cost rate in transaction currency. TC_BRDND_COST_RATE_OVERRIDENUMBEROverride burdened cost rate in transaction currency. TC_STD_BILL_RATENUMBERStandard bill rate in transaction currency. TC_BILL_RATE_OVERRIDENUMBEROverride bill rate in transaction currency. TC_MARKUP_PERCENTNUMBERMarkup percentage in transaction currency. TC_MARKUP_PERCENT_OVERRIDENUMBEROverride markup percentage in transaction currency. PFC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project ledger currency. PFC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project ledger currency. PFC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project ledger currency. PFC_COST_RATE_DATEDATECurrency conversion cost rate date in project ledger currency. PFC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project ledger currency. PFC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project ledger currency. PFC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project ledger currency. PFC_REV_RATE_DATEDATECurrency conversion revenue rate date for project ledger currency. PC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project currency. PC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project currency. PC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project currency. PC_COST_RATE_DATEDATECurrency conversion cost rate date in project currency. PC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project currency. PC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project currency. PC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project currency. PC_REV_RATE_DATEDATECurrency conversion revenue rate date for project currency. COST_IND_COMPILED_SET_IDNUMBER18Identifier of the burdened cost compiled set. RATE_BASED_FLAGVARCHAR21Specifies whether the planning resource is rate based. BILLABLE_FLAGVARCHAR21Specifies whether the task is billable. DELETE_FLAGVARCHAR21Specifies whether the period must be deleted during later processing. SYSTEM_REFERENCE1VARCHAR230Column used for system reference. SYSTEM_REFERENCE2VARCHAR230Column used for system reference. SYSTEM_REFERENCE3VARCHAR230Column used for system reference. SYSTEM_REFERENCE4VARCHAR230Column used for system reference. SYSTEM_REFERENCE5VARCHAR230Column used for system reference. SYSTEM_REFERENCE6VARCHAR230Column used for system reference. FINAL_TXN_CURR_CODEVARCHAR230Code identifying the final transaction currency. PROCESSED_FLAGVARCHAR21Specifies whether a record is processed. PLAN_START_DATE_SHRUNK_FLAGVARCHAR21Specifies whether the start date has moved to a later date. PLAN_END_DATE_SHRUNK_FLAGVARCHAR21Specifies whether the end date has moved to an earlier date. BL_CREATED_BYVARCHAR264Standard WHO column. Specifies the user who created the period. BL_CREATION_DATEDATEStandard WHO column. Specifies the date on which the period was created. RESOURCE_NAMEVARCHAR2240Name of the resource. TASK_NAMEVARCHAR2240Name of the task. OLD_QUANTITYNUMBERPrevious quantity value. OLD_TXN_RAW_COSTNUMBERPrevious value of raw cost in transaction currency. OLD_TXN_REVENUENUMBERPrevious value of revenue in transaction currency. ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield. ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE16VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE17VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE18VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE19VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE20VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE21VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE22VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE23VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE24VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE25VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE26VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE27VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE28VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE29VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE30VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

Name

ROLLUP_IDNUMBERIdentifier of the table row.

PLAN_LINE_DETAIL_IDNUMBERIdentifier of the plan line details row.

PLANNING_ELEMENT_IDNUMBERYesIdentifier of the planning element.

TXN_CURRENCY_CODEVARCHAR215Code identifying the transaction currency associated with the plan line.

START_DATEDATEStart date of the period.

END_DATEDATEEnd date of the period.

PERIOD_NAMEVARCHAR230Name of the period.

PARENT_PLAN_ELEMENT_IDNUMBERIdentifier of the planning element from which this planning element was created.

PLAN_VERSION_IDNUMBERIdentifier of the plan version.

QUANTITYNUMBERQuantity associated with the planning element.

TC_RAW_COSTNUMBERRaw cost in transaction currency associated with the planning element.

TC_BRDND_COSTNUMBERBurdened cost in transaction currency associated with the planning element.

TC_REVENUENUMBERRevenue in transaction currency associated with the planning element.

PFC_CODEVARCHAR215Code identifying the project ledger currency.

PFC_RAW_COSTNUMBERRaw cost in project ledger currency associated with the planning element.

PFC_BRDND_COSTNUMBERBurdened cost in project ledger currency associated with the planning element.

PFC_REVENUENUMBERRevenue in project ledger currency associated with the planning element.

PC_RAW_COSTNUMBERRaw cost in project currency associated with the planning element.

PC_CODEVARCHAR215Code identifying the project currency.

PC_BRDND_COSTNUMBERBurdened cost in project currency associated with the planning element.

PC_REVENUENUMBERRevenue in project currency associated with the planning element.

ACT_QUANTITYNUMBERActual quantity associated with the planning element.

TC_ACT_RAW_COSTNUMBERActual raw cost in transaction currency associated with the planning element.

TC_ACT_BRDND_COSTNUMBERActual burdened cost in transaction currency associated with the planning element.

TC_ACT_REVENUENUMBERActual revenue in transaction currency associated with the planning element.

PFC_ACT_RAW_COSTNUMBERActual raw cost in project ledger currency associated with the planning element.

PFC_ACT_BRDND_COSTNUMBERActual burdened cost in project ledger currency associated with the planning element.

PFC_ACT_REVENUENUMBERActual revenue in project ledger currency associated with the planning element.

PC_ACT_RAW_COSTNUMBERActual raw cost in project currency associated with the planning element.

PC_ACT_BRDND_COSTNUMBERActual burdened cost in project currency associated with the planning element.

PC_ACT_REVENUENUMBERActual revenue in project currency associated with the planning element.

TC_STD_RAW_COST_RATENUMBERStandard raw cost rate in transaction currency.

TC_RAW_COST_RATE_OVERRIDENUMBEROverride raw cost rate in transaction currency.

TC_STD_BRDND_COST_RATENUMBERStandard burdened cost rate in transaction currency.

TC_BRDND_COST_RATE_OVERRIDENUMBEROverride burdened cost rate in transaction currency.

TC_STD_BILL_RATENUMBERStandard bill rate in transaction currency.

TC_BILL_RATE_OVERRIDENUMBEROverride bill rate in transaction currency.

TC_MARKUP_PERCENTNUMBERMarkup percentage in transaction currency.

TC_MARKUP_PERCENT_OVERRIDENUMBEROverride markup percentage in transaction currency.

PFC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project ledger currency.

PFC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project ledger currency.

PFC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project ledger currency.

PFC_COST_RATE_DATEDATECurrency conversion cost rate date in project ledger currency.

PFC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project ledger currency.

PFC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project ledger currency.

PFC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project ledger currency.

PFC_REV_RATE_DATEDATECurrency conversion revenue rate date for project ledger currency.

PC_COST_RATE_TYPEVARCHAR230Currency conversion cost rate type for project currency.

PC_COST_EXCHANGE_RATENUMBERCurrency conversion cost exchange rate for project currency.

PC_COST_RATE_DATE_TYPEVARCHAR230Currency conversion cost rate date type for project currency.

PC_COST_RATE_DATEDATECurrency conversion cost rate date in project currency.

PC_REV_RATE_TYPEVARCHAR230Currency conversion revenue rate type for project currency.

PC_REV_EXCHANGE_RATENUMBERCurrency conversion revenue exchange rate for project currency.

PC_REV_RATE_DATE_TYPEVARCHAR230Currency conversion revenue rate date type for project currency.

PC_REV_RATE_DATEDATECurrency conversion revenue rate date for project currency.

COST_IND_COMPILED_SET_IDNUMBER18Identifier of the burdened cost compiled set.

RATE_BASED_FLAGVARCHAR21Specifies whether the planning resource is rate based.

BILLABLE_FLAGVARCHAR21Specifies whether the task is billable.

DELETE_FLAGVARCHAR21Specifies whether the period must be deleted during later processing.

SYSTEM_REFERENCE1VARCHAR230Column used for system reference.

SYSTEM_REFERENCE2VARCHAR230Column used for system reference.

SYSTEM_REFERENCE3VARCHAR230Column used for system reference.

SYSTEM_REFERENCE4VARCHAR230Column used for system reference.

SYSTEM_REFERENCE5VARCHAR230Column used for system reference.

SYSTEM_REFERENCE6VARCHAR230Column used for system reference.

FINAL_TXN_CURR_CODEVARCHAR230Code identifying the final transaction currency.

PROCESSED_FLAGVARCHAR21Specifies whether a record is processed.

PLAN_START_DATE_SHRUNK_FLAGVARCHAR21Specifies whether the start date has moved to a later date.

PLAN_END_DATE_SHRUNK_FLAGVARCHAR21Specifies whether the end date has moved to an earlier date.

BL_CREATED_BYVARCHAR264Standard WHO column. Specifies the user who created the period.

BL_CREATION_DATEDATEStandard WHO column. Specifies the date on which the period was created.

RESOURCE_NAMEVARCHAR2240Name of the resource.

TASK_NAMEVARCHAR2240Name of the task.

OLD_QUANTITYNUMBERPrevious quantity value.

OLD_TXN_RAW_COSTNUMBERPrevious value of raw cost in transaction currency.

OLD_TXN_REVENUENUMBERPrevious value of revenue in transaction currency.

ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield.

ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE16VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE17VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE18VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE19VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE20VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE21VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE22VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE23VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE24VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE25VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE26VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE27VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE28VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE29VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE30VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index	Uniqueness	Columns
PJO_PLAN_ROLLUP_GT_N1	Non Unique	PLANNING_ELEMENT_ID, TXN_CURRENCY_CODE, START_DATE
PJO_PLAN_ROLLUP_GT_N2	Non Unique	PLAN_LINE_DETAIL_ID
PJO_PLAN_ROLLUP_GT_N3	Non Unique	PLAN_VERSION_ID