EOTF_MAP_ADD_VW

(SQL View)
Index Back

Value Map Add View

Value 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