PCDO Level 3 Technical Specification

Jira Tasks

• KITT-251@Jira

Revision History

Version	Date	User	Description
1.0	03/10/2009	Heather Lo	Initial Spec
1.1	03/19/2009	Heather Lo	Modified Spec, Draft

Technical Description

There is currently a PCard transactional document (PCDO) and a related inquiry screen for the PCDO in KFS. The inquiry screen needs to be modified to display Level 3 data from the bank, which needs to be added into the FP_PRCRMNT_TRN_DTL_T table.

Details

• Database Requirements
  1. Add fields for Level 3 data in FP_PRCRMNT_TRN_DTL_T.
• UI Design
  1. Level 3 data displayed on PCDO transaction inquiry screen.
• Development Checklist
  1. Write SQL to add Level 3 data to FP_PRCRMNT_TRN_DTL_T and add to schema-oracle.sql.
  2. Create/modify POJO to include Level 3 data (ProcurementCardTransactionDetail.java).
  3. Create/modify ojb-fp.xml file to include the Level 3 data.
  4. Update data dictionary.
     • Create new data dictionary file for the base business object (ProcurementCardTransaction.xml and/or ProcurementCardTransactionDetail.xml). Copy the original file and modify to include new attributes, including adding to the inquiry section.
  5. Create/modify the spring file (spring-fp.xml) to tell Spring where to look for our PCard files.