RB_EW_ACT_VW

(SQL View)
 Index Back

Email user preference view

Used to retrieve all enabled transaction type

SELECT SYSTEM_ID ,EMAIL_ACTIVITY_TYP FROM PS_RB_EM_ACT_DEFN WHERE ENABLE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYSTEM_ID Character(5) VARCHAR2(5) NOT NULL System ID

Default Value: CRM

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