Outreach Database Listing Report CAS009 (Output)

Contents Show

The Outreach Database Listing Report CAS009 (Output) is a detail report of state outreach agencies. The report is generated when the OK button is clicked on the Generate Outreach Listing Report screen.

Data Elements

This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.

Report Title

When the report is generated within the Central Administrative Site application, the title of the report will be the text "Outreach Listing Report - Agency".

When the report is generated within the State Office application, the title of the report will be the text "Outreach Listing Report - State".

Origin of Data Element

This is a literal value.

Format

The value will print as its literal value.

Outreach Agency County

The value will be the county where the outreach agency is located.

Origin of Data Element

The value will be taken from the CountyCD column of the ORANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Name

The value will be the full name of the outreach agency.

Origin of Data Element

The value will be taken from the Name column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Contact

The value will be the name of the contact for the outreach agency.

Origin of Data Element

The value will be taken from the ContactName column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Telephone Number

The value will be the telephone number for the outreach agency.

Origin of Data Element

The value will be taken from the Telephone1 column of the ORGANIZATION table.

Format

The value will print in the format ###-###-####.

Outreach Agency Address 1

The value will be the mailing address for the outreach agency.

Origin of Data Element

The value will be taken from the Address1 column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Address 2

The value will be the mailing address for the outreach agency.

Origin of Data Element

The value will be taken from the Address2 column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency City

The value will be the city for the outreach agency.

Origin of Data Element

The value will be taken from the City column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Mailing State

The value will be the mailing state for the outreach agency.

Origin of Data Element

The value will be taken from the StateCD column of the ORGANIZATION table.

Format

The value will print as its literal value.

Outreach Agency Mailing ZIP Code

The value will be the mailing ZIP code for the outreach agency.

Origin of Data Element

The value will be taken from the ZIPCODE column of the ORGANIZATION table.

Format

The value will print in #####-#### format.

Filter Criteria

Agency

When the report is generated from within the Central Administrative Site application, Outreach agencies associated with the OrganizationAgency.AgencyID for the selected AgencyID will be included in the report.

Is Outreach Agency

The report contains all Organizations for all Agencies where the Organizations.IsOutreachAgency = "Y".

County

All outreach agencies that are located within the selected county will be included in the report. If the value of 'All' is selected in the County drop-down list box, all counties will be included in the report.

ZIP Code

All outreach agencies that have a ZIP code that matches the one entered by the user will be included in the report. Partial ZIP field selection will be accommodated. For example, entering 802 will provide all ZIP codes beginning with those three numbers. If no ZIP code is entered, all ZIP codes will be included.

Sort Order

County

The report will be sorted first by county.

Outreach Organization/Agency Name

The report will be sorted by outreach organization/agency name within the selected county.

Control Break

County

On a change of a CountyCD, a line break will occur.

Grand Total

No grand totals are defined for this system output.

|

Central Administrative Site