EOTF_MAP_NAMEPrompt Table: EOTF_MAP_DEFN
EOTF_COMMONELEMENTEOTF_ELEMENT_NBRPrompt Table: EOTF_ELEMENTS
EOTF_DVMVALS_VW(SQL View) |
Index Back |
|---|---|
TF Runtime DVM Data ValuesEnterprise Transformation Framework - view for DVMs (static value maps) |
| SELECT R.EOTF_MAP_NAME , R.EOTF_COMMONELEMENT , V.EOTF_ELEMENT_NBR , V.EOTF_ELEMENT_VALUE FROM PS_EOTF_DVMROWS R , PS_EOTF_DVMVALS V WHERE R.EOTF_MAP_NAME = V.EOTF_MAP_NAME AND R.EOTF_ROW_NBR = V.EOTF_ROW_NBR |
| # | 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_COMMONELEMENT |
Character(36) | VARCHAR2(36) NOT NULL | Common Element |
| 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 |