TREE_NAMETERRITORY_IDEFFDTDefault Value: %date
PERSON_IDPrompt Table: RSF_SUSER_A_VW
RSF_TR_RROBINVW(SQL View) |
Index Back |
|---|---|
Round Robin By Time ViewThis determines the rep who was assigned least number of times. |
| SELECT A.TREE_NAME , A.TERRITORY_ID , A.EFFDT , A.PERSON_ID , LAST_ASSIGNED_DATE FROM PS_RSF_TR_TEAM A WHERE A.IS_SALES_REP = 'Y' AND LAST_ASSIGNED_DATE = ( SELECT MIN(A1.LAST_ASSIGNED_DATE) FROM PS_RSF_TR_TEAM A1 WHERE A.TERRITORY_ID = A1.TERRITORY_ID AND A.TREE_NAME = A1.TREE_NAME AND A.EFFDT = A1.EFFDT) |
| # | 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 | LAST_ASSIGNED_DATE | DateTime(26) | TIMESTAMP | Last Assigned Date |