EMPLIDSRVC_IND_DTTMDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
Default Value: %date
SCC_IMPACT1_VW(SQL View) |
Index Back |
|---|---|
Service Impact View by EmplidUsed by COBOL module |
| SELECT A.EMPLID , A.SRVC_IND_DTTM , A.INSTITUTION , A.SRVC_IND_CD , A.SRVC_IND_ACT_TERM , A.SCC_SI_END_TERM , A.SRVC_IND_ACTIVE_DT , A.SCC_SI_END_DT , A.POS_SRVC_INDICATOR , D.EFFDT , D.SERVICE_IMPACT , F.SCC_IMPACT_TERM , F.SCC_IMPACT_DATE , F.POS_SRVC_IMPACT FROM PS_SRVC_IND_DATA A ,PS_SERVICE_IMPACT D ,PS_SRVC_IND_CD_TBL E ,PS_SRVC_IMPACT_TBL F WHERE D.INSTITUTION = A.INSTITUTION AND D.SRVC_IND_CD = A.SRVC_IND_CD AND D.INSTITUTION=F.INSTITUTION AND D.INSTITUTION=E.INSTITUTION AND D.SRVC_IND_CD=E.SRVC_IND_CD AND D.EFFDT=E.EFFDT AND E.EFFDT=( SELECT MAX(E1.EFFDT) FROM PS_SRVC_IND_CD_TBL E1 WHERE E.INSTITUTION=E1.INSTITUTION AND E.SRVC_IND_CD=E1.SRVC_IND_CD AND E1.EFFDT <= %CurrentDateIn AND E1.EFF_STATUS='A') AND D.SERVICE_IMPACT=F.SERVICE_IMPACT AND F.EFFDT=( SELECT MAX(F1.EFFDT) FROM PS_SRVC_IMPACT_TBL F1 WHERE F.INSTITUTION=F1.INSTITUTION AND F.SERVICE_IMPACT=F1.SERVICE_IMPACT AND F1.EFFDT <= %CurrentDateIn AND F1.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SRVC_IND_DTTM |
DateTime(26) | TIMESTAMP | Service Indicator Date-Time field |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | SRVC_IND_CD | Character(3) | VARCHAR2(3) NOT NULL | Service Indicator Cd |
| 5 | SRVC_IND_ACT_TERM | Character(4) | VARCHAR2(4) NOT NULL | Service Indicator Start Term |
| 6 | SCC_SI_END_TERM | Character(4) | VARCHAR2(4) NOT NULL | Service Indicator End Term |
| 7 | SRVC_IND_ACTIVE_DT | Date(10) | DATE | Service Indicator Start Date |
| 8 | SCC_SI_END_DT | Date(10) | DATE | Service Indicator End Date |
| 9 | POS_SRVC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Positive Service Indicator |
| 10 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 11 | SERVICE_IMPACT | Character(5) | VARCHAR2(5) NOT NULL | Service Impact |
| 12 | SCC_IMPACT_TERM | Character(1) | VARCHAR2(1) NOT NULL | Service Indicator Impact attribute - Is this impact term based? |
| 13 | SCC_IMPACT_DATE | Character(1) | VARCHAR2(1) NOT NULL | Service Indicator Impact attribute - Is this impact date based? |
| 14 | POS_SRVC_IMPACT | Character(1) | VARCHAR2(1) NOT NULL | Positive Service Impact |