AA407PAFAY – Cama data extract - county specific for Fayette

 

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, AA407PAFAY.

 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 AA407PAFAY.LIS to create the file in text format.

 9. ID1: Enter the starting Parcel ID.

 10. ID2: Enter the ending Parcel ID.

 

 

 

 

 

 

13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPLP132.

 17. PARAM1 PRINT HEADING (Y/N):

‘Y’ – Prints column heading – Default

‘N’ - No column heading – only data

18. PARAM2 PATH: Enter the full path to the folder where the returned (DAT) files are located. This Path will be for both the DAT and CTL files. Make sure to NOT include the filename in the path.

 

 

Figure 2. SY 41 (BOTTOM)

You will need to do the following:

 

1. Import the dmp file (ayette.dmp) to extract three tables (extr_school – 42 records,  extr_state – 85 records, extr_region  - 42 records). 

 

    • IMP  clt/clt@ias4 file=ayette.dmp commit=Y fromuser=iasdev423 touser=clt
    • Run this command from the dos prompt (in the directory where the dmp file is copied). If Oracle user name is different from that of clt/clt@ias4 change it accordingly (the touser too will have to be changed).
    • The Table structures and control file contents are added to the end of aa407pafay.sql for reference if these are to be extracted again at a later time.

2. Please create a record in Param for rptname 'AA407PAFAY'. 

    • INSERT INTO param (rptname) VALUES ('AA407PAFAY');
    • Go to SY32 and insert a record for AA407PAFAY and set the update flag to 'Y' - to make it run from SY32 instead of SY31. Also, set 'Column Name[Y/N]:' on Label 1.

3. Copy the program file (aa407pafay.sql) to reports directory and run from SY32.

Parameters are :

             Jurisdiction  : Your county number

             Taxyr             : 2003

              Id1                 : 0

              Id2                 : z

              param1        :  Y  - Print column name  - N - Not print column names    (default = 'Y')

 

    • All the parcels will be picked up if ID1 and ID2 are left null.
    • I am assuming that the extract will be used in Excel. So, I have made it a comma delimited file with the column names in the first row. If you do not want the column name on first row set param1 to 'N'.  The report will print 1 line each for each commercial and dwelling cards. If no com and residential records are present, one record will be printed with the basic information.
    • You could take the information directly from Oracle table using External Data option in Excel by using oracle ODBC connection. If you wish to do so use the table name as 'TEMP_TX407PAFAY'.

 

 

Press [Submit Job]. The system will notify you when the report is finished

 

Updated 7/21/2006