HR_TIEFLDVW_LNG

(SQL View)
 Index Back

Record/Fields - Rel. Lang.

Related Language Record for HR_TIERECFLD_VW.

SELECT A.RECNAME , B.FIELDNAME , D.LANGUAGE_CD , C.LONGNAME FROM PSRECFIELDALL A , PSDBFIELD B , PSDBFLDLABL C , PSDBFLDLABLLANG D WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND D.FIELDNAME = B.FIELDNAME AND C.LABEL_ID = D.LABEL_ID AND C.DEFAULT_LABEL =1 AND ( (A.RECNAME = 'JOB' AND B.FIELDNAME IN ('BUSINESS_UNIT', 'COMPANY', 'DEPTID', 'EMPL_CLASS', 'EMPL_TYPE', 'FTE', 'FULL_PART_TIME', 'JOBCODE', 'LOCATION', 'REG_TEMP', 'SHIFT', 'STD_HOURS', 'UNION_CD')) OR (A.RECNAME = 'ADDRESS_SBR') OR (A.RECNAME = 'EMPLOYEES' AND B.FIELDNAME IN ('JOB_FAMILY', 'MILITARY_STATUS')) OR (A.RECNAME = 'PERSON' AND B.FIELDNAME IN ('BIRTHDATE')) OR (A.RECNAME = 'PERS_NID' AND B.FIELDNAME IN ('NATIONAL_ID')) OR (A.RECNAME = 'PERS_DATA_EFFDT' AND B.FIELDNAME IN ('LANG_CD', 'MAR_STATUS', 'SEX')) OR (A.RECNAME = 'COMPETENCIES' AND B.FIELDNAME IN ('YEARS_OF_EXP')) OR (A.RECNAME = 'NAMES' AND B.FIELDNAME IN ('FIRST_NAME', 'LAST_NAME')) OR (A.RECNAME = 'HR_SEN_DATE_TBL' AND B.FIELDNAME IN ('SENIORITY_DATE_ID')) OR (A.RECNAME = 'HR_TIEBRK_MAINT' AND B.FIELDNAME IN ('TIEBREAK_FREE_FORM')) )

  • Related Language Record for HR_TIERECFLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name