HRS_JOBCATUSLV2

(SQL View)
 Index Back

Job Category config

SQL for the sorable image column key as priority.

SELECT A.OPRID , A.HRS_JOBCAT_ID , B.LANGUAGE_CD , B.DESCR FROM PS_HRS_JOBCAT_USER A , PS_HRS_JOBCAT_ULNG B WHERE B.OPRID = A.OPRID AND B.HRS_JOBCAT_ID = A.HRS_JOBCAT_ID AND A.STATUS = 'A'

  • Related Language Record for HRS_JOBCATUSRV2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 HRS_JOBCAT_ID Character(4) VARCHAR2(4) NOT NULL Job Categoriation Id
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description