# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
RY_TRXN_SYS_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
2 |
RY_EXT_SYS_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
3 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
4 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
5 |
RY_TRXN_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Field used by Online Marketing.
|
6 |
STATUS_CODE |
Number(5,0) |
INTEGER NOT NULL |
Status Code
|
7 |
RY_URL |
Long Character(2000) |
VARCHAR2(2000) |
Template URL - Document Element
|