Configure a custom report for payroll data in Workday. The Workday external content connector uses this report to make content and metadata from your payroll data searchable.
이 태스크 정보
This task is optional. The Workday external content connector can retrieve payslip data from your Workday source system using a custom report that you configure. If you don't want to retrieve payslip data from Workday, you can skip this task.
프로시저
-
Log in to your Workday tenant with your administrator credentials.
-
Create a new custom report from the Payslip to Print - Report Design standard report.
-
In the Workday search bar, search for the Copy Standard Report to Custom Report task and select it.
-
On the Copy Standard Report to Custom Report page, in the Standard Report field, search for the Payslip to Print - Report Design report and select it.
-
Enter a name for your custom report.
As an example, you might enter Workday connector payslip report.
-
Select OK.
Workday creates your new custom report and displays its configuration screen.
-
In the Data Source field, search for the Payroll Results entry and select it.
Workday automatically populates the Data Source Filter field.
-
Configure the columns for your new custom report.
-
On the Columns tab for your new custom report, in the table, select + to add a row for a new column.
-
Select or enter the following field values for the new column.
-
For each row in the table that has Absence Plans specified as its Business Object, select – to remove the row.
-
Configure the group column headings for your new custom report.
-
In the Group Column Headings table, select – to remove the row that has Absence Plans specified as its Business Object.
-
For each remaining group column header rows, select and delete all text in the Group Column Heading field.
-
Configure the prompts for your new custom report.
-
On the Prompts tab for your new custom report, in the Prompt Defaults table, select – to remove the existing prompt row.
-
Select the Populate Undefined Prompt Defaults option.
Workday automatically populates the Prompt Defaults table with built-in prompts.
-
On the Advanced tab for your new custom report, select the Enable As Web Service option if it's not already selected, then select OK.
Workday saves your configuration changes for your new custom report.
-
Transfer ownership of your new custom report to the integration system user created for the Workday external content connector.
-
From the View Custom Report page, navigate to .
-
On the Transfer Ownership of Custom Reports page, in the New Owner field, enter or select the ISU SNOW ACL integration system user account.
-
Select OK.
-
Generate a sample report using your new custom report and copy its CSV URL.
-
On the View Custom Report page for your new custom report, navigate to .
-
On the View URLs Web Service page, configure a sample report by filling in the fields.
-
Select OK.
Workday displays parameters and URLs for your sample report.
-
Long-press (or right-click) the CSV link and copy the CSV URL.
-
Paste the copied URL into a web browser or a text editor.
The CSV URL has the format https://<hostname>.workday.com/ccx/service/customreport2/<tenant-name>/<report-owner-user-name>/<report-name-alias>. This URL may optionally be followed
by a question mark and one or more URL parameters separated by ampersands. As an example, your CSV URL might be
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef.
-
Copy the base URL for your Workday tenant, your Workday tenant name, the custom report owner's user name, the custom report name alias, and the period date indicator Workday ID (WID).
-
Copy the base URL for your Workday tenant from the pasted CSV URL and store it in a secure location.
The base URL for your
Workday tenant is the
https://<hostname>.workday.com portion of the CSV URL (everything before the third slash character). As an example, if your CSV URL is
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef, the
base URL for your
Workday tenant is
https://wd2-impl-services1.workday.com.
중요사항: Your external content connector admin needs this base URL when configuring the Workday external content connector.
-
Copy the tenant name for your Workday tenant from the pasted CSV URL and store it in a secure location.
The tenant name for your
Workday tenant is the
<tenant-name> portion of the CSV URL (everything between the sixth and seventh slash characters). As an example, if your CSV URL is
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef, your
Workday tenant name is
Example.
중요사항: Your external content connector admin needs this tenant name when configuring the Workday external content connector.
-
Copy the report owner's user name for your custom payslip report from the pasted CSV URL and store it in a secure location.
The report owner's user name for your custom payslip report is the
<report-owner-user-name> portion of the CSV URL (everything between the seventh and eighth slash characters). As an
example, if your CSV URL is
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef, your
custom payslip report owner's user name is
ISU_SNOW_ACL.
중요사항: Your external content connector admin needs this payslip report owner's user name when configuring the Workday external content connector.
-
Copy the report name alias for your custom payslip report from the pasted CSV URL and store it in a secure location.
The report name alias for your custom payslip report is the
<report-name-alias> portion of the CSV URL (everything between the eighth slash character and the question mark or the end of
the URL). As an example, if your CSV URL is
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef, your
custom payslip report name alias is
Workday_connector_payslip_report.
중요사항: Your external content connector admin needs this payslip report name alias when configuring the Workday external content connector.
-
Copy the period date indicator WID (Workday ID) for your custom payslip report from the pasted CSV URL and store it in a secure location.
The period date indicator WID for your custom payslip report is the value of the
Period_Date_Indicator_WID URL parameter from the CSV URL. As an example, if your CSV URL is
https://wd2-impl-services1.workday.com/ccx/service/customreport2/Example/ISU_SNOW_ACL/Workday_connector_payslip_report?Period_Date_Indicator%21WID=e3e3e13f80904ee185eab1fbf331acef, your
period date indicator WID is
e3e3e13f80904ee185eab1fbf331acef.
중요사항: Your external content connector admin needs this period date indicator WID when configuring the Workday external content connector.
다음에 수행할 작업
Provide the following items to the connector admin who creates your
Workday external content connectors:
Your connector admin needs these items to configure a Workday external content connector to retrieve searchable content and metadata from payroll information in your Workday source system.