Admin views provide a means of interacting with the WhereScape RED metadata from within your chosen reporting tools.
The following admin views are available:
Name | Description |
---|---|
ws_admin_v_audit | Created from the ws_wrk_audit_log table |
ws_admin_v_dim_col | Created from the ws_dim_tab and ws_dim_col tables |
ws_admin_v_error | Created from the ws_wrk_error_log table |
ws_admin_v_fact_col | Created from the ws_fact_tab and ws_fact_col tables |
ws_admin_v_fact_join | Created from the ws_fact_tab and ws_fact_col tables |
ws_admin_v_sched | Created from the ws_wrk_job_log table |
ws_admin_v_task | Created from the ws_wrk_task_run and ws_wrk_task_log tables |
Ws_admin_v_audit
This Audit view is created using columns from the ws_wrk_audit_log table.
Columns
The following columns are created:
Column | Description |
---|---|
wa_time_stamp | The date or time at which this view was created. |
wa_sequence | Refer to Callable Routines Common Input for details. |
wa_job | Refer to Callable Routines Common Input for details. |
wa_task | Refer to Callable Routines Common Input for details. |
wa_status | Refer to Callable Routines Common Input for details. |
wa_message | The message associated with this audit log. |
wa_db_msg_desc | The database message associated with this audit log. |
SQL Script
Ws_admin_v_dim_col
This Dimension Column view is created from the ws_dim_tab and ws_dim_col tables.
Columns
The following columns are created:
Column | Description |
---|---|
dimension_table | name of the dimension table |
dim_display_value | display value of the dimension |
dim_description | description of the dimension |
dim_type | a character value indicating the dimension type
|
column_name | column name |
business_name | business name chosen for the column |
description | description of the dimension column |
data_type | data type of the dimension column |
source_table | source table of the dimension table |
source_column | source column of the dimension column |
nulls_allowed | flag indicating whether or not nulls are allowed |
numeric | flag indicating whether or not the column is numeric |
additive | flag indicating whether or not the column is additive |
attribute | flag indicating whether or not the column is an attribute |
format | the dimension column format |
column_order | the dimension column order |
SQL Script
Ws_admin_v_error
This Error view is created using columns from the ws_wrk_error_log table.
Columns
The following columns are created:
Column | Description |
---|---|
wd_time_stamp | The date or time at which this view was created |
wd_sequence | Refer to Callable Routines Common Input for details. |
wd_job | Refer to Callable Routines Common Input for details. |
wd_task | Refer to Callable Routines Common Input for details. |
wd_status | Refer to Callable Routines Common Input for details. |
wd_message | the message associated with this audit log |
wd_db_msg_desc | the database message associated with this audit log |
SQL Script
Ws_admin_v_fact_col
This Fact Column view is created from the ws_fact_tab and ws_fact_col tables.
Columns
The following columns are created:
Column | Description |
---|---|
fact_table | name of the fact table |
fact_display_value | display value of the fact table |
fact_description | description of the fact table |
fact_type | a character value indicating the fact type
|
column_name | column name |
business_name | business name chosen for the column |
description | description of the fact column |
data_type | data type of the fact column |
source_table | source table of the fact table |
source_column | source column of the dimension column |
nulls_allowed | flag indicating whether or not nulls are allowed |
numeric | flag indicating whether or not the column is numeric |
additive | flag indicating whether or not the column is additive |
attribute | flag indicating whether or not the column is an attribute |
format | the fact column format |
column_order | the fact column order |
SQL Script
Ws_admin_v_fact_join
This Fact Column view is created from the ws_fact_tab and ws_fact_col tables.
Columns
The following columns are created:
Column | Description |
---|---|
fact_table | fact table name |
fact_column | fact table column name |
dimension_table | dimension table name |
dimension_column | dimension table column name |
SQL Script
Ws_admin_v_sched
This Scheduled Job view is created from the ws_wrk_job_log table.
Columns
The following columns are created:
Column | Description |
---|---|
type | "Waiting" |
job_name | the name of the job |
status | a character value indicating the job status
|
sequence | sequence number of the job |
started_scheduled | |
completed | date completed |
hours_elapsed | hours elapsed since job started |
minutes_elapsed | minutes elapsed since job started |
okay | okay count |
info | info count |
warn | warning count |
detail | detail count |
error | error count |
SQL Script
Ws_admin_v_task
This Task view is created from the ws_wrk_task_run and ws_wrk_task_log tables.
Columns
The following columns are created:
Column | Description |
---|---|
result | |
task_name | the name of the task |
status | a character value indicating the task status
|
sequence | sequence number of the task |
started | |
completed | |
hours_elapsed | hours elapsed since the task started |
minutes_elapsed | minutes elapsed since the task started |
info | info count |
warn | warning count |
detail | detail count |
inserted | record inserted |
updated | record updated |
replaced | record replaced |
deleted | record deleted |
discarded | record discarded |
rejected | record rejected |
errored | record errored |
SQL Script