SDB_RESP_IND_VW (SQL View)	Index Back
SLA Response Indicator View Used to load xlat values and descriptions of RC_RESP_IND field to contact center dashboard.

SDB_RESP_IND_VW

(SQL View)

SLA Response Indicator View

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

SELECT A.FIELDVALUE , A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'RC_RESP_IND' 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 RC_RESP_IND Character(4) VARCHAR2(4) NOT NULL Response Indicator, to indicate different stage of response for SLA.
A=Pending
N=Late
NA=Not Applicable
Y=On-Time

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RC_RESP_IND	Character(4)	VARCHAR2(4) NOT NULL	Response Indicator, to indicate different stage of response for SLA. A=Pending N=Late NA=Not Applicable Y=On-Time
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name