Difference between extract single instance and extract multiple instance in workday
Answers
http://chennaiacademy.com/workday-hcm-training/
Answer
1
Follow
Request
More
2 ANSWERS

BTS Software Training and Support, Technical Advisor at Bound Tech Solutions (2013-present)
Answered Dec 14

Hi Bound Tech Solutions is the Best place to get Workday Training with Highly Experienced and Integration Certified Consultant.
Workday training teaches outline of organizing in workday, compensation components and types of staffing models.
We present the best Workday Online Training, which has a great leaning in current software industry and helps the learners to develop their knowledge with bright information. Workday consultants are real time Professionals.
We provide training for Workday Finance\Techno functional\Functional. Course duration 35 hours
Course Content
Workday HCM Functional Training
Core concepts and Navigation Basics
Start of Supervisory Organizations
{ Start learning XML and XSLT}
1) Supervisory Organizations
Organization types
Supervisory Organizations
Reorganization
Setup of supervisory org structure
Creating a subordinate org
Dividing a supervisory org
Additional org types
Organization Hierarchies
Organization Assignments on supervisory org
Staffing Models
Types of Staffing Models
Configuring individual staffing model
Hiring Restrictions
Position Management
Headcount Management
Job Management
Differentiating between staffing models
Jobs and Positions
Job Profiles
Differentiating Job profiles, Job families, Job family groups
Creating Positions
Edit Position Restrictions
Compensation
Compensation Components
Creating Compensation
Compensation Rules
Compensation Packages
Compensation Grades
Security Groups
Domain security policies
Business process security policies
Functional Areas, Securable Items and Security Policies
Security Group Types
Configuring Role based security
Configuring Job based security
Configuring User based security
Business Process
Business Process Step types
Business Process Configuration Options
Default
Customize
Completion Steps
Business sub processes
Deploying Business Processes
Transactions in workday
Creating Applicants
Hiring in Supervisory Organizations
Staffing movement
Termination
Request Delegation, Rescind
Reports
Standard Reports
Custom Reports
Report Writer
Data Sources
Class Report fields
Create Report
Report type, Data source
Objects, Fields
Order columns
Sort outputs
Filter criteria
Business Object
Calculated Fields
Creating various kinds of Calculated Fields
Calculated Field Reports
Text functions
Working with Related Business Objects
Extract Single Instance
Extract Multi Instance
System wide vs. Report specific Calculated fields
Integration's in workday
EIB Outbound
Document Transformation
Introduction to Core Connectors
Core Connector: Worker
Sequence Generators
{Send Instructions to download and set up Studio.}
Contd. CCW
ISU
BP configuration for Integration
Configure Delivery and Retrieval
Payroll Interface
Diff B/w Payroll Interface and CCW
Workday Studio
Introduction to Studio
Creating a Simple Studio
Splitter and Aggregator Concept
RAAS Call and Web Service calls
Extract single instance returns a single instance from a Related Business Object. It allows you to extract a single instance type field from a multi-instance type field. Based on the no of instance that satisfy the condition specified on the Related business object.
e.g In worker history, a worker is having these transactions
wid | effdt | action | reason
7488 | 12/1/2019 | Transfer | New Manager
7488 | 12/2/2019 | Assign Org| New Dept
7488 | 12/3/2019 | Promotion | Progression
7488 | 12/12/2018 | Transfer | New Manager
7488 | 11/11/2018 | Transfer | New Assignment
consider this, now you want the effdt of the first transfer for this person i.e. 11/11/2018. How will you get this?
So you need to extract all the transfers first then you need to sort those transfer on the basis of effdt(Ascending ) (consider a SQL query to get the first transfer )
So the condition will be : Action should be transfer ( Create a calculated field to pull the transfer)
Sort field : Effdt
Order : Ascending
Instance to be returned : First
Couple of more example i can give e.g a person is having compensation change of different effdt(s) and you want to pull only the latest effdt compensation change . You can do the same way as explained above
Create a calculated field using the compensation history BO and pull the first occurrence of compensation change
other e.g. a person is having dependents(son, daughter, wife) you want to pull the information of the eldest son, you can use the extract single instance calculated field.
source field will be : Dependents
RBO : dependents
Condition : is-children( create a true/false calculated field for children and children should be son )
Sort field : Age
sort direction : Ascending
instance to be returned : First
Extract Multi Instance returns a multi instance from a RBO. It allows to extract a multiinstance type field from another instance field . Think these as union , except we use in sql queries
e.g In last example of transfer , if you want to pull the information of all the transfer you can use extract multi instance