RSFM_SUSRTREE_V

(SQL View)
Index Back

Trees by sales user

Trees by sales user. Used by Mobile Sales.

SELECT DISTINCT A.PERSON_ID , A.TREE_NAME , %subrec(RB_AUDIT_SBR, A) FROM PS_RSF_TR_TEAM A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RSF_TR_TEAM B WHERE A.TREE_NAME = B.TREE_NAME AND A.TERRITORY_ID = B.TERRITORY_ID AND A.PERSON_ID = B.PERSON_ID AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
4 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
7 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
8 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time