TREE_NAMETERRITORY_IDEFFDTDefault Value: %date
PERSON_IDRSF_OP_AVAIL1VW(SQL View) |
Index Back |
|---|---|
Availability Subquery- OppRep Availability View for Opportunity. |
| SELECT A.TREE_NAME , A.TERRITORY_ID , A.EFFDT , A.PERSON_ID , COUNT(*) FROM PS_RSF_TR_TEAM A , PS_RSF_OP_STATUSVW B WHERE A.PERSON_ID = B.PERSON_ID (+) AND A.IS_SALES_REP = 'Y' GROUP BY A.TREE_NAME , A.TERRITORY_ID , A.EFFDT , A.PERSON_ID |
| # | 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 |
| 5 | AVAILABILITY_COUNT | Number(5,0) | INTEGER NOT NULL | Availability Count |