RSFD_TASKCR_VW(SQL View) |
Index Back |
|---|---|
Tasks for dashboardBasic call report task information including assignee and task source as used in sales dashboard. |
| SELECT DISTINCT T.PERSON_ID , T.TASK_ID , 0 , T.RB_TRANSACTION_ID , ' ' , ' ' , ' ' , CR.CALL_REPORT_ID , CU.BO_ID_CUST , CU.ROLE_TYPE_ID_CUST , T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , T.START_DATE , T.END_DATE , T.TASK_LOCATION , T.PERSON_ID_OWNER , T.APPLICATION_USAGE , T.ACT_TF_ANNUAL , T.ACT_TF_QTR , T.ROW_LASTMANT_DTTM , T.RSD_UPD_TF_ANN , T.RSD_UPD_TF_QTR , 'Y' FROM PS_RSFD_TSKBASE_VW T , PS_RD_CALL_REPORT CR , PS_RD_CALLRPT_CONT CU WHERE T.RB_TRANSACTION_ID = 'CALLREPORT' AND T.REL_TXN_SYNCID = CR.SYNCID AND CR.CALL_REPORT_ID =CU.CALL_REPORT_ID AND CU.ROLE_TYPE_ID_CUST IN (2, 9) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | TASK_ID |
Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
| 3 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | RB_TRANSACTION_ID | Character(25) | VARCHAR2(25) NOT NULL | Transaction ID |
| 5 | OPPORTUNITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 6 | LEAD_ID | Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 7 | RSP_UID20 | Character(20) | VARCHAR2(20) NOT NULL | This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER) |
| 8 | CALL_REPORT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Unique Identifier for Call Reports. |
| 9 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 10 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 11 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Task Subject |
| 12 | 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 |
| 13 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open |
| 14 | TASK_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL | Task Priority indicator for Task. Used in Task Management. |
| 15 | START_DATE | Date(10) | DATE | Start Date |
| 16 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 17 | TASK_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Task Location. Used by Task Management. |
| 18 | PERSON_ID_OWNER | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH |
| 19 | APPLICATION_USAGE | Character(4) | VARCHAR2(4) NOT NULL |
Application Usage. Holds the info about the application.
ALL=All Applications CHMG=Change Management EVNT=Marketing Events FLDS=Field Service HIED=Higher Education HLPD=HelpDesk HRHD=HR Helpdesk LEAD=Lead OPPY=Opportunity PIM=Personal Information Mgmt RSP=Strategic Planning SALS=Sales SUPP=Support |
| 20 | ACT_TF_ANNUAL | Character(32) | VARCHAR2(32) NOT NULL | Timeframe period used in dashboard for estimated close date range |
| 21 | ACT_TF_QTR | Character(32) | VARCHAR2(32) NOT NULL | Timeframe period used in dashboard for estimated close date range |
| 22 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 23 | RSD_UPD_TF_ANN | Character(32) | VARCHAR2(32) NOT NULL | Timeframe period used in dashboard for the annual period enclosing date when the record was updated. |
| 24 | RSD_UPD_TF_QTR | Character(32) | VARCHAR2(32) NOT NULL | Timeframe period used in dashboard for the quarterly period enclosing date when the record was updated. |
| 25 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |