| # | 
PeopleSoft Field Name | 
PeopleSoft Field Type | 
Database Column Type | 
Description | 
| 1 | 
 SUBSCRIBE_DTTM | 
DateTime(26) | 
TIMESTAMP | 
Subscription Date Time
 | 
| 2 | 
 TRANSACTIONID | 
Number(10,0) | 
DECIMAL(10) NOT NULL | 
Transaction Identifier
 | 
| 3 | 
 TRANSACTIONID2 | 
Number(10,0) | 
DECIMAL(10) NOT NULL | 
Transaction ID
 | 
| 4 | 
 FIELDNAME | 
Character(18) | 
VARCHAR2(18) NOT NULL | 
Field Name (see PSDBFIELD).
 | 
| 5 | 
TASK_ELEMENT_CD | 
Character(3) | 
VARCHAR2(3) NOT NULL | 
Task Element Code
 | 
| 6 | 
MESSAGE_SET_NBR | 
Number(5,0) | 
INTEGER NOT NULL | 
Message Set Number.  This field refers to the Message Set Number in the Message Catalog.
 | 
| 7 | 
MESSAGE_NBR | 
Number(5,0) | 
INTEGER NOT NULL | 
Message Number.  This field refers to the Message Number in the Message Catalog.
 |