KFS-External Check Load File Update Format

Owned by Kathleen Avery (Deactivated)
Nov 13, 2014
1 min read

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

Destination   of Data
External check data is staged for upload via batch file transfer job:   PRD-KFS-StudentRefundChecksFromPSOFTtoKFS
Field IDColumn   Name for Bank File DataStartEndLengthComment   (UConn)Data   TypeRequired   in Dest?
        
1KFS   Memo Bank122Leading zeros. See Note 1 below.NUMBER   (2,0)Yes
2Check   Number386Leading zeros.NUMBER   (6,0)Yes
3Check   Status Code9124Constant: See   Status Codes below.AlphanumericYes
5Check   Issue Date132210Format: CCYY-MM-DDDATEYes

4

Check Amount

23

39

17

See Note 2 below.NUMBERYes
        
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).  Â