EOTF_MAP_LANGVW

(SQL View)
Index Back

Value Map Search View

Enterprise 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