FO_MAP_VALUE(SQL Table) |
Index Back |
---|---|
Map ValueMap Value |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FO_MAP_COMMON_UID | Character(36) | VARCHAR2(36) NOT NULL | Map Common UID |
2 | FO_ELEMENT_UID | Character(150) | VARCHAR2(150) NOT NULL | Element UID |
3 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
4 | EOTF_ELEMENT001 | Character(254) | VARCHAR2(254) NOT NULL | Element 001 |
5 | EOTF_ELEMENT002 | Character(254) | VARCHAR2(254) NOT NULL | Element 002 |
6 | EOTF_ELEMENT003 | Character(254) | VARCHAR2(254) NOT NULL | Element 003 |
7 | EOTF_ELEMENT004 | Character(254) | VARCHAR2(254) NOT NULL | Element 004 |
8 | EOTF_ELEMENT005 | Character(254) | VARCHAR2(254) NOT NULL | Element 005 |
9 | EOTF_ELEMENT006 | Character(254) | VARCHAR2(254) NOT NULL | Element 006 |
10 | EOTF_ELEMENT007 | Character(254) | VARCHAR2(254) NOT NULL | Element 007 |
11 | EOTF_ELEMENT008 | Character(254) | VARCHAR2(254) NOT NULL | Element 008 |
12 | EOTF_ELEMENT009 | Character(254) | VARCHAR2(254) NOT NULL | Element 009 |
13 | EOTF_ELEMENT010 | Character(254) | VARCHAR2(254) NOT NULL | Element 010 |
14 | EOTF_ELEMENT011 | Character(254) | VARCHAR2(254) NOT NULL | Element 011 |
15 | EOTF_ELEMENT012 | Character(254) | VARCHAR2(254) NOT NULL | Element 012 |
16 | EOTF_ELEMENT013 | Character(254) | VARCHAR2(254) NOT NULL | Element 013 |
17 | EOTF_ELEMENT014 | Character(150) | VARCHAR2(150) NOT NULL | Element 014 |
18 | EOTF_ELEMENT015 | Character(150) | VARCHAR2(150) NOT NULL | Element 015 |
19 | EOTF_ELEMENT016 | Character(150) | VARCHAR2(150) NOT NULL | Element 016 |
20 | PB_ADD | Character(1) | VARCHAR2(1) NOT NULL | Add |