SETIDCOMPANYIDDefault Value: NEXT
TASK_IDDefault Value: 999999999999
RB_TSK_COMPD_VW(SQL View) |
Index Back |
|---|---|
Tasks for a company View.Tasks for a company View. Used by Mobile Task Management. |
| SELECT DISTINCT CO.SETID , CO.COMPANYID , T.TASK_ID , TC.BO_ID_CUST , TC.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_CNTCT TC , PS_RD_COMPANY CO WHERE TC.BO_ID_CUST = CO.BO_ID AND T.TASK_ID = TC.TASK_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | COMPANYID |
Character(15) | VARCHAR2(15) NOT NULL |
Company ID
Default Value: NEXT |
| 3 | TASK_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
TaskIID field. Key for RB_TSK record. Used by Task Management.
Default Value: 999999999999 |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |