Table: Employee YTD Summaries

Table: CPYTDS
View: CP0047
Record Length: 70

Flags: A R 

Keys: 4

Title Flags Fields

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

Fields: 12

Field Type Title Presentation

YEARYTDS Integer Year
EMPLOYEE String*12 Employee Mask: %-12N
EARNDED String*6 Earning/Deduction Mask: %-6N
EARDEDCLAS Integer Earning/Deduction Class 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
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CATEGORY Integer Category 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 Integer Earning/Deduction Type 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 BCD*10.3 Sum of All Unposted Amounts
POSTEDAMT BCD*10.3 Sum of All YTD Posted Amounts