SRVC_CD_TBL_VW

(SQL View)
 Index Back

Service Indicator Code VW

This 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 A.INSTITUTION , A.SRVC_IND_CD , B.SRVC_IND_REASON , B.DEPTID , A.DESCRSHORT , A.DESCR FROM PS_SRVC_IND_CD_TBL A , PS_SRVC_IN_RSN_TBL B WHERE B.INSTITUTION = A.INSTITUTION AND B.SRVC_IND_CD = A.SRVC_IND_CD AND B.EFFDT = A.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SRVC_IND_CD_TBL C WHERE C.INSTITUTION = A.INSTITUTION AND C.SRVC_IND_CD = A.SRVC_IND_CD AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: SRVCCDTBLVWLNG

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd
    3 DFLT_SRVC_IND_RSN Character(5) VARCHAR2(5) NOT NULL Default Reason

    Prompt Table: SRVC_IN_RSN_TBL

    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SRVC_IND_CD_TBL.DESCR

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description