EOTF_MAP_LANGVW(SQL View) |
Index Back |
---|---|
Value Map Search ViewEnterprise Transformation Framework Value Map search view |
SELECT L.EOTF_MAP_NAME , L.LANGUAGE_CD , M.EOTF_MAP_TYPE , L.DESCR FROM PS_EOTF_MAP_DEFN M , PS_EOTF_MAP_LANG L WHERE M.EOTF_MAP_NAME = L.EOTF_MAP_NAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOTF_MAP_NAME | Character(150) | VARCHAR2(150) NOT NULL | Map Name |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | EOTF_MAP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Map Type
D=Cross-reference (dynamic) S=Domain Value Map (static) Default Value: S |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |