TSPLOAD process was delivered in Banner Accounts Receivable previously but has now been updated to allow for import of student charges and payments to TSAAREV from an external system, i.e. .csv file load. The process provides validation. This process also allows you to update the description of the detail code during import.
The input supports comma separated values or .csv file format. The file may contain a row with or without column headings, but the values need to be in the below order and format.
**users will need maintenance access to TSPLOAD, GJAJFLU and GJRJFLU
• Column 1 = Student ID
• Column 2 = Detail Code
• Column 3 = Term Code
• Column 4 = Source Code
• Column 5 = Amount (must be 10.2 decimal number, can be positive or negative)
• Column 6 = Entry Date (optional - defaults to current date) – Format (YYYY-MM-DD)
• Column 7 = Effective Date (optional - defaults to current date) – Format (YYYY-MM-DD)
• Column 8 = User ID (optional - defaults to user id of job submitter) – Value should be in All CAPS
• Column 9 = Transaction Date (optional) - If this field is null or empty, it will either default to the Effective Date if it's provided in the file, or to the current date.
Valid Date formats are:
• YYYY-MM-DD
• YYYY/MM/DD
• MM-DD-YYYY
• MM/DD/YYYY
GJAJFLU is utilized to upload the .csv file to banner for use by TSPLOAD
- Some points to note on GJAJFLU
- Change Delete After Days (I used 10 in the screen shot), default is 999
- If you check the box “Save in Product Data Home Directory”, then you would set parameter 2 in TSPLOAD to ‘Y’
Parameters for TSPLOAD are straight forward
You can review output for any errors when running in A – Audit mode
Once you run the process in U – update mode, you will see the below output
