EOTF_MAP_OPTION(SQL Table) |
Index Back |
---|---|
TF Value Map OptionsOptions 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 |