XML File Format Schema
EmployeePayRecord Element
Namespace (none)
Diagram
TimeOffBalancesList Element TaxesList Element EarningsList Element DirectDepositsList Element DeductionsList Element PayRecordBenefitsList Element Custom2 Element Custom1 Element W4FilingStatus Element W4AdditionalWithholding Element W4Exemptions Element Country Element Zip Element StateOrProvince Element City Element Address2 Element Address1 Element LocationID Element DepartmentID Element SSN Element LastName Element FirstName Element NetWages Element TotalTaxes Element TotalDeductions Element TotalBenefits Element DeclaredTips Element TotalEarnings Element CheckNumber Element PeriodEndDate Element PeriodStartDate Element IsVoided Element RecordType Element SequenceNumber Element CheckDate Element BatchID Element RecordID Element Sequence EmployeePayRecord Element
Overview
Sequence
RecordID xs:int
BatchID xs:string
CheckDate xs:dateTime
RecordType Restriction of xs:string
IsVoided xs:boolean
PeriodStartDate xs:dateTime
PeriodEndDate xs:dateTime
CheckNumber xs:string
TotalEarnings xs:float
DeclaredTips xs:float
TotalBenefits xs:float
TotalDeductions xs:float
TotalTaxes xs:float
NetWages xs:float
FirstName xs:string
LastName xs:string
SSN xs:string
DepartmentID xs:string
LocationID xs:string
Address1 xs:string
Address2 xs:string
City xs:string
StateOrProvince xs:string
Zip xs:string
Country xs:string
W4Exemptions xs:int
W4FilingStatus Restriction of xs:string
Custom1 xs:string
Custom2 xs:string
Sequence
Sequence
BenefitCodeID xs:string
StartDate xs:dateTime
EndDate xs:dateTime
BenefitAmount xs:float
Custom1 xs:string
Custom2 xs:string
NativeRowID xs:int
Sequence
Sequence
DeductionCodeID xs:string
StartDate xs:dateTime
EndDate xs:dateTime
DeductionAmount xs:float
Custom1 xs:string
Custom2 xs:string
NativeRowID xs:int
Sequence
Sequence
Index xs:int
RoutingNumber xs:string
AccountNumber xs:string
Amount xs:float
Custom1 xs:string
Custom2 xs:string
Sequence
Sequence
EarningsCodeID xs:string
ShiftCode xs:string
ShiftPremium xs:float
StartDate xs:dateTime
EndDate xs:dateTime
UnitsToPay xs:float
PayRate xs:float
TipType xs:string
EarnedAmount xs:float
StateCode xs:string
SutaState xs:string
StateJurisdiction xs:string
LocalTaxCodeID xs:string
WorkersCompCode xs:string
DaysWorked xs:int
WeeksWorked xs:int
MiscDate xs:dateTime
SubjectToFIT xs:boolean
SubjectToStateSDI xs:boolean
SubjectToLocalLDI xs:boolean
SubjectToLocalOther xs:boolean
IsTimesheet xs:boolean
Custom1 xs:boolean
Custom2 xs:boolean
NativeRowID xs:int
Sequence
Sequence
TaxCodeID xs:string
StartDate xs:dateTime
EndDate xs:dateTime
TaxAmount xs:float
PreVoidedAmount xs:string
TaxableWages xs:float
UserDefined1 xs:string
UserDefined2 xs:string
NativeRowID xs:int
Jurisdiction xs:string
JurisdictionType xs:string
Sequence
Sequence
TimeOffCodeID xs:string
DateObservedUTC xs:dateTime
Balance xs:float
CurrentlyActive xs:boolean
CheckNumber xs:string
HoursAccrued xs:float
Custom1 xs:boolean
Custom2 xs:boolean
Source
<xs:element name="EmployeePayRecord" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:complexType>
    <xs:sequence>
      <xs:element type="xs:int" name="RecordID" nillable="true" />
      <xs:element type="xs:string" name="BatchID" />
      <xs:element type="xs:dateTime" name="CheckDate" />
      <xs:element type="xs:int" name="SequenceNumber" />
      <xs:element name="RecordType">
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:enumeration value="Check" />
            <xs:enumeration value="DirectDeposit" />
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element type="xs:boolean" name="IsVoided" />
      <xs:element type="xs:dateTime" name="PeriodStartDate" nillable="true" />
      <xs:element type="xs:dateTime" name="PeriodEndDate" nillable="true" />
      <xs:element type="xs:string" name="CheckNumber" />
      <xs:element type="xs:float" name="TotalEarnings" />
      <xs:element type="xs:float" name="DeclaredTips" />
      <xs:element type="xs:float" name="TotalBenefits" />
      <xs:element type="xs:float" name="TotalDeductions" />
      <xs:element type="xs:float" name="TotalTaxes" />
      <xs:element type="xs:float" name="NetWages" />
      <xs:element type="xs:string" name="FirstName" />
      <xs:element type="xs:string" name="LastName" />
      <xs:element type="xs:string" name="SSN" />
      <xs:element type="xs:string" name="DepartmentID" />
      <xs:element type="xs:string" name="LocationID" />
      <xs:element type="xs:string" name="Address1" />
      <xs:element type="xs:string" name="Address2" />
      <xs:element type="xs:string" name="City" />
      <xs:element type="xs:string" name="StateOrProvince" />
      <xs:element type="xs:string" name="Zip" />
      <xs:element type="xs:string" name="Country" />
      <xs:element type="xs:int" name="W4Exemptions" />
      <xs:element type="xs:float" name="W4AdditionalWithholding" />
      <xs:element name="W4FilingStatus">
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:enumeration value="Married" />
            <xs:enumeration value="Single" />
            <xs:enumeration value="MarriedFilingSingle" />
            <xs:enumeration value="" />
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element type="xs:string" name="Custom1" nillable="true" />
      <xs:element type="xs:string" name="Custom2" nillable="true" />
      <xs:element name="PayRecordBenefitsList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="BenefitDetail">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:string" name="BenefitCodeID" />
                  <xs:element type="xs:dateTime" name="StartDate" />
                  <xs:element type="xs:dateTime" name="EndDate" />
                  <xs:element type="xs:float" name="BenefitAmount" />
                  <xs:element type="xs:string" name="Custom1" />
                  <xs:element type="xs:string" name="Custom2" />
                  <xs:element type="xs:int" name="NativeRowID" nillable="true" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="DeductionsList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="DeductionDetail">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:string" name="DeductionCodeID" />
                  <xs:element type="xs:dateTime" name="StartDate" />
                  <xs:element type="xs:dateTime" name="EndDate" />
                  <xs:element type="xs:float" name="DeductionAmount" />
                  <xs:element type="xs:string" name="Custom1" nillable="true" />
                  <xs:element type="xs:string" name="Custom2" nillable="true" />
                  <xs:element type="xs:int" name="NativeRowID" nillable="true" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="DirectDepositsList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="DirectDepositDetail">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:int" name="Index" />
                  <xs:element type="xs:int" name="TransactionCode" />
                  <xs:element type="xs:string" name="RoutingNumber" />
                  <xs:element type="xs:string" name="AccountNumber" />
                  <xs:element type="xs:float" name="Amount" />
                  <xs:element type="xs:string" name="Custom1" nillable="true" />
                  <xs:element type="xs:string" name="Custom2" nillable="true" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="EarningsList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="EarningsDetail">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:string" name="EarningsCodeID" />
                  <xs:element type="xs:string" name="ShiftCode" />
                  <xs:element type="xs:float" name="ShiftPremium" />
                  <xs:element type="xs:dateTime" name="StartDate" />
                  <xs:element type="xs:dateTime" name="EndDate" />
                  <xs:element type="xs:float" name="UnitsToPay" />
                  <xs:element type="xs:float" name="PayRate" />
                  <xs:element type="xs:string" name="TipType" />
                  <xs:element type="xs:float" name="EarnedAmount" />
                  <xs:element type="xs:string" name="StateCode" />
                  <xs:element type="xs:string" name="SutaState" />
                  <xs:element type="xs:string" name="StateJurisdiction" />
                  <xs:element type="xs:string" name="SutaStateJurisdiction" />
                  <xs:element type="xs:string" name="LocalTaxCodeID" />
                  <xs:element type="xs:string" name="WorkersCompCode" />
                  <xs:element type="xs:int" name="DaysWorked" nillable="true" />
                  <xs:element type="xs:int" name="WeeksWorked" nillable="true" />
                  <xs:element type="xs:dateTime" name="MiscDate" />
                  <xs:element type="xs:boolean" name="SubjectToFIT" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToEmployeeFICA" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToEmployerFICA" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToEmployeeMedicare" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToEmployerMedicare" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToFederalUnemployment" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToStateWithholding" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToStateSDI" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToStateUnemployment" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToLocalWithholding" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToLocalLDI" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToLocalUnemployment" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToLocalOther" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToEmployeeSUI" nillable="true" />
                  <xs:element type="xs:boolean" name="SubjectToWorkersComp" nillable="true" />
                  <xs:element type="xs:boolean" name="IsTimesheet" />
                  <xs:element type="xs:boolean" name="Custom1" nillable="true" />
                  <xs:element type="xs:boolean" name="Custom2" nillable="true" />
                  <xs:element type="xs:int" name="NativeRowID" nillable="true" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="TaxesList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="TaxDetail">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:string" name="TaxCodeID" />
                  <xs:element type="xs:dateTime" name="StartDate" />
                  <xs:element type="xs:dateTime" name="EndDate" />
                  <xs:element type="xs:float" name="TaxAmount" />
                  <xs:element type="xs:string" name="PreVoidedAmount" nillable="true" />
                  <xs:element type="xs:float" name="TaxAmountJustOnTips" />
                  <xs:element type="xs:float" name="TaxableWages" />
                  <xs:element type="xs:string" name="UserDefined1" />
                  <xs:element type="xs:string" name="UserDefined2" />
                  <xs:element type="xs:int" name="NativeRowID" />
                  <xs:element type="xs:string" name="Jurisdiction" />
                  <xs:element type="xs:string" name="JurisdictionType" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="TimeOffBalancesList">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="TimeOffBalanceHistory">
              <xs:complexType>
                <xs:sequence>
                  <xs:element type="xs:string" name="TimeOffCodeID" />
                  <xs:element type="xs:dateTime" name="DateObservedUTC" />
                  <xs:element type="xs:float" name="Balance" />
                  <xs:element type="xs:boolean" name="CurrentlyActive" />
                  <xs:element type="xs:string" name="CheckNumber" />
                  <xs:element type="xs:float" name="HoursAccrued" />
                  <xs:element type="xs:boolean" name="Custom1" nillable="true" />
                  <xs:element type="xs:boolean" name="Custom2" nillable="true" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>
See Also
PayRecordsList ElementEmployee ElementEmployeesList ElementSyncDataSet ElementXML File Format Schema

 

 


© 2015 All Rights Reserved.

Send comments on this topic.