RSF_TR_TEAM_VW

(SQL View)
Index Back

Territory Mgt. - Sales Team

Territory Management - Sales Team.

SELECT TREE_NAME ,TERRITORY_ID ,EFFDT ,PERSON_ID ,PRIMARY_USER FROM PS_RSF_TR_TEAM TR WHERE TR.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_RSF_TR_TEAM Y WHERE Y.TREE_NAME = TR.TREE_NAME AND Y.TERRITORY_ID = TR.TERRITORY_ID AND Y.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
2 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER_A_VW

5 PRIMARY_USER Character(1) VARCHAR2(1) NOT NULL Primary Sales User

Y/N Table Edit

Default Value: N