RB_TSK_DEMON_VW

(SQL View)
 Index Back

View for Task Demon AE

View for Task Demon AE. Used by Task Management.

SELECT T.TASK_ID , TA.PERSON_ID_ASSIGNEE , T.TASK_STATUS , T.TASK_TYPE , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , TA.BO_ID_PERSON , TA.REMINDAT , TA.NOTIFY_STATUS , T.DESCR60 , TA.BO_ID_CONTACT , TA.ROLE_TYPE_ID_CNTCT , TA.BO_ID_CUST , TA.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA WHERE T.TASK_ID = TA.TASK_ID AND T.TASK_STATUS <> 'CNCL'

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open

Default Value: OPEN

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 START_DATE Date(10) DATE Start Date
6 START_TIME Time(15) TIMESTAMP Start Time
7 END_DATE Date(10) DATE End date field to store an end date.
8 END_TIME Time(15) TIMESTAMP End Time
9 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID
10 REMINDAT DateTime(26) TIMESTAMP Time Field. for reminder. Useb by Task Management.
11 NOTIFY_STATUS Number(4,0) SMALLINT NOT NULL Notify Status

Default Value: 0

12 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
13 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
14 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
15 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
16 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer