=-

RFC/Agency Link Output File Format

START

BYTE

STOP

BYTE DESCRIPTION FORMAT

-------------------------------------------------------

1

5

12

15

4

11

14

19

MARKER

MARKER DESCRIPTION

FILLER

RFC RECORD COUNT

@@@@

RFC CNT

CHAR

RECORD FORMAT 3:

START

BYTE

STOP

BYTE DESCRIPTION FORMAT

-------------------------------------------------------

--------------------------------------------------------

1 8 ALC CHAR

9 11 RFC CODE CHAR

12 17 POSTING DATE CHAR YYMMDD

18 23 CONFIRM DATE CHAR YYMMDD

24 37 SCHEDULE CHAR

38 39 SCHEDULE COUNT CHAR

40 43 CHECK SYMBOL CHAR

44 63 CHECK RANGE CHAR

64 78 AMOUNT CHAR

79 79 DOCUMENT TYPE CHAR

80 84 RFC/POST REC NUMBER CHAR

RECORD FORMAT 2:

START STOP

BYTE BYTE DESCRIPTION FORMAT

1 4 MARKER @@@@

5 11 MARKER,DESCRIPTION RFC AMT

12 14 FILLER

15 29 RFC AMOUNT TOTAL CHAR

RECORD FORMAT 4:

START STOP

BYTE BYTE DESCRIPTION FORMAT

-------------------------------------------------------

1 4 MARKER @@@@

5 11 MARKER DESCRIPTION ALC AMT

12 14 FILLER

15 29 ALC AMOUNT TOTAL CHAR
acctng_year+month

filler

alc

trans amt

2

8

14

22

7

13

21

39

6

6

8

18

yyyymm

blank

99999999

[-19]99999999999999.99

Example:

HIAS00510VEROOI2001-05-07T21:45:00.980

Dyyyymmyyyymm99999999999999999999999.99XXXXXXXXXXXXXXXX99999999

Dyyyymmyyyymm99999999-99999999999999.99XXXXXXXXXXXXXXXX99999999

Tyyyymmyyyymm99999999999999999999999.99XXXXXXXX

Dyyyymmyyyymm99999999-99999999999999.99XXXXXXXXXXXXXXXX99999999

Dyyyymmyyyymm99999999999999999999999.99XXXXXXXXXXXXXXXX99999999

Dyyyymmyyyymm99999999-99999999999999.99XXXXXXXXXXXXXXXX99999999

Tyyyymmyyyymm99999999-99999999999999.99XXXXXXXX ..

Gyyyymm 99999999-99999999999999.99

Dyyyymmyyyymm99999999999999999999999.99XXXXXXXXXXXXXXXX99999999

Dyyyymmyyyymm99999999-99999999999999.99XXXXXXXXXXXXXXXX99999999

Tyyyymmyyyymm99999999999999999999999.99XXXXXXXX

Gyyyymm 99999999999999999999999.99

-- Notes:

-- -------------------------------------------------------------------------

-- pflt_sod511: returns flat-file data for the sod 511 (DTDV) report.

-- Input:

@appl_user_id: user identifier; if null or blank, superuser access.

@alc: agency location code; if null or blank, all are selected.

@acctng_year: YYYY format.

@acctng_month: MM format.

@sort order 1: doc_num, doc_date; 2: doc_date, doc num.

T - Total Rows (each acctng year+month, audit date, alc):

Field Name Start - End Length Format/Data

Indicator 1 1 1 'D'

-- Output:

H - Header Row:

Indicator 1 1 1 'H'

IAS ID 2 9 8 'IAS00511'

Version 10 15 6 'VEROOl"

Date-Time 16 38 23 'CCYY-MM-DDThh:mi:ss.mmm'

D - Detail Rows:

Field Name Start End Length Format/Data

Indicator 1 1 1 'D'

acctng_year+month 2 7 6 yyyymm

audit date (doc_date) 8 13 6 yyyymm

alc 14 21 8 99999999

trans amt '22 39 18 [-19]99999999999999.99

doc date 40 45 6 yymmdd

rptng_date 46 51 6 yymmdd

doc num 52 59 8 99999999

ref num 60 67 8 XXXXXXXX

aba num 68 76 9 999999999

bank code 76 79 3 999

loc num 79 82 3 999
acctng_year+month

audit_date (doc_date)

alc

trans amt

2

8

14

22

7

13

21

39

6

6

8

18

yyyymm

yyyymm

99999999

[-19]99999999999999.99

G - Grand Total Rows

Field Name

Indicator

acctng_year+month

filler

alc

trans amt

(each

Start

1

2

8

14

22

acctng year+month, alc):

End - Length Format/Data

