PERSONNEL_LNG

(SQL View)
 Index Back

Rel Lang for PERSONNEL

Related Language Record for PERSONNEL.

SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.EFFSEQ ,L.LANGUAGE_CD , COALESCE (( SELECT NL.NAME FROM PS_PERSON_NAME_LNG NL WHERE NL.EMPLID = J.EMPLID AND NL.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT N.NAME FROM PS_PERSON_NAME N WHERE N.EMPLID = J.EMPLID), ' ') , COALESCE(( SELECT JCL.DESCR FROM PS_JOBCODE_LANG JCL WHERE JCL.SETID = J.SETID_JOBCODE AND JCL.JOBCODE = J.JOBCODE AND JCL.LANGUAGE_CD = L.LANGUAGE_CD AND JCL.EFFDT = ( SELECT MAX(JCL1.EFFDT) FROM PS_JOBCODE_LANG JCL1 WHERE JCL1.SETID = JCL.SETID AND JCL1.JOBCODE = JCL.JOBCODE AND JCL1.EFFDT <= J.EFFDT)), ( SELECT JC.DESCR FROM PS_JOBCODE_TBL JC WHERE JC.SETID = J.SETID_JOBCODE AND JC.JOBCODE = J.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.SETID = JC.SETID AND JC1.JOBCODE = JC.JOBCODE AND JC1.EFFDT <= J.EFFDT)), ' ') , COALESCE(( SELECT JCL.DESCRSHORT FROM PS_JOBCODE_LANG JCL WHERE JCL.SETID = J.SETID_JOBCODE AND JCL.JOBCODE = J.JOBCODE AND JCL.LANGUAGE_CD = L.LANGUAGE_CD AND JCL.EFFDT = ( SELECT MAX(JCL1.EFFDT) FROM PS_JOBCODE_LANG JCL1 WHERE JCL1.SETID = JCL.SETID AND JCL1.JOBCODE = JCL.JOBCODE AND JCL1.EFFDT <= J.EFFDT)), ( SELECT JC.DESCRSHORT FROM PS_JOBCODE_TBL JC WHERE JC.SETID = J.SETID_JOBCODE AND JC.JOBCODE = J.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.SETID = JC.SETID AND JC1.JOBCODE = JC.JOBCODE AND JC1.EFFDT <= J.EFFDT)), ' ') , COALESCE(( SELECT DL.DESCR FROM PS_DEPT_TBL_LANG DL WHERE DL.SETID = J.SETID_DEPT AND DL.DEPTID = J.DEPTID AND DL.LANGUAGE_CD = L.LANGUAGE_CD AND DL.EFFDT = ( SELECT MAX(DL1.EFFDT) FROM PS_DEPT_TBL_LANG DL1 WHERE DL1.SETID = DL.SETID AND DL1.DEPTID = DL.DEPTID AND DL1.EFFDT <= J.EFFDT)), ( SELECT D.DESCR FROM PS_DEPT_TBL D WHERE D.SETID = J.SETID_DEPT AND D.DEPTID = J.DEPTID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D1.SETID = D.SETID AND D1.DEPTID = D.DEPTID AND D1.EFFDT <= J.EFFDT)), ' ') , COALESCE(( SELECT DL.DESCRSHORT FROM PS_DEPT_TBL_LANG DL WHERE DL.SETID = J.SETID_DEPT AND DL.DEPTID = J.DEPTID AND DL.LANGUAGE_CD = L.LANGUAGE_CD AND DL.EFFDT = ( SELECT MAX(DL1.EFFDT) FROM PS_DEPT_TBL_LANG DL1 WHERE DL1.SETID = DL.SETID AND DL1.DEPTID = DL.DEPTID AND DL1.EFFDT <= J.EFFDT)), ( SELECT D.DESCRSHORT FROM PS_DEPT_TBL D WHERE D.SETID = J.SETID_DEPT AND D.DEPTID = J.DEPTID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D1.SETID = D.SETID AND D1.DEPTID = D.DEPTID AND D1.EFFDT <= J.EFFDT)), ' ') FROM PS_JOB J , PSLANGUAGES L WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O)

  • Related Language Record for PERSONNEL PERSONNEL_HIST

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    8 JOBTITLE_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    9 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    10 DEPTNAME_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name