PIM_TSK_DLGP_VW(SQL View) |
Index Back |
---|---|
Tasks Delegated Provider GroupThis view shows all delegated tasks for a person as member of a Provider Group |
SELECT DISTINCT T.TASK_ID , T.TASK_STATUS , T.TASK_PRIORITY , T.DESCR60 , M.PERSON_ID , M.PERSON_ID , T.TASK_TYPE , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , TT.SHOW_IN_CAL_FLG , TT.PIM_OUTLOOK_TYPE , TT.PIM_NOTES_TYPE , 'N' , %subrec(RB_AUDIT_SBR, T) FROM PS_RB_TSK T , PS_RB_TSK_TYPE TT , PS_RB_TSK_DELEGATE DLG , PS_RF_GRP_MEMBER M WHERE DLG.TSK_DELEGATE_ID = M.PROVIDER_GRP_ID AND M.PROVIDER_GRP_ID = T.PROVIDER_GRP_ID AND M.SETID = T.SETID_PROV_GRP AND M.PERSON_ID <> DLG.PERSON_ID AND %DateOut(DLG.START_DT) <= %CurrentDateOut AND %DateOut(DLG.END_DT) >= %CurrentDateOut AND DLG.TSK_DELEGATE_TYPE = 'P' AND (DLG.TASK_TYPE = 'A11-ALL' OR DLG.TASK_TYPE = T.TASK_TYPE) AND T.TASK_TYPE = TT.TASK_TYPE AND TT.ACTIVE_FLG = 'Y' AND TT.SHOW_IN_CAL_FLG = 'N' AND T.PERSON_ID_OWNER = ' ' AND DLG.READONLY = 'N' AND T.TASK_STATUS NOT IN ('CNCL') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_ID | Number(15,0) | DECIMAL(15) NOT NULL |
TaskIID field. Key for RB_TSK record. Used by Task Management.
Default Value: 999999999999 |
2 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open |
3 | TASK_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL | Task Priority indicator for Task. Used in Task Management. |
4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
5 | PERSON_ID_ASSIGNEE | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH |
6 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
7 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Copied from Resouce Management (8.1). Added new label id for "Task Type"
Prompt Table: RB_TSK_TYPE |
8 | START_DATE | Date(10) | DATE | Start Date |
9 | START_TIME | Time(15) | TIMESTAMP | Start Time |
10 | END_DATE | Date(10) | DATE | End date field to store an end date. |
11 | END_TIME | Time(15) | TIMESTAMP | End Time |
12 | SHOW_IN_CAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if the Task should be shown in Calendar. Used by Task Management.
N=No Y=Yes Y/N Table Edit Default Value: Y |
13 | PIM_OUTLOOK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Outlook Integration mapping. Used by Task Management for PIM
A=Appointment C=Meeting E=All Day Event T=Task Default Value: T |
14 | PIM_NOTES_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Lotus Notes Integration mapping. Used by Task Management for PIM
A=Appointment E=All Day Event M=Meeting N=Anniversary R=Reminder T=To Do Default Value: T |
15 | OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Owner
N=No Y=Yes |
16 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
17 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
18 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
19 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
20 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
21 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |