You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
Home page for the PeopleSoft - TRansfer Rule Extractor
T-REX will remove the need for PeopleSoft schools to provide transfer rule flat file imports and work through the import process with Halena. Subscribing schools using the flat file import are only allowed two imports per year and must resolve the error/validation issues identified by Halena during the vetting stages.
We believe the above goals are satisfied by the following components:
- Downloadable artifact is packaged as a zip file
- Zip file contains several shell/batch scripts
- Includes a sub directory with the necessary java libraries
- An extractor.properties file for configuration.
- Installation requires school to schedule the weekly extract and send process via favorite platform scheduling service (cron, FireDaemon, etc.)
Milestones for Brett
- Review current CSI usage of PeopleSoft database tables.
- Are we using the correct PeopleSoft database tables?
- Are other PeopleSoft database tables more appropriate?
- Since PeopleSoft versions 8.9 and 9.0 have PeopleSoft database table changes occurred which we must account for?
- Since PeopleSoft versions 8.9 and 9.0 have PeopleSoft database table changes occurred which we should account for?
- Are there occasional school data customizations in the identified PeopleSoft database tables which may be problematic?
- Are there other things we don't know?
- Is there a different table access approach we should consider?
- Review the significant SQL WHERE clauses in use and recommend revisions.
- Identify the details of an alternative all PeopleSoft approach.
- What are the elements/components of the proposed all PeopleSoft approach?
- What are the advantages of the proposed all PeopleSoft approach?
Questions for Brett
tbd
Test Database