Mẫu dữ liệu xử lý bảng lương

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:wd="urn:com.workday/bsvc">
  <xsl:output method="text" encoding="UTF-8"/>
  <xsl:variable name="separator" select="','"/>
  <xsl:variable name="newline" select="'&#10;'"/>
  <xsl:template match="/">
    <xsl:text>PayrollRecordId,ActivityName,EventTimestamp,SourceSystem,LastDataUpdate,PayrollSpecialist,CostCenter,Country,PayPeriod,PayrollRunType,IsAutomated,CorrectionReason,PayGroup,ProcessingTime</xsl:text>
    <xsl:value-of select="$newline"/>
    <xsl:for-each select="wd:Report_Data/wd:Report_Entry">
      <xsl:variable name="RecordId" select="wd:PayrollRecordId"/>
      <xsl:variable name="Source" select="'Workday Payroll'"/>
      <xsl:variable name="Update" select="wd:LastDataUpdate"/>
      <xsl:variable name="User" select="wd:PayrollSpecialist"/>
      <xsl:variable name="CC" select="wd:CostCenter"/>
      <xsl:variable name="Ctry" select="wd:Country"/>
      <xsl:variable name="Period" select="wd:PayPeriod"/>
      <xsl:variable name="RunType" select="wd:PayrollRunType"/>
      <xsl:variable name="Auto" select="wd:IsAutomated"/>
      <xsl:variable name="Reason" select="wd:CorrectionReason"/>
      <xsl:variable name="Group" select="wd:PayGroup"/>
      <xsl:variable name="ProcTime" select="wd:ProcessingTime"/>
      
      <!-- Activity 1: Time Sheet Submitted -->
      <xsl:if test="wd:Time_Sheet_Submitted_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Time Sheet Submitted</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Time_Sheet_Submitted_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 2: Time Sheet Approved -->
      <xsl:if test="wd:Time_Sheet_Approved_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Time Sheet Approved</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Time_Sheet_Approved_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 3: Incentive Data Imported -->
      <xsl:if test="wd:Incentive_Data_Imported_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Incentive Data Imported</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Incentive_Data_Imported_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 4: Payroll Record Created -->
      <xsl:if test="wd:Payroll_Record_Created_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Payroll Record Created</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Payroll_Record_Created_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 5: Gross Pay Calculated -->
      <xsl:if test="wd:Gross_Pay_Calculated_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Gross Pay Calculated</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Gross_Pay_Calculated_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 6: Benefits Deductions Applied -->
      <xsl:if test="wd:Benefits_Deductions_Applied_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Benefits Deductions Applied</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Benefits_Deductions_Applied_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 7: Audit Exception Flagged -->
      <xsl:if test="wd:Audit_Exception_Flagged_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Audit Exception Flagged</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Audit_Exception_Flagged_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 8: Data Correction Performed -->
      <xsl:if test="wd:Data_Correction_Performed_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Data Correction Performed</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Data_Correction_Performed_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 9: Payroll Result Previewed -->
      <xsl:if test="wd:Payroll_Result_Previewed_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Payroll Result Previewed</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Payroll_Result_Previewed_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 10: Payroll Record Approved -->
      <xsl:if test="wd:Payroll_Record_Approved_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Payroll Record Approved</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Payroll_Record_Approved_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 11: Bank Transfer File Generated -->
      <xsl:if test="wd:Bank_Transfer_File_Generated_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Bank Transfer File Generated</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Bank_Transfer_File_Generated_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 12: Pay Slip Published -->
      <xsl:if test="wd:Pay_Slip_Published_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Pay Slip Published</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Pay_Slip_Published_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 13: Payment Executed -->
      <xsl:if test="wd:Payment_Executed_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Payment Executed</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Payment_Executed_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>

      <!-- Activity 14: Tax Filing Completed -->
      <xsl:if test="wd:Tax_Filing_Completed_TS != ''">
        <xsl:value-of select="$RecordId"/><xsl:value-of select="$separator"/>
        <xsl:text>Tax Filing Completed</xsl:text><xsl:value-of select="$separator"/>
        <xsl:value-of select="wd:Tax_Filing_Completed_TS"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Source"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Update"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$User"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$CC"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Ctry"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Period"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$RunType"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Auto"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Reason"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$Group"/><xsl:value-of select="$separator"/>
        <xsl:value-of select="$ProcTime"/><xsl:value-of select="$newline"/>
      </xsl:if>
    </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

