SERVICE_IMPACTSRVC_IMP_DSB_VW(SQL View) |
Index Back |
|---|---|
Service Indicator Code View FAThis table maintains all service indicator codes. Its positive service indicator determines whether enhanced services are provided. It's child record, Service Impact, contains the services that are impacted. |
| SELECT DISTINCT A.SERVICE_IMPACT ,A.DESCR FROM PS_SRVC_IMPACT_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SRVC_IMPACT_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.SERVICE_IMPACT = B.SERVICE_IMPACT AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERVICE_IMPACT |
Character(5) | VARCHAR2(5) NOT NULL | Service Impact |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |