PERSON_IMCHT_VW

(SQL View)
Index Back

Person IM View

This view combines the PERSON_IMCHAT record with name information from the PERSON_NAME record

SELECT IM.EMPLID , IM.MCF_IM_PROTOCOL , IM.MCFIMDOMAIN , IM.MCF_IMUSERID , %Substring(NM.FIRST_NAME , 1 , 19) %Concat %Substring(NM.LAST_NAME , 1 , 20) %Concat '@' %Concat %Substring(IM.MCFIMDOMAIN , 1 , 10) , IM.PREF_CHATID_FLAG FROM PS_PERSON_IMCHAT 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

Prompt Table: PERSON_NAME

2 MCF_IM_PROTOCOL Character(50) VARCHAR2(50) NOT NULL IM Protocol
XMPP=XMPP

Prompt Table: PERSON_IM_SRVRS

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

Prompt Table: MCF_IM_XMPP_CFG

4 MCF_IMUSERID Character(200) VARCHAR2(200) NOT NULL UserID
5 MCF_IMUSERANDNET Character(150) VARCHAR2(150) NOT NULL User and Network
6 PREF_CHATID_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Chat Id Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N