Usda Fsa-Itsd-Otc-Dbmo

MRTWebInterface DataStewardApplication

HelpManualforService CenterDataStewardsv1.1

PreparedFor

USDA FSA-ITSD-OTC-DBMO

USDAFSA-ITSD-OTC-DBMO

6501BeaconDriveKansasCity,MO64133-4676

USDA

August26,2015

TableofContents

1Introduction...... 3

2First Time User'sGuide...... 3

3Overview...... 4

3.1Browser...... 4

3.2Support...... 6

3.3ConnectingtotheApplication...... 6

3.4Homepage...... 7

3.5Helppage...... 8

4Service CenterDataSteward...... 9

4.1OverviewofService Center DataStewardFunctions...... 9

4.1.1MRTWIMenu...... 9

4.2Add Office...... 11

4.3Modify Office...... 12

4.3.1AddingaCongress...... 12

4.3.2AddingRepresentativeInformation...... 14

4.4Modifying an Office Mappings...... 18

4.4.1Office Mappings...... 18

4.5View Office Mappings...... 22

4.5.1Office Mapping...... 22

AppendixA:Messages...... 34

A.1HomePage...... 34

A.2HelpPage...... 34

A.3AddOffice...... 34

A.4Modify Office...... 34

A.5Office Mappings...... 34

A.6View Office Mappings...... 34

AppendixB:AcronymsandAbbreviations...... 35

AppendixC:Terms...... 35

AppendixD:UsersTypes...... 37

1Introduction

ThismanualprovidesinformationandinstructionsforusingtheMasterReferenceTable(MRT)DataStewardApplication.Screenshotsareincludedinthismanualforclarity indescribingtheMRTDataStewardApplicationfunctions.

2FirstTimeUser'sGuide

TheMRTData StewardapplicationallowsDataStewardstomaintaindatainaparticularEnterprise MRT.MRTsarebasedonauthoritativedatasourcesandaretheprimarydatasourcefortheinformationtheycontain.

TheMRTDataStewardApplicationsupportsDataStewardswhohavebeenassignedresponsibilityforMRTdatautilized byOCIO-ITSandtheServiceCenterAgencies,whichconsistoftheFarmServiceAgency (FSA),RuralDevelopment(RD),andNaturalResourceConservationService(NRCS). Currently,theInterestRate,ExternalPartner (CMA,LSAandDMA),County,Service Center mappings, DisasterCountyandCongressional DistrictMRTscanbemaintainedthroughtheMRTDataStewardApplication.

ThestepsyouwillneedtotaketogainaccessandbeginusingtheMRTDataStewardApplicationfollow. IfyoualreadyhaveaLevel2eAuthenticationid,youcanskipSteps1and2:

1.UsetheinternettoobtainaUSDAeAuthenticationLevel2account:

Ifyouareagovernmentemployee:

• YouwillneedcopiesofyourlatestAD-334(EarningsandLeaveStatement)andSF50-B(NotificationofPersonnelAction)formstoanswerquestionsduringtheregistrationprocess.
• FromyourinternetbrowsergototheUSDAeAuthenticationsiteat
• Followtheregistrationprocessasdescribed.

If youareacontractor:

• Fromyourinternetbrowser,gototheUSDAeAuthenticationsiteatIeauthentication/
• FollowtheLevel2Accessregistrationprocessasdescribed.

2.CompleteActivationProcess:

If youareagovernmentemployee:

• Within24hours,youwillreceiveanemailfromtheUSDAeAuthenticationHelpDesk containinganactivationlink.
• ClickontheactivationlinkintheconfirmationemailtoactivateyourUSDAeAuthenticationLevel2account.

If youareacontractor:

1.Within24hours,youwillreceiveaconfirmationemailfromtheeAuthenticationHelpDeskcontaininganactivationlink.

2.Within 7days,clickontheconfirmationlinkintheconfirmationemailandfollowallinstructionsprovided.

