CS_ACT_TASK_VW (SQL View)	Index Back
Action Task Table View created for messaging email notifications to CS

CS_ACT_TASK_VW

(SQL View)

Action Task Table

View created for messaging email notifications to CS

SELECT RY_ACTION_ID , LABEL_TEXT , ROW_LASTMANT_DTTM FROM PS_RY_ACT_TASK WHERE RY_ACT_TYPE_ID = 1 OR RY_ACT_TYPE_ID = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.

2 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name

3 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RY_ACTION_ID	Number(18,0)	DECIMAL(18) NOT NULL	Id for a dialog element for the dialog designer.
2	LABEL_TEXT	Character(254)	VARCHAR2(254) NOT NULL	Activity Name
3	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.