RB_EW_PREF_ACTS (SQL Table)	Index Back
Email preference activity list Used to save the email preference activity list

RB_EW_PREF_ACTS

(SQL Table)

Email preference activity list

Used to save the email preference activity list

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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