Viewing and Editing the Survey Data Warehouse Tables

After you have run the appropriate ETL jobs and imported your data into the Operational Warehouse - Enriched (OWE) tables, you can view and edit the data in the tables online.

Note: The following table lists pages used to view and edit survey data in the data warehouse tables. Because these pages are basic setup pages and the fields for the underlying tables are shown in the flat file definitions at the end of this topic, this topic doesn't discuss these pages in detail here.

Pages Used to View and Edit the Survey Data Warehouse Tables

Page Name	Definition Name	Navigation	Usage
Survey Author	WA_AUTHOR_R00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Author	View and edit data about external survey providers and their address information.
Survey Instance	WA_SURVEY_R00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Instance	View and edit publication information about a survey.
Survey Job Code	WA_SUR_JOB_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Job Code	View and edit the job codes that are used in external surveys.
Survey Compensation Code	WA_SUR_COMP_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Compensation Code	View and edit external survey compensation codes.
Survey Geography ID	WA_SUR_GEO_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Geography ID	View and edit external survey geographical regions.
Survey Industry Code	WA_SUR_IND_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Industry Code	View and edit external survey industry categories.
Survey Financial Code	WA_SUR_FIN_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Financial Code	View and edit data about the financial size (based on factors such as sales or revenue) of companies participating in external surveys.
Survey Unit Code	WA_SUR_UNIT_D00	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Setup Survey Unit Code	View and edit data, other than financial data, that measures the relative size of companies participating in external surveys.