EOTF_MAP_ADD_VW(SQL View) |
Index Back |
|---|---|
Value Map Add ViewValue Map add view for Enterprise Transformation Framework |
| SELECT EOTF_MAP_NAME , 'D' , DESCR FROM PS_EOTF_MAP_DEFN UNION SELECT EOTF_MAP_NAME , 'S' , DESCR FROM PS_EOTF_MAP_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(150) | VARCHAR2(150) NOT NULL | Map Name | |
| 2 | Character(1) | VARCHAR2(1) NOT NULL |
Map Type
D=Cross-reference (dynamic) S=Domain Value Map (static) Default Value: S |
|
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |