Create a view to easily allow expired project remapping
Closed this issue · 8 comments
Shannon first searches by Principal Investigator, then by department, and lastly by project title.
I will provide the list of expired projects that she will need to remap, and then she will go through the selection process in a similar fashion as described above.
Do we have a place to store the remapped information (new column?).
We can do search w/ auto type on those 3 columns.
@taylorkj What table/sql contains the projects that need remapping?
Where should I store the choosen remapped project number?
The remapped project information is stored in the ExpiredProjectCrossReference table. This is where the end results go after they are through picking.
You can determine which projects need to be remapped by providing the Fiscal Year to the stored procedure thusly:
select * FROM udf_GetExpired20xProjects(2015)
You can get the list of possible replacements by using the following examples:
@jpknoll: Yup, it doesn't return any data for me at this time either, because I was doing some database cleanup and I apparently deleted the table! I will recreate it once I go through the regeneration process. Sorry.
@jpknoll: Hi John, I re-created and populated the table, so it's now working as intended.
Cheers,
Ken
Ok, I look forward to seeing it.
Thanks,
Ken
Get Outlook for Androidhttps://aka.ms/ghei36
On Mon, Jul 25, 2016 at 2:01 PM -0700, "John Knoll" <notifications@github.commailto:notifications@github.com> wrote:
@taylorkjhttps://github.com/taylorkj i can demo the feature to you next time you're in the office.
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://github.com//issues/26#issuecomment-235083711, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAjl4QvdB1EXsimKA7jTy6iFpTnpzxj9ks5qZSP_gaJpZM4JAXwr.