입사부터 퇴직까지의 직원 생애주기 데이터 템플릿

import requests
import pandas as pd
import datetime
import time
import json

class=class="hl-string">"hl-comment"># --- CONFIGURATION --- #
UKG_BASE_URL = class="hl-string">"https://service[YourServiceNumber].ultipro.com/api"
API_KEY = class="hl-string">"[Your_API_Key]"
USERNAME = class="hl-string">"[Your_Service_Account_Username]"
PASSWORD = class="hl-string">"[Your_Service_Account_Password]"
COMPANY_ID = class="hl-string">"[Your_Company_ID]"
START_DATE = (datetime.date.today() - datetime.timedelta(days=180)).strftime(class="hl-string">'%Y-%m-%d')
END_DATE = datetime.date.today().strftime(class="hl-string">'%Y-%m-%d')

class=class="hl-string">"hl-comment"># --- API HELPER FUNCTION --- #

def get_ukg_data(endpoint, params=None):
    class="hl-string">"""Helper function to handle authentication and pagination for UKG API calls."""
    auth_data = json.dumps({
        class="hl-string">"username": USERNAME,
        class="hl-string">"password": PASSWORD,
        class="hl-string">"apiKey": API_KEY
    })
    headers = {class="hl-string">'Content-Type': class="hl-string">'application/json'}
    
    class=class="hl-string">"hl-comment"># Authenticate and get token
    try:
        auth_response = requests.post(fclass="hl-string">"{UKG_BASE_URL}/v1/login", data=auth_data, headers=headers)
        auth_response.raise_for_status()
        token = auth_response.json().get(class="hl-string">'token')
    except requests.exceptions.RequestException as e:
        print(fclass="hl-string">"Authentication failed: {e}")
        return []

    all_records = []
    page = 1
    per_page = 100
    
    api_headers = {class="hl-string">'Authorization': fclass="hl-string">'Bearer {token}'}
    
    while True:
        if params is None:
            params = {}
        params.update({class="hl-string">'page': page, class="hl-string">'per_page': per_page})
        
        try:
            response = requests.get(fclass="hl-string">"{UKG_BASE_URL}{endpoint}", headers=api_headers, params=params)
            response.raise_for_status()
            data = response.json()
            
            if isinstance(data, list) and data:
                all_records.extend(data)
                if len(data) < per_page:
                    break class=class="hl-string">"hl-comment"># Last page
                page += 1
            elif isinstance(data, dict) and class="hl-string">'results' in data:
                all_records.extend(data[class="hl-string">'results'])
                if len(data[class="hl-string">'results']) < per_page:
                    break class=class="hl-string">"hl-comment"># Last page
                page += 1
            else:
                 break class=class="hl-string">"hl-comment"># No more data

            time.sleep(1) class=class="hl-string">"hl-comment"># Respect rate limits

        except requests.exceptions.RequestException as e:
            print(fclass="hl-string">"Error fetching data from {endpoint}: {e}")
            break
            
    return all_records

class=class="hl-string">"hl-comment"># --- ACTIVITY EXTRACTION FUNCTIONS --- #

def get_employee_hired_events():
    print(class="hl-string">"Fetching 'Employee Hired' events...")
    events = []
    class=class="hl-string">"hl-comment"># Use employee changes API to find hire events
    params = {class="hl-string">'action': class="hl-string">'HIRE', class="hl-string">'effectiveDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/personnel/v1/employee-changes', params=params)
    for record in data:
        if record.get(class="hl-string">'effectiveDate') and record.get(class="hl-string">'effectiveDate') <= END_DATE:
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Employee Hired',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmployeeDepartment': record.get(class="hl-string">'department'),
                class="hl-string">'JobRequisitionId': record.get(class="hl-string">'jobRequisitionId'),
                class="hl-string">'EmploymentStatus': record.get(class="hl-string">'employmentStatus'),
                class="hl-string">'JobTitle': record.get(class="hl-string">'jobTitle'),
                class="hl-string">'ManagerName': record.get(class="hl-string">'supervisorName'),
                class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
            })
    return events

def get_onboarding_events():
    print(class="hl-string">"Fetching 'Onboarding' events...")
    events = []
    class=class="hl-string">"hl-comment"># Note: Requires Onboarding module. This is a conceptual endpoint.
    class=class="hl-string">"hl-comment"># You may need to adjust the endpoint based on your UKG configuration.
    data = get_ukg_data(fclass="hl-string">'/onboarding/v1/employee-onboarding-activities?start-date={START_DATE}&end-date={END_DATE}')
    for record in data:
        if record.get(class="hl-string">'workflow') == class="hl-string">'New Hire Onboarding':
            if record.get(class="hl-string">'dateAssigned'):
                events.append({
                    class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                    class="hl-string">'ActivityName': class="hl-string">'Onboarding Initiated',
                    class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateAssigned'),
                    class="hl-string">'ActioningUser': record.get(class="hl-string">'assignedBy'),
                    class="hl-string">'EmployeeDepartment': record.get(class="hl-string">'department'),
                    class="hl-string">'JobTitle': record.get(class="hl-string">'jobTitle'),
                    class="hl-string">'ManagerName': record.get(class="hl-string">'managerName'),
                    class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
                })
            if record.get(class="hl-string">'dateCompleted'):
                events.append({
                    class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                    class="hl-string">'ActivityName': class="hl-string">'Employee Onboarded',
                    class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateCompleted'),
                    class="hl-string">'ActioningUser': None,
                    class="hl-string">'EmployeeDepartment': record.get(class="hl-string">'department'),
                    class="hl-string">'JobTitle': record.get(class="hl-string">'jobTitle'),
                    class="hl-string">'ManagerName': record.get(class="hl-string">'managerName'),
                    class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
                })
    return events