import requests
import pandas as pd
import io
import datetime

class=class="hl-string">"hl-comment"># --- Configuration --- 
class=class="hl-string">"hl-comment"># Replace with your Workday tenant URL and the RaaS report alias
WORKDAY_RAAS_URL = class="hl-string">"https://[Your Workday Tenant URL]/ccx/service/customreport2/[Your_Tenant]/[Your_ISU_User]/[Your_RaaS_Report_Name]?format=json"

class=class="hl-string">"hl-comment"># Replace with your Integration System User (ISU) credentials
WORKDAY_USER = class="hl-string">"[Your_ISU_Username]@[Your_Tenant]"
WORKDAY_PASSWORD = class="hl-string">"[Your_ISU_Password]"

class=class="hl-string">"hl-comment"># Define the date range for the extraction
START_DATE = class="hl-string">"2023-01-01"
END_DATE = class="hl-string">"2023-12-31"

class=class="hl-string">"hl-comment"># --- Main Extraction Logic --- 

def fetch_workday_data(url, user, password, start_date, end_date):
    class="hl-string">"""Fetches paginated data from a Workday RaaS endpoint."""
    all_results = []
    page = 1
    
    class=class="hl-string">"hl-comment"># The RaaS API uses specific parameter names for prompts
    params = {
        class="hl-string">'Pay_Period_Start_Date!WID': start_date,
        class="hl-string">'Pay_Period_End_Date!WID': end_date
    }

    while True:
        print(fclass="hl-string">"Fetching page {page}...")
        try:
            response = requests.get(url, auth=(user, password), params={**params, class="hl-string">'page': page}, timeout=300)
            response.raise_for_status()  class=class="hl-string">"hl-comment"># Raises an exception for bad status codes (4xx or 5xx)
            data = response.json()
            
            report_entries = data.get(class="hl-string">'Report_Entry', [])
            if not report_entries:
                print(class="hl-string">"No more data found. Ending fetch.")
                break
                
            all_results.extend(report_entries)
            
            class=class="hl-string">"hl-comment"># Simple check for end of pagination (may need adjustment based on your report's total results)
            total_results = data.get(class="hl-string">'Report_Data', {}).get(class="hl-string">'Total_Results', len(report_entries))
            if len(all_results) >= int(total_results):
                 print(class="hl-string">"Fetched all results.")
                 break

            page += 1

        except requests.exceptions.HTTPError as err:
            print(fclass="hl-string">"HTTP Error: {err}")
            print(fclass="hl-string">"Response Text: {response.text}")
            break
        except requests.exceptions.RequestException as e:
            print(fclass="hl-string">"Request failed: {e}")
            break

    return all_results

