HRCD_CNT_IM_VW (SQL View)	Index Back
Co.Dir.-Addtl IM Cntct Types Used to populate the Instant Message drop down that the users see in the Additional Contacts area of Company Directory.

HRCD_CNT_IM_VW

(SQL View)

Co.Dir.-Addtl IM Cntct Types

Used to populate the Instant Message drop down that the users see in the Additional Contacts area of Company Directory.

SELECT A.HRCD_IM_PROTOCOL , A.HRCD_CNTCT_TYPE , %Substring(B.DESCR50 , 1 , 20) FROM PS_HRCD_SETUP_CNTC A , PS_PERSON_IM_SRVRS B WHERE A.HRCD_IM_PROTOCOL = B.MCF_IM_PROTOCOL AND A.HRCD_SELECT_FLG = 'Y' AND A.HRCD_CNTCT_FMT = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRCD_IM_PROTOCOL 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

2 HRCD_CNTCT_TYPE Character(4) VARCHAR2(4) NOT NULL This field contains the Contact Type that will be displayed in the Company Directory.
EMOT=Other Email
EMPE=Personal Email
IMGT=Instant Msg GTALK
IMMS=Instant Msg MSN
IMXP=Instant Msg XMPP
IMYH=Instant Msg YAHOO
PHHM=Home Phone
PHHO=Home Office Phone
PHMO=Mobile Phone
PHOT=Other Phone
USER=Other
ZZZZ=Admin-Defined

3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRCD_IM_PROTOCOL	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
2	HRCD_CNTCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field contains the Contact Type that will be displayed in the Company Directory. EMOT=Other Email EMPE=Personal Email IMGT=Instant Msg GTALK IMMS=Instant Msg MSN IMXP=Instant Msg XMPP IMYH=Instant Msg YAHOO PHHM=Home Phone PHHO=Home Office Phone PHMO=Mobile Phone PHOT=Other Phone USER=Other ZZZZ=Admin-Defined
3	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description