| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CALL_REPORT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Unique Identifier for Call Reports.
|
| 2 |
NOTE_GUID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
GUID as a number for notes.
|
| 3 |
NOTE_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Note ID
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
NOTE_SUMMARY |
Character(50) |
VARCHAR2(50) NOT NULL |
This field is used for Notes Summary (50 characters).
|
| 6 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|