PERSON_IDRB_TSK_DTP_VW(SQL View) |
Index Back |
|---|---|
Delegate ViewView for retrieving Tasks delegated to Provider Group from the Task Delegate record. |
| SELECT E.PERSON_ID , E.BO_ID , D.BO_NAME_DISPLAY , B.SETID , B.PROVIDER_GRP_ID , B.PERSON_ID , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_RF_GRP_MEMBER B , PS_BO_NAME D , PS_RB_WORKER E WHERE A.TSK_DELEGATE_TYPE = 'P' AND A.TASK_LIST = 'DT' AND A.SETID = B.SETID AND A.TSK_DELEGATE_ID = B.PROVIDER_GRP_ID AND B.STATUS = 'A' 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 5 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 6 | PERSON_ID_MBR | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 7 | READONLY | Character(1) | VARCHAR2(1) NOT NULL | Read Only |
| 8 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Copied from Resouce Management (8.1). Added new label id for "Task Type" |