Add a new Reporting Org maintenance page, and review page.
Closed this issue · 2 comments
Please add a new page under the Maintenance tab: "Reporting Org".
Allow insert, update, and delete.
The corresponding database table is: ReportingOrg.
We won't need all the fields, since some no longer apply. The applicable fields can be obtained using the following query:
SELECT [OrgR]
,[OrgName]
,[OrgShortName]
,[OrgCd3Char]
,[IsActive]
,[SecondAndThirdAcctNumCharacters]
,[IsAdminCluster]
,[AdminClusterOrgR]
FROM [AD419].[dbo].[ReportingOrg]
The AD419 application fetches data from this table based on the setting of the IsActive flag = 1.
Please also add a companion page under review that displays the OrgR, and OrgName of those that have an isActive flag of 1, and a link back to the maintenance page for modification as we have for some of the other pages such as Finance Doc Type Codes, etc.
Thank you,
Ken
Are you sure you don't need [OrgCd3Char] ?
We match on it during the project import process.
Yes, you are correct. We need that also.
From: John Knoll [mailto:notifications@github.com]
Sent: Monday, August 08, 2016 11:14 AM
To: ucdavis/AD419DataHelper
Cc: Kenneth J Taylor; Author
Subject: Re: [ucdavis/AD419DataHelper] Add a new Reporting Org maintenance page, and review page. (#39)
Are you sure you don't need [OrgCd3Char] ?
We match on it during the project import process.
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/39#issuecomment-238327118, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAjl4d86J8hYC4UIfeBza-xaNZ-zTVjrks5qd3HYgaJpZM4JfQ76.