...
| Question | Status | Conclusion | Comments |
|---|
| Do we need to output encumbrance values or estimated prices? | | Estimated prices | No need to output encumbrances associated with funds at this time - purely estimated costs of orders. |
| What format does the output need to be in? | | Status |
|---|
| colour | Yellow |
|---|
| title | In Progress |
|---|
|
| JSON desired. | semi-structured text. Can we do JSON? Sample output to come. |
| What is the relationship, if any, with the need to output organization info? | | Tight integration |
|
| Is this export process handled via scheduled job, manual export order or API call from the AP system? | | Report generated and pushed through pl1/python script for conversion to AP format via automated script on automated or on-demand basis |
|
| If a file is to be output, is it output to local or output to sftp? | | SFTP; local download from logs |
|
| External account number associated with fund code? Does it need to be associated with specific bank account numbers? | |
|
|
| What additional info needs to be included in the output? | |
| UUID as primary match point? PO numbers are changeable (though some should not be) and they need something fixed, unchangeable and searchable within FOLIO |
| Where is the match point between FOLIO and the AP system for a given order? | | Existing vendor, ledger, fund (AP level), order number. Firm orders must have precise vendor match, approval plans, subscriptions allow for misc. For firm orders, invoice must be within a specified window of estimated price or invoice will be rejected. | If required fields do not match, AP system will reject |
| Do scripts get data out of Voyager currently? |
| PL1 scripts manage the retrieval and transformation of data. APIs must be made available to these scripts. Scripts are being rewritten in Python currently. Owned by PL1 modernization group (PM is in OCI, and Daniel is also a member of that group.) need to coordinate with them on design. | Suite of scripts that collect and assemble requested information. One set extracts data, another set reformats into Momentum-ingestible - sent via SFTP to Momentum staging server, where preprocessing starts. Currently runs just after midnight on all orders approved "yesterday". Updates (other than cancellations) not captured. |
Sample Data
Bulk Obligation
Bulk Obligation
**********************************************************************
RECORD-NUMBER 1
FUND-ID :1124
TRANS-DATE :011823
TRANS-TYPE :6
REFERENCE-NO :ABA RESERVE
AMOUNT :94275
FUND-TYPE-NAME :Bulk
INST-FUND-ID :2301411341010003101,0001
FUND-NAME :KOREAN PUBS ABROAD
FUND-TYPE-ID :1
LEDGER-ID :1637
**********************************************************************
Regular Obligation
Regular Obligations
********************************************************************************
RECORD NUMBER 1
OA_PO_ID : 361196
OA_PO_NUMBER : 361196
OA_VENDOR_ID : 38369
OA_PO_STATUS_DESC : Canceled
OA_PO_STATUS_DATE : 071323
OA_LINE_ITEM_ID : 451699
OA_COPY_ID_1 : 671420
OA_LINE_ITEM_STATUS : Canceled
OA_STATUS_DATE : 071323
OA_COPY_ID_2 : 671420
OA_FUND_ID_1 : 1736
OA_AMOUNT_1 : 27500
OA_FUND_ID_2 : 1736
OA_FUND_TYPE_NAME : Regular
OA_FUND_NAME : SERIAL & GOV PUBLICATIONS
OA_INSTITUTION_FUND_I: 2301411341010003100,0001
OA_OBJECT_ID :
OA_ADJUSTMENT_AMOUNT :
OA_METHOD :
OA_OBJECT_TYPE :
OA_PAYMENT_ID :
OA_SEQUENCE :
OA_FUND_ID_3 :
OA_AMOUNT_2 :
OA_DEFAULT_CURRENCY : USD
OA_CURRENCY_CODE : USD
OA_CONVERSION_RATE : 0
OA_DECIMALS : 2
OA_CATEGORY : 1
OA_PARENT_FUND : 1071
OA_FUND_TYPE_ID : 4
OA_LEDGER_ID : 1637
OA_LOCATION_CODE : w-ACQ/FO
OA_LOCATION_NAME : w-LS/ACQ/FO
********************************************************************************