Create a Simple Application Data Set

Application Data Sets are objects that relate data through a common key. The data is organized by a primary key so that parent-child relationships as there must be common keys. We'll walk through the steps to create a simple ADS with three tables: one parent record and two child records.

Create the Application Data Set

1. Navigate to PeopleTools > Lifecycle Tools > Migrate Data > Data Set Designer.
2. Click the Add tab.
3. Enter "Z_BEN_PLAN" for the new Data Set Name and "Benefits Plan" for the Description
4. Click the Add button.
5. Click the "Add Record to Root" link.
6. Select BENEF_PLAN_TBL for the Record Name.

7. Click OK.

   If the record has a Related Language table defined, the Data Set Designer will automatically include the associate language record in the ADS.

8. Select the "Is Copyable" option.

9. Click the Save button.

   You will receive a warning that data will be in clear text when copied to file. You can click "Yes" to dismiss the warning.

Add Child Records

You have created a new Data Set. You can easily add child records to the Data Set.

1. Click on the Root Record name in the Data Set Description box.

2. Click the "Record Details" icon to view the key structure for our record.

   This display shows the key fields for "BENEF_PLAN_TBL" as PLAN_TYPE, BENEFIT_PLAN and EFFDT. When we add child records our search view will be limited to records who key structure matches our root record.

3. Click OK to dismiss the Record Details screen.

4. Click on the "Insert Record" icon to add a child record.
5. Click on the lookup icon to view all the records with key structures that match our root record "BENEF_PLAN_TBL".