EOEW_RULE_OBJPrompt Table: EOEW_PSFIELD_VW
Prompt Table: EOEW_OBJ_OWNER
00=Source
01=Transformation
02=Constant
03=Default
04=SQL Object
05=Built-In Function
06=Translation Set
Default Value: 03
EOEW_RULEDFN_VW(SQL View) |
Index Back |
|---|---|
Map RulesUsed to capture high level map definition attributes such as description, object ownerid, version and last updates. |
| SELECT EOEW_RULE_OBJ , EOEW_TAR_FLD , EOEW_OBJ_OWNER , EOEW_INPUT_TYP FROM PS_EOEW_RULE_DFN WHERE EOEW_INPUT_TYP IN ('00','01','06') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_RULE_OBJ |
Character(50) | VARCHAR2(50) NOT NULL | Map Rule |
| 2 | EOEW_TAR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Target Field
Prompt Table: EOEW_PSFIELD_VW |
| 3 | EOEW_OBJ_OWNER | Character(15) | VARCHAR2(15) NOT NULL |
Subject Area
Prompt Table: EOEW_OBJ_OWNER |
| 4 | EOEW_INPUT_TYP | Character(2) | VARCHAR2(2) NOT NULL |
Source object type.
00=Source 01=Transformation 02=Constant 03=Default 04=SQL Object 05=Built-In Function 06=Translation Set Default Value: 03 |