POI_NOJOB_VW

(SQL View)
 Index Back

POI types without Jobs

Prompt table for POI_TYPES that can be assigned pois without JOBS

SELECT A.POI_TYPE , A.DESCR FROM PS_POI_TYPE_TBL A WHERE A.EFF_STATUS = 'A' AND A.JOB_REQUIRED = 'N'

  • Related Language Record: POI_NOJOB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description