150 likes | 169 Views
The Perishable Agricultural Commodities Act (PACA) Branch oversees enforcement and fair trade practices violations under the 1930 Act. This system handles complaints, administrative functions, case management, and more. A comprehensive application domain covers complaints, administrative functions, license issuance, renewal, and security implementations for government applications.
E N D
Perishable Agricultural Commodities Act(PACA) For Agricultural Marketing Service USDA/AMS
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
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
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
Perishable Agricultural Commodities Act (PACA) Application Domain Various Complaints & Administrative Functions.
Perishable Agricultural Commodities Act (PACA) Application Domain Admin Function Screen, which handles the Administrative complaints against the customer.
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.
Perishable Agricultural Commodities Act (PACA) Application Domain List of Correspondence Reports for various actions related to Complaints and Admin Functions.
Perishable Agricultural Commodities Act (PACA) Application Domain Various Actions in Complaints and Admin Functions resulted in change of license status of a licensee.
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
Perishable Agricultural Commodities Act (PACA) Application Domain Issuing License and their Renewals
Perishable Agricultural Commodities Act (PACA) Application Domain Renewal Process of PACA.
Perishable Agricultural Commodities Act (PACA) Application Domain Fee Process of PACA.
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
Perishable Agricultural Commodities Act (PACA) Reference Estela M. Diaz 4700 River Road, Unit 45, Riverdale, MD - 20737 Ph: (301)734-8110 Email: Estela.M.Diaz @usda.gov