def get_payroll_setup_events():
    print(class="hl-string">"Fetching 'Payroll Setup Completed' events...")
    events = []
    class=class="hl-string">"hl-comment"># Inferring this from direct deposit creation date
    params = {class="hl-string">'dateTimeCreated': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/personnel/v1/employees/direct-deposit', params=params)
    processed_employees = set()
    for record in data:
        if record.get(class="hl-string">'employeeId') not in processed_employees and record.get(class="hl-string">'dateTimeCreated') <= END_DATE:
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Payroll Setup Completed',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateTimeCreated'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'userWhoModified'),
                class="hl-string">'EmploymentStatus': record.get(class="hl-string">'employeeStatus')
            })
            processed_employees.add(record.get(class="hl-string">'employeeId'))
    return events

def get_training_assigned_events():
    print(class="hl-string">"Fetching 'Training Assigned' events...")
    events = []
    class=class="hl-string">"hl-comment"># Note: Requires Learning module.
    params = {class="hl-string">'assignmentDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/learning/v1/enrollments', params=params)
    for record in data:
        if record.get(class="hl-string">'assignmentDate') <= END_DATE:
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employee').get(class="hl-string">'id'),
                class="hl-string">'ActivityName': class="hl-string">'Training Assigned',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'assignmentDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'assignedBy').get(class="hl-string">'name'),
                class="hl-string">'JobTitle': record.get(class="hl-string">'employee').get(class="hl-string">'jobTitle')
            })
    return events

def get_performance_review_events():
    print(class="hl-string">"Fetching 'Performance Review' events...")
    events = []
    class=class="hl-string">"hl-comment"># Note: Requires Performance Management module.
    params = {class="hl-string">'completionDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/performance/v1/reviews', params=params)
    for record in data:
        if record.get(class="hl-string">'completionDate') <= END_DATE:
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employee').get(class="hl-string">'id'),
                class="hl-string">'ActivityName': class="hl-string">'Performance Review Conducted',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'completionDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'manager').get(class="hl-string">'name'),
                class="hl-string">'ManagerName': record.get(class="hl-string">'manager').get(class="hl-string">'name')
            })
    return events

def get_job_change_events():
    print(class="hl-string">"Fetching job and compensation change events...")
    events = []
    params = {class="hl-string">'effectiveDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/personnel/v1/employee-changes', params=params)
    for record in data:
        if record.get(class="hl-string">'effectiveDate') > END_DATE: continue

        action = record.get(class="hl-string">'action', class="hl-string">'').upper()
        reason = record.get(class="hl-string">'reason', class="hl-string">'').upper()
        
        if action == class="hl-string">'PROMOTION' or reason == class="hl-string">'PROMOTION':
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Promotion Approved',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'JobTitle': record.get(class="hl-string">'jobTitle'),
                class="hl-string">'ManagerName': record.get(class="hl-string">'supervisorName')
            })

        if action == class="hl-string">'TRANSFER' or reason == class="hl-string">'TRANSFER' or reason == class="hl-string">'REASSIGNMENT':
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Role Change Processed',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmployeeDepartment': record.get(class="hl-string">'department'),
                class="hl-string">'JobTitle': record.get(class="hl-string">'jobTitle')
            })

        if record.get(class="hl-string">'isPayRateChanged') == class="hl-string">'true':
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Compensation Changed',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmploymentStatus': record.get(class="hl-string">'employmentStatus')
            })

        if record.get(class="hl-string">'isSupervisorChanged') == class="hl-string">'true':
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Manager Changed',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'ManagerName': record.get(class="hl-string">'supervisorName')
            })
    return events

def get_leave_events():
    print(class="hl-string">"Fetching 'Leave of Absence' events...")
    events = []
    params = {class="hl-string">'action': class="hl-string">'LEAVE', class="hl-string">'effectiveDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/personnel/v1/employee-changes', params=params)
    for record in data:
        if record.get(class="hl-string">'effectiveDate') and record.get(class="hl-string">'effectiveDate') <= END_DATE:
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Leave of Absence Started',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmploymentStatus': record.get(class="hl-string">'employmentStatus'),
                class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
            })
    return events

