SPB_TEAM_STR_VW (SQL View)	Index Back
Team By Region/Service Type Vw This view fetches the Setid, Region code, description, Service type and its descption

SPB_TEAM_STR_VW

(SQL View)

Team By Region/Service Type Vw

This view fetches the Setid, Region code, description, Service type and its descption

SELECT A.BUSINESS_UNIT ,B.DESCR , A.REGION_CD , R.DESCR FROM PS_SPB_TEAM_STREG A ,PS_BUS_UNIT_TBL_FS B , PS_REGION_CD R , PS_SET_CNTRL_GROUP G WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND G.SETID = R.SETID AND G.SETCNTRLVALUE = A.BUSINESS_UNIT AND G.REC_GROUP_ID = 'FS_38' AND A.REGION_CD = R.REGION_CD AND %EffdtCheck(REGION_CD, R, %CURRENTDATEIN) AND R.REGION_CD_TYPE = 'SPRS' AND R.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW

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

3 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: SPB_REGIONCD_VW
Set Control Field: SETID

4 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: SPB_REGIONCD_VW Set Control Field: SETID
4	DESCR_2	Character(30)	VARCHAR2(30) NOT NULL	Description