RY_DIALOG (SQL Table)	Index Back
Dialog Table Dialog Designer main record used for live dialogs.

RY_DIALOG

(SQL Table)

Dialog Table

Dialog Designer main record used for live dialogs.

Related Language Record: RY_DLG_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

2 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

3 RY_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.

4 RYE_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Design Time Status for dialogs.

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

6 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

7 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

9 IS_STAGING Character(1) VARCHAR2(1) NOT NULL Staging Dialog
N=No
Y=Yes

10 RY_MARKET_ROLE_ID Number(18,0) DECIMAL(18) NOT NULL Online Marketing Default Marketing Role ID

11 START_DT Date(10) DATE Start date field to store start date value.

12 END_DT Date(10) DATE This field stores the end date values.

13 RYE_OWNER Character(30) VARCHAR2(30) NOT NULL Dialog Designer:Owner ID used for Dialogs

14 RYE_APPROVAL Character(1) VARCHAR2(1) NOT NULL Dialog Designer: Approval Status for Dialogs.
A=Approved
Q=Requested
R=Rejected

15 RA_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL Objective code of the campaign

16 RY_USE_SYS_IND_RL Character(1) VARCHAR2(1) NOT NULL Online Marketing Individuals matching rules
Default Value: Y

17 RY_USE_SYS_ORG_RL Character(1) VARCHAR2(1) NOT NULL Online Marketing Organization matching rules.
Default Value: Y

18 RY_LAST_LIVE_DTTM DateTime(26) TIMESTAMP Field used by Online Marketing.

19 RY_LOGIN_REQUIRED Character(1) VARCHAR2(1) NOT NULL New property for Dialog
Y/N Table Edit
Default Value: N

20 RY_SECURE_DIALOG Character(1) VARCHAR2(1) NOT NULL Checkbox for securing Dialog
Y/N Table Edit
Default Value: N

21 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

22 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

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

24 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

25 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
2	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.
3	RY_DIALOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.
4	RYE_DIALOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Design Time Status for dialogs.
5	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
6	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
7	APPROVAL_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a given transaction is approved by an oper
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	IS_STAGING	Character(1)	VARCHAR2(1) NOT NULL	Staging Dialog N=No Y=Yes
10	RY_MARKET_ROLE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Online Marketing Default Marketing Role ID
11	START_DT	Date(10)	DATE	Start date field to store start date value.
12	END_DT	Date(10)	DATE	This field stores the end date values.
13	RYE_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Dialog Designer:Owner ID used for Dialogs
14	RYE_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	Dialog Designer: Approval Status for Dialogs. A=Approved Q=Requested R=Rejected
15	RA_OBJECTIVE_CD	Character(4)	VARCHAR2(4) NOT NULL	Objective code of the campaign
16	RY_USE_SYS_IND_RL	Character(1)	VARCHAR2(1) NOT NULL	Online Marketing Individuals matching rules Default Value: Y
17	RY_USE_SYS_ORG_RL	Character(1)	VARCHAR2(1) NOT NULL	Online Marketing Organization matching rules. Default Value: Y
18	RY_LAST_LIVE_DTTM	DateTime(26)	TIMESTAMP	Field used by Online Marketing.
19	RY_LOGIN_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	New property for Dialog Y/N Table Edit Default Value: N
20	RY_SECURE_DIALOG	Character(1)	VARCHAR2(1) NOT NULL	Checkbox for securing Dialog Y/N Table Edit Default Value: N
21	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
22	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
23	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
24	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
25	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.
26	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time