RY_OPTIONS(SQL Table) |
Index Back |
---|---|
Dialog OptionsDialog 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 |