HRCD_FLDMAP_IDHRCD_SECTION_TYPENDAT=Org Chart - Node Attributes
PRCD=Profile - HR Details
PRCN=Profile - Contact Information
TSUM=General
HCTS_FIELDMAP_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 HRCD_FLDMAP_ID , HRCD_SECTION_TYPE , DESCR FROM PS_HRCD_SETUP_MAP WHERE HRCD_SECTION_TYPE = 'TSUM' AND 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |