IDO_HC_JPN_SRCH

(SQL View)
 Index Back

Ido Headcount Plan Search Rec

Used as a search record allowing a user to enter in both Org Plan and Business Unit to enter a component.

SELECT A.ORG_PLAN_JPN , B.BUSINESS_UNIT , A.DESCR , B.DESCR FROM PS_IDO_ORGPLAN_JPN A , PS_BUS_UNIT_TBL_HR B WHERE B.ACTIVE_INACTIVE = 'A'

  • Related Language Record: IDO_HC_JPN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORG_PLAN_JPN Character(3) VARCHAR2(3) NOT NULL Tracks one possible view of the employees in a company.

    Prompt Table: IDO_ORGPLAN_JPN

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUSUNIT_HR_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2