PJS_FP_SUM_FIN3_GT

This global temporary table contains non-persistent actuals data mapped to RBS and prepared for Essbase. It is used during online summarization for exposing data to Essbase.

Details

Schema: FUSION
Object owner: PJS
Object type: TABLE

Columns

Name
WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. SCENARIOVARCHAR210Type of data in Essbase whether actuals, current baseline budget, etc. PJS_SUMMARY_IDNUMBER18The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized. PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1) PROJECT_ELEMENT_IDNUMBER18The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID PROJECT_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the PROJECT_ELEMENT_ID is an interior node, or a self node (both of which have the same PROJECT_ELEMENT_ID). TIME_IDNUMBER18Period time ID RBS_VERSION_IDNUMBER18Resource breakdown structure version ID RBS_ELEMENT_IDNUMBER18Resource breakdown structure element ID RBS_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the RBS_ELEMENT_ID is an interior node, or a self node (both of which have the same RBS_ELEMENT_ID). CALENDAR_TYPEVARCHAR21Indicates whether PA or GL calendar CURRENCY_TYPEVARCHAR21Currency type CURRENCY_CODEVARCHAR23Currency code REVENUENUMBERRevenue LABOR_REVENUENUMBERRevenue RAW_COSTNUMBERRaw cost BILL_RAW_COSTNUMBERBillable raw cost CAP_RAW_COSTNUMBERCapitalizable raw cost EXP_RAW_COSTNUMBERExpense raw cost LABOR_RAW_COSTNUMBERRaw cost BILL_LABOR_RAW_COSTNUMBERBillable raw cost EQUIPMENT_RAW_COSTNUMBERRaw cost BRDN_COSTNUMBERBurdened cost BILL_BRDN_COSTNUMBERBillable burdened cost CAP_BRDN_COSTNUMBERCapitalizable burdened cost EXP_BRDN_COSTNUMBERExpense burdened cost LABOR_BRDN_COSTNUMBERBurdened cost BILL_LABOR_BRDN_COSTNUMBERBillable burdened cost EQUIPMENT_BRDN_COSTNUMBERBurdened cost LABOR_HRSNUMBERQuantity BILL_LABOR_HRSNUMBERQuantity EQUIPMENT_HRSNUMBERQuantity BILL_EQUIPMENT_HRSNUMBERQuantity SUP_INV_COMMITTED_COSTNUMBERSupplier invoice commitment cost PO_COMMITTED_COSTNUMBERPurchase order commitment cost PR_COMMITTED_COSTNUMBERRequisition commitment cost OTH_COMMITTED_COSTNUMBERCommitment cost that is not Purchace Order, Requisition or Supplier Invoice INVOICE_AMTNUMBERInvoice amount RETIRE_RAW_COSTNUMBERRaw cost RETIRE_BRDN_COSTNUMBERBurdened cost

Name

WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.

SCENARIOVARCHAR210Type of data in Essbase whether actuals, current baseline budget, etc.

PJS_SUMMARY_IDNUMBER18The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized.

PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1)

PROJECT_ELEMENT_IDNUMBER18The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID

PROJECT_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the PROJECT_ELEMENT_ID is an interior node, or a self node (both of which have the same PROJECT_ELEMENT_ID).

TIME_IDNUMBER18Period time ID

RBS_VERSION_IDNUMBER18Resource breakdown structure version ID

RBS_ELEMENT_IDNUMBER18Resource breakdown structure element ID

RBS_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the RBS_ELEMENT_ID is an interior node, or a self node (both of which have the same RBS_ELEMENT_ID).

CALENDAR_TYPEVARCHAR21Indicates whether PA or GL calendar

CURRENCY_TYPEVARCHAR21Currency type

CURRENCY_CODEVARCHAR23Currency code

REVENUENUMBERRevenue

LABOR_REVENUENUMBERRevenue

RAW_COSTNUMBERRaw cost

BILL_RAW_COSTNUMBERBillable raw cost

CAP_RAW_COSTNUMBERCapitalizable raw cost

EXP_RAW_COSTNUMBERExpense raw cost

LABOR_RAW_COSTNUMBERRaw cost

BILL_LABOR_RAW_COSTNUMBERBillable raw cost

EQUIPMENT_RAW_COSTNUMBERRaw cost

BRDN_COSTNUMBERBurdened cost

BILL_BRDN_COSTNUMBERBillable burdened cost

CAP_BRDN_COSTNUMBERCapitalizable burdened cost

EXP_BRDN_COSTNUMBERExpense burdened cost

LABOR_BRDN_COSTNUMBERBurdened cost

BILL_LABOR_BRDN_COSTNUMBERBillable burdened cost

EQUIPMENT_BRDN_COSTNUMBERBurdened cost

LABOR_HRSNUMBERQuantity

BILL_LABOR_HRSNUMBERQuantity

EQUIPMENT_HRSNUMBERQuantity

BILL_EQUIPMENT_HRSNUMBERQuantity

SUP_INV_COMMITTED_COSTNUMBERSupplier invoice commitment cost

PO_COMMITTED_COSTNUMBERPurchase order commitment cost

PR_COMMITTED_COSTNUMBERRequisition commitment cost

OTH_COMMITTED_COSTNUMBERCommitment cost that is not Purchace Order, Requisition or Supplier Invoice

INVOICE_AMTNUMBERInvoice amount

RETIRE_RAW_COSTNUMBERRaw cost

RETIRE_BRDN_COSTNUMBERBurdened cost