External System ==> KFS Check File Record Format (PSoft S/F Checks)

4	Check Amount	23	39	17	See Note 2 below.	NUMBER	Yes
Destination of Data
External check data is staged for upload via batch file transfer job: PRD-KFS-StudentRefundChecksFromPSOFTtoKFS
Field ID	Column Name for Bank File Data	Start	End	Length	Comment (UConn)	Data Type	Required in Dest?

1	KFS Memo Bank	1	2	2	Leading zeros. See Note 1 below.	NUMBER (2,0)	Yes
2	Check Number	3	8	6	Leading zeros.	NUMBER (6,0)	Yes
3	Check Status Code	9	12	4	Constant: See Status Codes below.	Alphanumeric	Yes
5	Check Issue Date	13	22	10	Format: CCYY-MM-DD	DATE	Yes

Note 1:	In 'KFS-UAT' and 'KFS-PRD', valid "memo banks" are:
	Bank01 = '01'
	Bank04 = '04'
	Bank15 = '15'
	Bank16 = '16'
	Bank17 = '17'

Status Codes:	'CLRD' for CLEARED checks
	'CNCL' for CANCELLED checks
	'ISSD' for ISSUED checks
	'STAL' for STALE checks (Escheated checks)
	'STOP' for STOPPPED checks
	'CDIS' for VOIDED checks
	'REVD' for VOIDED checks

Note 2:	Check Amount:
	All check amounts are left justified beginning at column 23; NO leading or trailing '0's.
	For statuses: 'CLRD', 'ISSD', 'STAL';
	Amounts are always POSITIVE; no '+' sign is necesssary.
	Whole dollar amounts must be entered as follows: 123 ($123), or 1234 ($1,234), or 1234 ($12,345).
	Dollar and cents amounts must be entered as follows: 123.67 ($123.67), or 1234.67 ($1,234.67).
	For statuses: 'CNCL', 'STOP', 'CDIS', 'REVD';
	Amounts are always NEGATIVE; '-' sign is required.
	Whole dollar amounts must be entered as follows: -123 (-$123), or -1234 (-$1,234), or -12345 (-$12,345).
	Dollar and cents amounts must be entered as follows: -123.67 (-$123.67), or -1234.67 (-$1,234.67).

Enterprise Financial Systems

KFS-External Check Load File Update Format

External System ==> KFS Check File Record Format (PSoft S/F Checks)