HRS_DM_KEY_IDPrompt Table: HRS_DM_KEY_VW
HRS_DM_VAL_IDPrompt Table: HRS_DM_VAL_VW
HRS_DM_MAP_IDPrompt Table: HRS_DM_MAPDEFN
10=Incoming Only
20=Outgoing Only
30=Bi-Directional
40=Unmapped
Default Value: 40
HRS_DM_VAL_MAP(SQL Table) |
Index Back |
|---|---|
DataMapping Map TableTable used to map data values to keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_DM_KEY_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Data Mapping Key ID
Prompt Table: HRS_DM_KEY_VW |
| 2 | HRS_DM_VAL_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Data Mapping Value ID.
Prompt Table: HRS_DM_VAL_VW |
| 3 | HRS_DM_MAP_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Assigned Mapping ID
Prompt Table: HRS_DM_MAPDEFN |
| 4 | HRS_DM_USE | Character(3) | VARCHAR2(3) NOT NULL |
Data Mapping Usage. If this mapping should be used with outgoing messages, incoming message or both.
10=Incoming Only 20=Outgoing Only 30=Bi-Directional 40=Unmapped Default Value: 40 |