RB_MBOX_ACT_VW (SQL View)	Index Back
Mail box activity CRM ERMS view about mail box activity

RB_MBOX_ACT_VW

(SQL View)

Mail box activity

CRM ERMS view about mail box activity

SELECT MAILBOX_ID ,EMAIL_ACTIVITY_TYP ,XLATLONGNAME FROM PS_RB_MBOX_ACTIVTY B ,PSXLATITEM A WHERE A.FIELDNAME='EMAIL_ACTIVITY_TYP' AND A.FIELDVALUE=B.EMAIL_ACTIVITY_TYP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes

2 EMAIL_ACTIVITY_TYP Character(4) VARCHAR2(4) NOT NULL Synched Email LinkType
CMCS=Support Case (COM)
CMPG=Campaign
EMAL=Emails
ENCS=Support Case (ENE)
ERRO=Unregistered Transaction
GBCS=Support Case
GVCS=Support Case (GOV)
HDCS=HelpDesk Case
HDER=HelpDesk Employee Relations
HECS=Higher Education Case
HRCS=HelpDesk Case (HR)
INCS=Support Case (INS)
ISSU=Issue
LEAD=Lead
OFPA=Product Application
OPPR=Opportunity
ORDR=Order
QINS=Quote (Insurance)
QUOT=Quote
SPSV=Stop Service
STSV=Start Service
SVMG=Service Management
SVOR=Service Order
TRSV=Transfer Service

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MAILBOX_ID	Character(30)	VARCHAR2(30) NOT NULL	Mail Box Id is an Id associated with Mail Boxes
2	EMAIL_ACTIVITY_TYP	Character(4)	VARCHAR2(4) NOT NULL	Synched Email LinkType CMCS=Support Case (COM) CMPG=Campaign EMAL=Emails ENCS=Support Case (ENE) ERRO=Unregistered Transaction GBCS=Support Case GVCS=Support Case (GOV) HDCS=HelpDesk Case HDER=HelpDesk Employee Relations HECS=Higher Education Case HRCS=HelpDesk Case (HR) INCS=Support Case (INS) ISSU=Issue LEAD=Lead OFPA=Product Application OPPR=Opportunity ORDR=Order QINS=Quote (Insurance) QUOT=Quote SPSV=Stop Service STSV=Start Service SVMG=Service Management SVOR=Service Order TRSV=Transfer Service
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name