EOEW_SRCFIELD(SQL Table) |
Index Back |
|---|---|
EOEW SDO Field metadata |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Source Data Object | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | EOEW_SRC_WHEREUSED | Number(1,0) | SMALLINT NOT NULL | Used in SELECT List |
| 5 | EOEW_SRCTABLE | Character(80) | VARCHAR2(80) NOT NULL | Source Record Name |
| 6 | EOEW_SRCCOL | Character(80) | VARCHAR2(80) NOT NULL | Source Field Name |
| 7 | EOEW_SRCCOLALIAS | Character(30) | VARCHAR2(30) NOT NULL | Column Alias |
| 8 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 9 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 10 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 11 | EOEW_EXPR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Expression |
| 12 | EOEW_AGGREGATE_IND | Character(1) | VARCHAR2(1) NOT NULL | Aggregate Function Indicator Flag |
| 13 | EOEW_EXPR_STMT | Character(254) | VARCHAR2(254) NOT NULL | Expression Statement |
| 14 | EOEW_SYSMAINT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Maintained
Y/N Table Edit Default Value: N |
| 15 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| 16 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 17 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |