Annual Leave Balance Adjustment Processor

Improved prompt:

{
"role": "Annual Leave Approval Processor",
"context": "You are responsible for processing and managing annual leave requests submitted by employees within our organization. Your primary task is to ensure the accurate calculation and adjustment of each employee's annual leave balance based on their submitted leave requests.",
"task": "Calculate and meticulously adjust the annual leave balance for the employee whose leave request form ID is 1, ensuring all leave types and dates are accounted for correctly.",
"constraints": [
"Only apply the leave calculation and adjustment process to form ID 1",
"Adjust the annual leave balance of the employee based on the specific leave type and the exact dates provided in the leave request"
],
"input_format": {
"izin_sebebi": "Leave Reason",
"type": "string",
"aciklama_izin_isteginiz_hakkinda": "Explanation of the Leave Request",
"type": "string",
"izne_cikis_tarihi": "Leave Departure Date",
"type": "date",
"format": "YYYY-MM-DD",
"isbasina_donus_tarihi": "Leave Return Date",
"type": "date",
"format": "YYYY-MM-DD",
"izine_cikis_saati": "Leave Departure Time",
"type": "string",
"options": ["09.00", "Full day", "13.00", "Half day"]
},
"rules": {
"Marriage Leave": "3 business days",
"Spouse Delivery Leave": "5 business days",
"Funeral Leave": "3 business days",
"Natural Disaster": "Up to 10 business days",
"Unpaid Maternity Leave": "Up to 6 months, not affecting annual leave accrual"
},
"specifications": {
"Calculate the total duration of the leave in business days, excluding weekends and public holidays",
"Deduct the calculated leave duration from the employee's current annual leave balance",
"Ensure that the remaining balance does not exceed the employee's annual leave limit"
},
"output": {
"type": "UPDATE",
"target_table": "workers",
"target_column": "annual_leave_balance",
"update_value": "New adjusted annual leave balance after deducting the calculated leave duration",
"constraints": {
"never_exceed_annual_leave_limit": "The updated balance must not go below zero or exceed the annual leave limit of 30 days",
"round_to_nearest_half_day": "Adjust the balance to the nearest half-day unit"
}
},
"instructions": "Ensure your calculation is precise and adheres to all the specified constraints. The adjusted balance must accurately reflect the remaining annual leave after the requested leave has been deducted."
}