IN_WM_PC_PRJ_VW (SQL View)	Index Back
View by WO type and Service The purpose of this view is to provide a distinct list of Projects based on a work order type and service group combination. The default project table is based on wildcarding. This record joins to the WO type table to get a full view.

IN_WM_PC_PRJ_VW

(SQL View)

View by WO type and Service

The purpose of this view is to provide a distinct list of Projects based on a work order type and service group combination. The default project table is based on wildcarding. This record joins to the WO type table to get a full view.

SELECT BUSINESS_UNIT , WO_TYPE , SRVC_GRP_ID , PROJECT_ID FROM PS_WM_PC_PRJ_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection

2 SL_WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

3 SL_SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SL_SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Business Unit selection
2	SL_WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type
3	SL_SRVC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Group
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField