EOTF_DFLTOPT_VW

(SQL View)
 Index Back

TF Default Options

Default option values for the Enterprise Tansformation Framework. This view will always return only one record.

SELECT EOTF_MAP_NAME , EOTF_SHORT_NAME , EOTF_CACHE_MINS , EOTF_SEPARATOR , EOTF_IMP_DUP_FLG , EOTF_IMP_DEL_FLG , EOTF_IMP_MODE , EOTF_EXP_MODE , EOTF_EXP_GUID_FLG FROM PS_EOTF_MAP_OPTION WHERE 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 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: 10

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

Default Value: ::

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: Y

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: Y

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

Default Value: B

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

Default Value: B

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: N