PIM_CAL_DLGI_VW(SQL View) |
Index Back |
|---|---|
Tasks by DelegatedThis view shows all delegated tasks for a person. |
| SELECT DISTINCT T.TASK_ID , %Substring(DLG.TSK_DELEGATE_ID,1,15) , 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 , TA.OWNER , %subrec(RB_AUDIT_SBR, T) FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RB_TSK_TYPE TT , PS_RB_TSK_DELEGATE DLG WHERE DLG.PERSON_ID = TA.PERSON_ID_ASSIGNEE AND %DateOut(DLG.START_DT) <= %CurrentDateOut AND %DateOut(DLG.END_DT) >= %CurrentDateOut AND DLG.TSK_DELEGATE_TYPE = 'I' 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.TASK_ID = TA.TASK_ID AND TA.TASK_ASGN_STATUS <>'DCLN' AND DLG.READONLY = 'N' |
| # | 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 | PERSON_ID_ASSIGNEE | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH |
| 3 | 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 |
| 4 | START_DATE | Date(10) | DATE | Start Date |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start Time |
| 6 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 7 | END_TIME | Time(15) | TIMESTAMP | End Time |
| 8 | 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 |
| 9 | 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 |
| 10 | 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 |
| 11 | OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Owner
N=No Y=Yes |
| 12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 13 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 14 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 15 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 16 | 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. |
| 17 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |