EOTF_MAP_NAMEPrompt Table: EOTF_MAP_DEFN
EOTF_ROW_NBRPrompt Table: EOTF_DVMROWS
EOTF_ELEMENT_NBRPrompt Table: EOTF_ELEMENTS
Y/N Table Edit
Default Value: N
EOTF_DVMVALS(SQL Table) |
Index Back |
|---|---|
TF Runtime DVM Data ValuesRepresents element values of Domain Value Map (DVM) runtime data 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_DEFN |
| 2 | EOTF_ROW_NBR |
Number(5,0) | INTEGER NOT NULL |
Row Number
Prompt Table: EOTF_DVMROWS |
| 3 | EOTF_ELEMENT_NBR |
Number(3,0) | SMALLINT NOT NULL |
Element Number
Prompt Table: EOTF_ELEMENTS |
| 4 | EOTF_ELEMENT_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Element Value |
| 5 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |