PJS_BU_INFO
This table contains persistent information about all business units for use in summarization.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | ||
| FUN_CURRENCY_CODE | VARCHAR2 | 15 | Project functional currency code | ||
| FUN_CURRENCY_MAU | NUMBER | Functional currency minimum accounting unit | |||
| GL_CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | ||
| GL_CALENDAR_MIN_DATE | DATE | Start date of earliest summarized GL period | |||
| GL_CALENDAR_MAX_DATE | DATE | End date of latest summarized GL period | |||
| GL_FIRST_PERIOD_ID | NUMBER | 18 | Earliest period for the GL calendar | ||
| GL_FIRST_PERIOD_NAME | VARCHAR2 | 100 | Contains the earliest summarized GL period | ||
| GL_FIRST_START_DATE | DATE | The start date of the earliest period for the GL calendar for the BU | |||
| GL_FIRST_END_DATE | DATE | The end date of the latest period for the GL calendar for the BU | |||
| GL_CURR_REP_PERIOD_ID | NUMBER | 18 | GL current reporting period | ||
| PA_CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | ||
| PA_CALENDAR_MIN_DATE | DATE | Start date of earliest summarized PA period | |||
| PA_CALENDAR_MAX_DATE | DATE | End date of earliest summarized PA period | |||
| PA_FIRST_PERIOD_ID | NUMBER | 18 | Earliest period for the PA calendar | ||
| PA_FIRST_PERIOD_NAME | VARCHAR2 | 100 | Contains the earliest summarized PA period | ||
| PA_FIRST_START_DATE | DATE | The start date of the earliest period for the PA calendar for the BU | |||
| PA_FIRST_END_DATE | DATE | The end date of the latest period for the PA calendar for the BU | |||
| PA_CURR_REP_PERIOD_ID | NUMBER | 18 | PA current reporting period | ||
| PA_CUR_PER_NAME | VARCHAR2 | 100 | PA current period name | ||
| PA_CUR_PER_START_DATE | DATE | PA current period start date | |||
| PA_CUR_PER_END_DATE | DATE | PA current period end date | |||
| PA_CUR_CAL_PER_ID | NUMBER | 18 | PA current calender period | ||
| PA_PRI_PER_NAME | VARCHAR2 | 100 | PA prior period name | ||
| PA_PRI_PER_START_DATE | DATE | PA prior period start date | |||
| PA_PRI_PER_END_DATE | DATE | PA prior period end date | |||
| PA_PRI_CAL_PER_ID | NUMBER | 18 | PA prior calender period | ||
| PA_FOP_PER_NAME | VARCHAR2 | 100 | PA FOP period name | ||
| PA_FOP_PER_START_DATE | DATE | PA FOP period start date | |||
| PA_FOP_PER_END_DATE | DATE | PA FOP period end date | |||
| PA_FOP_CAL_PER_ID | NUMBER | 18 | PA FOP calender period | ||
| PA_LOP_PER_NAME | VARCHAR2 | 100 | PA LOP period name | ||
| PA_LOP_PER_START_DATE | DATE | PA LOP period start date | |||
| PA_LOP_PER_END_DATE | DATE | PA LOP period end date | |||
| PA_LOP_CAL_PER_ID | NUMBER | 18 | PA LOP calender period | ||
| PA_LCL_PER_NAME | VARCHAR2 | 100 | PA local period name | ||
| PA_LCL_PER_START_DATE | DATE | PA local period start date | |||
| PA_LCL_PER_END_DATE | DATE | PA local period end date | |||
| PA_LCL_CAL_PER_ID | NUMBER | 18 | PA local calender period | ||
| PA_MIN_PER_NAME | VARCHAR2 | 100 | PA minimum period name | ||
| PA_MIN_PER_START_DATE | DATE | PA minimum period start date | |||
| PA_MIN_PER_END_DATE | DATE | PA minimum period end date | |||
| PA_MIN_CAL_PER_ID | NUMBER | 18 | PA minimum calender period | ||
| PA_MAX_PER_NAME | VARCHAR2 | 100 | PA maximum period name | ||
| PA_MAX_PER_START_DATE | DATE | PA maximum period start date | |||
| PA_MAX_PER_END_DATE | DATE | PA maximum period end date | |||
| PA_MAX_CAL_PER_ID | NUMBER | 18 | PA maximum calender period | ||
| GL_CUR_PER_NAME | VARCHAR2 | 100 | GL current period name | ||
| GL_CUR_PER_START_DATE | DATE | GL current period start date | |||
| GL_CUR_PER_END_DATE | DATE | GL current period end date | |||
| GL_CUR_CAL_PER_ID | NUMBER | 18 | GL current calender period | ||
| GL_PRI_PER_NAME | VARCHAR2 | 100 | GL perior period name | ||
| GL_PRI_PER_START_DATE | DATE | GL prior period start date | |||
| GL_PRI_PER_END_DATE | DATE | GL prior period end date | |||
| GL_PRI_CAL_PER_ID | NUMBER | 18 | GL prior calender period | ||
| GL_FOP_PER_NAME | VARCHAR2 | 100 | GL FOP period name | ||
| GL_FOP_PER_START_DATE | DATE | GL FOP period start date | |||
| GL_FOP_PER_END_DATE | DATE | GL FOP period end date | |||
| GL_FOP_CAL_PER_ID | NUMBER | 18 | GL FOP calender period | ||
| GL_LOP_PER_NAME | VARCHAR2 | 100 | GL LOP period name | ||
| GL_LOP_PER_START_DATE | DATE | GL LOP period start date | |||
| GL_LOP_PER_END_DATE | DATE | GL LOP period end date | |||
| GL_LOP_CAL_PER_ID | NUMBER | 18 | GL LOP calender period | ||
| GL_LCL_PER_NAME | VARCHAR2 | 100 | GL local period name | ||
| GL_LCL_PER_START_DATE | DATE | GL local period start date | |||
| GL_LCL_PER_END_DATE | DATE | GL local period end date | |||
| GL_LCL_CAL_PER_ID | NUMBER | 18 | GL local calender period | ||
| GL_MIN_PER_NAME | VARCHAR2 | 100 | GL minimum period name | ||
| GL_MIN_PER_START_DATE | DATE | GL minimum period start date | |||
| GL_MIN_PER_END_DATE | DATE | GL minimum period end date | |||
| GL_MIN_CAL_PER_ID | NUMBER | 18 | GL minimum calender period | ||
| GL_MAX_PER_NAME | VARCHAR2 | 100 | GL maximum period name | ||
| GL_MAX_PER_START_DATE | DATE | GL maximum period start date | |||
| GL_MAX_PER_END_DATE | DATE | GL maximum period end date | |||
| GL_MAX_CAL_PER_ID | NUMBER | 18 | GL maximum calender period | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ADDL_ATTR_CHAR_1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR_2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR_3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR_4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR_5 | VARCHAR2 | 150 | Oracle internal use only. |