General Views

This set of views expose the general related data. The set consists of the views described in the following table.

Table 1. General Views
View Description Interpreted Columns SQL Filename
YNA_COMMON_CODE_NL This view exposes limited columns from the YFS_COMMON_CODE table None
CONFIGURATION/
Common_CodeNL.sql
YNA_COMMON_CODE_VW This view exposes data from the YFS_COMMON_CODE table. None
CONFIGURATION/
common_code_vw.sql

YNA_DESCRIPTIONS_CONFIG

_VW

This view contains DESCRIPTION column from all of Configuration Tables None
CONFIGURATION/description
_view_config.sql

YNA_DESCRIPTIONS_MASTER

_VW

This view contains DESCRIPTION column from all of Master Tables None
MASTER/description_
view_master.sql

YNA_LANGUAGE_DESCRIPTION

_VW

This view exposes data from the YFS_LANGUAGE_DESCRIPTION table. None
MASTER/language_
description_vw.sql
YNA_LOCALE_VW This view exposes data from the YFS_LOCALE table. None
CONFIGURATION/
locale_vw.sql
YNA_LOCALIZED_STRINGS_VW This view exposes data from the YFS_LOCALIZED_STRINGS table. None
CONFIGURATION/
localized_
strings_vw.sql
YNA_PERSON_INFO_VW This view exposes data from the YFS_PERSON_INFO table. None
CONFIGURATION/
person_info_vw.sql
YNA_PRODUCTIVITY_VW This view exposes data from the YFS_PRODUCTIVITY table. None
TRANSACTION/
Productivity.sql
YNA_PERSON_INFO_VW This view exposes data from the YFS_PERSON_INFO table None
TRANSACTION/
person_info_
vw.sql
YNA_WORKFLOW_PTD_VW

This view exposes the data in the YFS_PIPELINE, YFS_PIPELINE_DEFINITION,

and YFS_PIPELINE_DROP

_STS_COND tables. It provides information about the Pipeline, Transaction, and Drop Status (PTD) for various Process Types. It is a helper view used by other views in IBM® Sterling Warehouse Management System Business Intelligence

.
None
CONFIGURATION/
Workflow_PTD.sql
YNA_PERSON_INFO_VW This view exposes data from the YFS_PERSON_INFO table None
MASTER/
Person_Info.sql
YNA_PIPELINE_VW This view exposes data from the YFS_PIPELINE table. None
CONFIGURATION/
pipeline_vw.sql
YNA_SCAC_AND_SERVICE_VW

This view exposes data by joining the YNA_SCAC

_AND_SERVICE_NL_VW and YNA_

LOCALIZED_DESCRIPTIONS_

VW views.

None
CONFIGURATION/
scac_and_service_
vw.sql
YNA_STATUS_NL_VW This view exposes the data for few columns in the YFS_STATUS table. None
CONFIGURATION/
StatusNL.sql
YNA_STATUS_VW This view exposes data from the YFS_STATUS table. None
CONFIGURATION/
status_vw.sql
YNA_DOCUMENT_PARAMS_VW This view exposes data from the YFS_DOCUMENT_PARAMS table. None
CONFIGURATION/
document_params_
vw.sql
YNA_QUEUE_VW This view exposes data from the YFS_QUEUE table. None
CONFIGURATION/
queue_vw.sql