SF_ORG_SRVC_VW

(SQL View)
 Index Back

SF BU Corp Service Indicators

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

SELECT C.BUSINESS_UNIT ,A.EXT_ORG_ID ,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_SCC_SI_ORG 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 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org 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