PIM_CAL_MYO_VW(SQL View) |
Index Back |
|---|---|
Calendar Items for My OppysThis view selects Calendar Items for My Oppys |
| SELECT DISTINCT TX.TASK_ID , OP.OPPORTUNITY_ID , T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , T.TIMEZONE , T.TASK_LOCATION , T.PERSON_ID_OWNER , TT.SHOW_IN_CAL_FLG , TT.PIM_OUTLOOK_TYPE , TT.PIM_NOTES_TYPE , OP.PERSON_ID ,%subrec(RB_AUDIT_SBR, T) FROM PS_RB_TSK T , PS_RB_TSK_TXN TX , PS_RSF_OPPORTUNITY OP , PS_RB_TSK_TYPE TT WHERE TX.REL_TXN_SYNCID = OP.SYNCID AND TX.RB_TRANSACTION_ID = 'OPPRT' AND TX.TXN_MARKET = 'GBL' AND T.TASK_ID = TX.TASK_ID AND T.TASK_TYPE = TT.TASK_TYPE AND TT.ACTIVE_FLG = 'Y' AND TT.APPLICATION_USAGE = 'ALL' AND TT.SHOW_IN_CAL_FLG <> '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 | OPPORTUNITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | 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 |
| 5 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN |
| 6 | TASK_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Task Priority indicator for Task. Used in Task Management.
Prompt Table: RB_TSK_PRTY_VW |
| 7 | START_DATE | Date(10) | DATE | Start Date |
| 8 | START_TIME | Time(15) | TIMESTAMP | Start Time |
| 9 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 10 | END_TIME | Time(15) | TIMESTAMP | End Time |
| 11 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table: PSTIMEZONE |
| 12 | TASK_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Task Location. Used by Task Management. |
| 13 | PERSON_ID_OWNER | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH |
| 14 | 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 |
| 15 | 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 |
| 16 | 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 |
| 17 | PERSON_ID_OPPY | Character(15) | VARCHAR2(15) NOT NULL | This field used to store person ID for the owner of an Opportunity |
| 18 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 19 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 20 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 21 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 22 | 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. |
| 23 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |