View: Employee YTD Summaries

RotoID: CP0047
Table: CPYTDS
Protocol: Flat
DLL:CPYTDS

Keys: 4

Title Fields

Year Summaries YEARYTDSEMPLOYEEEARNDEDEARDEDCLAS
YTD Summaries by Category YEARYTDSEMPLOYEECATEGORYEARNDEDEARDEDCLAS
YTD Summaries by Employee EMPLOYEEYEARYTDSEARNDEDEARDEDCLAS
YTD by Earning/Deduction EARNDED

Fields: 8

Field Index Type Title Attributes Presentation

YEARYTDS 1 Integer Year E A K R 
EMPLOYEE 2 String*12 Employee E A K R  Mask: %-12N
EARNDED 3 String*6 Earning/Deduction E A K R  Mask: %-6N
EARDEDCLAS 4 Integer Earning/Deduction Class E A K R  List:23 entries
1 = YTD Amount
2 = Employer Contribution
3 = Wages Subject To
4 = Wages Subject To, Ceiling
5 = Not Withheld
6 = Tips Subject To
7 = Tips Subject To, Ceiling
8 = Tax On Tips
9 = Base Hours
10 = Base Count
11 = Base Amount
12 = Base Sales
16 = Weeks Worked
17 = Hours Worked
18 = Backup Withholding
13 = Accrued Dollars
14 = Accrued Hours
15 = Accrued Hours Paid
19 = Taxable Non-periodic Earnings
20 = Subject to Income tax before deductions
21 = WC Base
22 = Non-Periodic Deduction Before Tax
23 = Repayment deductions before Income Tax
CATEGORY 5 Integer Category E A  List:11 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
11 = n/a
EARDEDTYPE 6 Integer Earning/Deduction Type E A  List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Employment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
UNPSTEDAMT 7 BCD*10.3 Sum of All Unposted Amounts E A 
POSTEDAMT 8 BCD*10.3 Sum of All YTD Posted Amounts E A