RY_OPTIONS

(SQL Table)
Index Back

Dialog Options

Dialog global options definitions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DDLSPACENAME_RYD Character(30) VARCHAR2(30) NOT NULL Documents Tablespace Name

Prompt Table: PSTBLSPCCAT_VW

2 DDLSPACENAME_RYP Character(30) VARCHAR2(30) NOT NULL Profiles Tablespace Name

Prompt Table: PSTBLSPCCAT_VW

3 DBNAME_RYD Character(8) VARCHAR2(8) NOT NULL Documents Database Name

Prompt Table: RY_TBLSPCCATDVW

4 DBNAME_RYP Character(8) VARCHAR2(8) NOT NULL Profiles Database Name

Prompt Table: RY_TBLSPCCATPVW

5 AUD_CNT_WRN Number(9,0) DECIMAL(9) NOT NULL Issue a warning message if the audience count is greater than the number entered.
6 AUD_CNT_ERR Number(9,0) DECIMAL(9) NOT NULL Issue a warning message if the audience count is greater than the number entered.
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

8 RY_DLG_APPRV_ROLE Character(30) VARCHAR2(30) NOT NULL This is the role that is allowed to approve dialogs.

Prompt Table: PSROLEDEFN

9 MIN_DELAY_AMT Number(5,0) INTEGER NOT NULL minimum delay amount field used in Dialog Staging/Testing

Default Value: 5

10 MIN_FREQUENCY Number(5,0) INTEGER NOT NULL minimum freq. interval field used in Dialog Staging/Testing

Default Value: 60

11 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

Prompt Table: PSURLDEFN

12 TRACKING_BLOCK Character(1) VARCHAR2(1) NOT NULL Include unique ID in text of email for bounce and reply processing.
F=False
T=True

Default Value: F

13 TRACKING_BLOCK_LOC Character(1) VARCHAR2(1) NOT NULL Location of tracking block in email.
B=Bottom
T=Top

Default Value: T

14 USEDATAVALIDATION Character(1) VARCHAR2(1) NOT NULL Include form field validation JavaScript in forms.
F=False
T=True

Default Value: T

15 RA_IND_SUBJ_AREA Number(31,0) DECIMAL(31) NOT NULL High-Level Individual Subject Area
16 RA_ORG_SUBJ_AREA Number(31,0) DECIMAL(31) NOT NULL High-Level Organizational Subject Area
17 RY_UPDT_EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL Automaticlly update basic profile's DoNotEmail flag.

Y/N Table Edit

Default Value: N

18 RY_DEDUP_OPT Character(1) VARCHAR2(1) NOT NULL Used for dedup options for the broadcast email in Global Options.
B=Unique System ID
E=Email Address
S=Customer ID (External ID)

Default Value: B

19 RY_DOC_DSGN_MODE Character(1) VARCHAR2(1) NOT NULL Indecate the Document Designer mode
N=Normal
Y=Advanced

Default Value: Y

20 RY_MATCH_OPTION Character(1) VARCHAR2(1) NOT NULL Use Expanded Matching Rule

Y/N Table Edit

Default Value: N