COMPENSATION_IDPrompt Table: TC_COMP_DEFN
MAP_BASEDD=Benefits and Deductions
E=Earnings
M=Multiple Components
N=No Mapping
T=Taxes - United States
U=Taxes - Canada
V=Variable Compensation
TAX_CLASSPrompt Table: TC_TAX_CLASS
GROSSUPY/N Table Edit
TC_MAP_TAX(SQL Table) |
Index Back |
|---|---|
Comp Mapping for TaxesHolds Total Compensation Mapping for a Comp ID when the map is based on Tax data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPENSATION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Compensation ID
Prompt Table: TC_COMP_DEFN |
| 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 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL |
Tax Balance Class
Prompt Table: TC_TAX_CLASS |
| 4 | GROSSUP |
Character(1) | VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit |