HCTS_SETUP_COL2(SQL Table) |
Index Back |
---|---|
Co.Dir.-Profile-Contact InfoCompany 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. |