1 1 'D'

7 6 yyyymm

13 6 blank

21 8 99999999.

39 18 [-19]99999999999999.99

Example:

HIAS00511VER0012001-05-07T21:45:00.980

Dyyyymmyyyymm99999999999999999999999.99yymmddyymmdd99999999XXXXXXXX999999999

99

DYYYYInInyyyymm99999999-

99999999999999. 99YYInInddyymmdd99999999XXXXXXXX999999999999999

TYYYYInInyyyymm99999999999999999999999.99

Dyyyymmyyyymm99999999-

99999999999999. 99YYInInddYYInIndd99999999XXXXXXXX9999999999999 99

Dyyyymmyyyymm99999999999999999999999.99yymmddYYInIndd99999999XXXXXXXX99999999~

99

DYYYYInInyyyymm99999999-

99999999999999. 99yymmddYYInIndd99999999XXXXXXXX999999999999999

TyyyymmYYYYInIn99999999-99999999999999.99

GyyyYInIn 99999999999999999999999.99

DYYYYInInyyyymm99999999-

99999999999999. 99yymmddyymmdd99999999XXXXXXXX999999999999999

Dyyyymmyyyymm99999999999999999999999.99yymmddyymmdd99999999XXXXXXXX99999999~

99

DYYYYInInyyyymm99999999-

99999999999999. 99YYInInddyymmdd99999999XXXXXXXX999999999999999

Tyyyymrnyyyymrn99999999-99999999999999.99

GyyyYInIn 99999999-99999999999999.99

-- Notes:

Temp table columns named nseq (node

build an ordered tree (parent-child

setting up the proper #lines output

sequence) and ndiv (node divisio

relationships), and are used for

sequence.

-----------------------------------------------------------------------

-- pflt_sod512: returns flat-file data for the sod 512 (us) report.

-- Input:

@appl_user_id: user identifier; if null or blank,

@alc: agency location code; if null or blank, all

@acctng_year: YYYY format.

@acctng_month: MM format.

@age:

superuser access.

are selected.

-- Output:

Header Row:
Total Rows:

Same as Detail Rows except: Indicator = 'T', rptng_date, ref nurn and

rptng_alc = blank.

*trans_amt_280,

respectively.

410 = trans amt where acctblty_code = 280, or 410 - 411

Example:

HIAS00512VEROOI2001-05-07T21:45:00.980

Dyyyymrnyyyyrnrn99999999000000000000000.00999999999999999.99yyrnrnddXXXXXXXX99999999

-- Dyyyyrnrnyyyyrnrn99999999-

99999999999999. 99000000000000000. 00yyrnrnddXXXXXXXX99999999

Tyyyyrnrnyyyyrnrn99999999-99999999999999.99999999999999999.99

Dyyyyrnrnyyyyrnrn99999999000000000000000.00999999999999999.99yyrnrnddXXXXXXXX99999999

-- Dyyyyrnrnyyyyrnrn99999999000000000000000.00-

99999999999999. 99yyrnrnddXXXXXXXX99999999

Dyyyyrnrnyyyyrnrn99999999999999999999999.99000000000000000.00yyrnrnddXXXXXXXX99999999

Tyyyyrnrnyyyyrnrn99999999999999999999999.99-99999999999999.99

----------------------------------------------------------------------------

-- pflt_sod513: returns flat-file data for the sod 513 (dts) report.

-- Input:

@appl_user_id: user identifier; if null or blank,

@alc: agency location code; if null or blank, all

@acctng_year: YYYY format.

@acctng_month: MM format.

@age:

superuser access.

are selected.

-- Output:

Header Row:

Field Name

Indicator

IAS ID

Version

Date-Time

Start

1

2

10

16

End

1

9

15

38

Length

1

8

6

23

Format/Data

'H'

'IAS00513'

'VEROOl'

'CCYY-MM-DDThh:rni:ss.rnrnrn'

Field Name Start End Length Format/Data

Indicator 1 1 1 'H'

IAS ID 2 9 8 'IAS00512'

Version 10 15 6 'VEROOI'

Date-Time 16 38 23 'CCYY-MM-DDThh:rni:ss.rnrnrn'

Detail Rows:

Field Name Start End Length Format/Data

Indicator 1 1 1 'D'

acctng_year+month 2 7 6 yyyymrn

audit date 8 13 6 yyyymrn

alc 14 21 8 99999999

trans amt 280* 22 39 18 [-19]99999999999999.99

trans-amt-410* 40 57 18 [-19]9999999999999.99

rptng_date 58 63 6 yymrndd

ref nurn 64 71 8 XXXXXXXX

rptng_alc 72 79 8 99999999