Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. New form auto-created for each user from Concur .csv file
    1.  (Elements: First Name, Last Name, User Email, Spend Limit, Declining Balance Begin Date, Declining Balance End Date, User Net Id, DBC Flag, Employee Id)
  2. DBC User (student) receives email notification to complete form.
  3. DBC User completes form.
  4. Expense Card Admin group receives notification of submitted form.
  5. Expense Card Admin Approves form.
  6. DBC User receives notification of approval and link to form.
  7. Expense Card Admin transmits form.  Form is created in export report.
  8. Expense Card Admin Exports the data into Excel.


DATA SPEC:

View file
nameTravel Card Request Application_data specs_20200818University Expense Card Mapping Spec.xlsx
height250

TEMPLATE EXPORT FROM LEAP:

TCard_and_DBC_Report_Export_DEVSAMPLE.xls

Import file into KFS from Concur:

Student Approved Requests.txt


Jiras:

Jira Legacy
serverSystem JIRA
serverId61b6191de13bbb29-d4120ac2-3043366b-a96c9316-75b7bceaed1f9d0d3a27caef
keyKPS-1200

Jira Legacy
serverSystem JIRA
serverIde13bbb29-0ac2-366b-9316-9d0d3a27caef
keyKPS-1283


Testing prior to Production.

...

Job that picks up file is decliningBalanceCardJob.  can be run manually.  This will run after the travelerExportJob daily.

When the job runs, it will ignore any previously run files.  to re-run a file, rename the .txt file first and then re-upload using the special batch upload process.


JSON sent to LEAP example:

{
	"pressedButton": "S_CrtDbcReq",
	"flowState": "ST_Start",
	"F_UserFirstName": "James",
	"F_UserEmailAddress": "klaben@uconn.edu",
	"F_DbcFlag": "true",
	"F_EmployeeId": "000001",
	"F_UserNetId": "jtk17003",
	"F_DecBalEndDat": "11/20/2019",
	"F_DecBalBegDat": "11/17/2019",
	"F_SpendLimit": "800",
	"F_UserLastName": "Klaben"
}