Integrations - Sequence Generator

Sequence Generator

While producing an output file for your vendor or third party system, you don't want to send same file name all the time. Sequence Generator is used to generate a unique, sequenced number each time you run and produce an output file.

For Example your file name looks like - WorkdayDemog.csv and your vendor needs this file every day two times, then with the same file name it will add to more confusion to identify.

If we make using Sequence Generator to the above example you can generate the file name say WorkdayDemog0109112019124039.csv

This represents:

              WorkdayDemog is the file name,               01 is the sequence ,               09112019 is the date,              124039 being the time HHMMSS

The Sequence generator can be used in EIB , Core Connectors or Studio integrations.

If a process generates multiple requests for the next sequence number very close together:

·        Workday attempts to generate the sequence numbers.

·        Workday can generate skipped, nonconsecutive numbers.

Tasks you can use to create, edit and view sequence generators for EIB :

Create ID Definition / Sequence Generator (Also see View and Edit)

Integration System > Configure Integration Sequence Generators 

Below are the detailing of the field while 

Last Number Used- Manually sets the last sequence number. This option is useful if you previously used a different ID generator and you want to continue from where the ID ended. When you set the number, the initial sequence number will be your number plus the Increment by value.

Last Date Used- Specify this date, plus an interval for Restart Every to determine whether the date is before or after the last restart interval. Then Workday sets the sequence number based on the date.

Increment by- Specify the value to increment sequence numbers by.

Restart Every -Specify how often Workday resets the sequence numbers.

Restart Based on Time Zone- The standard time zone is Pacific Standard Time/Pacific Daylight Time (PST/PDT). To use a different time zone for the file generation date and time used in the Format/Syntax field, select the time zone from the prompt.

This value doesn't affect when the event actually occurs. Use this prompt only to localize the date for display purposes.

Restart at Number- Specify the number Workday uses when restarting sequence numbers. To use this field, you set the Restart Every value.

Padding with '0'- To pad sequence numbers, specify the number of zeros that Workday uses to pad each sequence number.

Format/Syntax- Define the filename format by entering:

o A string constant.

o A pattern for the date and time.

o A sequence number pattern.

o The file extension.

Workday can dynamically generate only date values and a sequence number for use in the filename. Any other values are static; they're identical for all files generated by the integration. Hold your cursor over this field to see the full list of valid sequence generator and date/time patterns.