EOTF_MAP_NAMEEOTF_DOMAIN_NAMEEOTF_ELEMENT_NAMEFO_ELEM_SIZE_VW(SQL View) |
Index Back |
|---|---|
Elements Field Size ViewElements Field Size View |
| SELECT A.EOTF_MAP_NAME , A.EOTF_DOMAIN_NAME , B.EOTF_ELEMENT_NAME , B.EOTF_DATA_LENGTH FROM PS_EOTF_ELEMENTSET A , PS_EOTF_ELEMENTS B WHERE A.EOTF_MAP_NAME = B.EOTF_MAP_NAME AND A.EOTF_ELEMENT_NAME = B.EOTF_ELEMENT_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_DOMAIN_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Domain Name |
| 3 | EOTF_ELEMENT_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Element Name |
| 4 | EOTF_DATA_LENGTH | Number(7,0) | INTEGER NOT NULL | Max Length |