PERSON_IDRB_TSK_DTS_VW(SQL View) |
Index Back |
|---|---|
Delegate ViewView for retrieving Tasks delegated to Sales Team from the Task Delegate record. |
| SELECT E.PERSON_ID , E.BO_ID , D.BO_NAME_DISPLAY , B.TEAM_ID , B.PERSON_ID , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_RSF_TEAM_MBRS B , PS_BO_NAME D , PS_RB_WORKER E WHERE A.TSK_DELEGATE_TYPE = 'S' AND A.TASK_LIST = 'DT' AND A.TSK_DELEGATE_ID = B.TEAM_ID AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn AND A.PERSON_ID = E.SUPERVISOR_ID AND E.EMPL_STATUS = 'A' AND D.BO_ID = E.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 4 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Sales Team ID |
| 5 | PERSON_ID_MBR | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 6 | READONLY | Character(1) | VARCHAR2(1) NOT NULL | Read Only |
| 7 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Copied from Resouce Management (8.1). Added new label id for "Task Type" |