| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| CREATEDTTM |
DateTime(26) |
TIMESTAMP NOT NULL |
DateTime of Query Creation
|
| LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
translate values
|
| NOTIFY_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Unique Identifier
|
| COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
translate values
|
| WL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Name
|
| WL_SUBJECT |
Character(254) |
VARCHAR2(254) NOT NULL |
Subject
|
| EMAIL_SENDER |
Character(254) |
VARCHAR2(254) NOT NULL |
EMAIL_SENDER
|
| EMAIL_TEXTLONG |
Long Character |
CLOB |
Message Text
|