RY_OPTIONS_VW(SQL View) |
Index Back |
|---|---|
Dialog OptionsDialog global options definitions |
| SELECT DISTINCT(A.URL_ID) , A.RY_MATCH_OPTION , CASE WHEN A.URL_ID = ' ' THEN ' ' ELSE B.URL END , A.USEDATAVALIDATION ,A.TRACKING_BLOCK_LOC ,A.TRACKING_BLOCK FROM PS_RY_OPTIONS A , PSURLDEFN B WHERE ( A.URL_ID = B.URL_ID OR A.URL_ID = ' ' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 2 | RY_MATCH_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Use Expanded Matching Rule |
| 3 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 4 | USEDATAVAL_D | Character(10) | VARCHAR2(10) NOT NULL | Include form field validation JavaScript in forms. |
| 5 | TRACK_BLOCK_LOC_D | Character(10) | VARCHAR2(10) NOT NULL | Location of tracking block in email. |
| 6 | TRACKING_BLOCK_D | Character(10) | VARCHAR2(10) NOT NULL | Include unique ID in text of email for bounce and reply processing. |