CDL elements specialized grant columns

[qjhart]

Vessela has supplied a methodology for adding new columns for the grants upload data, https://qa-oapolicy.universityofcalifornia.edu/objecttype.html?cid=2&tid=91

We need to see if this works, and how it's represented in the interface, and the API calls.

We've decided as a first step to add a column for the funder_uri. This will point back to the rems code.

• [x] Add in the column definition [quinn]
• [x] Update feed [roger]

This is part of #223 as well.

[qjhart]

I have added the following c-davis underlying field c-ucop-sponsor which is set to be a URL. This is meant to hold the sponsor code for grants. The format for those URIs is http:/rems.ucop.edu/sponsor/[CODE] where [CODE] is a valid REMS sponsor code.

I have also added a new field for c-davis, sponsor code using this underlying field. The instructions say they need to be propagated to the reporting database, I don''t know if we need to send a request for that action.

[qjhart]

@rakunkel-ucd This is the information about this new column.

[rakunkel-ucd]

Confirmed that the ucop-sponsor field now exits in grants in QA.

[qjhart]

Here's an example of how that shows up in the API

describe ?record
where { graph cdl: { 
    ?s :category "grant";
       :records/:record ?record;
       .
  } } limit 1

:13955697  oap:format         "native";
        oap:id-at-source         "ark:/87287/d7gt0q/grant/102424";
        oap:native               [ oap:field  [ oap:display-name  "Funder reference";
                                                oap:name          "funder-reference";
                                                oap:text          "NNX11AF93G";
                                                oap:type          "text"
                                              ];
                                   oap:field  [ oap:display-name  "Funder name";
                                                oap:name          "funder-name";
                                                oap:text          "NASA/MISCELLANEOUS CENTERS";
                                                oap:type          "text"
                                              ];
                                   oap:field  [ oap:display-name  "ucop-sponsor";
                                                oap:name          "c-ucop-sponsor";
                                                oap:text          "http://rems.ucop.edu/sponsor/5101";
                                                oap:type          "text"
                                              ];
                              ];