RSF_TR_REA_SRCH(SQL View) |
Index Back |
|---|---|
Search Reassignments ViewSearch leads, opportunities and account reassignments view |
| SELECT REASSIGN_ID , REASSIGN_DATE , TREE_NAME , TREE_EFFDT , FROM_USER , TO_TREE , TO_USER , FROM_TERRITORY , TO_TERRITORY , DESCR100 , REASSIGN_OPTION , REASSIGN_STATUS FROM PS_RSF_TR_REASSIGN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REASSIGN_ID | Character(15) | VARCHAR2(15) NOT NULL |
Reassignment ID
Default Value: NEXT |
| 2 | REASSIGN_DATE | Date(10) | DATE |
Reassignment Date
Default Value: %date |
| 3 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Default Value: RSF_OPR_DEF_VW.TREE_NAME Prompt Table: RSF_OPR_TREE_VW |
| 4 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 5 | FROM_USER | Character(15) | VARCHAR2(15) NOT NULL |
Current Owner
Prompt Table: RSF_ACC_FROM_VW |
| 6 | TO_TREE | Character(18) | VARCHAR2(18) NOT NULL |
New Tree Name
Default Value: RSF_TR_REASSIGN.TREE_NAME Prompt Table: RSF_OPR_TREE_VW |
| 7 | TO_USER | Character(15) | VARCHAR2(15) NOT NULL |
New Sales Rep
Prompt Table: RSF_ACC_TO_VW |
| 8 | FROM_TERRITORY | Character(20) | VARCHAR2(20) NOT NULL | Current Territory |
| 9 | TO_TERRITORY | Character(20) | VARCHAR2(20) NOT NULL | New Territory |
| 10 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 11 | REASSIGN_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
Reassign Option
LOA=Leads, Opportunities, Accounts LOX=Leads, Opportunities LXX=Leads XOX=Opportunities XXA=Accounts |
| 12 | REASSIGN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reassigment Status.
I=In Progress N=New P=Processing R=Reviewed S=Submitted Default Value: I |