List active employees as of a given date, optionally scoped to a department.

KNOWN ISSUE: The /ClientOut/ReportCenter/ActiveEmployeeData route returns 404 on the PRE Foundation backend. The tool is kept for when MAYO deploys the Report Center endpoints to this environment.

List employees who resigned or took leave within a date range.

KNOWN ISSUE: The /ClientOut/ReportCenter/ResignAndLeaveData route returns 404 on the PRE Foundation backend. The tool is kept for when MAYO deploys the Report Center endpoints to this environment.

Get the organization hierarchy as of a specific date.

KNOWN ISSUE: The /ClientOut/ReportCenter/OrgData route returns 404 on the PRE Foundation backend. The tool is kept for when MAYO deploys the Report Center endpoints to this environment.

Export effective organization units together with their employees (OM + PA).

Export effective employee master data (core fields only).

Export effective department master data (core fields only).

Export effective organization master data with all fields (OM endpoint).

Export effective employee data with every PA field. Supports many optional filters.

Export effective employee expatriation (外派/派駐) assignments.

Export all employees' work-experience records.

Export all employees' education records.

Export employee change orders within a date range (paginated).

Export organization change orders within a date range (paginated).

Export reference code tables used by the People+ (PA) module.

Export the custom field definitions configured by the tenant.

Get each employee's base attendance configuration as of a given date.

Returns the shift, rest-day rule, and attendance-group information that applies to every active employee on search_date.

Get raw clock-in / clock-out records across all employees within a date range.

Get attendance exceptions (late, early leave, missed punch, etc.) within a date range.

Get manually-added or corrected clock-in records within a date range.

Get approved and pending leave applications within a date range (leave_historyV2).

Get each employee's assigned shift calendar (work day / rest day / holiday) for a range.

Get approved overtime records within a date range.

Get business trip / field-work records within a date range.

KNOWN ISSUE: This endpoint is marked as failing upstream in MAYO's own Postman collection. Expect a server-side error response until MAYO fixes it.

Get the monthly labor insurance (勞保) detail list for an insurance unit.

KNOWN ISSUE: This endpoint is marked as failing upstream in MAYO's own Postman collection. Expect a server-side error response until MAYO fixes it.

Get the monthly National Health Insurance (健保) detail list for a unit.

KNOWN ISSUE: This endpoint is marked as failing upstream in MAYO's own Postman collection. Expect a server-side error response until MAYO fixes it.

Get the monthly labor pension (勞退) detail list for a unit.

KNOWN ISSUE: This endpoint is marked as failing upstream in MAYO's own Postman collection. Expect a server-side error response until MAYO fixes it.

Get per-employee salary insurance contribution detail for a given date.

Get the salary and bonus distribution roster across a month range.

Accepts ISO-style YYYY-MM input (or a full YYYY-MM-DD, which is truncated to its month) and sends MAYO's expected YYYY/MM format internally.

Aggregate one employee's master, work history, and education into a single profile.

Calls PA (filtered by employee_number) plus the company-wide Working and Education exports, then filters the latter two down to the target employee. Useful when an assistant needs a complete picture without having to call three raw tools and join the results.

Capture the organization tree and active headcount as of a specific date.

Combines organization_tree (OrgData) with active_employees (ActiveEmployeeData) so one call returns both the org hierarchy and the people staffed against it on that day.

KNOWN ISSUE: Both underlying Report Center routes currently 404 on the PRE Foundation backend. This composite tool will light up once MAYO redeploys those endpoints.

Build a consolidated attendance picture for a date range.

Fans out to attendance_history plus optional attendance_abnormal, overtime_records, and leave_history, returning each section under a dedicated key.

List active employees as of a date, defaulting to today when as_of_date is omitted.

KNOWN ISSUE: Wraps /ClientOut/ReportCenter/ActiveEmployeeData, which currently returns 404 on the PRE Foundation backend.

Get the salary and bonus distribution roster for a single month.

Accepts ISO YYYY-MM (or YYYY-MM-DD, truncated) and converts to MAYO's required YYYY/MM format. Use the raw get_salary_bonus_list tool when you need a multi-month range.