EFFDTDefault Value: %date
R=Range
S=Single
RSF_ACC_PRD_VW(SQL View) |
Index Back |
|---|---|
Product AccessCRM Sales - Product Access View |
| SELECT T.EFFDT , P.PERSON_ID , T.TREE_NAME , T.TERRITORY_ID , C.BUSINESS_UNIT , T.CONFIG_CRITERIA_CD , C.CRITERIA_TYPE , T.CRITERIA_VALUE , T.FROM_CRIT_VALUE , T.TO_CRIT_VALUE FROM PS_RSF_TR_EFFDT E1 , PS_RSF_TR_CRIT_VAL T , PS_RSF_PRD_CRIT_VW C , PS_RSF_TR_TEAM P , PSTREENODE TR1 WHERE T.TREE_NAME = C.TREE_NAME AND T.TERRITORY_ID = C.TERRITORY_ID AND T.CONFIG_CRITERIA_CD = C.CONFIG_CRITERIA_CD AND T.TREE_NAME = P.TREE_NAME AND T.TERRITORY_ID = P.TERRITORY_ID AND T.EFFDT = P.EFFDT AND E1.TREE_NAME = T.TREE_NAME AND E1.TERRITORY_ID = T.TERRITORY_ID AND E1.EFFDT = T.EFFDT AND E1.EFFDT = ( SELECT MAX(E2.EFFDT) FROM PS_RSF_TR_EFFDT E2 WHERE E2.TREE_NAME = E1.TREE_NAME AND E2.TERRITORY_ID = E1.TERRITORY_ID AND E2.EFFDT <= %CurrentDateIn ) AND TR1.TREE_NAME = T.TREE_NAME AND TR1.TREE_NODE = T.TERRITORY_ID AND TR1.EFFDT = ( SELECT MAX(TR2.EFFDT) FROM PSTREEDEFN TR2 WHERE TR2.TREE_NAME = TR1.TREE_NAME AND TR2.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | TERRITORY_ID | Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | CONFIG_CRITERIA_CD | Character(10) | VARCHAR2(10) NOT NULL | Configurable Criteria Code |
| 7 | CRITERIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Criteria Type
R=Range S=Single |
| 8 | CRITERIA_VALUE | Character(50) | VARCHAR2(50) NOT NULL | A value for criteria code that will be used to match people with Service Orders or Call Center Cases. |
| 9 | FROM_CRIT_VALUE | Character(50) | VARCHAR2(50) NOT NULL | From Criteria Value |
| 10 | TO_CRIT_VALUE | Character(50) | VARCHAR2(50) NOT NULL | To Criteria Value |