MAP_BASEDD=Benefits and Deductions
E=Earnings
M=Multiple Components
N=No Mapping
T=Taxes - United States
U=Taxes - Canada
V=Variable Compensation
TC_COMP_SOURCE_IDTC_COMP_SRC_VW(SQL View) |
Index Back |
|---|---|
Compensation Source ViewUsed for prompting in the Compensation Mapping panel |
| SELECT MAP_BASED, TC_COMP_SOURCE_ID, DESCR50 FROM PS_TC_COMP_SOURCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MAP_BASED |
Character(1) | VARCHAR2(1) NOT NULL |
Map Based On
D=Benefits and Deductions E=Earnings M=Multiple Components N=No Mapping T=Taxes - United States U=Taxes - Canada V=Variable Compensation |
| 2 | TC_COMP_SOURCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compensation Source |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |