PERSON_IDRB_TSK_DELEG_VW(SQL View) |
Index Back |
|---|---|
Delegate ViewView for retrieving Tasks delegated to Individual from the Task Delegate record. |
| SELECT A.PERSON_ID , B.BO_ID , A.TSK_DELEGATE_ID , B.BO_NAME_DISPLAY , A. READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_BO_NAME B , PS_RD_PERSON C WHERE A.PERSON_ID = C.PERSON_ID AND C.BO_ID = B.BO_ID AND A.TSK_DELEGATE_TYPE = 'I' AND A.TASK_LIST = 'MT' AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn UNION SELECT A.TASK_LIST , B.BO_ID , A.TSK_DELEGATE_ID , B.BO_NAME_DISPLAY , A. READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_BO_NAME B , PS_RD_PERSON C WHERE A.TASK_LIST = C.PERSON_ID AND C.BO_ID = B.BO_ID AND A.TSK_DELEGATE_TYPE = 'I' AND (A.TASK_LIST <> 'MT' OR A.TASK_LIST <> 'DT') AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn |
| # | 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 | TSK_DELEGATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Id of the Person or Group to whom the task is delegated. |
| 4 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 5 | READONLY | Character(1) | VARCHAR2(1) NOT NULL | Read Only |
| 6 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Copied from Resouce Management (8.1). Added new label id for "Task Type" |