LM_DM_FREQ_LVW

(SQL View)
 Index Back

Datamapping Frequency Lang


SELECT A.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDNAME='LM_OFRNG_FREQ' AND A.FIELDNAME=B.FIELDNAME AND A.EFFDT=B.EFFDT AND A.EFFDT IN ( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME='LM_OFRNG_FREQ') AND A.EFF_STATUS='A'

  • Related Language Record for LM_DM_FREQ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_DM_KEY_NAME Character(50) VARCHAR2(50) NOT NULL Data Mapping Key Name. This is what is shown in value mappings.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 HRS_DM_DESCR Character(254) VARCHAR2(254) NOT NULL Data Mapping Object Description