SRVC_IMPACT_VW5

(SQL View)
 Index Back

Service Impact

This record indicates the services that a Service Indicator Code impacts irrespective of the Code's Effective Status

SELECT A.INSTITUTION ,A.SRVC_IND_CD ,A.EFFDT ,A.SERVICE_IMPACT ,A.TERM_CATEGORY ,C.SCC_IMPACT_TERM ,C.SCC_IMPACT_DATE ,C.DESCR ,A.DESCRLONG FROM PS_SERVICE_IMPACT A ,PS_SRVC_IND_CD_TBL B ,PS_SRVC_IMPACT_TBL C WHERE A.INSTITUTION=C.INSTITUTION AND A.INSTITUTION=B.INSTITUTION AND A.SRVC_IND_CD=B.SRVC_IND_CD AND A.EFFDT=B.EFFDT AND B.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_SRVC_IND_CD_TBL B1 WHERE B.INSTITUTION=B1.INSTITUTION AND B.SRVC_IND_CD=B1.SRVC_IND_CD AND B1.EFFDT <= %CurrentDateIn) AND A.SERVICE_IMPACT=C.SERVICE_IMPACT AND C.EFFDT=( SELECT MAX(C1.EFFDT) FROM PS_SRVC_IMPACT_TBL C1 WHERE C.INSTITUTION=C1.INSTITUTION AND C.SERVICE_IMPACT=C1.SERVICE_IMPACT AND C1.EFFDT <= %CurrentDateIn AND C1.EFF_STATUS = 'A')

  • Related Language Record: SERVICE_IMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

    Prompt Table: SRVC_IND_CD_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

    Prompt Table: %EDITTABLE

    5 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term
    6 SCC_IMPACT_TERM Character(1) VARCHAR2(1) NOT NULL Service Indicator Impact attribute - Is this impact term based?
    7 SCC_IMPACT_DATE Character(1) VARCHAR2(1) NOT NULL Service Indicator Impact attribute - Is this impact date based?
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DESCRLONG Long Character CLOB Long Description