TC_MAP_EARN(SQL Table) |
Index Back |
---|---|
Comp Mapping for EarningsHolds 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 |