XCC_BALANCES_CUBES
This table stores the budgetary control structure Essbase Cube information
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUBE_ID | NUMBER | 18 | Yes | Unique identifier for XCC Essbase Cube | |
| CUBE_NAME | VARCHAR2 | 60 | Yes | Name of essbase cube that stores budgetary control balances | |
| APPLICATION_NAME | VARCHAR2 | 60 | Yes | Unique Name for the Essbase Application | |
| DESCRIPTION | VARCHAR2 | 240 | Description of the Essbase Cube | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | UNique identifier for the Budget Chart Of Accounts | |
| CALENDAR_ID | NUMBER | 18 | Yes | Unique identifier for the Accounting Calendar | |
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Accounting Calendar Period Set Name | |
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting Calendar Period Type | |
| SEGMENT1_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE1" | ||
| SEGMENT2_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE2" | ||
| SEGMENT3_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE3" | ||
| SEGMENT4_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE4" | ||
| SEGMENT5_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE5" | ||
| SEGMENT6_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE6" | ||
| SEGMENT7_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE7" | ||
| SEGMENT8_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE8" | ||
| SEGMENT9_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE9" | ||
| SEGMENT10_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE10" | ||
| SEGMENT11_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE11" | ||
| SEGMENT12_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE12" | ||
| SEGMENT13_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE13" | ||
| SEGMENT14_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE14" | ||
| SEGMENT15_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE15" | ||
| SEGMENT16_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE16" | ||
| SEGMENT17_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE17" | ||
| SEGMENT18_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE18" | ||
| SEGMENT19_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE19" | ||
| SEGMENT20_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE20" | ||
| SEGMENT21_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE21" | ||
| SEGMENT22_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE22" | ||
| SEGMENT23_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE23" | ||
| SEGMENT24_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE24" | ||
| SEGMENT25_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE25" | ||
| SEGMENT26_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE26" | ||
| SEGMENT27_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE27" | ||
| SEGMENT28_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE28" | ||
| SEGMENT29_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE29" | ||
| SEGMENT30_SEQ | NUMBER | 18 | Sequece value assigned to Budget Chart Of Accounts Segment column - "SEGMENT_VALUE30" | ||
| ESSBASE_SERVER_PORT | VARCHAR2 | 1000 | Essbase OLAP Server information | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CUBE_CREATION_STATUS_CODE | VARCHAR2 | 60 | Cube Creation Status Code Column | ||
| PROJECT_ID | NUMBER | 18 | Project accounting project unique identifier. | ||
| CUBE_END_PERIOD_EFF_NUM | NUMBER | 18 | The latest period extracted into this cube. | ||
| REBUILD_CALENDAR_REQD_FLAG | VARCHAR2 | 1 | Indicates whether the calendar dimension of the budgetary control cube must be rebuilt. | ||
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_BALANCES_CUBES_U1 | Unique | Default | CUBE_ID |
| XCC_BALANCES_CUBES_U2 | Unique | Default | APPLICATION_NAME |
| XCC_BALANCES_CUBES_U3 | Unique | Default | CHART_OF_ACCOUNTS_ID, CALENDAR_ID |