def transform_to_event_log(raw_data):
    class="hl-string">"""Transforms the wide RaaS format to a long event log format."""
    event_log_records = []
    
    class=class="hl-string">"hl-comment"># This mapping links the column name from your RaaS report to the desired Activity Name
    class=class="hl-string">"hl-comment"># CRITICAL: The keys of this dictionary must exactly match the JSON element names from your RaaS report
    activity_mapping = {
        class="hl-string">'Time_Sheet_Submitted_Timestamp': class="hl-string">'Time Sheet Submitted',
        class="hl-string">'Time_Sheet_Approved_Timestamp': class="hl-string">'Time Sheet Approved',
        class="hl-string">'Incentive_Data_Imported_Timestamp': class="hl-string">'Incentive Data Imported',
        class="hl-string">'Payroll_Record_Created_Timestamp': class="hl-string">'Payroll Record Created',
        class="hl-string">'Gross_Pay_Calculated_Timestamp': class="hl-string">'Gross Pay Calculated',
        class="hl-string">'Benefits_Deductions_Applied_Timestamp': class="hl-string">'Benefits Deductions Applied',
        class="hl-string">'Audit_Exception_Flagged_Timestamp': class="hl-string">'Audit Exception Flagged',
        class="hl-string">'Data_Correction_Performed_Timestamp': class="hl-string">'Data Correction Performed',
        class="hl-string">'Payroll_Result_Previewed_Timestamp': class="hl-string">'Payroll Result Previewed',
        class="hl-string">'Payroll_Record_Approved_Timestamp': class="hl-string">'Payroll Record Approved',
        class="hl-string">'Bank_Transfer_File_Generated_Timestamp': class="hl-string">'Bank Transfer File Generated',
        class="hl-string">'Pay_Slip_Published_Timestamp': class="hl-string">'Pay Slip Published',
        class="hl-string">'Payment_Executed_Timestamp': class="hl-string">'Payment Executed',
        class="hl-string">'Tax_Filing_Completed_Timestamp': class="hl-string">'Tax Filing Completed'
    }

    last_update_ts = datetime.datetime.now().isoformat()

    for record in raw_data:
        base_record = {
            class="hl-string">'PayrollRecordId': record.get(class="hl-string">'PayrollRecordId'),
            class="hl-string">'PayrollSpecialist': record.get(class="hl-string">'Initiating_User', record.get(class="hl-string">'Last_Updated_By_User')),
            class="hl-string">'CostCenter': record.get(class="hl-string">'CostCenter'),
            class="hl-string">'Country': record.get(class="hl-string">'Country'),
            class="hl-string">'PayPeriod': record.get(class="hl-string">'PayPeriod'),
            class="hl-string">'PayrollRunType': record.get(class="hl-string">'PayrollRunType'),
            class="hl-string">'CorrectionReason': record.get(class="hl-string">'CorrectionReason'),
            class="hl-string">'PayGroup': record.get(class="hl-string">'PayGroup'),
            class="hl-string">'SourceSystem': class="hl-string">'Workday Payroll',
            class="hl-string">'LastDataUpdate': last_update_ts,
            class="hl-string">'ProcessingTime': record.get(class="hl-string">'ProcessingTime_Seconds')
        }

        for timestamp_field, activity_name in activity_mapping.items():
            event_timestamp = record.get(timestamp_field)
            if event_timestamp:
                event_record = base_record.copy()
                event_record[class="hl-string">'ActivityName'] = activity_name
                event_record[class="hl-string">'EventTimestamp'] = event_timestamp
                class=class="hl-string">"hl-comment"># A simple heuristic for automation, refine based on your Workday configuration
                event_record[class="hl-string">'IsAutomated'] = class="hl-string">'EIB' in event_record.get(class="hl-string">'PayrollSpecialist', class="hl-string">'') or class="hl-string">'System' in event_record.get(class="hl-string">'PayrollSpecialist', class="hl-string">'')
                event_log_records.append(event_record)
    
    return pd.DataFrame(event_log_records)

class=class="hl-string">"hl-comment"># --- Main Execution --- 
if __name__ == class="hl-string">"__main__":
    print(class="hl-string">"Starting Workday Payroll data extraction...")
    raw_payroll_data = fetch_workday_data(WORKDAY_RAAS_URL, WORKDAY_USER, WORKDAY_PASSWORD, START_DATE, END_DATE)
    
    if raw_payroll_data:
        print(fclass="hl-string">"Successfully fetched {len(raw_payroll_data)} records from Workday.")
        event_log_df = transform_to_event_log(raw_payroll_data)
        
        if not event_log_df.empty:
            class=class="hl-string">"hl-comment"># Reorder columns for clarity
            column_order = [
                class="hl-string">'PayrollRecordId', class="hl-string">'ActivityName', class="hl-string">'EventTimestamp', class="hl-string">'SourceSystem', class="hl-string">'LastDataUpdate',
                class="hl-string">'PayrollSpecialist', class="hl-string">'CostCenter', class="hl-string">'Country', class="hl-string">'PayPeriod', class="hl-string">'PayrollRunType', 
                class="hl-string">'IsAutomated', class="hl-string">'CorrectionReason', class="hl-string">'PayGroup', class="hl-string">'ProcessingTime'
            ]
            event_log_df = event_log_df[column_order]
            
            output_filename = class="hl-string">'workday_payroll_event_log.csv'
            event_log_df.to_csv(output_filename, index=False, date_format=class="hl-string">'%Y-%m-%dT%H:%M:%S.%f%z')
            print(fclass="hl-string">"Event log created successfully: {output_filename}")
            print(fclass="hl-string">"Total events generated: {len(event_log_df)}")
        else:
            print(class="hl-string">"Transformation resulted in an empty event log.")
    else:
        print(class="hl-string">"Extraction failed. No data was retrieved from Workday.")

