RSFD_LE_RJCT_VW (SQL View)	Index Back
Lead Reject Reason Setup Table Set up table for Lead Reject Reasons

RSFD_LE_RJCT_VW

(SQL View)

Lead Reject Reason Setup Table

Set up table for Lead Reject Reasons

SELECT A.SETID , A.LEAD_REJECT_CD ,A.DESCR , A.STATUS , B.XLATSHORTNAME FROM PS_RSF_LE_RJCT_RSN A , PSXLATITEM B WHERE A.STATUS = B.FIELDVALUE AND B.FIELDNAME = 'STATUS' AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 LEAD_REJECT_CD Character(10) VARCHAR2(10) NOT NULL LEAD_REJECT_CD

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

5 STATUS_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display status category short description.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	LEAD_REJECT_CD	Character(10)	VARCHAR2(10) NOT NULL	LEAD_REJECT_CD
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
5	STATUS_CAT_SDESCR	Character(10)	VARCHAR2(10) NOT NULL	Used for contact center dashboard to display status category short description.