HRCD_IM_CTC_VW (SQL View)	Index Back
Company Directory-User Cntacts User maintained Additional Content information

HRCD_IM_CTC_VW

(SQL View)

Company Directory-User Cntacts

User maintained Additional Content information

SELECT IM.EMPLID ,IM.HRCD_CNTCT_TYPE ,IM.HRCD_IM_PROTOCOL ,IM.HRCD_IM_DOMAIN ,IM.HRCD_IM_USERID , %Substring(NM.FIRST_NAME , 1 , 19) %Concat %Substring(NM.LAST_NAME , 1 , 20) %Concat '@' %Concat %Substring(IM.HRCD_IM_DOMAIN , 1 , 10) ,IM.LASTUPDOPRID ,IM.LASTUPDDTTM FROM PS_HRCD_USR_IM_CTC IM , PS_PERSON_NAME NM WHERE IM.EMPLID = NM.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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 MCF_IM_PROTOCOL Character(50) VARCHAR2(50) NOT NULL IM Protocol
XMPP=XMPP

4 MCFIMDOMAIN Character(50) VARCHAR2(50) NOT NULL Instant Messaging Domain

5 MCF_IMUSERID Character(200) VARCHAR2(200) NOT NULL UserID

6 MCF_IMUSERANDNET Character(150) VARCHAR2(150) NOT NULL User and Network

7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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	MCF_IM_PROTOCOL	Character(50)	VARCHAR2(50) NOT NULL	IM Protocol XMPP=XMPP
4	MCFIMDOMAIN	Character(50)	VARCHAR2(50) NOT NULL	Instant Messaging Domain
5	MCF_IMUSERID	Character(200)	VARCHAR2(200) NOT NULL	UserID
6	MCF_IMUSERANDNET	Character(150)	VARCHAR2(150) NOT NULL	User and Network
7	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.