RYEQ_COMM_EXP

(SQL Table)
Index Back

Query Comm Expression

Online Marketing Design-Time Query Comm Expression

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_COMM_EXPRESS_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
2 RY_QUERY_SPEC_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
3 RY_TYPE Character(20) VARCHAR2(20) NOT NULL Field used by Online Marketing.
4 RY_CONDITION Number(19,0) DECIMAL(19) NOT NULL Field used by Online Marketing.
5 ORDER_INDEX Number(6,0) INTEGER NOT NULL ORDER_INDEX
6 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
7 RY_LIST_ID Number(18,0) DECIMAL(18) NOT NULL Audience ID for Dialogs, used in the dialog designer.
8 RY_CONNECT_BY Number(4,0) SMALLINT NOT NULL Field used by Online Marketing.
9 RY_VC_OBJ_ID Number(18,0) DECIMAL(18) NOT NULL Variable Content Object ID - Dialog Document