HRCD_MAP_NDAT_V(SQL View) |
Index Back |
---|---|
Co.Dir.-Fld Map Vw-Contct InfoCompany 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' |
# | 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 |