DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_OLAP_STAGE

Object Details
Object Name: PA_OLAP_STAGE
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_OLAP_STAGE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
PA_OLAP_STAGE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ELEMENT_ID
ColumnPLAN_VERSION_ID
ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
OLAP_GROUP NUMBER (15) Yes Identifier for the partition within reporting cube
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ELEMENT_ID NUMBER (15) Yes This is the WBS element id and consists of projects and tasks.
TIME_ID NUMBER (15) Yes Numeric identifier for time
CALENDAR_TYPE VARCHAR2 (1) Yes Specifies the calendar type (PA, GL, Enterprise)
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
RBS_ELEMENT_ID NUMBER (15) Yes Identifier for the RBS
RBS_VERSION_ID NUMBER (15) Yes Identifier for the RBS version
PLAN_VERSION_ID NUMBER (15) Yes Same as Budget version identifier. >0 = version id, -1 = Actuals, -2 = Progress Actuals, -3 = Current Baselined, -4 = Current Original Baselined
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
RAW_COST NUMBER

Transaction Raw Cost
BRDN_COST NUMBER

Transaction Burdened Cost
REVENUE NUMBER

Transaction Revenue
BILL_RAW_COST NUMBER

Billable Raw Cost
BILL_BRDN_COST NUMBER

Billable Burdened Cost
BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost
BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost
BILL_LABOR_HRS NUMBER

Billable Labor Hours
EQUIPMENT_RAW_COST NUMBER

Equipment Raw Cost
EQUIPMENT_BRDN_COST NUMBER

Equipment Burdened Cost
CAPITALIZABLE_RAW_COST NUMBER

Capitalizable Raw Cost
CAPITALIZABLE_BRDN_COST NUMBER

Capitalizable Burdened Cost
LABOR_RAW_COST NUMBER

Labor Raw Cost
LABOR_BRDN_COST NUMBER

Labor Burdened Cost
LABOR_HRS NUMBER

Labor Hours
LABOR_REVENUE NUMBER

Labor Revenue
EQUIPMENT_HOURS NUMBER

Equipment Hours
BILLABLE_EQUIPMENT_HOURS NUMBER

Billable Equipment Hours
SUP_INV_COMMITTED_COST NUMBER

Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST NUMBER

Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST NUMBER

Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST NUMBER

Commitments other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CUSTOM1 NUMBER

Custom measure1
CUSTOM2 NUMBER

Custom measure2
CUSTOM3 NUMBER

Custom measure3
CUSTOM4 NUMBER

Custom measure4
CUSTOM5 NUMBER

Custom measure5
CUSTOM6 NUMBER

Custom measure6
CUSTOM7 NUMBER

Custom measure7
CUSTOM8 NUMBER

Custom measure8
CUSTOM9 NUMBER

Custom measure9
CUSTOM10 NUMBER

Custom measure10
CUSTOM11 NUMBER

Custom measure11
CUSTOM12 NUMBER

Custom measure12
CUSTOM13 NUMBER

Custom measure13
CUSTOM14 NUMBER

Custom measure14
CUSTOM15 NUMBER

Custom measure15
ACT_LABOR_HRS NUMBER

ACT_EQUIP_HRS NUMBER

ACT_LABOR_BRDN_COST NUMBER

ACT_EQUIP_BRDN_COST NUMBER

ACT_BRDN_COST NUMBER

ACT_RAW_COST NUMBER

ACT_REVENUE NUMBER

ETC_LABOR_HRS NUMBER

ETC_EQUIP_HRS NUMBER

ETC_LABOR_BRDN_COST NUMBER

ETC_EQUIP_BRDN_COST NUMBER

ETC_BRDN_COST NUMBER

ETC_RAW_COST NUMBER

ACT_LABOR_RAW_COST NUMBER

ACT_EQUIP_RAW_COST NUMBER

ETC_LABOR_RAW_COST NUMBER

ETC_EQUIP_RAW_COST NUMBER

CBS_VERSION_ID NUMBER

CBS_ELEMENT_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OLAP_GROUP
,      PROJECT_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      CALENDAR_TYPE
,      CURRENCY_CODE
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      PLAN_VERSION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RAW_COST
,      BRDN_COST
,      REVENUE
,      BILL_RAW_COST
,      BILL_BRDN_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BRDN_COST
,      BILL_LABOR_HRS
,      EQUIPMENT_RAW_COST
,      EQUIPMENT_BRDN_COST
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_HRS
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      BILLABLE_EQUIPMENT_HOURS
,      SUP_INV_COMMITTED_COST
,      PO_COMMITTED_COST
,      PR_COMMITTED_COST
,      OTH_COMMITTED_COST
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
,      ACT_LABOR_HRS
,      ACT_EQUIP_HRS
,      ACT_LABOR_BRDN_COST
,      ACT_EQUIP_BRDN_COST
,      ACT_BRDN_COST
,      ACT_RAW_COST
,      ACT_REVENUE
,      ETC_LABOR_HRS
,      ETC_EQUIP_HRS
,      ETC_LABOR_BRDN_COST
,      ETC_EQUIP_BRDN_COST
,      ETC_BRDN_COST
,      ETC_RAW_COST
,      ACT_LABOR_RAW_COST
,      ACT_EQUIP_RAW_COST
,      ETC_LABOR_RAW_COST
,      ETC_EQUIP_RAW_COST
,      CBS_VERSION_ID
,      CBS_ELEMENT_ID
FROM PA.PA_OLAP_STAGE;

Dependencies

[top of page]

PA.PA_OLAP_STAGE does not reference any database object

PA.PA_OLAP_STAGE is referenced by following:

SchemaPA
ViewPA_OLAP_STAGE#