3.GototheeAuthenticationweb siteat Clickonthe"UpdateYourAccount"link,loginandreview youraccount informationforaccuracy.YourfirstandlastnamemustmatchyourgovernmentissuedphotoID(e.g.,stateissueddriver'slicense).

4.TakeyourgovernmentissuedIDtoyour LocalRegistrationAuthority(LRA)foractivationofyouraccountwithLevel2access.ContactyourlocalInformationSecurityOfficetodeterminewhoyourLRAis.UntilyourLRAactivatesyouraccount,youwillnothaveLevel2access.

3.ObtainaccesstoMRTs:

1.ContacttheMRTteam:

•MRTteamgroupemail:ug-mokansasc2-MRT

•NormaWestbrook at816-926-2688,

•JanetStinsonat816-926-1421,

2.WorkwiththeMRTteamtodeterminewhatMRTsyouareauthorizedtomaintain. TogainaccesstotheMRTdata you are authorized to maintain, you will need to submit a FSA-13A form to FSA Security requesting that theappropriateEASrole(s)beassignedtoyoureAuthenticationLevel2ID.TheMRTteamwillassistyouwiththecompletionofthisform.

3.ProvidetheMRTteamwithyoureAuthenticationLevel2ID. Toprovideyouwithaccesstotheapplication,theMRTteamwillassigntheappropriateIdentityMinderroletoyoureAuthenticationLevel2ID.

4.LogintotheMRTDataStewardApplication:

1.UseyourInternetbrowsertolocatetheMRTDataStewardApplicationsite:

2.ClicktheContinuebuttonontheUSDAeAuthenticationpage.

3.EnteryourUSDAeAuthenticationLevel2AccountUserIDandpasswordontheeAuthenticationLoginpageandclickthe"Login"button.

4.SelectanMRTformaintenancefromtheMasterReferenceDataStewardApplicationHomepage.

5.LogoutoftheMRTDataStewardApplication:

Forsecuritypurposesyoushouldalwayslogoutaftereachsession.TherearetwologoutbuttonoptionslocatedintheheaderportionofanyMRTDataStewardApplicationpage:

•"ExitMRTWI"-Chosethisoptionto logoutoftheMRTDataStewardapplicationandremainloggedontoeAuthentication.

•"LogoutofeAuth"-ChosethisoptiontologoutofbotheAuthenticationandtheMRTDataStewardapplication.

3Overview

TheMRTDataStewardApplicationisawebapplicationthatprovidesMRTDataStewardswiththeabilitytoviewandupdateMRTdata. Majorfeaturesofthisapplicationincludebutarenotlimitedto:

•Limitstheaccesstotheapplicationaccordingtotheroleoftheuser.

•ProvidesselectioncriteriasothatusercanselectcertainrecordsfromtheMRTdatabase.

•DisplaysdetailedinformationfortheselectedMRTrecord.

•ProvidesabilitytoaddnewMRTdataandchangeordeleteexistingMRTdata.

•Validatesuserinputagainstbusinessrules.

TheMRTDataStewardApplicationprovidesuserswitheaseofnavigationandtheconvenienceofdataentry.The"MRTWIMenu"sectionallowstheusertoeasilynavigatethroughtheapplicationbygivingtheuserdifferentoptionstoaccessdifferenttypesofMRTdatadependingonthecurrentuser'sassigneddatastewardrole.

TheMRTDataStewardHomepageprovidesanentrypointformanagingdifferenttypesofMRTData.UsersareabletonavigatetopagesthatmanageMRTdatathroughthe"Home"pageprovidedtheyhavetheappropriatedatastewardrole. ThisHelpGuideprovidesinformationpertainingtousersassignedthecongressionaldistrictdatastewardrole.

Theapplicationvalidatesuser'sinputagainstbusinessrules.InvalidentrieswillnotmakeitintotheMRTdatabase. Forexample,abusinessruleexistswhichstates"The county group code can only be a letter" Ifanattemptismadetoenterdatathatviolatesthisbusinessrule,anerrormessagewillbedisplayed.

3.1Browser

TheMRTData StewardApplicationshouldbeaccessedusingInternetExplorer6orabove.Thereisnoguaranteethatthedisplaywillbecorrectusingotherwebbrowsers.

3.2 Support

Ifyou arehavingproblemswith theMRTDataStewardApplication,pleasecontacttheMRTgroupby emailatug-mokansasc2-MRTorcontactoneoftheindividualslistedinthe"TechnicalHelp"sectionofthe"Help"page.

3.3 Connecting to the Application

TheapplicationcanbeaccessedthroughtheIntranetusingMicrosoftInternetExplorer.TheapplicationislocatedatURL:

YouwillfirstbepresentedwiththeUSDAeAuthenticationLoginpages.AfterenteringyoureAuthenticationUserIDandPassword youwillbepresentedwiththeMRTDataStewardApplicationHomepage. (PleaseseeFigure1).

Note:Ifyouraccesssetupisnotcomplete youmayexperienceoneofthefollowingsituations:

•eAuthenticationdeniesaccesstothehomepage. Inthiscase,contacttheMRTTeamtoverifythattheproperIdentityMinderrolehasbeenassignedtoyoureAuthenticationUserID.

•YouareabletoaccesstheHomePagebutthefollowingerrormessagedisplays:"AnErrorhasoccurred.Thecurrentuserdoesnothave authoritytoaccesstheMRTDataStewardApplication.InternalError-UnrecoverableApplicationError".Inthiscase,FSAsecurityshould be contacted toverifythatrequestedEASrole hasbeenassigned.

3.4Home page

AllfunctionalitywillbeaccessedfromtheMRTDataStewardApplicationHomepage.Therearefourpartsonthispage:

• The"MRTWIMenu"sectiondisplaysawelcomemessagewhichconfirmstheuserhascorrectlyloggedin.Italsolistsalldata stewardfunctionsforwhichthecurrentuserhasbeenauthorized.Asyoucansee,thecurrentpageishighlightedintheMRTWIMenuSection.ThecontentoftheMRTWIMenuSectionwillnot changethroughoutthe application.Itprovidestheuser shortcutstoeachfunctionwithouthavingtogobacktotheHomepage.
• Thesamelinkswillalsoappearinthe"MRTTableMaintenance"sectionofthemainwindow withdescriptionsforeachfunction andaregroupedbyeachtypeofMRTdata.Thereisalsothewelcomemessageonthetop whichconfirmstheuserhascorrectlyloggedin.
• Theheaderhas6usefullinks:MRTWIHome,AboutFSA,Help,ContactUs,ExitMRTWIandLogoutofeAuth.ForsecuritypurposestheusershouldalwayslogoutaftereachsessionbyeitherselectingExitMRTWIorLogout.
• ThefootercontainsmorelinkstogeneralFSA,USDAandwebsiteinformation.

3.5Helppage

Onthehelppage,theusercanfindcontactinformation(SeeFigure2).

Figure2:HelpPage

4Service CenterDataSteward

4.1OverviewofService CenterDataStewardFunctions

AS 400 and control file back ground information

The Service Center Data Stewards access the MRT Web Interface application to add an Office MRT code and to modify Alternate Name, Notes and County File Group Codes.

To access the service center functions the data stewards are required to have one or more of the following roles.

• app.fsa.mrtda.sc.hqsteward.sc
• app.fsa.mrtda.sc.hqview.sc

Service Center Data Stewards that have the app.fsa.mrtda.sc.hqsteward.sc role can use the MRT Data Steward application to:

• Add a MRT code to an office that does not have a MRT code associated.
• Modify an office to add/modify note text and alternate name.
• View office mappings and add county group codes to location areas mapped to the office

Service Center Data Stewards that have the app.fsa.mrtda.sc.hqview.sc role can use the MRT Data Steward application to:

• View the office mappings and county group codes of the associated location areas.

TheMRTDataStewardApplication menuprovidesuserswiththeabilitytoview,addandupdateservice centers like offices and modify county file group codes.

4.1.1MRTWIMenu

The"MRTWIMenu"sectionallowstheusertoeasilynavigateto"Add Office”,"Modify Office",” Office Mappings"and"View Office Mappings"pages.

•Add Office:

Thisoptionallowstheusertoadd a new office.

•Modify Office:

Thisoptionallowstheusertoview or modify existing office.

•Office Mappings

Thisoptionallowstheusertoaddnew office mapping.

•View Office Mappings

Thisoptionallowstheusertoview existing office mappings.

Note: TheMRTWIMenuSectionisincludedoneverypagein theMRTDataStewardApplication.

Figure3: TheMRTDataStewardApplication MRTWIMenuSection

4.2AddingOffice

Thefunctionsavailablethrough the"AddOffice"linkwillbe explained here.

Thebasicflowfollows:

• Selectthe"AddOffice"linkfromthe"MRTWIMenu"or"MRTTableMaintenance"sectionoftheMRTDataStewardApplication Homepage.
• The"AddOffice"page displays. See Figure: 4 Note:requiredfieldswillbemarkedwithanasterisk.
• The application displays a list of states to select. Select a ‘State’ in which the new office is located
• The application displays the list of all FSA offices located in that state. Select new ‘Office’ from the drop down list to enter data
• Enter ‘Office MRT Code’, ‘Alternate Name’ and ‘Notes’. The office MRT code is the FSA state and county code of the location area which will be considered as the headquarters county or as the 'A' county for this office

Figure: 4 Add Office

• Oncealltheinformationfortheofficehasbeenspecifiedclickthe"Add"button tosubmittheinformationentered.
• Thebrowserwilldisplaythe"Add Office"confirmation pagewhere youwillbeabletoviewtheinformationentered.
• Click ‘Done’ button to take you to home page

Figure5:AddOffice confirmation page

Note:Thereisa"Cancel"buttononthe"AddOffice"page.Usethisbuttontoreturn tothe"MRTDataStewardApplicationHome"pagewithout addingan office.

Pleasereferto"AppendixA:Messages-AddOffice"shouldyouencounteranyerrorswhileaddingaoffice.Errormessagesandremediesarelistedthere.

4.3ModifyOffice

Thefunctionsavailablethrough the"ModifyOffice"linkwillbe explained here.

Thebasicflowfollows:

• Selectthe"ModifyOffice"linkfromthe"MRTWIMenu"or"MRTTableMaintenance"sectionoftheMRTDataStewardApplication Homepage.
• The"ModifyOffice"page displays. See Figure: 6 Note:requiredfieldswillbemarkedwithanasterisk.
• The application displays a list of states to select. Select a ‘State’ in which the new office is located
• The application displays the list of all FSA offices located in that state. Select new ‘Office’ from the drop down list to enter data
• Enter ‘Alternate Name’ and ‘Notes’ for existing Office MRT Code. The Office MRT code is the FSA state and county code of the location area which will be considered as the headquarters county or as the 'A' county for this office

Note: Office MRT Code cannot be modified

Figure 7: Modify Office

4.4ModifyinganOffice Mapping

This process can only be used after a successful run of the OIP data stage process that updates internal office information in the database. Modifyinganoffice mappingisaprocess that allows user to associate county file group codes to the location areas mapped to the newly created office reference identifier.

4.4.1Office Mappings

Usethe"Office Mappings"pageto modify an office mapping.

Thebasicflowfollows:

4.4.1.1Selectthe"Office Mappings"linkfromthe"MRTWIMenu"or"MRTTableMaintenance"sectionoftheMRTDataStewardApplicationHomepage.

Figure 6: Office Mappings in MRTWI Menu

• The application displays a list of states to select. Select a ‘State’ in which the new office is located Note:requiredfieldswillbemarkedwithanasterisk
• The application displays the list of all FSA offices located in that state. Select new ‘Office’ from the drop down list to enter data
• Enter ‘Office MRT Code’, ‘Alternate Name’ and ‘Notes’. The office MRT code is the FSA state and county code of the location area which will be considered as the headquarters county or as the 'A' county for this office
• Enter Group Codes to each of the office mappings

Pleaserefer to"AppendixA:Messages-Office Mappings"shouldyouencounteranyerrorswhileaddingan Office Mapping.Errormessagesandremediesarelistedthere.

Figure: 7Office Mappings - InitialDisplay

4.5ViewOffice Mappings

This process can be used by users who cannot modify the office mappings. This functionality requiresthe users to have the ‘app.fsa.mrtda.sc.hqview.sc’ role.

4.5.1Office Mappings

Usethe"View Office Mappings"pageto view an existing office mappings.

Thebasicflowfollows:

4.5.1.1Selectthe"View Office Mappings"linkfromthe"MRTWIMenu"or"MRTTableMaintenance"sectionoftheMRTDataStewardApplicationHomepage.

Figure 8: View Office Mappings in MRTWI Menu

• The application displays a list of states to select. Select a ‘State’ in which the new office is located Note:requiredfieldswillbemarkedwithanasterisk
• The application displays the list of all FSA offices located in that state. Select new ‘Office’ from the drop down list to enter data
• The application displays Office MRT Code, Alternate Name, Notes and a list of Office Mappings

Figure 9: View Office Mappings Initial Display

Lastupdated: 08/26/2015

MRT

AppendixA:Messages

A.1HomePage

A.2HelpPage

A.3Add Office

A.4Modify Office

A.5Office Mappings

AppendixB:AcronymsandAbbreviations

AppendixC:Terms

MRT

AppendixD:UserTypes

MRT