CA131 – Sales Ratio Extract for SPSS
|
In order to more
easily use PC-based statistical software, such as SPSS, CA131 combines data
from several IAS tables into one separate table. This eliminates the need for
table joins at the PC level. When the program is finished, the resulting data
|
will be in a table called
TEMP_SALERATE_RESULTS. Run this report from SY31 before using your PC
software. Running this report will refresh the table with the most current
data. |
|
|
NOTE: The specific fields
with permissible entries to be filled in or left blank are listed
below. Ignore fields that are not in the list next to the screens. |
||
|
Figure 1. SY41 (TOP) |
1. Job: Report name should always appear
here. For example, CA131. 2. Server Name: Keep the server name that
first appears. 3. Printer_Name:
Select a
valid printer or keep the displayed printer if one is present. 4. Jurisdiction: Enter your jurisdiction. 5. Tax Year: Enter the current Tax Year. 6. Spool File Name: Enter CA131.LIS to create the file in text format. 13.
FCU: Formatting code. Enter “PDF” to print in PDF format.
Otherwise keep the default printer setting that is present when the screen
appears. 17. PARAM1 CARD: The program
can be run for all cards or for card = 1 only. For card 1, enter a
"1". For all cards, enter
"ALL". If no value is entered, the program runs for card = 1 by
default. |
|
Figure 2. SY 41
(BOTTOM) |
|
Press
[Submit Job]. The system will notify you when the report is finished.
CA131 is a batch program that builds a temporary table
for use in developing reports with 3rd party applications such as SPSS. The
table combines data from several of our base tables to make the data retrieval
easier for the other application.
The name of the table is TEMP_SALERATE_RESULTS. Here
is the table definition:
|
Column Name |
Type |
Length |
Description |
|
PARID |
CHAR |
18 |
Parcel ID |
|
APRLAND |
NUM |
10 |
Final land value |
|
APRBLDG |
NUM |
10 |
Final building value |
|
APRTOT |
NUM |
10 |
Final value |
|
LANDVAL |
NUM |
10 |
Cost land value |
|
BLDGVAL |
NUM |
10 |
Cost building value |
|
COSTVAL |
NUM |
10 |
Final cost value |
|
INCOME |
NUM |
10 |
Final income value |
|
MKTVAL |
NUM |
10 |
Market value |
|
DWELVAL |
NUM |
10 |
Dwelling value |
|
OBYVAL |
NUM |
10 |
OBY value |
|
COMVAL |
NUM |
10 |
Commercial value (parcel) |
|
RESGRMVAL |
NUM |
10 |
GRM value from CA21 |
|
NBHD |
CHAR |
8 |
Neighborhood code |
|
CLASS |
CHAR |
4 |
CA12 property class |
|
LUC |
CHAR |
4 |
Land use code |
|
CALCACRES |
NUM |
12,4 |
Total land acres |
|
OFCARD |
NUM |
4 |
Total cards for the parcel |
|
PRICE |
NUM |
10 |
|
|
SALEDT |
DATE |
|
|
|
BOOK |
CHAR |
8 |
Book from sale |
|
PAGE |
CHAR |
8 |
Page from sale |
|
SALEKEY |
NUM |
8 |
Unique identifier for sale |
|
RATIO |
NUM |
14,4 |
Final appraised value / sale price |
|
YRBLTCOM |
NUM |
4 |
Commercial year built |
|
STRUCTURE |
CHAR |
3 |
Commercial structure code |
|
GRADECOM |
CHAR |
3 |
Commercial grade (CA31) |
|
STORIES |
NUM |
2,1 |
Residential story height |
|
STYLE |
CHAR |
2 |
Residential dwelling style |
|
YRBLTDWEL |
NUM |
4 |
Residential year built |
|
CONDLVL |
NUM |
2 |
Residential condo level |
|
CONDOTYP |
CHAR |
4 |
Residential condo type |
|
CONDOVW |
CHAR |
3 |
Residential condo view |
|
SFLA |
NUM |
6 |
Residential square feet living area |
|
GRADEDWEL |
CHAR |
2 |
Residential grade (CA21) |
|
CDU |
CHAR |
2 |
Residential CDU |
|
TOTAREAIEP |
NUM |
10 |
Commercial area (from CA34) |
|
NETAREAIEP |
NUM |
10 |
Leasable area (from CA34) |
|
GROUPNUM |
NUM |
4 |
Numeric value assigned to nbhd |
Updated 7/21/2006