EOEW_SRCDONAMESEQ_NUMEOEW_EXPRES_SEQ1=Operator
2=Record Fieldname
3=Value Object
4=Constant Value
5=Built-In Function
C=Character
D=Date
N=Numeric
Default Value: N
Default Value: %datetime
EOEW_EXPR_ELEM(SQL Table) |
Index Back |
|---|---|
ETL Source Expression ElementThis table contains the individual elements/components of an ETL source data object expression. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_SRCDONAME |
Character(30) | VARCHAR2(30) NOT NULL | Source Data Object |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | EOEW_EXPRES_SEQ |
Number(4,0) | SMALLINT NOT NULL | Expression Sequence Number |
| 4 | EOEW_OPERAND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Operand Type
1=Operator 2=Record Fieldname 3=Value Object 4=Constant Value 5=Built-In Function |
| 5 | EOEW_OPERAND | Character(40) | VARCHAR2(40) NOT NULL | Operand |
| 6 | EOEW_EXPR_ELEM_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Expression Element Type
C=Character D=Date N=Numeric |
| 7 | EOEW_SRC_COL_NAME | Character(254) | VARCHAR2(254) NOT NULL | Source Column Name |
| 8 | EOEW_EXPR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Expression |
| 9 | 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. |
| 10 | 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. |
| 11 | EOEW_SYSMAINT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Maintained
Default Value: N |
| 12 | CREATEDTTM | DateTime(26) | TIMESTAMP |
DateTime of Query Creation
Default Value: %datetime |