PJS_UNIT_INFO

This table contains persistent information about all project units for use in summarization.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: FUSION_TS_SUMMARY

Columns

Name Datatype Length Precision Not-null Comments Status
PROJECT_UNIT_ID NUMBER 18 Project unit ID Active
FUN_CURRENCY_CODE VARCHAR2 3 Project functional currency code Active
FUN_CURRENCY_MAU NUMBER Project functional currency minimum accounting unit Active
GL_CALENDAR_ID NUMBER 18 Time dimension calendar ID Active
GL_CALENDAR_MIN_DATE DATE Start date of the earliest period for the GL calendar Active
GL_CALENDAR_MAX_DATE DATE End date of the latest period for the GL calendar Active
GL_FIRST_PERIOD_ID NUMBER 18 Contains the earliest summarized PA period Active
GL_FIRST_PERIOD_NAME VARCHAR2 100 Contains the earliest summarized GL period Active
GL_FIRST_START_DATE DATE The start date of the earliest period for the GL calendar for the PU Active
GL_FIRST_END_DATE DATE The end date of the latest period for the GL calendar for the PU Active
GL_CURR_REP_PERIOD_ID NUMBER 18 Current reporting GL period Active
PA_CALENDAR_ID NUMBER 18 Time dimension calendar ID Active
PA_CALENDAR_MIN_DATE DATE Start date of the earliest period for the PA calendar Active
PA_CALENDAR_MAX_DATE DATE End date of the latest period for the PA calendar Active
PA_FIRST_PERIOD_ID NUMBER 18 Contains the earliest summarized PA period Active
PA_FIRST_PERIOD_NAME VARCHAR2 100 Contains the earliest summarized PA period Active
PA_FIRST_START_DATE DATE The start date of the earliest period for the PA calendar for the PU Active
PA_FIRST_END_DATE DATE The end date of the latest period for the PA calendar for the PU Active
PA_CURR_REP_PERIOD_ID NUMBER 18 Current reporting PA period 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