250 likes | 446 Vues
New HMMS DRMO Interface Terry Owens, IHS Souriya Sengsouvanna, IHS August 25, 2010. New HMMS DRMO Interface. The Defense Reutilization and Marketing Office (DRMO) Interface was established;
E N D
New HMMS DRMO Interface Terry Owens, IHS Souriya Sengsouvanna, IHS August 25, 2010
New HMMS DRMO Interface • The Defense Reutilization and Marketing Office (DRMO) Interface was established; • To provide Disposal Turn In Documents and Waste Profile Sheets electronically from HMMS to the DRMO. • To receive shipping and funding information from DRMO to HMMS. • A new DRMO Management screen has been added to HMMS and can be found under Administration > Waste > DRMO Management. • Users must have this screen access added to their default HMMS profile. • Additionally, there are four values that need to be into the “Site Configuration” screen to fully enable the new HMMS/DRMO electronic interface.
DRMO Management Screen • The new DRMO Management screen performs the following functions: • Scheduling • Activation State • Automatic funding update • Management Notifications • DRMO Management Users
DRMO Management Screen • Scheduling • Users are able to define when they want the communications between HMMS and DRMO to take place. Schedule options change depending on the selection. • Hourly — Every hour at the top of each hour. • Daily — Once each day. Inputs are provided to set the specified time. Time is input on a 24-hour clock. • Weekly — Once each week. Inputs are provided to specify the day of the week and the time. • Monthly — Once each month. Inputs are provided to specify the day of the month and the time.
DRMO Management Screen • Activation State • Allows you to choose the portions of the interface, if any, that will run at your site. • This indicator will also be reflected in the “About” screen DRMO Status field. The status will show active if any portion of the DRMO interface is activated or inactive if not activated. • Will default to Not Active, so after the release is loaded onto your server, you will be required to make a selection to get the DRMO interface to run. • The following options are available: • Both Active • DRMO to HMMS • HMMS to DRMO • Not Active
DRMO Management Screen Automatic funding update Occasionally, when you send a GENCOMM to DRMO, DRMO may find some discrepancies that impact waste funding. DRMO sends data regarding these discrepancies in their DRMOGEN file. You can choose to automatically update HMMS funding information with DRMOGEN funding data or not by using the following settings: Override Site Contract with DRMO This configuration has been moved from the Site Configuration screen to the DRMO Managements screen. If this configuration is set to yes, contract information returned from DRMO will override any contract information that you have previously assigned to a waste container. Override Site Weight with DRMO This configuration has been moved from the Site Configuration screen to the DRMO Managements screen. If this configuration is set to yes, the container weight returned from DRMO will override the weight that you have previously assigned to a waste container. Add new DRMO CLIN This configuration has been moved from the Site Configuration screen to the DRMO Managements screen. If this configuration is set to yes, and DRMO sends a CLIN that is not already associated with a waste container, the CLIN will be added to HMMS. Override DRMO Update This configuration has been moved from the Site Configuration screen to the DRMO Managements screen. If this configuration is set to yes, and the interface returns an update to a container record that is different from a previous update sent by DRMO, the field(s) will be updated with the new information.
DRMO Management Screen • Management Notifications • The DRMO interface prepares and sends files to DRMO from HMMS and receives and processes files from DRMO to HMMS. • The DRMO Management Notifications section of the screen will show different records attached to the files and reports applicable to the interface. • HMMS GENCOMM File Report • HMMS GENCOMM File • GENCOMM Log File • DRMOGEN File • DRMOGEN Update • You can delete notifications when you do not need to view them anymore; deleting a notification will not affect the interface file transfers. • Notifications will be automatically deleted after six months to keep the table manageable.
Management Notifications • HMMS GENCOMM File Report: • This report is a “readable report format” of the actual GENCOMM data sent to DRMO. • The report has the following fields: • Container Number – Lists the containers sent to DRMO. • Turn In Doc Number – Lists the DTIDS associated with the containers sent to DRMO. • Profile Number – Lists the profile number associated with the container • Name of Waste – Lists the name of waste from the profile associated with the container • DRMO Send Date – Lists the day that the container was sent to DRMO.
Management NotificationsHMMS GENCOMM File • The actual GENCOMM file sent to DRMO. • This file is available to you and very useful if you are ever required to trouble-shoot interface problems with DRMO.
Management NotificationsHMMS GENCOMM File FB2067|2010188|1412|5.0.0|SXGD|ENVMX 4.0 beg_wps_sect PROFILE1|WASTE|ADDRESS1| |SLC, UT|84121|GEN1| | | |UNKNOWN|2010188|DRMO PROFILE1|UNKNOWN|0000000000.0000| | |N|N|N|N| | |000.000|0000000000|000.00|000.00| |SOLID|N|N|0000.0|N|N|N|N|N|N|N|0000000.0|N|N|0| |0| |0| |0| |0| |0| |0| |0| | |0| |N|UREA NITRATE, DRY OR WETTED WITH LESS THAN 20 PERCENT WATER, BY MASS| |UN0220| | |0| |II|1| | | | | | beg_comp_sect NONE|NA|NA|NA end_comp_sect beg_ewn_sect NONE|NA|NA end_ewn_sect end_wps_sect beg_dtid_sect 6810|00WASTE| |FB206701391CP1|LB|000030| |W|00000.01|DRMO PROFILE1|H| |2010188|PROFILE1| | |1 QT BA|000030|P| | |DRMO WCS1 DESCRIPTION|A 19T401AMBASYE|721-4668|UREA NITRATE, DRY OR WETTED WITH LESS THAN 20 PERCENT WATER,|BY MASS| | |CON1|0814|01500.00|81| | |2 beg_cont_sect FB206701391CP1|DRMS1 | |000010|2010188 FB206701391CP1|DRMS2 | |000020|2010188 end_cont_sect beg_dtidepa_sect
Management NotificationsGENCOMM Log File • The actual file received from DRMO showing the DTIDs received and being processed. • This file will identify any records that have been rejected by DRMO.
Management NotificationsGENCOMM Log File Fri May 14 12:20:00 EDT 2010 SESSION LOG-GENERATOR TO DRMO FILE TRANSFER,VER:5.0 ********************************************************** 1030:DATA DIRECTORY = /func/shipdrmo/data/gencomm/upload 1030:DATA FILE = FB2067.134a VERSION 5.0.0 1030:SESSION LOG FILE = FB2067.134a.log ********************************************************** PROCESSING WPS "PROFILE1" PROCESSING WPS "PROFILE2" PROCESSING WPS "PROFILE3" PROCESSING DTID "FB206701331DP1" PROCESSING DTID "FB206701331DP2" PROCESSING DTID "FB206701331DP3" PROCESSING DTID "FB206701332DP1" PROCESSING DTID "FB206701341DP1" PROCESSING DTID "FB206701341DP2" PROCESSING DTID "FB206701341DP3" PROCESSING DTID "FB206701342DP1" SUBMITTED DATA FILE ANALYSIS COMPLETED 1050: TOTAL PACKAGES READ = 11 1050: TOTAL PACKAGES REJECTED = 0 1050: TOTAL UNKNOWN PACKAGES REJECTED = 0 1050: TOTAL WPS PACKAGES READ = 3 1050: TOTAL WPS PACKAGES REJECTED = 0 1050: TOTAL DTID PACKAGES READ = 8 1050: TOTAL DTID PACKAGES REJECTED = 0 ******AT THE END OF ANALYSIS SECTION****** NOTE:RAW=FB2067.134a DRMO dir=sxga DODAAC dir=fb2067 NOTE: RAW=FB2067.134a UDCF11 file=/func/shipdrmo/data/gencomm/UDCF11_SXGAFB2067.134a
Management NotificationsDRMOGEN File • A formatted readable version of the actual data file sent to HMMS from DRMO showing such items as disposition, CLIN data, etc. • The sections of this report vary depending on the information sent back from DRMO.
Management NotificationsDRMOGen Update • The actual data file sent to HMMS from DRMO. • This file is available to you and very useful if you are ever required to trouble-shoot interface problems with DRMO.
Management NotificationsDRMOGen Update FB2067|2010139|1038|5.0.0|SXGD|6.19 beg_do_sect FB206701391CP1|G|1003|LB|110.33|00000.11|71766456|7097|CON1|1234|0815|0815 FB206701392CP1|G|1007|LB|221.54|00000.22|71766456|7097|CON1|5678|0813|0813 FB206701393CP1|G|505|LB|166.65|00000.33|71766456|7097|CON2|5678|0813|0813 FB206701391CP2|G|1013|LB|445.72|00000.44|71766456|7097|CON1|4321|0813|0813 FB206701391CP3|G|2038|LB|1120.9|00000.55|71766456|7097|CON1|8765|0813|0813 end_do_sect beg_pmf_sect FB206701391CP1|71586062|9TSDFEPAID1|DRMOMANIFEST|1|1|1|CY|100|LB|2010139|2010139|1|2010139|M10 beg_epa_sect FB206701391CP1|71586080|DRMOMANIFEST|D006|1 FB206701391CP1|71586080|DRMOMANIFEST|D007|2 end_epa_sect beg_hndl_sect FB206701391CP1|71586045|DRMOMANIFEST|HC1|1 end_hndl_sect beg_tran_sect FB206701391CP1|71586045|DRMOMANIFEST|9TRANSEPAID1|2010139|1 end_tran_sect FB206701392CP1|71586062|9TSDFEPAID1|DRMOMANIFEST|1|1|1|CY|200|LB|2010139|2010139|1|2010139|M10 beg_epa_sect FB206701392CP1|71586080|DRMOMANIFEST|D006|1 end_epa_sect
DRMO Management Users • As the DRMO interface prepares and sends files to DRMO from HMMS and receives and processes files from DRMO to HMMS, the DRMO Management Notifications section of the screen will show different records attached to the files and reports applicable to the interface. • If you want to receive these notifications in your inbox, then you can add your user id in the DRMO Management User section of the DRMO Management screen.