| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 2 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 3 |
BIND_ID |
Number(3,0) |
SMALLINT NOT NULL |
Bind ID
|
| 4 |
LEVELNUM |
Number(5,0) |
INTEGER NOT NULL |
Level Number
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 7 |
IS_RELATED_REC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Related Record Flag
|
| 8 |
RELATED_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Used in SS Framework
|
| 9 |
RELATED_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Used in SS Framework
|
| 10 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
|