Versions Compared

Version Old Version 2 New Version 3
Changes made by

Modesto Sevilla

Modesto Sevilla

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added new column, Payment change Code and Previous Check Number, for reissued checks. Added to the end of the layout to minimize changes. Fixed begin and end locations in layout.

...

Version

Date

Author

Description

1.0

07/23/12

 

Modesto Sevilla

Initial specification

1.1

10/29/12

Maria Lieggi

Finalize field mapping

1.2

11/27/12

Modesto Sevilla

Added new record layout

1.3

12/10/12

Modesto Sevilla

Added Invoice No. char(25)

1.4

12/14/12

Modesto Sevilla

Removed Invoice No. and instead put Req. No. char(8)

1.5

01/13/12

Modesto Sevilla

Payment Type should be CHCK and ACH.  Filled in End Col. Added ‘EXTR – Check Created’ to Transaction Type.

1.6

02/05/13

Modesto Sevilla

Removed Check reissue date from CHECK DATE because KFS really does not support check re-issue.  It just Issues a new check after the previous one is Cancelled.

1.7

02/08/13

Modesto Sevilla

Added questions on the last page.  Added KFS equivalent attribute names to layout.  Removed ISSD transaction type because it is internal to Check Reconciliation in KFS and goes to EXTR once the check or ACH is produced

1.8

02/13/13

Modesto Sevilla

Added Questions and responses at the end of the document. Removed CPAY transaction type as this is not common and should not happen at UCI.  See Questions section for description.

1.9

02/26/13

Modesto Sevilla

Added new column, Payment change Code and Previous Check Number, for reissued checks.  Added to the end of the layout to minimize changes.  Fixed begin and end locations in layout.

Functional Description

The Check Reconciliation File process enables the external systems to obtain feedback concerning checks. They will be able to obtain check number and the status of the checks such as check clear date, check cancellations, stale check date, check cancellation with re-issue.

...

 

Field Name

 

Format

 

Len

Beg Col

End Col

 

Comments/Values

 PAYEE_ID

AlphaNumeric

25

1

25

Student ID #, Employee ID, or Vendor ID

SOURCE_DOCUMENT_NO

(Customer Payment Document Number in KFS)

AlphaNumeric

14

26

39

Unique identifier sent to KFS via Source Document Number

 REQ_NO

(Requisition Number in KFS)

AlphaNumeric

8

40

47

Requisition number, optional for students.

 TRANS_AMOUNT

(Net Payment Amount in KFS)

 

Numeric

9(12).99

15

48

62

Check Amount

 CHECK_NUMBER

(Disbursement Number in KFS)

AlphaNumeric

8

63

70

KFS Check Number

 CHECK_DATE

(Disbursement Timestamp in KFS)

AlphaNumeric

8

71

78

YYYYMMDD

Depending on the TRANSACTION_TYPE this date may have different meanings:

Check Creation Date

Check Cleared Date

Check Canceled Date

Check Stale Date

Stop Pay Date

Check Voided Date

 

 EFFECTIVE_DATE

(Posting Date on the GL side)

AlphaNumeric

8

79

8286

YYYYMMDD

TRANSACTION_TYPE

(Payment Status Code in KFS)

 

 

 

 

 

AlphaNumeric

    4

8387

8690

EXTR – Check Created

CLRD – Check Cleared

CDIS – Cancel Disbursement

STAL – Check Stale

STOP – Check Stop

VOID – Check Voided

 PAYMENT_TYPE

(Disbursement Type Code in KFS)

 

AlphaNumeric

    4

8791

9094

  CHCK -  Check

  ACH – EFT/ACH

 DISTRIBUTION_TYPE

(Payment Special Handling Indicator in KFS)

AlphaNumeric

1

919591

95

Y – Pick up check

PAYMENT_CHG_CD

(Payment Change Code in KFS)

AlphaNumeric

4

96

99

Payment Change Code:

CRD – Stop with Reissue

Ignore all other values

PREV_CHECK_NUMBER

(Original Check Number in KFS)

AlphaNumeric

8

100

107

Previous Check Number for Reissued checks.

 

Database Objects

 

 

Questions and Issues

...

2)      KFS has no Stop with re-issue, correct? It does not, only STOP.  But in KFS, Cancel with Reissue can be treated the same as Stop with Reissue.

3)      What are the differences at UCI between VOID, STOP, and CANCEL?

...