SSR_HE_FSSCHEMEIDSSR_HE_FSOFFERIDSSR_HE_OFID_VW(SQL View) |
Index Back |
|---|---|
Offer ID viewOffer ID view |
| SELECT A.SSR_HE_FSSCHEMEID , A.SSR_HE_FSOFFERID FROM %Table(SSR_HE_FIN_SUP) A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM %Table(SSR_HE_FIN_SUP) B WHERE B.INSTITUTION=A.INSTITUTION AND B.SSR_HE_FSSCHEMEID=A.SSR_HE_FSSCHEMEID AND B.SSR_HE_FSOFFERID=A.SSR_HE_FSOFFERID AND B.EFFDT<=%CurrentDateTimeIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_HE_FSSCHEMEID |
Character(50) | VARCHAR2(50) NOT NULL | HESA Scheme ID |
| 2 | SSR_HE_FSOFFERID |
Character(50) | VARCHAR2(50) NOT NULL | HESA Offer ID |