RB_EM_ACTIVITY

(SQL Table)
 Index Back

Email activity

CRM ERMS table used to store emial activity information

# 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
3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: CTI_MENU_VW

4 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

Prompt Table: CTI_BAR_VW

5 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

Prompt Table: PSMENUITEM_VW2

6 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname

Prompt Table: PRCSPNLNAME_VW

7 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name

Prompt Table: PSRECDEFN

8 CREATE_NEW_BUTTON Character(1) VARCHAR2(1) NOT NULL Create New Button

Y/N Table Edit