HR_TIERECFLD_VW

(SQL View)
 Index Back

Record/Fields

View to display all the fields of a record selected.

SELECT A.RECNAME , B.FIELDNAME , C.LONGNAME FROM PSRECFIELDALL A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME 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_SNR_DATE_TBL' AND B.FIELDNAME IN ('SENIORITY_DATE_ID')) )

  • Related Language Record: HR_TIEFLDVW_LNG

    • # 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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name