RYEACT_TYPE_VW (SQL View)	Index Back
Action Type Used to get the different options in the element types.

RYEACT_TYPE_VW

(SQL View)

Action Type

Used to get the different options in the element types.

SELECT A.RY_ACT_TYPE_ID , A.RY_ACT_TYPE , A.RY_ACT_LABEL , A.RY_IS_EXTERNAL , B.RY_ICON_NAME FROM PS_RY_ACT_TYPE A , PS_RYEACT_OPTIONS B WHERE A.RY_ACT_TYPE_ID = B.RY_ACT_TYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RY_ACT_TYPE_ID Number(18,0) DECIMAL(18) NOT NULL Used to determine the type of Element for the Dialog.

2 RY_ACT_TYPE Character(30) VARCHAR2(30) NOT NULL Used to determine an elements type.

3 RY_ACT_LABEL Character(80) VARCHAR2(80) NOT NULL Used to store an element Types label.

4 RY_IS_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Use to know if an object is meant for external usage.

5 RY_ICON_NAME Character(80) VARCHAR2(80) NOT NULL Icon Image name field for Various Elements.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RY_ACT_TYPE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Used to determine the type of Element for the Dialog.
2	RY_ACT_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Used to determine an elements type.
3	RY_ACT_LABEL	Character(80)	VARCHAR2(80) NOT NULL	Used to store an element Types label.
4	RY_IS_EXTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Use to know if an object is meant for external usage.
5	RY_ICON_NAME	Character(80)	VARCHAR2(80) NOT NULL	Icon Image name field for Various Elements.