[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIX_DM_UWQ_GROUP_SUM |
|---|---|
| Object Type: | TABLE |
| Owner: | BIX |
| Subobject Name: | |
| Status: | VALID |
This table stores summarized UWQ (Universal Work Queue) information. The measures which are captured are the number of logins and the login durations. The information is summarized by group by day. The table is sourced from the UWQ application's base tables.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BIX_DM_UWQ_GROUP_SUM_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
 GROUP_ID
DAY
|
| BIX_DM_UWQ_GROUP_SUM_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
DAY
|
| BIX_DM_UWQ_GROUP_SUM_N3 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
LAST_UPDATE_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GROUP_ID | NUMBER | Yes | Group identifier from the transaction table JTF_RS_GROUPS | |
| DAY | DATE | Yes | Date that the measures correspond to. UWQ summary tables are based on a day level. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Identifier of last concurrent program to update this record | |
| PROGRAM_UPDATE_DATE | DATE | Date when a concurrent program last updated this record | ||
| SECURITY_GROUP_ID | NUMBER | Subscriber id for CRM Online Services use | ||
| DAY_LOGIN | NUMBER | Number of logins for the date referenced in DAY column | ||
| DAY_DURATION | VARCHAR2 | (15) | Total login duration in secondsfor the date referenced in the DAY column | |
| DAY1_LOGIN | NUMBER | Number of logins for DAY-1 | ||
| DAY1_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-1 | |
| DAY2_LOGIN | NUMBER | Number of logins for DAY-2 | ||
| DAY2_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-2 | |
| DAY3_LOGIN | NUMBER | Number of logins for DAY-3 | ||
| DAY3_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-3 | |
| DAY4_LOGIN | NUMBER | Number of logins for DAY-4 | ||
| DAY4_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-4 | |
| DAY5_LOGIN | NUMBER | Number of logins for DAY-5 | ||
| DAY5_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-5 | |
| DAY6_LOGIN | NUMBER | Number of logins for DAY-6 | ||
| DAY6_DURATION | VARCHAR2 | (15) | Total login duration in seconds for DAY-6 | |
| PRIOR_WEEK_LOGIN | NUMBER | Number of logins for the prior week (week definition based on ISO standard) | ||
| PRIOR_WEEK_DURATION | VARCHAR2 | (15) | Total duration in seconds for the prior week (week definition based on ISO standard) | |
| CURRENT_WEEK_LOGIN | NUMBER | Number of logins for the current week to date (week definition based on ISO standard) | ||
| CURRENT_WEEK_DURATION | VARCHAR2 | (15) | Total duration in seconds for the current week to date (week definition based on ISO standard) | |
| PRIOR_MONTH_LOGIN | NUMBER | Number of logins for prior month | ||
| PRIOR_MONTH_DURATION | VARCHAR2 | (15) | Total duration in seconds for prior month | |
| CURRENT_MONTH_LOGIN | NUMBER | Number of logins for current month to date | ||
| CURRENT_MONTH_DURATION | VARCHAR2 | (15) | Total duration in seconds for the current month to date |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, DAY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
, DAY_LOGIN
, DAY_DURATION
, DAY1_LOGIN
, DAY1_DURATION
, DAY2_LOGIN
, DAY2_DURATION
, DAY3_LOGIN
, DAY3_DURATION
, DAY4_LOGIN
, DAY4_DURATION
, DAY5_LOGIN
, DAY5_DURATION
, DAY6_LOGIN
, DAY6_DURATION
, PRIOR_WEEK_LOGIN
, PRIOR_WEEK_DURATION
, CURRENT_WEEK_LOGIN
, CURRENT_WEEK_DURATION
, PRIOR_MONTH_LOGIN
, PRIOR_MONTH_DURATION
, CURRENT_MONTH_LOGIN
, CURRENT_MONTH_DURATION
FROM BIX.BIX_DM_UWQ_GROUP_SUM;
BIX.BIX_DM_UWQ_GROUP_SUM does not reference any database object
BIX.BIX_DM_UWQ_GROUP_SUM is referenced by following:
APPS
BIX_DM_UWQ_GROUP_SUM
|
|
|
|