32 Work with Supplemental Data Reports
You must build a workfile before you can print supplemental data reports. Supplemental data reports are useful when you want to review the data in your supplemental database.
These reports summarize data stored in the following files:
-
Supplemental Database - Core (F01090)
-
Supplemental Database - Code (F01092)
-
Supplemental Database - Narrative (F01093)
This chapter contains these topics:
-
Verify that you have information stored in CIF
32.1 Creating a Workfile
From Address Book (G01), enter 27
From A/B Advanced and Technical Operations (G0131), choose CIF Supplemental Data
From CIF Supplemental Data (G01312), choose Work File Build
Before you can print supplemental data reports, you must use Work File Build to build a workfile that contains address book data.
The supplemental data that exists in your workfile comes from data stored in the Address Book Master and in the Supplemental Database files. This supplemental data is the basis for your reports.
32.2 Printing Supplemental Data Reports
To view a printed version of your supplemental data, you can:
-
Print the Data by Data Type report
-
Print the Data by Address Book report
These are DREAM Writer reports. In addition to using DREAM Writer to create these reports, you can use the World Writer and World Vista reporting programs.
32.2.1 Printing Data by Data Type Report
From Address Book (G01), enter 27
From A/B Advanced and Technical Operations (G0131), choose CIF Supplemental Data
From CIF Supplemental Data (G01312), choose Data by Data Type
Figure 32-2 All Address by Data Type report (1 of 2)
Description of "Figure 32-2 All Address by Data Type report (1 of 2)"
Figure 32-3 All Address by Data Type report (2 of 2)
Description of "Figure 32-3 All Address by Data Type report (2 of 2)"
32.2.3 Data Sequence for Data by Data Type Report
You must sequence your data in one of two ways:
-
All addresses for a record type
-
All information for a record type by address
All Addresses for a Record Type
To print all addresses for a specific record type (for example, all addresses with professional licenses, listed by license), use the following sequence:
-
Type Data - Total Level 02
-
User Defined Code - Total Level 01
-
Address Number
-
Effective Date
-
Line Number
To print record types in alphabetical order, use the following sequence:
-
Type Data - Total Level 02
-
User Defined Code - Total Level 01
-
Alpha Name
-
Address Number
-
Effective Date
-
Line Number
All Information for a Record Type by Address
To print all information for a specific record type by address (for example, licenses held by addresses, listed by address or address emergency contacts), use the following sequence:
-
Type Data - Total Level 02
-
Address Number - Total Level 01
-
User Defined Code
-
Effective Date
-
Line Number
To print record types in alphabetical order, use the following sequence:
-
Type Data - Total Level 02
-
Alpha Name - Total Level 01
-
Address Number
-
User Defined Code
-
Effective Date
-
Line Number
32.2.4 Printing the Data by Address Book Report
From Address Book (G01), enter 27
From A/B Advanced and Technical Operations (G0131), choose CIF Supplemental Data
From CIF Supplemental Data (G01312), choose Data by Address Book
32.2.6 Data Sequence for Data by Address Book Report
You must sequence your data to produce accurate results. To print all addresses in address order, use the following sequence:
-
Address Number
-
Type Data
-
User Defined Code
-
Effective Date
-
Line Number
To print all addresses in alphabetical order, use the following sequence:
-
Alpha Name
-
Address Number
-
Type Data
-
User Defined Code
-
Effective Date
-
Line Number