JOB_SUBFUNCLNVW

(SQL View)
 Index Back

Job Subfunction View Rel Lang

Related language data for Job Subfunction View

SELECT A.JOB_SUB_FUNC ,B.LANGUAGE_CD , B.DESCR FROM PS_JOB_SUBFUNC_TBL A ,PS_JOB_SUBFUNC_LNG B WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB_SUBFUNC_TBL A_ED WHERE A.JOB_SUB_FUNC = A_ED.JOB_SUB_FUNC) AND A.JOB_SUB_FUNC = B.JOB_SUB_FUNC AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_JOB_SUBFUNC_TBL B_ED WHERE B.JOB_SUB_FUNC = B_ED.JOB_SUB_FUNC)

  • Related Language Record for JOB_SUBFUNC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOB_SUB_FUNC Character(3) VARCHAR2(3) NOT NULL Job sub Function
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description