-Uses the same form in the App for 'University Expense Card Request'
-Forms are auto-created from a file we get from Concur.
-Form utilizes flags for DBC/Travel Card to show/hide correct fields when needed. This includes on ST_Start and through the various DBC and Travel Card stages.
Use Case (happy path)
- New form auto-created for each user from Concur .csv file
- (Elements: First Name, Last Name, User Email, Spend Limit, Declining Balance Begin Date, Declining Balance End Date, User Net Id, DBC Flag, Employee Id)
- DBC User (student) receives email notification to complete form.
- DBC User completes form.
- Expense Card Admin group receives notification of submitted form.
- Expense Card Admin Approves form.
- DBC User receives notification of approval and link to form.
- Expense Card Admin transmits form. Form is created in export report.
- Expense Card Admin Exports the data into Excel.
DATA SPEC:
TEMPLATE EXPORT FROM LEAP:
TCard_and_DBC_Report_Export_DEVSAMPLE.xls
Import file into KFS from Concur:
Testing prior to Production.
- Create/receive a student file from Concur. (see attached sample in JIRA KPS-1200)
- Note that any email address in the file will receive an email from the LEAP workflow.
- Ensure the filename matches the prefix within the CONCUR_DBC_EXTRACT_PREFIX parameter
- Log into KFS-YE environment
- Navigate to Administration tab.
- Select Special Batch File Upload under Batch/Scheduled Jobs
- Make sure to pick the concur/originEntry from dropdown.
- Browse for DBC file. and submit.
- Navigate to Administration Tab
- Select Schedule under Batch/Scheduled Jobs
- Execute the decliningBalanceCardJob in KFS-CONCUR Namespace.
When running multiple tests, make sure that the filename used is different than the last test. The coding will NOT process a file that has already been processed.
Production
FTP site file name: Student_Approved_Requests_POC__159853324902774.csv.pgp
DBC Parameter: CONCUR_DBC_EXTRACT_PREFIX = “Student_Approved_Requests”
Job that picks up file is decliningBalanceCardJob. can be run manually. This will run after the travelerExportJob daily.