FO_JOBTTL_LNGVW

(SQL View)
 Index Back

Job Title Detail set-up table

Set-Up Record for Jobtitles.

SELECT FO_JOBTITLE , JOB_CAT , LANGUAGE_CD , DESCR100 FROM PS_FO_JOBTITLE_LNG

  • Related Language Record for FO_JOBTITLE_VW2

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

    Prompt Table: FO_JOBTITLE_HDR

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description