EMPLIDSRVC_IMP_SF_VW(SQL View) |
Index Back |
|---|---|
Stud Rec Srvc ImpactStudent Financials view joing the SRVC_IND_DATA and SERVICE_IMPACT tables. |
| SELECT A.EMPLID , A.INSTITUTION , B.SERVICE_IMPACT FROM PS_SRVC_IND_DATA A , PS_SERVICE_IMPACT B WHERE A.INSTITUTION=B.INSTITUTION AND A.SRVC_IND_CD=B.SRVC_IND_CD AND A.SRVC_IND_ACTIVE_DT <= %CurrentDateIn AND (A.SCC_SI_END_DT IS NULL OR A.SCC_SI_END_DT > %CurrentDateIn) AND B.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_SERVICE_IMPACT B1 WHERE B1.INSTITUTION=B.INSTITUTION AND B1.SRVC_IND_CD=B.SRVC_IND_CD AND B1.EFFDT<=%CurrentDateIn AND B1.SERVICE_IMPACT=B.SERVICE_IMPACT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SERVICE_IMPACT | Character(5) | VARCHAR2(5) NOT NULL | Service Impact |