EOTF_MAP_OPTION

(SQL Table)
Index Back

TF Value Map Options

Options for the Enterprise Transformation Framework

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name

Prompt Table: EOTF_MAP_SVW

2 EOTF_SHORT_NAME Character(30) VARCHAR2(30) NOT NULL Short Map Name
3 EOTF_CACHE_MINS Number(6,0) INTEGER NOT NULL Stale Cache Minutes

Default Value: EOTF_DFLTOPT_VW.EOTF_CACHE_MINS

4 EOTF_SEPARATOR Character(4) VARCHAR2(4) NOT NULL Concatenation Separator

Default Value: EOTF_DFLTOPT_VW.EOTF_SEPARATOR

5 EOTF_IMP_DUP_FLG Character(1) VARCHAR2(1) NOT NULL Error When Map Exists
N=No
Y=Yes

Y/N Table Edit

Default Value: EOTF_DFLTOPT_VW.EOTF_IMP_DUP_FLG

6 EOTF_IMP_DEL_FLG Character(1) VARCHAR2(1) NOT NULL Delete Map/Data Before Import
N=No
Y=Yes

Y/N Table Edit

Default Value: EOTF_DFLTOPT_VW.EOTF_IMP_DEL_FLG

7 EOTF_IMP_MODE Character(1) VARCHAR2(1) NOT NULL Import Mode
B=Definition and Data
D=Definition Only
V=Values Only

Default Value: EOTF_DFLTOPT_VW.EOTF_IMP_MODE

8 EOTF_EXP_MODE Character(1) VARCHAR2(1) NOT NULL Export Mode
B=Definition and Data
D=Definition Only

Default Value: EOTF_DFLTOPT_VW.EOTF_EXP_MODE

9 EOTF_EXP_GUID_FLG Character(1) VARCHAR2(1) NOT NULL Export UniqueGUID to DVM.V1
N=No
Y=Yes

Y/N Table Edit

Default Value: EOTF_DFLTOPT_VW.EOTF_EXP_GUID_FLG