HCTS_SETUP_COL2

(SQL Table)
Index Back

Co.Dir.-Profile-Contact Info

Company Directory Setup This table contains the data elements displayed in the Company Directory on the Profile Tab in the Contact Information section.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRCD_FLDMAP_ID Character(10) VARCHAR2(10) NOT NULL Company Directory

Prompt Table: HCTS_FIELDMAP_V

2 HRCD_LINE_NBR Number(3,0) SMALLINT NOT NULL Line Number
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 EXPORT_FLG Character(1) VARCHAR2(1) NOT NULL This field is will indicate whether export is allowed or not.