def get_termination_events():
    print(class="hl-string">"Fetching 'Termination' events...")
    events = []
    params = {class="hl-string">'action': class="hl-string">'TERM', class="hl-string">'effectiveDate': fclass="hl-string">'ge {START_DATE}'}
    data = get_ukg_data(class="hl-string">'/personnel/v1/employee-changes', params=params)
    for record in data:
        if record.get(class="hl-string">'effectiveDate') and record.get(class="hl-string">'effectiveDate') <= END_DATE:
            class=class="hl-string">"hl-comment"># Termination Initiated is when the record is created, Terminated is the effective date
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Termination Initiated',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateCreated'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmploymentStatus': record.get(class="hl-string">'employmentStatus'),
                class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
            })
            events.append({
                class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                class="hl-string">'ActivityName': class="hl-string">'Employee Terminated',
                class="hl-string">'EventTimestamp': record.get(class="hl-string">'effectiveDate'),
                class="hl-string">'ActioningUser': record.get(class="hl-string">'changedByUserName'),
                class="hl-string">'EmploymentStatus': class="hl-string">'Terminated',
                class="hl-string">'HireDate': record.get(class="hl-string">'hireDate')
            })
    return events

def get_offboarding_events():
    print(class="hl-string">"Fetching 'Offboarding' events...")
    events = []
    class=class="hl-string">"hl-comment"># Note: Requires Onboarding module for offboarding checklists.
    class=class="hl-string">"hl-comment"># Conceptual endpoint, may need adjustment.
    data = get_ukg_data(fclass="hl-string">'/onboarding/v1/employee-onboarding-activities?start-date={START_DATE}&end-date={END_DATE}')
    for record in data:
        if record.get(class="hl-string">'workflow') == class="hl-string">'Employee Offboarding':
            if record.get(class="hl-string">'stepName') == class="hl-string">'Exit Interview' and record.get(class="hl-string">'dateCompleted'):
                events.append({
                    class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                    class="hl-string">'ActivityName': class="hl-string">'Exit Interview Conducted',
                    class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateCompleted'),
                    class="hl-string">'ActioningUser': record.get(class="hl-string">'completedBy')
                })
            if record.get(class="hl-string">'dateCompleted') and record.get(class="hl-string">'isWorkflowComplete'):
                events.append({
                    class="hl-string">'EmployeeId': record.get(class="hl-string">'employeeId'),
                    class="hl-string">'ActivityName': class="hl-string">'Offboarding Completed',
                    class="hl-string">'EventTimestamp': record.get(class="hl-string">'dateCompleted'),
                    class="hl-string">'ActioningUser': None
                })
    return events

class=class="hl-string">"hl-comment"># --- MAIN EXECUTION --- #
if __name__ == class="hl-string">"__main__":
    all_events = []
    last_data_update = datetime.datetime.utcnow().isoformat() + class="hl-string">'Z'

    class=class="hl-string">"hl-comment"># Collect events from all functions
    all_events.extend(get_employee_hired_events())
    all_events.extend(get_onboarding_events())
    all_events.extend(get_payroll_setup_events())
    all_events.extend(get_training_assigned_events())
    all_events.extend(get_performance_review_events())
    all_events.extend(get_job_change_events())
    all_events.extend(get_leave_events())
    all_events.extend(get_termination_events())
    all_events.extend(get_offboarding_events())

    if not all_events:
        print(class="hl-string">"No events found for the specified period. Exiting.")
    else:
        class=class="hl-string">"hl-comment"># Create DataFrame
        df = pd.DataFrame(all_events)
        
        class=class="hl-string">"hl-comment"># Add required static columns
        df[class="hl-string">'SourceSystem'] = class="hl-string">'UKG Pro'
        df[class="hl-string">'LastDataUpdate'] = last_data_update
        
        class=class="hl-string">"hl-comment"># Standardize and clean up
        df = df.rename(columns={class="hl-string">'employeeId': class="hl-string">'EmployeeId', class="hl-string">'activityName': class="hl-string">'ActivityName', class="hl-string">'eventTimestamp': class="hl-string">'EventTimestamp'})
        df[class="hl-string">'EventTimestamp'] = pd.to_datetime(df[class="hl-string">'EventTimestamp']).dt.strftime(class="hl-string">'%Y-%m-%dT%H:%M:%S.%f')[:-3] + class="hl-string">'Z'
        df = df.sort_values(by=[class="hl-string">'EmployeeId', class="hl-string">'EventTimestamp'])
        
        class=class="hl-string">"hl-comment"># Reorder columns for clarity
        column_order = [
            class="hl-string">'EmployeeId', class="hl-string">'ActivityName', class="hl-string">'EventTimestamp', class="hl-string">'SourceSystem', class="hl-string">'LastDataUpdate',
            class="hl-string">'ActioningUser', class="hl-string">'EmployeeDepartment', class="hl-string">'JobRequisitionId', class="hl-string">'EmploymentStatus',
            class="hl-string">'JobTitle', class="hl-string">'ManagerName', class="hl-string">'HireDate'
        ]
        df = df.reindex(columns=column_axist)

        class=class="hl-string">"hl-comment"># Save to CSV
        output_filename = class="hl-string">'ukg_hire_to_retire_event_log.csv'
        df.to_csv(output_filename, index=False)
        print(fclass="hl-string">"\nExtraction complete. Event log saved to {output_filename}")