Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • What Banner FIS calls Index Codes are called GLAs (General “General Ledger AccountsAccounts”) by PCR-360

  • What Banner FIS calls Organizations are called Departments by PCR-360

  • Billing Groups are an OIT/Telecom invention in PCR-360 that classifies aspects of University operations based on how they’re funded (so we can charge different rates for some services):

    • E&G means Education & General Funded, more precisely activities that are related to budgeted operations of the University (the specific Fund-based logic is described below)

    • JV (“Journal Voucher”) means Service & Grant Funded, more precisely everything that’s all University activities that are not E&G funded

    • CASH means cash customers, entities that are not part of the University (retail customers)

Telephone service is billed differently for E&G vs. JV vs. CASH customers, so it’s important to classify the usage of each service by billing group, which we do based on the fund classification of the index code that’s paying for it. However, nonNon-telephone services generally bill everyone at the same price no matter which billing group they’re in.

How do these things get into PCR-360?

Index

...

Codes/GLAs

...

are automated

  1. The Schedule_Index_List Cognos report is generated every morning and its export file is uploaded to the PCR-360 server (/wiki/spaces/TKB/pages/1724645544 managed by BI team + server operations by LAP)

  2. PCR-360 detects and imports the file, as described in /wiki/spaces/ICAT/pages/2205647320

  3. The result is that the GLA Catalog is always an accurate representation of Banner index codes (including the codes themselves, their descriptions, active/inactive statuses, and even further FOAPAL associations in User Defined Fields).

Orgs/Departments (E&G + JV

...

) are manual

The E&G and JV branches of the Department Hierarchy were initially populated from a bulk import in 2017, and have been manually maintained since then. Departments only appear here in the Department Hierarchy if they are manually added.

Departments whose index codes are all associated with E&G funds (below) should only have an “E&G” version; departments who have only JV fund-associated index codes should have only a “JV” version; departments with index codes which are associated with both types of funds should have two Department entries, one of each type. The Department list allows us to associate each IT service with a Department Owner, and the connection to a default index code and the billing group classification helps set GLAs and billing groups more automatically, though not perfectly.

CASH Departments & GLAs

...

are manual

These are manually created and linked by the SMO team as part of cash customer onboarding (Specific PCR-360 Procedures).

ESIGN Departments

...

were a mistake

These seem to have been invented by Layton Webber as a pilot of how Adobe Sign charges might be linked to their customer GLAs. They are no longer in use for this purpose and are in the process of being were inactivated and removed by the directory by Brent Emerson (SMO-308). Until this is complete, they They should not be used in service orders.

...

  1. Each Department has one Default GLA assigned; when that Department is selected on a Service Order, that GLA is autofilled as the Default GLA for that order. Conversely, if you search for one of the default GLAs in the Department Owner field, it will turn up the associated Department. If you search for a GLA that is not linked to a Department in this way, no Department will be returned. The mapping is from each Department to one index code; there is no guarantee that each index code is in the mappingmap.

  2. The GLA Permissions tab on each Department allows us to associate multiple GLAs with each Department, ostensibly for the purpose of restricting Coordinators to using certain GLAs based on their Department affiliation. We don’t use this feature, and the GLAs listed on this tab don’t help autofill the Department Owner field on Service Orders as the Default GLA does.

...