HRCD_MAP_NDAT_V

(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.DESCR FROM PS_HRCD_SETUP_MAP 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' AND A.ACTIVE_INACTIVE = 'A'

  • Related Language Record: HRCD_MAP_NDATVL
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description