RO_PROCESS_MAP (SQL Table)	Index Back
Mapping table Mapping table between Association Type and Event Name

RO_PROCESS_MAP

(SQL Table)

Mapping table

Mapping table between Association Type and Event Name

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

2 RO_PROCESS_TYPE Character(4) VARCHAR2(4) NOT NULL Field decribes the order process type like resume service, suspend service. It has translate values.
ACT=Activate
CHA=Change Service Attribute
CHG=Change Service
CNCL=Cancel Service
DIS=Disconnect Service
EDCH=Change End Date
NEW=New Service
PAC=PAC Code Request
PORT=Port In Request
RDCH=Change Resume Date
RES=Resume Service
RNW=Renew Service
SNC=Suspend/Change Service
SURE=Suspend / Resume Service
SUS=Suspend Service

3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order
2	RO_PROCESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Field decribes the order process type like resume service, suspend service. It has translate values. ACT=Activate CHA=Change Service Attribute CHG=Change Service CNCL=Cancel Service DIS=Disconnect Service EDCH=Change End Date NEW=New Service PAC=PAC Code Request PORT=Port In Request RDCH=Change Resume Date RES=Resume Service RNW=Renew Service SNC=Suspend/Change Service SURE=Suspend / Resume Service SUS=Suspend Service
3	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow