SECE XML

ITS Administrative Application (ITSAdmin) pulls data from the SECE Application (SECE) as needed.

An API key is required to communicate with SECE. This api key is stored in SECE's database in table APIKEY. A common occurrence is for the SECE TEST database to be refreshed with production data, which changes the api key thus breaking the communication link between SECE TEST and ITS Admin TEST. The result is no data being pulled into ITS Admin. The fix is to update the api key in ITS Admin's property file to what's in the newly refreshed SECE TEST database or update the api key in SECE TEST database to what's in ITS Admin's property file.

When a student is hired by ITS, a personnel from the Admin Services group will create the record of that student within ITSAdmin.

The process outline:

Calls a struts action defined on the SECE side to lookup a student via the placement ID (plcID). The values are defaulted for transID and plcTransID. Ex. https://sece.its.hawaii.edu/sece/extractSeceData.do?plcID=123450&transID=000&plcTransID=
The call returns an XML file to be parsed locally and saved:

<transaction>
   <header>
     <plcID>323692</plcID>
     <plcStdUhuuid>24318333</plcStdUhuuid>
     <plcStdName>Haake Contento, Mark</plcStdName>
     <plcJobID>7127</plcJobID>
     <payCode>A1</payCode>
     <plcJobTitle>Computer Operator I</plcJobTitle>
     <plcJobPayCode>A11</plcJobPayCode>
     <plcJobPayValue>9.75</plcJobPayValue>
     <deptName>Information Technology Services-Network Operations</deptName>
     <plcType>UH Payroll</plcType>
     <plcActiveDate>11-02-2016</plcActiveDate>
     <plcInactiveDate/>
   </header>
   <transactionOptions>
     <transactionOption>
       <plcTransID>839933</plcTransID>
       <transDescr>11-02-2016 Hire Student - Establish on UH Payroll</transDescr>
     </transactionOption>
   </transactionOptions>
</transaction>