Table: Employee EI History

Table: CPEUIC
View: CP0030
Record length: 132
Flags: A R 

Keys: 5

Title  Flags  Fields

EI End Date, Descending  EMPLOYEE, DATESORT, UIENDDATE, PEREND, ENTRYSEQ
Post Status  D M  POSTSTAT, EMPLOYEE, PEREND, ENTRYSEQ, UIENDDATE
EI End Date  D  EMPLOYEE, UIENDDATE
Period End Date, Descending  D M  EMPLOYEE, PERENDX, PPEXCEPT, DATESORT, ESTATUS
Employment Status  D M  EMPLOYEE, ESTATUS

Fields: 24

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee   
DATESORT  Long     
UIENDDATE  Date  Insurable Period End Date   
PEREND  Date  Pay Period End Date   
ENTRYSEQ  Long  Entry Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
POSTSTAT  Boolean  Post Status   
UIGROSS  BCD*10.3  Earnings Subject to EI   
HOURS  BCD*4.3  Hours Worked   
UIEARNINGS  BCD*10.3  Insurable Earnings   
UIPREMIUM  BCD*10.3  Employee EI Contribution   
PAYFREQ  Integer  Employee Pay Frequency   
PPEXCEPT  Boolean  EI Period Exception   
PERENDX  Long     
TRANSDATE  Date  Transaction Date   
GROSSHOURS  BCD*4.3  Hours Subject to EI   
UIRPREMIUM  BCD*10.3  Employer EI Contribution   
ENTRYTYPE  Integer  Check Type   
TAXID  String*6  Tax  Mask: %-6N
ESTATUS  Integer  Employment Status  List: 5 entries
1=Active
4=Inactive - ROE Pending
2=Inactive
5=Terminated - ROE Pending
3=Terminated
ESTATDATE  Date  Employment Status Date   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.