| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
CMF_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Correspondence ID
|
| 2 |
CMF_TRNS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Correspondence Management Package Sequence Number
|
| 3 |
CMF_RECIP_SEQ_NUM |
Number(18,0) |
DECIMAL(18) NOT NULL |
Correspondence Management Package Sequence Number
|
| 4 |
APP |
Character(20) |
VARCHAR2(20) NOT NULL |
Application ID Field
|
| 5 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 6 |
CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Datetime
|