XCC_ACCOUNT_GROUPS
This table stores the groups of accounts setup by each user to enable easy monitoring of funds available balances.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_ACCOUNT_GROUPS_PK |
ACCOUNT_GROUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNT_GROUP_ID | NUMBER | 18 | Yes | Identifier of the account group. Account groups are pre-determined sets of budget accounts which can be used for instant review of funds available balances. | |
| ACCOUNT_GROUP_NAME | VARCHAR2 | 100 | Yes | User-visible name for the account group. Account groups are pre-determined sets of budget accounts which can be used for instant review of funds available balances. | |
| DESCRIPTION | VARCHAR2 | 240 | Description for the account group. Account groups are pre-determined sets of budget accounts which can be used for instant review of funds available balances. | ||
| USER_GUID | VARCHAR2 | 32 | Yes | Identifier of the user who creates and uses this account group. | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Identifier of the control budget upon which this account group is based. | ||
| DEFAULT_FLAG | VARCHAR2 | 1 | Controls whether this account group will be displayed automatically rather than the user having to choose it. There can only be one default account group per user. | ||
| TIME_OPTION_CODE | VARCHAR2 | 10 | Controls whether the account group displays budget balances for the period, quarter, or year. | ||
| COMPARISON_OPTION_CODE | VARCHAR2 | 10 | Determines which budgetary and funds available balances should be reviewed and compared. | ||
| FUNDS_AVAIL_MONITOR_THRESHOLD | NUMBER | The threshold below which funds available as a percentage of budget requires monitoring. | |||
| FUNDS_AVAIL_WARNING_THRESHOLD | NUMBER | The threshold below which funds available as a percentage of budget is a concern. | |||
| FUNDS_AVAIL_WARNING_COLOR | VARCHAR2 | 10 | The color used to display the funds available in a range of concern. | ||
| FUNDS_AVAIL_MONITOR_COLOR | VARCHAR2 | 10 | The color used to display the funds available in between a range that requires monitoring. | ||
| FUNDS_AVAIL_NORMAL_COLOR | VARCHAR2 | 10 | The color used to display the funds available above the threshold that requires monitoring. | ||
| ACCESS_LEVEL_CODE | VARCHAR2 | 30 | Yes | Account group access level. The possible values are Private and Public. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_ACCOUNT_GROUPS_U1 | Unique | Default | ACCOUNT_GROUP_ID |
| XCC_ACCOUNT_GROUPS_U2 | Unique | Default | USER_GUID, ACCOUNT_GROUP_NAME |