TC_MAP_MCOMP(SQL Table) |
Index Back |
|---|---|
TC Multiple Componment MappingTC Multiple Componment Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPENSATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compensation ID |
| 2 | 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 |
| 3 | COMP_BASE_PAY_SW |
Character(1) | VARCHAR2(1) NOT NULL |
Comp Base Pay Switch
Y/N Table Edit |
| 4 | RATE_CODE_CLASS |
Character(6) | VARCHAR2(6) NOT NULL |
Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
Prompt Table: RATECD_CLS_TBL |
| 5 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RATECD_TBL |