Work Order Views

This view exposes the Work Order-related audit data. The set consists of the views described in the following table.

Table 1. Work Order Views
View Description Interpreted Columns SQL Filename
YNA_WORK_ORDER_NL_VW This view exposes data from the YFS_WORK_ORDER table. None
TRANSACTION/YNA_
WORK_ORDER_NL_VW.sql
YNA_WORK_ORDER_TAG_VW This view exposes the data in the YFS_WORK_ORDER_TAG table. None
TRANSACTION/YNA_WORK_
ORDER_TAG_VW.sql
YNA_WORK_ORDER_STS_AUDIT_VW

This view exposes the data in the YFS_WORK_ORDER_

STS_AUDIT table.

None
TRANSACTION/YNA_WORK_
ORDER_STS_AUDIT_VW.sql

YNA_WORK_ORDER_

SERVICE_TOOL_VW

This view exposes the data in the YFS_WORK_

ORDER_SERVICE_TOOL table.

None
TRANSACTION/YNA_WORK_
ORDER_SERVICE_TOOL_VW.sql

YNA_WORK_ORDER_SERVICE

_LINE_VW

This view exposes the data in the YFS_WORK_

ORDER_SERVICE_LINE table.

None
TRANSACTION/YNA_WORK_ORDER
_SERVICE_LINE_VW.sql

YNA_WORK_ORDER_PROD

_DEL_VW

This view exposes the data in the YFS_WORK_ORDER

_PROD_DEL table.

None
TRANSACTION/YNA_WORK_
ORDER_PROD_DEL_VW.sql

YNA_WORK_ORDER_

NOTES_VW

This view exposes the data in the YFS_WORK_

ORDER_NOTES table.

None
TRANSACTION/YNA_WORK_
ORDER_NOTES_VW.sql

YNA_WORK_ORDER_COMPONENT

_VW

This view exposes the data in the YFS_WORK_

ORDER_COMPONENT table.

None
TRANSACTION/YNA_WORK_
ORDER_COMPONENT_VW.sql

YNA_WORK_ORDER_COMP_

TAG_VW

This view exposes the data in the YFS_WORK_ORDER

_COMP_TAG table.

None
TRANSACTION/YNA_WORK_
ORDER_COMP_TAG_VW.sql

YNA_WORK_ORDER_AUDT

_DTL_VW

This view exposes the data in the YFS_WORK_ORDER_

AUDT_DTL table.

None
TRANSACTION/YNA_WORK_
ORDER_AUDT_DTL_VW.sql

YNA_WORK_ORDER_APPT_

VW

This view exposes the data in the YFS_WORK_ORDER_

APPT table.

None
TRANSACTION/YNA_WORK_
ORDER_APPT_VW.sql

YNA_WORK_ORDER_ACTY

_DTL_VW

This view exposes the data in the YFS_WORK_ORDER

_ACTY_DTL table.

None
TRANSACTION/YNA_WORK_
ORDER_ACTY_DTL_VW.sql

YNA_WORK_ORDER_ACTIVITY

_VW

This view exposes the data in the YFS_WORK_ORDER_

ACTIVITY table.

None
TRANSACTION/YNA_WORK_
ORDER_ACTIVITY_VW.sql
YNA_WO_HOLD_TYPE_VW

This view exposes the data in the YFS_WO_HOLD

_TYPE table.

None
TRANSACTION/YNA_
WO_HOLD_TYPE_VW.sql
YNA_WO_HOLD_TYPE_LOG_VW

This view exposes the data in the YFS_WO_HOLD_

TYPE_LOG table.

None
TRANSACTION/YNA_
WO_HOLD_TYPE_LOG_VW.sql
YNA_WO_APPT_USER_VW

This view exposes the data in the YFS_WO_

APPT_USER table.

None
TRANSACTION/YNA_
WO_APPT_USER_VW.sql