BRIM Collection Data Diagram

The diagram illustrates the architecture of the BRIM Business Objects Universe, and identifies joins. While viewing the diagram, you can also display its table documentation. If you need to print the diagram, print it in landscape orientation.

BRIM UNIVERSE CLASSES

Classes are roughly equivalent to database tables, and may include extra columns providing descriptions of codes from decode tables. In cases where all the elements from the decode table are available from querying, they are displayed in a subfolder of the table/class to which the decode table is joined. In general, these folders are prefixed by an acronym representing the main table (ie, APP for Automatic Payment Profiles).

BRIM Automatic Payment Profiles
° APP Fund Codes

BRIM Cash Receipts
° CR Fund Codes
° CR Par and GP RespOrg Codes

BRIM Funds
° FND Budget Periods
° FND Fund Codes
° FND Fund Codes Gp
° FND Fund Codes P
° FND Par and GP RespOrg Codes

BRIM Fund SB Expenses
° FSBE Fund Codes
° FSBE Par and GP RespOrg Codes

BRIM Billed Fund Object Expenses
° BFOE Fund Codes
° BFOE Fund Codes Gp
° BFOE Fund Codes P
° BFOE Object Codes
° BFOE Par Object Codes Gp
° BFOE Par Object Codes P
° BFOE Par and GP RespOrg Codes

BRIM Unbilled Fund Object Expenses
° UFOE Fund Codes
° UFOE Fund Codes Gp
° UFOE Fund Codes P
° UFOE Object Codes
° UFOE Par Object Codes Gp
° UFOE Par Object Codes P
° UFOE Par and GP RespOrg Codes

Balances (identical to the Balances class in the FINQUERY universe, with the exception of the BRIM Balances Objects folder, which is unique to the BRIM universe)

BRIM Balances Objects (contains these objects derived from Balances columns):

• Cash Received Actual Month (BAL)
  [sum(case when DWADMIN.BALANCES_V.coa_object in ('1220','4600') then DWADMIN.BALANCES_V.actual_month else 0 end)]
• Cash Received Actual PJTD (BAL)
  [sum(case when DWADMIN.BALANCES_V.coa_object in ('1220','4600') then DWADMIN.BALANCES_V.actual_pjtd else 0 end)]
• PBIL Pjtd (BAL)
  [sum(decode(DWADMIN.BALANCES_V.COA_OBJECT, 'PBIL', DWADMIN.BALANCES_V.SPECIAL_BUDGET_PJTD,0))]
• Total Expense Actual Month (BAL)
  [sum((case when DWADMIN.BALANCES_V.COA_OBJECT IN (SELECT CHILD_OBJECT FROM DWADMIN.PARENT_OBJECT_CODES WHERE PARENT_OBJECT_CODES.PARENT_OBJECT between 'SB01' and 'SB40') then DWADMIN.BALANCES_V.ACTUAL_MONTH else 0 end)]
• Total Expense Actual PJTD (BAL)
  [sum((case when DWADMIN.BALANCES_V.COA_OBJECT IN (SELECT CHILD_OBJECT FROM DWADMIN.PARENT_OBJECT_CODES WHERE PARENT_OBJECT_CODES.PARENT_OBJECT between 'SB01' and 'SB40') then DWADMIN.BALANCES_V.ACTUAL_PJTD else 0 end)]
• 1220 Actual Month (BAL)
  [sum(decode(DWADMIN.BALANCES_V.COA_OBJECT, '1220',DWADMIN.BALANCES_V.ACTUAL_MONTH,0))]
• 1220 Actual Pjtd (BAL)
  [sum(decode(DWADMIN.BALANCES_V.COA_OBJECT, '1220',DWADMIN.BALANCES_V.ACTUAL_PJTD,0))]
• 4600 Actual Month (BAL)
  [sum(decode(DWADMIN.BALANCES_V.COA_OBJECT, '4600',DWADMIN.BALANCES_V.ACTUAL_MONTH,0))]
• 4600 Actual Pjtd (BAL)
  [sum(decode(DWADMIN.BALANCES_V.COA_OBJECT, '4600',DWADMIN.BALANCES_V.ACTUAL_PJTD,0))]
  

GL Detail

FINQUERY Reference Tables (as in the FINQUERY universe)
° Budget Periods
° Center Ref Codes
° Cnac Codes
° Fund Codes
° Fund Freeze
° Fund Freeze History
° Fund Status
° Object Codes
° Org Codes
° Org Codes Resp
° Par Cnac Codes Gp
° Par Cnac Codes P
° Par Fund Codes Gp
° Par Fund Codes P
° Par Object Codes Gp
° Par Object Codes P
° Par Org Codes Gp
° Par Org Codes P
° Par Pgm Codes Gp
° Par Pgm Codes P
° Par Resporg Codes Gp
° Par Resporg Codes P
° Program Codes