XML File Format Schema
PayRecordsList Element
Namespace (none)
Diagram
EmployeePayRecord Element Sequence PayRecordsList Element
Overview
Sequence
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="PayRecordsList" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="EmployeePayRecord">
        <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>
    </xs:sequence>
  </xs:complexType>
</xs:element>
See Also
Employee ElementEmployeesList ElementSyncDataSet ElementXML File Format Schema

 

 


© 2015 All Rights Reserved.

Send comments on this topic.