...

insert into ps_sponsor_mappings(sponsor_code, fed_agency, reporting_agency, display_acronym, mapping_level, update_timestamp, update_user, ver_nbr, obj_id) values
	('000000', 'DOD', 'DOD', 'DOD>USMA>', 1, sysdate, 'admin', 1, sys_guid());
	-- First parameter is the six-digit sponsor code
    -- Second parameter is the Federal Agency code
    -- Third parameter is the Reporting Agency code
    -- Fourth parameter is the Display Acronym
    -- Other parameters can be left with the provided values

Other

...

Update RAS Menu Files (Job Aids, Checklists, etc)

There are a number of files hosted on the RAS web servers that are linked in the main 'Researcher' menu of the application (screenshot below). Occasionally, new versions of these files will need to be uploaded.

To update these files, use WinSCP (or another SCP/FTP tool) to upload the new file to BOTH raweb-prod-01 and raweb-prod-02, and copy the file(s) to the directory:

/usr/local/apache-tomcat-8.5.38/webapps/ROOT/ras_docs/

Ensure that the filename matches the existing files so that the links will still work.

Image Added

Update Known Issues List

See Known Issues Page.