EOEW_SETRULE_VW(SQL View) |
Index Back |
---|---|
Set target field default ruleUsed for search dialog to set target field default value rule. |
SELECT A.EOEW_RULE_OBJ , A.EOEW_TAR_FLD , A.EOEW_INPUT_VAL FROM PS_EOEW_RULE_DFN A WHERE A.EOEW_INPUT_TYP <> '03' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOEW_RULE_OBJ | Character(50) | VARCHAR2(50) NOT NULL |
Map Rule
Prompt Table:
EOEW_ETL_FLD
|
2 | EOEW_TAR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Target Field
Prompt Table: EOEW_FIELD_VW |
3 | EOEW_INPUT_VAL | Character(120) | VARCHAR2(120) NOT NULL | Source Input Value |