SA406 –SPECIAL ASSESSMENT RECORDS INSERTED FROM A FLAT FILE

Program loads file from tape user SQLLOADER. This file must be present for SQLLOADER: LOAD_SPECIALS.CTL

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

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

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

 17. PARAM1 ROLLTYPE: Enter a valid rolltype. If blank, all rolltypes are processed.

 18. PARAM2 DATA FILE LOCATION: Enter the name of the data file with path to load. For example:

C:\temp\SA406.TXT

 19. PARAM3 CONTROL FILE LOCATION: Enter name of the SQLLDR CONTROL file, including the path. For example:

C:\temp\SA406.CTL

Figure 2. SY 41 (BOTTOM)

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

 

NOTE TO PROGRAMMER: If for some reason the file is lost, below is the code to be copied to textpad and saved as SA406_LOAD .CTL.

 

Text Box: LOAD DATA INFILE * INTO TABLE temp_sa406_1 ( PARID POSITION(1:17) CHAR, PROJNO POSITION(19:23) CHAR, TAXYR POSITION(25:28) INTEGER EXTERNAL(4), AMOUNT POSITION(30:39) DECIMAL EXTERNAL(10)":AMOUNT/100"

Updated 12/11/2006