EOEW_SRCDONAMEPV_SRCFDLOAD_VW(SQL View) |
Index Back |
|---|---|
EOEW SDO Source Load viewthis view is a copy of EOEW_SRCFIELD except that ePro's version has a FIELDTYPE field. |
| SELECT EOEW_SRCDONAME , EOEW_SRC_WHEREUSED , EOEW_SRCCOLALIAS , EOEW_SRCTABLE , EOEW_SRCCOL , FIELDTYPE FROM PS_EOEW_SRCFIELD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_SRCDONAME |
Character(30) | VARCHAR2(30) NOT NULL | Source Data Object |
| 2 | EOEW_SRC_WHEREUSED | Number(1,0) | SMALLINT NOT NULL | Used in SELECT List |
| 3 | EOEW_SRCCOLALIAS | Character(30) | VARCHAR2(30) NOT NULL | Column Alias |
| 4 | EOEW_SRCTABLE | Character(80) | VARCHAR2(80) NOT NULL | Source Record Name |
| 5 | EOEW_SRCCOL | Character(80) | VARCHAR2(80) NOT NULL | Source Field Name |
| 6 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |