HRCD_MAP_USED_V

(SQL View)
 Index Back

Field Map Used By View

Tests where a field map id is used in the system

SELECT HRCD_ORGVIEW_TYPE , 'NDAT' , HRCD_FLDMAP_ID FROM PS_HRCD_SETUP_NDAT UNION SELECT HRCD_ORGVIEW_TYPE , 'PRCN' , HRCD_FLDMAP_ID FROM PS_HRCD_SETUP_PRCN UNION SELECT HRCD_ORGVIEW_TYPE , 'PRCD' , HRCD_FLDMAP_ID FROM PS_HRCD_SETUP_PRCD UNION SELECT HRCD_ORGVIEW_TYPE , 'TSUM' , HRCD_FLDMAP_ID FROM PS_HCTS_SETUP_COL1 UNION SELECT HRCD_ORGVIEW_TYPE , 'TSUM' , HRCD_FLDMAP_ID FROM PS_HCTS_SETUP_COL2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
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_FLDMAP_ID Character(10) VARCHAR2(10) NOT NULL Company Directory

Prompt Table: HRCD_MAP_NDAT_V