Web:Special Programs

General Information

Special Programs is a feature in Prime that allows you to add custom intake sheets that link with a Client Intake or Eligibility Slip. The uses of the Special Program are only limited by the imagination of the user. Some of its uses are to:

1) Gather additional information for funders such as Title III and VOCA. This information can be additional demographic information, information using different coding (such as racial classifications), actions taken, or even narratives about particular aspects of a case.

2) Provide client satisfaction surveys. For example, you might list a set of goals the client wants to achieve and whether they were achieved.

3) Track information you want about all clients such as, do they receive food stamps, have they had their children checked for lead poisoning, or do they own a truck?

4) Arrange for specific interviews on topics where you need to report, and thus need to control the answer type and codes, for example an interview for public housing eligibility. (This can supplement or replace the interview system or canned questions.)

5) Display a list of documents to print for a specific type of case. For example, you might want to have a set of immigration documents available to print by checking a box next to the ones you need.

6) Store multiple people involved in a case such as law students, advocates, etc. to supplement the limited list on the intake sheet.

7) Add a special program for the Eligibility Slip. An applicant not eligible under your normal funding might fit under another program, such as a Veteran’s Program. The special program could check to see if the client satisfied that program’s requirements.

Unlimited Special Programs

Any number of Special Programs can be added to Prime. Some offices have developed over thirty for their internal use.

Using Special Programs

1) In Prime 16 Web, go to page 3 of the client intake form and press the "Special Programs" button. In the Special Programs page, any special programs already in use are shown in the "Already Entered" area. You can open those and others using the "Select" button next to the list of Special Programs available.

2) They are associated with the main case by a case number.

3) You can have Special Programs that have a one to one relationship with the case or a one to many.

i) An example one-to-one relationship might be where you have a single Title III Special Program that matches a case.

ii) An example one-to-many relationship is a list of Litigation Expenses associated with a case. There might be one expense or a hundred.

Building a Special Program

We can build the special program for you, you can do it yourself, or we can do it together. No matter which method you chose, understanding the process helps you to assist in the design and construction. Design is often the longest portion of the process. You need to know what information must be gathered and what format it should be in. If you are doing this in response to a funder, look at what reports they want. No matter how long you spend, advocates will probably find a need to make changes, so be prepared to modify the design a time or two before the Special Program is ready for data input. For example, you might need to record whether a client is left handed. Should you make it a Yes/No field, a letter field or store the whole word? Should your field also store right handed and ambidextrous? If a code is used, should it be a letter (L, R, A) or the numbers used in a needed report (1, 2, 3)?

1) Build a table in SQL Server – It is necessary to build a table to store the needed information. You must name the table with a z, e.g., zUnitedWay

2) Build a web form and save it in the Special Programs subdirectory – The form allows staff to input data and you can control validation. You should name the form after the table, with no z. Example: UnitedWay

3) Test the Special Program. Open up a Client Intake, go to Special Programs, choose your new one and put in data. Close the Client and then reopen. Go to Special Programs and make sure your data is there.

4) Build any queries or reports you need to get information out of the SP. Save them and add them to the list of Reports as explained in the Reports section.