FO_JOBTITLE_VW

(SQL View)
 Index Back

Job Title Detail set-up table

Set-Up Record for Jobtitles.

SELECT JOB_CAT ,FO_JOBTITLE ,DESCR100 FROM PS_FO_JOBTITLE

  • Related Language Record: FO_JOBTITLE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOB_CAT Character(3) VARCHAR2(3) NOT NULL Job Category

    Prompt Table: FO_JOBTITLE_HDR

    2 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description