WM_PM_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.

SELECT A.BUSINESS_UNIT , CASE WHEN A.WO_TYPE = '%' THEN ' ' ELSE A.WO_TYPE END , CASE WHEN A.SRVC_GRP_ID = '%' THEN ' ' ELSE A.SRVC_GRP_ID END , A.EFFDT , A.PROJECT_ID , B.DESCR , A.DEFAULT_FLAG , B.MANAGED_BY_WO FROM PS_WM_PC_DFLT_DTL A , PS_PROJECT B WHERE A.BUSINESS_UNIT_PC = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.EFF_STATUS = 'A'

  • Related Language Record: WM_PM_PC_PRJ_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_WM_NONVW

    2 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
    3 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit

    8 MANAGED_BY_WO Character(1) VARCHAR2(1) NOT NULL Indicates whether a project is Work Order Managed.
    N=No
    Y=Yes

    Y/N Table Edit