Design proposal for a form processing web application to implement numerous forms
Download
1 / 14

Design Proposal for a Form Processing Web Application to Implement Numerous Forms - PowerPoint PPT Presentation


  • 72 Views
  • Uploaded on

Design Proposal for a Form Processing Web Application to Implement Numerous Forms. Larry Guentert, HRIS April 17, 2011. Today’s Agenda. Motivation for Project Basics of Form Processing Roles of Form Processing Description of Goals What’s Under the Hood Brief Demo Questions?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Design Proposal for a Form Processing Web Application to Implement Numerous Forms' - xanti


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Design proposal for a form processing web application to implement numerous forms

Design Proposal for a Form Processing Web Application to Implement Numerous Forms

Larry Guentert, HRIS

April 17, 2011


Today s agenda
Today’s Agenda Implement Numerous Forms

  • Motivation for Project

  • Basics of Form Processing

  • Roles of Form Processing

  • Description of Goals

  • What’s Under the Hood

  • Brief Demo

  • Questions?


Motivation for project
Motivation for Project Implement Numerous Forms

Department is floating in paper processing forms


Basic form processing
Basic Form Processing Implement Numerous Forms

Aspects of a typical form:

  • Collection of information

  • Identification of User / Requestor

  • Approval Information / Identification

  • Processing Information


Roles associated with form
Roles Associated with Form Implement Numerous Forms

Typical Roles for Processing

  • Requester: person initiating request

  • Reviewer of information:

  • Approver: one (or several)

  • Processor: person who implements request


Goals of this implementation
Goals of this Implementation Implement Numerous Forms

  • Store form data in a generic way

    • Have Role-based access to system

      • Requester

      • Reviewer

      • Approver(s)

      • Processer

      • Developer

    • Separate out aspects unique to each form into separate tables


Goals of this implementation1
Goals of this Implementation Implement Numerous Forms

Main Form Data table consists of:

  • 12 Text fields (varchar)

  • 6 Dates fields

  • 35 Decimal fields (for financial data types)

  • 6 Integer fields (for flags)

    Designed to hold typical information found on forms.


Goals of this implementation2
Goals of this Implementation Implement Numerous Forms

Data Captured (Request side):

  • Auditing information (who, what, when)

  • Request Status information (for tracking)

  • 35 Decimal fields (for financial data types)

  • 6 Integer fields (for status flags)


Goals of this implementation3
Goals of this Implementation Implement Numerous Forms

Data Captured (Role Side):

  • RequestApproverStatus

  • All person information for those that interact

  • Permission information for associated roles


What s under the hood
What’s Under the Hood Implement Numerous Forms

  • Summer PayCalc consists of:

    • SQL Server Database Tables 14

    • 7 Stored Procedures

    • Coldfusion Scripts (~60)

    • One automated SAP Query refreshes

      data in one table nightly.


What s under the hood tables
What’s Under the Hood: Tables Implement Numerous Forms

Tables unique to each application

Tables used by all forms


Next steps for this project
Next Steps for this Project Implement Numerous Forms

  • Test, Test, Test

  • ITAP Security Scan

  • User Training/Documentation

  • Push to Production

  • Go Live


Brief demo
Brief Demo Implement Numerous Forms


Questions
Questions? Implement Numerous Forms

Thank you!


ad