RIM_TSK_DENORM(SQL View) |
Index Back |
|---|---|
Task datamodel denormalizationThis view is denormalized version of Task data model and is used in RIM Blackberry module |
| SELECT A.TASK_ID , MAX(A.ROW_LASTMANT_DTTM) , MAX(B.ROW_LASTMANT_DTTM) , MAX(C.ROW_LASTMANT_DTTM) , MAX(D.ROW_LASTMANT_DTTM) FROM PS_RB_TSK A LEFT OUTER JOIN PS_RB_TSK_CNTCT B ON A.TASK_ID=B.TASK_ID LEFT OUTER JOIN PS_RB_TSK_NOTE C ON A.TASK_ID=C.TASK_ID LEFT OUTER JOIN PS_RB_TSK_ASGN D ON A.TASK_ID=D.TASK_ID GROUP BY A.TASK_ID |
| # | 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. |
| 2 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 3 | ROW_TCNTLASTM_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 4 | ROW_TNOTLASTM_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 5 | ROW_TASGLASTM_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |