This set of views expose the general related data. The set consists of the views described in the following table.
View | Description | Interpreted Columns | SQL Filename |
---|---|---|---|
YNA_COMMON_CODE_NL | This view exposes limited columns from the YFS_COMMON_CODE table | None |
|
YNA_COMMON_CODE_VW | This view exposes data from the YFS_COMMON_CODE table. | None |
|
YNA_DESCRIPTIONS_CONFIG _VW |
This view contains DESCRIPTION column from all of Configuration Tables | None |
|
YNA_DESCRIPTIONS_MASTER _VW |
This view contains DESCRIPTION column from all of Master Tables | None |
|
YNA_LANGUAGE_DESCRIPTION _VW |
This view exposes data from the YFS_LANGUAGE_DESCRIPTION table. | None |
|
YNA_LOCALE_VW | This view exposes data from the YFS_LOCALE table. | None |
|
YNA_LOCALIZED_STRINGS_VW | This view exposes data from the YFS_LOCALIZED_STRINGS table. | None |
|
YNA_PERSON_INFO_VW | This view exposes data from the YFS_PERSON_INFO table. | None |
|
YNA_PRODUCTIVITY_VW | This view exposes data from the YFS_PRODUCTIVITY table. | None |
|
YNA_PERSON_INFO_VW | This view exposes data from the YFS_PERSON_INFO table | None |
|
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 |
|
YNA_PERSON_INFO_VW | This view exposes data from the YFS_PERSON_INFO table | None |
|
YNA_PIPELINE_VW | This view exposes data from the YFS_PIPELINE table. | None |
|
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 |
|
YNA_STATUS_NL_VW | This view exposes the data for few columns in the YFS_STATUS table. | None |
|
YNA_STATUS_VW | This view exposes data from the YFS_STATUS table. | None |
|
YNA_DOCUMENT_PARAMS_VW | This view exposes data from the YFS_DOCUMENT_PARAMS table. | None |
|
YNA_QUEUE_VW | This view exposes data from the YFS_QUEUE table. | None |
|