RB_TSK_TYPE_DSV (SQL View)	Index Back
Task Type View for Mobile DSR Task Type View for Mobile DSR. Used for Data Distribution rules in My Tasks.

RB_TSK_TYPE_DSV

(SQL View)

Task Type View for Mobile DSR

Task Type View for Mobile DSR. Used for Data Distribution rules in My Tasks.

SELECT T.TASK_TYPE , T.APPLICATION_USAGE , T.SYNCID , T.SYNCDTTM FROM PS_RB_TSK_TYPE T WHERE T.APPLICATION_USAGE IN ('ALL', 'SALS') AND ACTIVE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

2 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

3 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

4 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"
2	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
3	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
4	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time