CIPHR Integration

Upload CIPHR holiday data files and review processed data with automated conflict detection and status tracking.

Who can use this feature

Role	Upload Files	Review Data	Resolve Conflicts	Export Data
Admin	✓	✓	✓	✓
Ops Support	✓	✓	✓	✓
Ops Manager	✓	✓	✓	✓

File Upload

Supported File Types

• File formats: .xlsx files up to 10MB
• Upload method: Drag and drop or click to browse
• Processing: Files are automatically processed after upload

Upload Process

1. Drag file to upload area or click “Drop your file here, or click to browse”
2. Select .xlsx file (max 10MB)
3. Click “Upload” button
4. System processes file and displays results in CIPHR Data Review section

CIPHR Data Review

Data Table Columns

• Employee Name: Staff member name from CIPHR data
• Absence Type: Type of absence (e.g., “Absence”)
• Start Date: Absence start date
• End Date: Absence end date
• CIPHR Status: Processing status with color coding
• Schedule Status: Conflict status with existing schedules
• Line Manager: Assigned manager for the employee

Status Indicators

CIPHR Status:

• Pending Awaiting processing
• Approved Successfully processed

Schedule Status:

• Conflict Conflicts with existing schedule
• Verified by CIPHR: No scheduling conflicts detected

Current Data Examples

Employee	Dates	CIPHR Status	Schedule Status	Manager
George Davies	Aug 12-26, 2026	Pending	Conflict	Freya Turner
Grace Mason	Nov 18, 2025	Approved	Verified	Oliver Bennett
George Davies	Oct 22-26, 2025	Approved	Verified	Freya Turner

Conflict Resolution

Handling Conflicts

• Conflict Detection: System automatically identifies scheduling conflicts
• Status Filtering: Use “Filter by CIPHR status” to focus on conflicts
• Manual Review: Review conflicted entries and resolve manually
• Manager Coordination: Contact line managers for conflict resolution

Best Practices

CIPHR Integration Tips

• File Format: Ensure CIPHR exports are in .xlsx format
• Regular Uploads: Process CIPHR data regularly to minimize conflicts
• Conflict Resolution: Address conflicts promptly to maintain schedule accuracy
• Manager Communication: Coordinate with line managers on scheduling conflicts

Troubleshooting

Upload Issues

• Check file is .xlsx format and under 10MB
• Ensure stable internet connection
• Try refreshing page and uploading again

Data Not Appearing

• Wait for file processing to complete
• Check if file contains valid CIPHR data
• Refresh page to see updated results