FALLOUT_RSN_CDA=Active
I=Inactive
RSFD_FALLOUT_VW(SQL View) |
Index Back |
|---|---|
Fallout reason for DashboardDashboard lookup view with fallout reason descriptor. |
| SELECT A.FALLOUT_RSN_CD ,A.DESCR , A.DESCR254 , A.STATUS , B.XLATSHORTNAME FROM PS_RSF_FALLOUT_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 | FALLOUT_RSN_CD |
Character(10) | VARCHAR2(10) NOT NULL | Fall Out Reason code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 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. |