TREE_NAMETERRITORY_IDEFFDTDefault Value: %date
PERSON_IDRSF_OP_AVAIL_VW(SQL View) |
Index Back |
|---|---|
Availability For OpportunityRep Availability View for Opportunity. |
| SELECT A.TREE_NAME , A.TERRITORY_ID , A.EFFDT ,A.PERSON_ID ,A.AVAILABILITY_COUNT FROM PS_RSF_OP_AVAIL1VW A WHERE A.AVAILABILITY_COUNT = ( SELECT MIN(A2.AVAILABILITY_COUNT) FROM PS_RSF_OP_AVAIL1VW A2 WHERE A2.TREE_NAME = A.TREE_NAME AND A2.TERRITORY_ID = A.TERRITORY_ID AND A2.EFFDT = A.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 |
| 5 | AVAILABILITY_COUNT | Number(5,0) | INTEGER NOT NULL | Availability Count |