CF_MAPPING_SETCHARTFIELDD=Drop the Values
K=Keep the Values
M=Map to New Values
Default Value: K
Prompt Table:
CF_VALUE_MAP
Set Control Field: CHARTFIELD
Prompt Table: SP_SETID_NONVW
CF_MAPPING_CF(SQL Table) |
Index Back |
|---|---|
Chartfield Mapping Set Lines |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CF_MAPPING_SET |
Character(10) | VARCHAR2(10) NOT NULL | ChartField Mapping Set |
| 2 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 3 | CF_CONVERSION_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
ChartField Conversion Option
D=Drop the Values K=Keep the Values M=Map to New Values Default Value: K |
| 4 | VALUE_SET_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Value Set Name
Prompt Table:
CF_VALUE_MAP
|
| 5 | SETID_TO | Character(5) | VARCHAR2(5) NOT NULL |
Target SetID
Prompt Table: SP_SETID_NONVW |