<?xml version="1.0" encoding="UTF-8"?>
<WorkdayStudioIntegrationAssembly>
  <Configuration>
    <StartDate>[Start date]</StartDate>
    <EndDate>[End date]</EndDate>
    <CompanyFilter>[Company filter]</CompanyFilter>
    <PayGroupFilter>[Pay group filter]</PayGroupFilter>
    <CountryFilter>[Country filter]</CountryFilter>
    <SourceSystem>Workday Payroll</SourceSystem>
    <OutputFormat>CSV</OutputFormat>
    <OutputLocation>[Approved output location]</OutputLocation>
  </Configuration>
  <EventSchema>
    <Column name="PayrollRecordId" required="true" />
    <Column name="ActivityName" required="true" />
    <Column name="EventTimestamp" required="true" />
    <Column name="SourceSystem" required="true" />
    <Column name="LastDataUpdate" required="true" />
    <Column name="PayrollSpecialist" />
    <Column name="CostCenter" />
    <Column name="Country" />
    <Column name="PayPeriod" />
    <Column name="PayrollRunType" />
    <Column name="IsAutomated" />
    <Column name="CorrectionReason" />
    <Column name="PayGroup" />
  </EventSchema>
  <ExtractionBranches>
    <Branch activity="Time Sheet Submitted" source="[Configure based on your system]" />
    <Branch activity="Time Sheet Approved" source="[Configure based on your system]" />
    <Branch activity="Incentive Data Imported" source="[Configure based on your system]" />
    <Branch activity="Payroll Record Created" source="[Configure based on your system]" />
    <Branch activity="Gross Pay Calculated" source="[Configure based on your system]" />
    <Branch activity="Benefits Deductions Applied" source="[Configure based on your system]" />
    <Branch activity="Audit Exception Flagged" source="[Configure based on your system]" />
    <Branch activity="Data Correction Performed" source="[Configure based on your system]" />
    <Branch activity="Payroll Result Previewed" source="[Configure based on your system]" />
    <Branch activity="Payroll Record Approved" source="[Configure based on your system]" />
    <Branch activity="Bank Transfer File Generated" source="[Configure based on your system]" />
    <Branch activity="Pay Slip Published" source="[Configure based on your system]" />
    <Branch activity="Payment Executed" source="[Configure based on your system]" />
    <Branch activity="Tax Filing Completed" source="[Configure based on your system]" />
  </ExtractionBranches>
  <Normalization>
    <Rule target="PayrollRecordId">Map the tenant configured worker and pay period identifiers to one stable payroll record key.</Rule>
    <Rule target="ActivityName">Use the exact activity label defined in EventSchema.</Rule>
    <Rule target="EventTimestamp">Map the explicit source occurrence or status transition timestamp and convert it to ISO 8601.</Rule>
    <Rule target="SourceSystem">Set to Workday Payroll unless the configured source system is explicitly different.</Rule>
    <Rule target="LastDataUpdate">Set to the extraction or source refresh timestamp.</Rule>
    <Rule target="IsAutomated">Set from an explicit source indicator when available. Do not infer it from the activity name.</Rule>
    <Rule target="Deduplication">Use the source event identifier when available. Otherwise use PayrollRecordId, ActivityName, EventTimestamp, and the configured source object identifier.</Rule>
  </Normalization>
  <Validation>
    <RequiredFields>PayrollRecordId,ActivityName,EventTimestamp,SourceSystem,LastDataUpdate</RequiredFields>
    <AllowedActivities>Time Sheet Submitted,Time Sheet Approved,Incentive Data Imported,Payroll Record Created,Gross Pay Calculated,Benefits Deductions Applied,Audit Exception Flagged,Data Correction Performed,Payroll Result Previewed,Payroll Record Approved,Bank Transfer File Generated,Pay Slip Published,Payment Executed,Tax Filing Completed</AllowedActivities>
    <RejectMissingRequiredFields>true</RejectMissingRequiredFields>
  </Validation>
  <Export>
    <Header>PayrollRecordId,ActivityName,EventTimestamp,SourceSystem,LastDataUpdate,PayrollSpecialist,CostCenter,Country,PayPeriod,PayrollRunType,IsAutomated,CorrectionReason,PayGroup</Header>
    <Encoding>UTF-8</Encoding>
    <TimestampFormat>ISO 8601</TimestampFormat>
    <ProcessMindCaseIdentifier>PayrollRecordId</ProcessMindCaseIdentifier>
    <ProcessMindActivityColumn>ActivityName</ProcessMindActivityColumn>
    <ProcessMindTimestampColumn>EventTimestamp</ProcessMindTimestampColumn>
  </Export>
</WorkdayStudioIntegrationAssembly>