RB_TSK_DELEP_VW

(SQL View)
 Index Back

Delegate View

View for retrieving Tasks delegated to Provider Group from the Task Delegate record.

SELECT A.PERSON_ID , C.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_RD_PERSON C , PS_BO_NAME D WHERE A.TSK_DELEGATE_TYPE = 'P' AND A.TASK_LIST = 'MT' AND A.SETID = B.SETID AND A.TSK_DELEGATE_ID = B.PROVIDER_GRP_ID AND B.STATUS = 'A' AND C.PERSON_ID = A.PERSON_ID AND D.BO_ID = C.BO_ID AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn UNION SELECT A.TASK_LIST , C.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_RD_PERSON C , PS_BO_NAME D WHERE A.TSK_DELEGATE_TYPE = 'P' AND (A.TASK_LIST <> 'MT' OR A.TASK_LIST <> 'DT') AND A.SETID = B.SETID AND A.TSK_DELEGATE_ID = B.PROVIDER_GRP_ID AND B.STATUS = 'A' AND C.PERSON_ID = A.TASK_LIST AND D.BO_ID = C.BO_ID 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 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"