HRCD_MAP_NDATVL

(SQL View)
 Index Back

Co.Dir.-Fld Map Vw-Contct Info

Company Directory Setup Prompt view for active Contact Information section data elements.

SELECT DISTINCT A.HRCD_FLDMAP_ID , A.HRCD_SECTION_TYPE , B.HRCD_ORGVIEW_TYPE ,A.LANGUAGE_CD , A.DESCR FROM PS_HRCD_SETMAP_LNG A , PS_HRCD_FLDMAP_ORG B WHERE A.HRCD_FLDMAP_ID = B.HRCD_FLDMAP_ID AND A.HRCD_SECTION_TYPE = B.HRCD_SECTION_TYPE AND A.HRCD_SECTION_TYPE = 'NDAT'

  • Related Language Record for HRCD_MAP_NDAT_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRCD_FLDMAP_ID Character(10) VARCHAR2(10) NOT NULL Company Directory
    2 HRCD_SECTION_TYPE Character(4) VARCHAR2(4) NOT NULL Company Directory Setup
    NDAT=Org Chart - Node Attributes
    PRCD=Profile - HR Details
    PRCN=Profile - Contact Information
    TSUM=General
    3 HRCD_ORGVIEW_TYPE Character(4) VARCHAR2(4) NOT NULL This field stores the Org View Type.
    CDFL=Company Directory Fluid
    CDOV=Company Directory
    MGSS=Direct-Line Reports
    MTRX=Matrix Reports
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description