| # |
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_MULT_JOBS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if Multiple Jobs information will be displayed for the Company Directory.
Y/N Table Edit
Default Value: N
|
| 3 |
HRCD_SHOW_MTRX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if Matrix Hierarchies will be displayed for an Org View.
Y/N Table Edit
Default Value: N
|
| 4 |
HRCD_LAYOUT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether Profile or Org Chart should be displayed first for the Company Directory.
O=Org Chart First
P=Profile First
Default Value: O
|
| 5 |
HRCD_START_PG_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
This field indicates what the Start Page Content will be when displaying Company Directory information.
ME=Show My Information
OT=Show Other Person's Info
SB=Search Box Only
UE=Show User's Information
Default Value: SB
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
HRCD_OTHEREMP_V
|
| 7 |
HRCD_OC_TO_XCL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if an Org Chart can be exported to Excel.
Y/N Table Edit
Default Value: N
|
| 8 |
HRCD_PR_TO_XCL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if a Profile can be exported to Excel.
Y/N Table Edit
Default Value: N
|
| 9 |
HRCD_OC_TO_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if an Org Chart can be exported to MS Visio.
Y/N Table Edit
Default Value: N
|
| 10 |
HRCD_PR_PHOTO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if a photo will be displayed for the Profile Content of the Company Directory.
Y/N Table Edit
Default Value: N
|
| 11 |
HRCD_N_PHOTO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if a photo will be displayed for the Org Chart Node of the Company Directory.
Y/N Table Edit
Default Value: N
|
| 12 |
HRCD_DFLT_IMG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if the default photo from the HR System Record will be displayed in the Company Directory.
Y/N Table Edit
Default Value: Y
|
| 13 |
HRCD_ADD_IMG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if an employee is allowed to upload his/her own image for the Company Directory.
Y/N Table Edit
Default Value: N
|
| 14 |
HRCD_MAX_IMG_SIZE |
Number(4,0) |
SMALLINT NOT NULL |
This field indicates the maximum image size (KB) that is allowed for a photo displayed in the Profile content of the Company Directory.
Default Value: 256
|
| 15 |
HRCD_IMAGE_HEIGHT |
Number(4,0) |
SMALLINT NOT NULL |
This field indicates the image height (pixels) that is allowed for a photo displayed in the Org Chart Node of the Company Directory.
Default Value: 50
|
| 16 |
HRCD_CNTCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if additional contact information will be displayed in the Company Directory.
Y/N Table Edit
Default Value: N
|
| 17 |
HRCD_PERS_STMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if the 'Personal Statement' section will be displayed in the Company Directory.
Y/N Table Edit
Default Value: N
|
| 18 |
HRCD_MY_LINKS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if the 'My Links' section will be displayed in the Company Directory.
Y/N Table Edit
Default Value: N
|
| 19 |
HRCD_SHOW_SIBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Peers of Focus Node
Y/N Table Edit
Default Value: Y
|
| 20 |
HRCD_MAX_CT_CNTCTS |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Additional Contacts
Default Value: 99
|
| 21 |
HRCD_MAX_CT_LINKS |
Number(2,0) |
SMALLINT NOT NULL |
Maximum User Links
Default Value: 99
|
| 22 |
HRCD_SHOW_LINK_ICN |
Character(1) |
VARCHAR2(1) NOT NULL |
Show My Links Shortcut Icon
Y/N Table Edit
Default Value: Y
|
| 23 |
HRCD_SHOW_EMAIL_DM |
Character(1) |
VARCHAR2(1) NOT NULL |
Company Directory
Y/N Table Edit
Default Value: Y
|
| 24 |
HRCD_IM_PR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if Instant Message Presence Icon will be displayed.
Y/N Table Edit
Default Value: N
|
| 25 |
HRCD_IM_PROTOCL_PR |
Character(50) |
VARCHAR2(50) NOT NULL |
This field stores the Instant Message Protocol value for the Profile Setup.
Prompt Table:
PERSON_IM_SRVRS
|
| 26 |
HRCD_IM_DOMAIN_PR |
Character(50) |
VARCHAR2(50) NOT NULL |
This field stores the Instant Message Domain value for the Profile setup.
Prompt Table:
HRCD_DOM_PR_VW
|
| 27 |
HRCD_IM_OC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if Instant Message Presence Icon will be displayed.
Y/N Table Edit
Default Value: N
|
| 28 |
HRCD_IM_PROTOCL_OC |
Character(50) |
VARCHAR2(50) NOT NULL |
This field stores the Instant Message Protocol value for the Org Chart Node Setup.
Prompt Table:
PERSON_IM_SRVRS
|
| 29 |
HRCD_IM_DOMAIN_OC |
Character(50) |
VARCHAR2(50) NOT NULL |
This field stores the Instant Message Domain value for the Org Chart Node setup.
Prompt Table:
HRCD_DOM_OC_VW
|
| 30 |
HRCD_EXP_THRESHOLD |
Number(3,0) |
SMALLINT NOT NULL |
This field stores the export threshold.
Default Value: 500
|
| 31 |
HRCD_SHOW_POSN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Empty Position Number
Y/N Table Edit
Default Value: N
|
| 32 |
HRCD_SHOW_PRONOUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Pronoun
Y/N Table Edit
Default Value: N
|
| 33 |
DISPLAYTIMEZONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Time Zone
Default Value: N
|
| 34 |
HR_RW_CONFIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Remote worker config flag
Default Value: N
|