Perishable Agricultural Commodities Act (PACA)

1
Perishable Agricultural Commodities Act(PACA)

• For
• Agricultural Marketing Service
• USDA/AMS

2
Perishable Agricultural Commodities Act (PACA)
Client
The Perishable Agricultural Commodities Act
(PACA) Branch (located in USDA, D.C.) handles
Enforcement and tracking violations against fair
trade practices under Perishable Agricultural
Commodities Act, 1930.
System Services

• Complaints/Administrative Functions
• Case Management
• Enforcing rules of Fair Trade Practices
• Automated Customer License Renewal System

3
Perishable Agricultural Commodities Act (PACA)

• Relational Databases and Database Connectivity
• GUI Development
• Client Server Application Development
• Web Application Development

Technology/Disciplines
Software Tools Used

• Oracle Forms6i
• Oracle Report6i
• Oracle Forms Server
• Oracle Reports Server

• Oracle 8i Database Server
• Oracle Application Server
• Adobe Acrobat

4

Perishable Agricultural Commodities Act (PACA)
Application Domain
Functionality of Complaints Admin Module

• Handling various complaints like
• Civil
• Administration
• Reparation

• Handling various Administrative functions like
• Bankruptcy
• Violations
• Bonds
• Misbranding
• Precedents
• Information Request

5

Perishable Agricultural Commodities Act (PACA)
Application Domain
Various Complaints Administrative Functions.
6
Perishable Agricultural Commodities Act (PACA)
Application Domain
Admin Function Screen, which handles the
Administrative complaints against the customer.
7
Perishable Agricultural Commodities Act (PACA)
Application Domain
Reparation which handle complaints for or against
the customer either by the third party or by
government itself.
8
Perishable Agricultural Commodities Act (PACA)
Application Domain
List of Correspondence Reports for various
actions related to Complaints and Admin Functions.
9
Perishable Agricultural Commodities Act (PACA)
Application Domain
Various Actions in Complaints and Admin Functions
resulted in change of license status of a
licensee.
10
Perishable Agricultural Commodities Act (PACA)
Application Domain
Functionality of Issuing Licenses, fees and their
yearly renewal Module

• This module handles various functions like
• Issuing License
• Renewal of License
• Fees Structure
• Automated correspondence to the client
  regarding their renewals and their yearly fees.
• Termination of Licenses
• Migrating data from various sources

11
Perishable Agricultural Commodities Act (PACA)
Application Domain
Issuing License and their Renewals
12
Perishable Agricultural Commodities Act (PACA)
Application Domain
Renewal Process of PACA.
13
Perishable Agricultural Commodities Act (PACA)
Application Domain
Fee Process of PACA.
14
Perishable Agricultural Commodities Act (PACA)
Application Domain
Implementing the Security for Government
Applications

• Application Level Security
• Login Screen
• Restricting Menu Options

• Database Level Security
• Creating Roles with different Access
  Privileges
• Assign those Roles to the Users

• Internet Level Security
• Implementing Digital Certificates

15
Perishable Agricultural Commodities Act (PACA)
Reference
Estela M. Diaz 4700 River Road, Unit
45, Riverdale, MD - 20737 Ph [phone] Email
Estela.M.Diaz _at_usda.gov