FO_MAP_ELEMENTFO_MAP_ELEM_SYS(SQL Table) |
Index Back |
|---|---|
Map SetMap Set |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_MAP_ELEMENT |
Character(3) | VARCHAR2(3) NOT NULL | Staffing Element |
| 2 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 3 | RECNAME_TRANS | Character(18) | VARCHAR2(18) NOT NULL | Selected Transactions |
| 4 | RECNAME_TEMP | Character(18) | VARCHAR2(18) NOT NULL | Temporary Record |
| 5 | RECNAME_VO | Character(18) | VARCHAR2(18) NOT NULL | VO Record Name |
| 6 | DTL_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Detail Record name |
| 7 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 8 | DYNAMIC_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Dynamic Flag |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 10 | MESSAGENBR | Number(10,0) | DECIMAL(10) NOT NULL | Message Number |