SDB_E_PROC_VW (SQL View)	Index Back
Email Process Status View Used to load xlat values and descriptions of PROCESS_STATE field to contact center dashboard.

SDB_E_PROC_VW

(SQL View)

Email Process Status View

Used to load xlat values and descriptions of PROCESS_STATE field to contact center dashboard.

SELECT A.FIELDVALUE , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'PROCESS_STATE' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_STATE Character(4) VARCHAR2(4) NOT NULL Process State for AE Processing
AUTO=Auto Responded by System
CREA=Email Instance Created
FORW=Mailbox Forwarding
PIMS=Synched Email
QUED=Queued for Routing
ROUT=Email Routed

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

3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_STATE	Character(4)	VARCHAR2(4) NOT NULL	Process State for AE Processing AUTO=Auto Responded by System CREA=Email Instance Created FORW=Mailbox Forwarding PIMS=Synched Email QUED=Queued for Routing ROUT=Email Routed
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
3	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name