Skip to content

Aggie Enterprise Migration

Jump to bottom
Jason Sylvestre edited this page Aug 31, 2023 · 3 revisions

December-ish

  • Ensure latest code is merged and deployed.
  • Confirm Config settings are as expected

Default Config Settings

"Finance": {
"ClearingChart": "3",
"ClearingAccount": "XXCLEAR",
"FeeChart": "3",
"FeeAccount": "XXXXFEE",
"ClearingFinancialSegmentString": "3110-13U20-ADNO003-238538-00-000-GLPEV00118-000000-0000-000000-000000",
"FeeFinancialSegmentString": "3110-13U20-ADNO003-410000-00-000-GLPEV00117-000000-0000-000000-000000",
"ValidateFinancialSegmentString": false,
"UseCoa": false,
"ShowCoa": false}


"AggieEnterprise": {
"GraphQlUrl": "[External]",
"Token": "[External]",
"ConsumerKey": "[External]",
"ConsumerSecret": "[External]",
"TokenEndpoint": "[External]",
"ScopeApp": "Payments-Web",
"ScopeEnv": "Test"}

Sometime in December

  • Get list of users with active roles in active team for Brian

SELECT TOP (100) PERCENT dbo.AspNetUsers.CampusKerberos, dbo.AspNetUsers.Email, dbo.AspNetUsers.Name, dbo.Teams.Name AS [Team Name], dbo.Teams.Slug, dbo.TeamRoles.Name AS Role FROM dbo.Teams INNER JOIN dbo.TeamPermissions ON dbo.Teams.Id = dbo.TeamPermissions.TeamId INNER JOIN dbo.AspNetUsers ON dbo.TeamPermissions.UserId = dbo.AspNetUsers.Id INNER JOIN dbo.TeamRoles ON dbo.TeamPermissions.RoleId = dbo.TeamRoles.Id WHERE (dbo.Teams.IsActive = 1) ORDER BY dbo.AspNetUsers.CampusKerberos, Role, [Team Name]

  • Communicate with users about editing their accounts
  • Update config settings for AE so they can enter and validate COAs
  • Update config to showCoa
  • They can do a one time edit on existing accounts to add a COA
  • They must edit their Default account to have a valid COA
  • Note: By Default, when using COA, there must be a value when sending to sloth, but we don't validate it at upload time. This allows sloth to validate it and have it fixed then. Note!!! Sloth's validation does not include special validation that payments does for things like the fund "13U00,13U01,13U02".
  • Don't think we need a config setting for AutoApprove in sloth. We can probably use prod AE with sandbox keys (test in test first) if that happens, AE txns should remain in scheduled status.

End of December

  • Update config to UseCoa
  • Update Sloth to use COA holding/clearing accounts.

Clone this wiki locally