ST301MO – Charms Interface for St Louis, MO

 

This report creates the Charms Interface from stlgroup.

 

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

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

 7.    Beginning Date: Enter the business date. If blank, program uses the system date.

13. FCU: Formatting code. Enter ‘NONE.’

17. PARAM1 PHASE: Enter phase. Default is 3.

 18. PARAM2 NO. OF POS. OF AUTH: Enter the number of positions of authority. Default is 2.

 19. PARAM3 COMMISSION PERCENTAGE: Enter commission percentage. Default is 1%.

 20. PARAM4 ASS. FEE PCT: Enter Assessment Fee Percentage. Default is .5%.

21. PARAM5 Frequency: Enter Settlement Frequency. Default is “D.”

 

 

Figure 2. SY 41 (BOTTOM)

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

 

Record Layout for ASCII file

 

Seq

Field Name

Start

End

Length

Format

IAS Table

IAS Column

Notes

1

REVTYP_CODE (Revenue Type Code)

1

1

1

C1

Generate

 

Generate REVTYP_CODE (See Note 1 below) based on ROLLTYPE, SETTYPE, and CATEGORY in STLGROUP table. The SETTYPE and CATEGORY are setup based on CODE and ACTION groupings.

2

TAX_YEAR (Taxing year)

2

3

2

C2

STLGROUP

PRIORYR

 

3

CATEGORY (Authority)

4

9

6

C6

STLGROUP

AUTH

 For Authority Code

 

 

 

 

 

 

RTDIST

USER1

 

 For City code

4

Original

10

23

14

S + N(10+DEC+2)

STLGROUP

Calculate

Base Revenue (sum of  tax Begamt) for the  settlement period (indicated by STLGROUP.BUSDATE) for the (REVTYP_CODE,  AUTHORITY and TAXYR) defined above.

5

Adjustments

24

37

14

S + N(10+DEC+2)

STLGROUP

Calculate

Base Revenue (sum of Tax addamt) for the  settlement period (indicated by STLGROUP.BUSDATE) for the (REVTYP_CODE,  AUTHORITY and TAXYR) defined above.

6

Payment of Principal

38

51

14

S + N(10+DEC+2)

STLGROUP

Calculate

Base Revenue (sum of Tax payamt) for the  settlement period (indicated by STLGROUP.BUSDATE) for the (REVTYP_CODE,  AUTHORITY and TAXYR) defined above.

7

Payment of Interest

52

63

12

S + N(8+DEC+2)

STLGROUP

Calculate

Base Revenue (sum of Interest Amount) for the  settlement period (indicated by STLGROUP.BUSDATE) for the (REVTYP_CODE,  AUTHORITY and TAXYR) defined above.

8

Commission on payments

64

75

12

S + N(8+DEC+2)

Calculate

 

Calculate commission amount per formula (1 % of TPRIN + TINTER Amount)

9

Ass. fee on  payments

76

87

12

S + N(8+DEC+2)

Calculate

 

Calculate commission amount per formula (0.5 % of TPRIN + TINTER Amount) on PP/MFG/SUR for all other authorities other than =01

10

Cash

(Principal + Interest – Commission – fee) of payments

88

101

14

S + N(10+DEC+2)

 

Calculate

(Principal + Interest – Commission – fee) of payments

11

BUSDATE

102

109

8

 

STLGROUP

BUSDATE

(mmddyyyy)  Settlement Date i.e. Ending date of period for which settlement is done.

 

 

 

 

 

 

 

 

 

 

 

Note 1: Revenue Type Code 1 thru 7 based  on Rolltype and CODE / ACTION

 

1  = PERSONAL PROPERTY (TAX+INT)

2  = M. AND M  (MFG+MFI)

3  = REAL PROPERTY (TAX+INT)

4  = REAL PROPERTY Sur.  Charge (SUR+SUI)

5  = REAL PROPERTY Special Asmt (SAC+SAI)

6  = REAL PROPERTY SEWER LATERAL FEE (SLF)

7  = PERSONAL PROPERTY VEHICLE FEE (VFE)

 

Note 2: Oracle does not support COMP-3 data format.  Data extracted from IAS will be in flat file character format

 

Updated 7/25/2006