RB_TSK_SETUP_VW(SQL View) |
Index Back |
|---|---|
contact management reportcontact management report view for setup page |
| SELECT T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.START_DATE , T.END_DATE , T.PERSON_ID_OWNER FROM PS_RB_TSK T , PS_RB_TASK_TYPE TT , PS_RB_TASK_STAT S , PS_RB_TASK_RANGE R WHERE T.TASK_TYPE = TT.TASK_TYPE AND T.TASK_STATUS = S.TASK_STATUS AND S.PERSON_ID = T.PERSON_ID_OWNER AND TT.PERSON_ID = T.PERSON_ID_OWNER AND (T.START_DATE > R.START_DATE AND T.END_DATE < R.END_DATE) AND R.PERSON_ID = T.PERSON_ID_OWNER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 2 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Copied from Resouce Management (8.1). Added new label id for "Task Type" |
| 3 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 6 | PERSON_ID_OWNER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |