RY_DV_GROUP_VW

(SQL View)
 Index Back

Prompt table view

For RY_DV_GROUPID field in RY_DV_GROUP rec

SELECT A.RY_DV_GROUPID , %Substring(B.MESSAGE_TEXT , 1, 30) FROM PS_RY_DV_GROUP A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_DV_GROUPID Number(3,0) SMALLINT NOT NULL Field used by Online Marketing.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description