Transcript eGovernment Working Group Electronic Customer Statement Release U.S. Department of Agriculture eGovernment Program

U.S. Department of Agriculture
eGovernment Program
eGovernment Working Group
Electronic Customer Statement Release
March 10, 2004
U.S. Department of Agriculture eGovernment Program
Agenda

 Welcome
 Customer Statement Demonstration
 Q&A and Next Steps
2
Customer Statement Overview
USDA Customer Statement
“The computer has already taken its place
next to the plowshare and tractor as
indispensable to farmers.”
-Anne Veneman, Jan 12, 2004
Farm Bureau Convention, Honolulu, HI
4
What is the Customer Statement?
Secretary Veneman on January 12th in her Remarks to
The American Farm Bureau Federation 85th Annual
Conference described the Customer Statement as:
"Another feature [of my.USDA] will put a whole range of USDA
services and programs into a single report at the fingertips of
individual farmers.
"For instance, farmers will be able to view their contracts in
various conservation programs, their payments under
commodity programs and information on loans and crop
insurance.
"Data can be cross-referenced with interactive maps of farm
operations using geographic information systems, or what is
commonly referred to as GIS technology with overlays for roads,
soil types, water and other geographic features.
"Producers will also have quick and easy access, in a single
gateway, to the volumes of maps and geospatial data generated
by USDA.”
5
Veneman Launches eGOV Initiatives To Meet The Needs
Of USDA Customers - USDA Web site Gets New Look
WASHINGTON, January 12, 2004 – Agriculture Secretary Ann M. Veneman today announced that eGovernment
initiatives would be a special focus of the U.S. Department of Agriculture in 2004.
•
"Veneman said that beginning today, visitors to the USDA website, www.usda.gov, will begin to see a new design,
which is the first phase in efforts to make the website a more powerful and improve access to USDA information
and science.
•
The new look will be followed by improved functionality," Veneman said. "We will continue adding features for
users, culminating in August with the launch of 'MyUSDA.gov' to provide a customized version of the USDA
homepage for individual users based on their unique needs."
Other features that users will see soon include a "customer
statement." Customer statements will put a whole range of
USDA services and programs into a single report at the
fingertips of agricultural producers. For instance, farmers
would be able to view their contracts in various conservation
programs, payments under commodity programs and information
on loans and crop insurance.
Veneman said that farmers and ranchers will even be able to cross-reference that data with interactive maps of
their operations using geographic information systems, or GIS, technology with overlays for roads, soil types,
water and other geographic features.
"Producers will have quick and easy access in a single gateway to the volumes and volumes of maps and
geospatial data generated by USDA," Veneman said. "Instead of traveling to a county office, farmers and
ranchers will be able to log on from a computer to apply for loan deficiency payments over the Internet. The goal
is to provide integrated service around customer needs…..
6
Goals--to provide integrated service
around customer needs
• Integrate with my.USDA portal
• Provides USDA customers’ “One-Stop” access to
USDA program participation information – their
Bank Statement with USDA
• Leverage USDA investment in eGovernment and
support more efficient operations (uses
eAuthenication User ID and password)
• Provide quick and easy access to data from
multiple USDA agencies in a single report
• Look and Feel of new USDA.gov
7
Features of the Summary Statement
– Address or contact information (USDA ID)
– Farm Bill Conservation Contracts (limited number of
programs) (FSA and NRCS)
– Commodity Payments from FSA Data Warehouse
(FSA)
– Links to Conservation Plan data (NRCS)
– Drill down capability for some components of
Statement into contract and Payment Data
warehouses
– Address and contact information for Service Centers
8
Additional Features
• “Maps and Data” link for simple interactive viewing
of Ortho maps in Geospatial Data Warehouse
• Conservation Plan Data from NRCS’s National
Conservation Planning Database
• Farm Loan Data (FSA)
• PDF Version of Customer Statement Report
9
Target Features for April-June
(3rd Quarter) Releases
• User profile management
• Customize content
• Allow producer to grant access to other parties
based on USDA ID
• Crop Insurance Summary
• Farm Bill Conservation Contracts (additional
programs)
• RESNOD Collection (pending approval)
10
Target Features for July-September
(4rd Quarter) Releases
• Integrate with My.USDA.gov
• Enhanced Maps and Data links
• Integrated Tools such as Farm Loan Calculator
• FSA Enhanced DOQ’s and Land Unit
• More TBD
11
Customer Statement “Spotlight”
on USDA Home Page
12
Customer Statement Home Page
In January, Agriculture Secretary Ann M. Veneman today announced that e
Government initiatives would be a special focus of the U.S. Department of
Agriculture in 2004. The USDA Customer Statement is part of this effort and
brings to the farmer un-precedented access to their business activities with
USDA 24 hours a day, 7 days a week. The Customer Statement, "will put a
whole range of USDA services and programs into a single report at the
fingertips of agricultural producers.“
The Customer Statement allows farmers to view (a) their participation and
application status in various conservation programs, (b)payments
associated with commodity and conservation programs, (c)information on
farm loans and crop insurance, and (d) conservation plan and land unit
information. The Customer Statement will be a focal point for providing
farm producers access to their USDA information and facilitate doing online
business with USDA.
New USDA
“Look and
Feel”
13
Customer Statement will be accessed
using secure login/password
In January, Agriculture Secretary Ann M. Veneman today announced that e
Government initiatives would be a special focus of the U.S. Department of
Agriculture in 2004. The USDA Customer Statement is part of this effort and
brings to the farmer un-precedented access to their business activities with
USDA 24 hours a day, 7 days a week. The Customer Statement, "will put a
whole range of USDA services and programs into a single report at the
fingertips of agricultural producers.“
The Customer Statement allows farmers to view (a) their participation and
application status in various conservation programs, (b)payments associated
with commodity and conservation programs, (c)information on farm loans and
crop insurance, and (d) conservation plan and land unit information. The
Customer Statement will be a focal point for providing farm producers access
to their USDA information and facilitate doing online business with USDA.
In the future, Veneman said that farmers and ranchers will even be able to
cross-reference that data with interactive maps of their operations using
geographic information systems, or GIS, technology with overlays for roads,
soil types, water and other geographic features. New features will be added to
the Customer Statement weekly as they are developed.
Confidentiality is a key feature of the Customer Statement. Just link your
bank, only you or someone your authorize (using your USDA ID) will be able
to see your Statement and your business transactions with USDA.
Customer uses
eAuthenticatio
n
login/password
14
Customer Statement (CS) Process Diagram
Customer
Learns about Customer
Statement from USDA
Home Page
Completes Online Level 2
eAuthenication request for
User Id and password
Goes to USDA Office for
identity check
Logs into Customer
Statement from CS Home
Page
Service Center
Identity Checks Customer and
activates Level 2 Account
Service Center links eAuth
account to customer database
(ie SCIMS)
Customer Statement and
Agency Systems
Email Confirming Level
2 Account
Customer Statement
system issues USDA ID
Email to Customer
confirming account
activation
FSA Payment
Data
Warehouse
Sets up Customer Profile
USDA ID
Database
Geospatial
Data
Warehouse
Views Statement
FSA Farm
Loans
NRCS
POINTS Data
Warehouse
15
Statement Components
•Address and Contact Information
•Conservation Contract Information
(ie EQIP, AMA, EQIP)
•Account Summary of Payments
•Crop Insurance
•Land Unit Data
•Customer Loans
•Service Center Contacts
16
Customer Statement
Provides Conservation
Program data:
•Contract amounts
•Payments
•Contract balances
17
Customer Statement (more)
Commodity and
Conservation Payments
(FSA Data Warehouse)
18
Customer Statement (more)
Conservation Plan Data
Farm Loan Program
data
19
Maps and Data linked to Customer
Farm Map Data
20
USDA ID Business Cards
U.S. Department of Agriculture
James Smith
123 Peighton Place
Jefferson City, MO 20406
USDA Customer Identifier for Online Systems:
184-FHT
When to use this Customer Identifier:
• Contains User ID (License Plate Coding)
• Facilitates exchange of USDA ID with
offices, partners, Technical Service
Providers for data tracking
•Provides incentive to keep information
current
Sandy Farmer
USDA-id: 437-FXB
1. When you first establish you’re My.USDA personal web site, you
will be asked to enter this USDA Customer Identifier.
2. When beginning to do business with a USDA agency or
participating in a new USDA program, you should provide this
USDA Customer ID. If the agency/program records your USDA
ID, the information from that program can be accessed through
your My.USDA web account.
3. If you want to grant permission in a USDA online system for
another customer (spouse, employee, partner, bank loan
officer, etc.) to be able to view your data, you will need to enter
that person’s USDA ID on the appropriate screen. The USDA
ID provides a means for you to identify a USDA customer
without having to ask for personal information such as Social
Security Number or Tax ID number.
4. If your USDA Customer Identifier is attached to a particular
agency or program, changes you make online to your personal
data (name, address, phone number, email address, etc.) using
your My.USDA web site, can be automatically communicated to
all attached systems.
Sandy Farmer
123 Shady Lane
Eden, ID 70523
907.721.1538 (day)
[email protected]
21
Additional Maps and Data Features
22
In August Customer Statement will
leverage My.USDA.gov Portal
23
USDA CUSTOMERS
Version 4
January 23, 2004
USDA Customer Database
USDA Customer Demographics
(RSNOD)
USDA Customer Demographics
USDA Customer ID
Gender Code
Customer Declined Indicator
Last Change Date
Last Change Source
int
char(2)
char(1)
datetime
char(20)
USDA Customer
USDA Customer ID
Customer Type Code
Customer Name
Creation Date
Creation Source
Last Change Date
Last Change Source
USDA Customer Statement
int
char(1)
varchar(50)
datetime
char(20)
datetime
char(20)
USDA Customer Statement
USDA Customer Statement ID
USDA Customer ID
USDA Customer Statement Title
Last Change Date
Last Change Source
A customer can create
multiple statements with
different content, and can
grant other customers
access to each statement.
int
int
char(80)
datetime
char(20)
USDA Agency System
USDA Customer Identifier
Agency System Identifier
Last Change Date
Last Change Source
USDA Customer Ethnicity
USDA Customer Ethnicity ID
USDA Customer ID
Ethnicity Type Code
Ethnicity Determination Code
int
int
char(1)
char(1)
USDA Authorized Access
int
int
datetime
char(20)
USDA Customer Access ID
USDA Customer ID
USDA Affiliate ID
Statement Access Start Date
Statement Access End Date
Last Change Date
Last Change Source
int
int
int
datetime
datetime
datetime
char(20)
USDA Customer Race
USDA Customer Race ID
USDA Customer ID
Race Type Code
Race Determination Code
int
int
char(1)
char(1)
USDA Statement Component
USDA Statement Component ID
USDA Customer Statement ID
Agency System Identifier
Component Sequence
Last Change Date
Last Change Source
USDA Customer Disability
USDA Customer Disability ID
USDA Customer ID
Disability Type Code
Disability Determination Code
int
int
char(3)
char(1)
int
int
int
int
datetime
char(20)
USDA Statement Attribute
USDA Statement Attribute ID
Data Attribute Name
Data Attribute Format
Last Change Date
Last Change Source
int
varchar(80)
varchar(80)
datetime
char(20)
Domains and Reference Tables
Views for Software Applications
Domain Race Type
Current Business
usda_customer_id
business_name
usda_customer_address.*
usda_customer_email.*
usda_customer_phone.*
usda_customer
Current Individual
usda_customer_id
common_customer_name
usda_customer_address.*
usda_customer_email.*
usda_customer_phone.*
usda_customer
Customer Demographic
usda_customer_id
ethnicity_type_code
race_type_code
disability_type_code
usda_customer
usda_customer_ethnicity
usda_customer_race
usda_customer_disability
Domain Agency System
Agency System ID
Agency System Type
Agency System Name
Agency System URL
Agency System Certificate
Last Change Date
Last Change Source
int
char(1)
varchar(50)
varchar(255)
varchar(255)
datetime
char(20)
Race Type Code
Domain
Disability Typechar(1)
Default Value Indicator char(1)
Disability Short
Type Code
char(3) varchar(15)
Description
Domain
Ethnicity
Type
Default Value
char(1) varchar(80)
LongIndicator
Description
Ethnicity Type Code
char(1)
Short Description
varchar(15)
Last Change Date
datetime
Default Value Indicator
char(1)
Long Description
Data Source varchar(80)
varchar(20)
Short Description
varchar(15)
Last Change Date
datetime
Long Description
varchar(80)
Data Source
varchar(20)
Last Change Date
datetime
Data Source
varchar(20)
24
USDA Customer
Agency Business Applications
Service Center
Customer Accessible Applications
Declare RSNOD
Common Customer
Statement Application
Census
Natl Fire Plan
Cust ID
State ID
County ID
Forest ID
FSA W/H
Statistics
Timber
State ID
County ID
Cust ID
SSN
Customer
RSNOD
USDA ID
Race(s)
Gender
Natl Origin
Disability
Relationships Statement Specs
USDA
ID
USDA
ID
Rltn
Statement
Type
USDA ID
Agencies
Program
s
FS
NASS
ProTracts
STATEMENT
MGR
Record Agencies and User
Program Participation. Store User
Statement Customization
Personalization
Agency User Databases
USDA Customer
USDA ID
Business/Individual
USDA
Custome
r
Databas
e
SCIMS
NASS-Cust
APHIS-Pharm
WebCAAF
RSNOD
MGR
Updates and Access
to RSNOD Data
USDA ID
LINK MGR
Service Center
NASS
Customer
Customer
F
S
Customer
Cust ID
Cust ID
Cust ID
Affiliate
Affiliate
Affiliate
Affil ID
Affil ID
Affil ID
Search
Criteria
eAuth
Bind USDA ID to
Agency-Specific ID’s
eAuthID
25
USDA ID Business Cards
A: License plate like coding of the USDA Customer ID
B,C,I: optional information (Company Name, slogan), D: Customer name
E,H,G: Customer declared contact information, F: USDA provided picture
B
USDA-id 437-FXB
Opt Card owner line 1
OPT card owner LINE 2
Sandy Farmer
C
A
123 Shady Lane
D
Eden, ID 70523
907.721.1538 (day)
Optional Line 3
E
F
H
[email protected]
G
I
26
U.S. Department of Agriculture eGovernment Program
Agenda


 Welcome
 Customer Statement Demonstration
 Q&A and Next Steps
27
Questions and Answers
28
U.S. Department of Agriculture eGovernment Program
Next Steps
New EGWG Schedule: 2nd and 4th Wednesday of every month
• Next EGWG Session
Date: March 24, 2004.
Time: 11:00 AM – 12:00PM EST
Location: S107
Topic: Smart Choice Strategic Initiatives Update
• eAuthentication - Release 2 Screens Review Meeting
Date: Monday, March 22, 2004
Time: 2:00 PM EST
Location: S107
29