SF_BU_SRVC_VW

(SQL View)
 Index Back

SF BU Student Srvc Indicators

Student Financials view joining the SRVC_IND_DATA, SERVICE_IMPACTand BUS_UNIT_TBL_SF tables. It is used to show a student's service indicator data by SF Business Unit.

SELECT C.BUSINESS_UNIT ,A.EMPLID ,B.SERVICE_IMPACT ,A.SRVC_IND_CD ,A.INSTITUTION ,A.SRVC_IND_ACT_TERM ,A.SRVC_IND_ACTIVE_DT ,A.SCC_SI_END_DT ,A.SCC_SI_END_TERM ,A.POS_SRVC_INDICATOR ,B.EFFDT FROM PS_SRVC_IND_DATA A , PS_SERVICE_IMPACT B , PS_BUS_UNIT_TBL_SF C , PS_SRVC_IND_CD_TBL D WHERE A.INSTITUTION=B.INSTITUTION AND A.INSTITUTION=C.INSTITUTION AND A.INSTITUTION=D.INSTITUTION AND A.SRVC_IND_CD=B.SRVC_IND_CD AND A.SRVC_IND_CD=D.SRVC_IND_CD 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 AND B1.TERM_CATEGORY = B.TERM_CATEGORY) AND D.EFFDT=( SELECT MAX(D1.EFFDT) FROM PS_SRVC_IND_CD_TBL D1 WHERE D1.INSTITUTION=D.INSTITUTION AND D1.SRVC_IND_CD=D.SRVC_IND_CD AND D1.EFFDT<=%CurrentDateIn) AND D.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact
4 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

6 SRVC_IND_ACT_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator Start 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 SCC_SI_END_TERM Character(4) VARCHAR2(4) NOT NULL Service Indicator End Term
10 POS_SRVC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Positive Service Indicator
11 EFFDT Date(10) DATE Effective Date

Default Value: %date