TC_MAP_EARN

(SQL Table)
Index Back

Comp Mapping for Earnings

Holds Total Compensation Mapping for a Comp ID when the map is based on Earnings 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 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: EARNINGS_TBL