1. Tables and Views for Project Management
  2. PJF_PU_REPORTING_SETTINGS

PJF_PU_REPORTING_SETTINGS

PJF_PU_REPORTING_SETTINGS stores the parameters and defaults that define the configuration of Oracle Project Performance Repoorting for summarization and reporting at Project Unit level .

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PJF_PU_REPORTING_SETTINGS_PK

PU_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PU_ID NUMBER 18 Yes Identifier for the setting. This is Primary key for this table ***** Active
ENABLE_REPORTING VARCHAR2 1 Reporting configuration attribute. This column's value is for enable Project Performance Reporting ***** Active
EXTR_COST_FLAG VARCHAR2 1 to summarize Cost which is Data Source for Reporting ***** Active
EXTR_REVENUE_FLAG VARCHAR2 1 to summarize Revenue, which is Data Source for Reporting ***** Active
EXTR_PLAN_FLAG VARCHAR2 2 to summarize B and F data which is Data Source for Reporting. ***** Active
EXTR_COMMITMENT_FLAG VARCHAR2 1 to summarize Commitments which is Data Source for Reporting ***** Active
EXTR_INVOICE_FLAG VARCHAR2 1 to summarize Invoice which is Data Source for Reporting *****
ONLINE_SUMM_COST_FLAG VARCHAR2 1 To enable real time processing of Cost transactions. *****
ONLINE_SUMM_REVENUE_FLAG VARCHAR2 1 To enable real time processing of Revenue transactions. *****
ONLINE_SUMM_PLAN_FLAG VARCHAR2 1 To enable real time processing of Budget and Forecast transactions. *****
ONLINE_SUMM_COMMITMENT_FLAG VARCHAR2 1 To enable real time processing of Commitment transactions. *****
ONLINE_SUMM_INVOICE_FLAG VARCHAR2 1 To enable real time processing of Invoice transactions. *****
COMMITMENT_STATUS_REQ VARCHAR2 1 This is to determine the status of Commitment requisitions.This is mapped to static list of values . This will have three values i.e All (A) , All Approved( R ), Do not Include( N ). ***** Active
COMMITMENT_STATUS_PO VARCHAR2 1 This is to determine the status of Commitment Purchase Order .This is mapped to static list of values . This will have three values i.e All (A) ***** Active
COMMITMENT_STATUS_SUPINV VARCHAR2 1 This is to determine the status of Commitment Supplier Invoice.This is mapped to static list of values . This will have three values i.e All (A) ***** Active
COMMITMENT_STATUS_EXTERNAL VARCHAR2 1 This is to determine the status of Commitment External.This is mapped to static list of values . This will have three values i.e All (A) ***** Active
PRJ_CURR_FLAG VARCHAR2 2 Project Currency Active
PRJ_FUNC_CURR_FLAG VARCHAR2 2 This column is to mark Project functional currency as reporting currency ***** Active
TXN_CURR_FLAG VARCHAR2 2 Transaction Currency flag Active
PA_CALENDAR_FLAG VARCHAR2 2 This column is to decide if summarization is done based upon PA calendar. ***** Active
GL_CALENDAR_FLAG VARCHAR2 2 This column is to decide if summarization is done based upon GL calendar. ***** Active
PA_REPORTING_PERIOD VARCHAR2 20 to set the Reporting Periods based on which reporting pages will display the ITD and PTD measures for PA Calendar. ***** Active
GL_REPORTING_PERIOD VARCHAR2 20 to set the Reporting Periods based on which reporting pages will display the ITD and PTD measures for GL Calendar. ***** Active
DEFAULT_CURRENCY VARCHAR2 30 to set the default Currency Type required for displaying measures on Project Performance Pages. ***** Active
DEFAULT_CALENDAR VARCHAR2 30 to set the default calender Type required for displaying measures on Project Performance Pages. ***** Active
DEFAULT_UOM VARCHAR2 15 To set the default UoM for effort required for displaying measures on Project Performance Pages ***** Active
DISPLAY_FACTOR VARCHAR2 30 To set the display factor. ***** Active
GENERATE_EXCEPTION_FLAG VARCHAR2 1 This column is to decide if user wants to generate exceptions automatically after Project Performance Data is updated by the summarization program ***** Active
REFRESH_ON_EXCEPTION_FLAG VARCHAR2 1 This column is to decide if user wants to automatically refresh Project Performance data immediately before the exception process is executed. ***** Active
COMPARISION_PERIOD NUMBER 18 to differentiate stale data while reporting exceptions. This will have values as defined in the billing cycle in the Project Setup for Billing ***** Active
PLANAMT_ALLOC_METHOD VARCHAR2 30 Planning amount allocation method Active
TRACK_MISSING_TIME_FLAG VARCHAR2 1 TRACK_MISSING_TIME_FLAG Active
PRIOR_EI_WEEKS NUMBER PRIOR_EI_WEEKS Active
INCLUDE_CURRENT_WEEK_FLAG VARCHAR2 1 INCLUDE_CURRENT_WEEK_FLAG Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active

Foreign Keys

Table Foreign Table Foreign Key Column
PJF_PU_REPORTING_SETTINGS pjf_pu_impl PU_ID
pjf_pu_time_sources pjf_pu_reporting_settings PU_ID

Indexes

Index Uniqueness Tablespace Columns Status
PJF_PU_REPORTING_SETTINGS_U1 Unique FUSION_TS_TX_DATA PU_ID Active