SAD_UC_REJN_CDSAD_UC_REJSP_VW(SQL View) |
Index Back |
|---|---|
Apply decision rejection view |
| SELECT A.SAD_UC_REJN_CD , A.SAD_UC_REJECT_RSN FROM %Table(SAD_UC_APP_REJN) A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM %Table(SAD_UC_APP_REJN) A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.SAD_UC_REJN_CD=A.SAD_UC_REJN_CD AND A1.EFFDT<=%CurrentDateIn) AND A.EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_UC_REJN_CD |
Character(10) | VARCHAR2(10) NOT NULL | Rejection Code |
| 2 | SAD_UC_REJECT_RSN | Long Character(1330) | VARCHAR2(1330) | Field for DFE API |