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 | EOTF_MAP_NAME | Character(150) | VARCHAR2(150) NOT NULL | Map Name |
2 | EOTF_MAP_TYPE | 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 |