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
MESSAGETYPE / MESSAGE / TRIGGER / EVENT
Error / ThecurrentuserdoesnothaveauthoritytoaccesstheMRTDataStewardApplication. / Theuserattempted toaccesstheMRTWebInterfaceapplication butdoesnothaveanappropriateroledefinedinEAS.

A.2HelpPage

MESSAGETYPE / MESSAGE / TRIGGER / EVENT
NONEANTICIPATED

A.3Add Office

MESSAGETYPE / MESSAGE / TRIGGER / EVENT
Info / State is a required field. Office is a required field. Office MRT Code is a required field / No value is selected for ‘State’, ‘Office’, ’Office MRT Code’
Info / Office is a required field. Office MRT Code is a required field. / No value is selected for ‘Office’, ’Office MRT Code’
Info / Office MRT Code is a required field / No MRT Code value is entered in the text field
Info / Office MRT code is a numeric with five digits or more / Invalid format MRT Code value entered

A.4Modify Office

MESSAGETYPE / MESSAGE / TRIGGER / EVENT
Info / State is a required field. Office is a required field. / No value is selected for ‘State’, ‘Office’
Info / Office is a required field. / No value is selected for ‘Office’

A.5Office Mappings

MESSAGETYPE / MESSAGE / TRIGGER / EVENT
Info / State is a required field. Office is a required field. / No value is selected for ‘State’, ‘Office’
Info / Office is a required field. / No value is selected for ‘Office’
Info / Group Code is a single letter / Invalid format Group Code value entered

AppendixB:AcronymsandAbbreviations

ACRONYM/ABBREVI ATION / TERM
AMC/AO / Architectureand ManagementCenterIArchitectureOffice
AMC/ClTSO / ArchitectureandManagementCenterICommonInformationTechnologySolutionsOffice
EAS / ExtensibleAuthorizationService
eAuth / eAuthentication
FSA / FarmServiceAgency
ICAMS / InternetCombinedAdministrativeManagementSystem
ITSD/OTC/DBMO / InformationTechnologyServicesDivisionIOperationsandTestingCenter
IDatabaseManagement Office
MRT / MasterReferenceTable
MRTWI / MRTWebInterface
NRCS / NationalResourceConservationService
OCIO-ITS / OfficeoftheChiefInformationOfficer-InformationTechnologyServices

AppendixC:Terms

TERM / DEFINITION
Agency Database / MRTSQLServer2005 databaselocatedoneachagency'sWebFarm.Itiscreatedbyreplicating thechangesappliedtotheITS-ManagedDatabase.TheAgencyDatabaseiswhere dataisde-normalizedforapplicationefficiency.NoupdatesareapplieddirectlytotheAgencyDatabasethroughtheMRTDataStewardApplication.
Architectureand ManagementCenterIArchitectureOffice / FSAofficewhichprovidesenterprisesystemarchitectureoversightbyprovidingcommonpoliciesandstandards, systemreviewsandwalk- through,andaddressingcommonITissues.
ArchitectureandManagementCenterICommonInformationTechnologySolutionsOffice / FSAofficewhichprovidescommontechnologysolutionsforITissues.EASisoneofthesystemssponsoredbytheCommonInformationTechnologySolutionsOffice.
eAuthentication / USDA'scentralized authenticationserviceforUSDAweb services
Extensible AuthorizationService / Arole-basedauthorizationserviceforusebyvarious applicationssponsoredbyUSDA/FSA/AMC/CITSO.
FarmServiceAgency / AUSDAagency thatisalsoknownasaServiceCenteragency.
IdentityMinder / TherolemanagementcomponentofeAuthentication.
InformationTechnologyServicesDivisionIOperationsandTestingCenterIDatabaseManagementOffice / FSAofficewhichdesigns,implementsandmonitorsmajorOCIO-ITSand ServiceCenterdatabases,supportstheenterprisemodelthroughrepositorytechnology,andprovidessystemlifecycledevelopmentstandards.
InternetCombined AdministrativeManagementSystem / Authoritativesourceofbasicinformationonemployees
InternalDatabase / MRTSQL Server2005databaselocatedontheKansasCityFSAWebFarm.TheInternalDatabaseiswhereMRTdataismanaged and normalized.AllupdatesmadethroughtheMRTDataStewardApplicationoccurtotheInternal Database.
MasterReferenceTable / Anenterprise-wide datasourcethatfeedsbothtransactionsystemsanddatawarehousesystems.
MRTFunctionalArea / RepresentsagroupoffunctionallyrelateddataforwhichMRTmaintenancefunctionsareperformed,forexample InterestRatefunctionalareaor ExternalPartnerfunctionalarea.
Office / Anofficeisrecognizedasaseparatecomponentofafederalagency,aunitofstateor localgovernment,oraunitofarelatednon-governmentalorganizationsuchasaConservationDistrict.FSAapplicationscommonlyrefertoanofficeasaServiceCenter,County,CountyOffice,HeadquartersCounty,etc.
Office MRT Code / A superset of various codes systems used to identify an office
Group Code / This code contains a character used to identify information fora specific geographic county. An "A" in the first position of aname identifies it as data for the county where the office islocated. When an office administers FSA programs for anearby county that does not have an FSA Office, theinformation will have a County File Group Code of "B".
Information referencing a third county will contain a "C", etc.Control information that does not relate to specific farmacreage contain a "T". Information for State use only containthe value "S".
Domain:
A Headquarters County Office file
B - R Serviced County file
S State files
T Shared County Control files
Alternate Name / An alternate name used by an agency to identify a county or office.
This name is used rather than the standard name.
Note Text / A textual note in a free format.

MRT

AppendixD:UserTypes

ACTOR / DEFINITION
DataSteward / Ageneraltermforapersonidentifiedas beingresponsibleformaintainingaspecificsetofdatawithintheMRTWebInterfaceapplication.Thisterm isinterchangeablywithMRTDataSteward.
Service CenterDataSteward / Apersonidentifiedasbeingresponsibleformaintaining
Office MRT code association and county file group codeswithintheMRTWebInterfaceapplication
MRTDataSteward / Ageneralterm forapersonidentifiedasbeingresponsibleformaintainingaspecificsetofdatawithintheMRTWebInterfaceapplication

MRT