PTWin User Tips / DATA MODEL 
|
Field Names
Revealed
Create a report listing links between Display
Labels & Field Names
Using the Ad Hoc reporter to print
the Data Dictionary
|
Tip #: 1.1.4 |
| Ver(s):PTWin32, V2, V1 |
Data fields in PTWin have two names.
The first name is a label used to identify a field on the screen. The other name is the
actual field name as defined in the database table. You must use database field names in
programs like the ad hoc report writer or Paradox.
When creating new fields for permits in the Modifications module, you supply a Display
Label that appears as a prompt for the field on the Permit Info page. Database field names
and their display labels are in a table called Permmap.DB, while the actual data is in the
Perminfo.DB table. If you include Perminfo in an ad hoc report and check the field names
you don’t see Display Labels; instead, you see names like, Alpha 1, Alpha 2, Number
1, Number 2, etc.
These fields are used on each permit type’s Permit Info page. PTWin tracks these
fields in a mapping table called Permmap.DB. To identify the database name for a
particular Permit Info display label you need to create an ad hoc report from the
Permmap.DB table. Follow these instructions to create the report.
1) Open Ad Hoc reporting by selecting Reports | Ad Hoc Reporting from the PTWin menu.
2) Click on the Add Tables icon in the tool bar to open the Add Tables box.
3) Scroll through the list and double click on the Permmap.DB file. Click the Close button
to exit.
4) Drop the Permit Type Key, Page Number, Display Label, Field Name, and Type of field,.
fields onto the lower part of the Define Search window from left to right in the order
listed.
5) Select Report Setup from Shazam’s tool bar to open the Report Setup dialog.
6) Click on Grid and type "Permmap Report" in the Title field. Type
"Permmap.SRW" in the Footer field, Click OK when done.
7) Click Save Report on the tool bar. Enter "Pemmap" in File name: and press OK.
8) Click on Preview Report to display. Print the report by clicking Print Report.
The report shows the following items:
Permit Type Key - correlates to the list of permit types. The "1" items
relate to the first permit type which is the Boundary Line Adjustment; the "2"
items relate to the Building permit; the "3" items relate to the Conditional Use
permit, etc.
Page Number – permit types with a single page do not have numbers in this
column. Multi-page permit types show fields from the first page as blank. Fields on the
second page have "1" in this column; Fields on the third page have "2"
in this column, etc.
Display Label - Identifies fields by the prompt seen on the Permit Info page.
This name appears in the Display Label column of the Permit Modifications window.
Field Name - Identifies the database field name used for a particular field
within a particular permit. The same field names are used repeatedly. These are the names
you use in ad hoc reports or Paradox .
Type of Field - Identifies the field type and any Selection Values assigned to
the field.
To identify a field name use the Permit Type Key and Page Number fields to focus on the
proper permit type. Then find the Field Name that corresponds to the Display Label in
question. Use the Field Name in your report.
Return to Data Model menu
