HR_PG_POSDT_LVW

(SQL View)
Index Back

Related Lang-Position Data

POSN_DATA_LANG is the language record related to POSITION_DATA. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.POSITION_NBR ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR ,B.DESCRSHORT ,( SELECT DISTINCT(ACTRSN.DESCR) FROM PS_ACTN_RSN_LANG ACTRSN WHERE Actrsn.Action=A.Action AND ACTRSN.ACTION_REASON = A.ACTION_REASON AND ACTRSN.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACTN_RSN_LANG ACTRSN1 WHERE ACTRSN.ACTION = ACTRSN1.ACTION AND ACTRSN.ACTION_REASON = ACTRSN1.ACTION_REASON AND ACTRSN1.EFFDT <= %CurrentDateIn)) ACTION_REASN_DESCR ,( SELECT DISTINCT(COMP.DESCR) FROM PS_COMPNY_TBL_LANG COMP WHERE COMP.COMPANY=A.COMPANY AND COMP.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPNY_TBL_LANG COMP1 WHERE COMP.COMPANY = COMP1.COMPANY AND COMP1.EFFDT <= %CurrentDateIn)) COMPANY_DESCR ,( SELECT DISTINCT(DEPT.DESCR) FROM PS_DEPT_TBL_LANG DEPT WHERE DEPT.DEPTID=A.DEPTID AND DEPT.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND DEPT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEPT_TBL_LANG DEPT1 WHERE DEPT.DEPTID = DEPT1.DEPTID AND DEPT1.EFFDT <= %CurrentDateIn)) DEPT_DESCR ,( SELECT UT.DESCR FROM PS_UNION_TBL_LANG UT WHERE UT.UNION_CD = A.UNION_CD AND UT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_UNION_TBL_LANG UT1 WHERE UT.UNION_CD = UT1.UNION_CD AND UT.EFFDT <= %CurrentDateIn) ) UNION_CODE_DESCR ,( SELECT DISTINCT(LOC.DESCR) FROM PS_LOCATION_LANG LOC WHERE LOC.LOCATION=A.LOCATION AND LOC.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND LOC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LOCATION_LANG LOC1 WHERE LOC.LOCATION = LOC1.LOCATION AND LOC1.EFFDT <= %CurrentDateIn)) Location_Descr, ( SELECT DISTINCT(JOBCD.DESCR) FROM PS_JOBCODE_LANG JOBCD WHERE JOBCD.JOBCODE=A.JOBCODE AND JOBCD.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND JOBCD.EFFDT = ( SELECT MAX(JOBCD1.EFFDT) FROM PS_JOBCODE_LANG JOBCD1 WHERE JOBCD.JOBCODE = JOBCD1.JOBCODE AND JOBCD1.EFFDT <= %CurrentDateIn)) JOBCODE_DESCR FROM PS_POSITION_DATA A, PS_POSN_DATA_LANG B WHERE A.EFFDT = ( SELECT MAX(C.EffDt) FROM PS_POSN_DATA_LANG C WHERE C.Position_Nbr = A.Position_Nbr AND C.Effdt <= %CurrentDateIn) AND A.Position_Nbr = B.Position_Nbr AND A.EFFDT = B.EFFDT

  • Related Language Record for HR_PG_POS_DT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 0

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 ACTION_REASN_DESCR Character(50) VARCHAR2(50) NOT NULL Action Reason Description
    7 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    8 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    9 UNION_CODE_DESCR Character(50) VARCHAR2(50) NOT NULL Description of length 50
    10 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    11 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description