BANNER
Download
1 / 45

BANNER ATTRIBUTES - PowerPoint PPT Presentation


  • 905 Views
  • Uploaded on

BANNER ATTRIBUTES. Using Banner Attributes. Uses of Attributes. As Extension of the Chart of Accounts To Add Reporting Flexibility To Enhance Accounting Controls. Using Banner Attributes.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'BANNER ATTRIBUTES' - Pat_Xavi


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Slide1 l.jpg

BANNER

ATTRIBUTES


Slide2 l.jpg

Using Banner Attributes

Uses of Attributes

  • As Extension of the Chart of Accounts

  • To Add Reporting Flexibility

  • To Enhance Accounting Controls


Slide3 l.jpg

Using Banner Attributes

  • Allows for groupings of similar information without having to build structure into account, fund or org codes

  • Provides a controlled method to classifying large groups of data

  • Enables dynamic reporting

Extension of the Chart of Accounts


Slide4 l.jpg

Using Banner Attributes

  • 990 Reporting

  • NSF Survey

  • NCAA Annual Audit

  • Internal Financial Reports

Adds Reporting Flexibility

  • Changes more easily applied

  • Easier to maintain consistency

  • At Lehigh codes used for:


Slide5 l.jpg

Using Banner Attributes

  • Authorization Verification

  • Reoccurring Entry Calculations

  • Report Distribution Control

To Enhance Accounting Controls


Slide6 l.jpg

Creating Banner Attributes

Will Attributes Work?

  • What are you trying to group/control?

  • Who is going to maintain it?

  • Is there another way?


Slide7 l.jpg

Roll up by Entity

Roll up by Accounts

Creating Banner Attributes

Lay It All Out – Be Specific


Slide9 l.jpg

Creating Banner Attributes

  • FTMCOAS – Define Set usage within COA

  • FTMATTT – Maintain TYPE codes

  • FTMATTS – Maintain SET codes

  • FTMATTV – Maintain valid VALUES

Forms Used to Create Attribute

Must be set up in the order as shown



Slide11 l.jpg

Creating Banner Attributes

ATTRIBUTE TYPE CODES

  • All TYPE codes are maintained on one table

  • Each TYPE code can be associated with multiple FOAPAL elements

  • Sample of TYPE codes used at Lehigh:

  • 990IILIN – linked to accounts for 990 line items

  • 990IICOL – linked to funds/orgs for 990 columns

  • NCAALIN – linked to accounts for NCAA reporting

  • AUTH* – linked to funds/orgs for authorized signers

  • FDST* – linked to funds/orgs for report distribution



Slide13 l.jpg

Creating Banner Attributes

ATTRIBUTE SET CODES

  • All SET codes maintained on one table

  • Used to further combine TYPEs for reporting purposes

  • Not required to use Attributes

  • Once initialized [FTMCOAS] is permanent

  • SET usage is initialized at Lehigh


Slide14 l.jpg

Banner Form FTMATTS

To create a new set:

Enter Chart of Accounts

Fill in code and description

Select FOAPAL element

Click on menu option “Select Attribute Types to Associate with Set


Slide15 l.jpg

Check TYPES to include

When complete select save


Slide18 l.jpg

Creating Banner Attributes

SETTING VALUES for TYPE’s

  • Specific values defined for each attribute TYPE

  • All VALUES, by TYPE, are on one table

  • Refine FOAPAL element(s) that can use it (e.g., FUND only, ORGN only, BOTH - based on TYPE FOAPAL definition)


Slide22 l.jpg

Applying the Attributes

Assigning the Attributes on Banner

  • ASSIGNED via form FTMFATA

  • VIEWED via form FTIFATA



Slide34 l.jpg

Select a FOAPAL and Criteria

To View Associations use form FTIFATA




Slide42 l.jpg

Working with the Attributes

Putting the Attributes to work

Oracle Tables for use via Access:

  • FIMSMGR_FTRORGA – ORGN usage

  • FIMSMGR_FTRFNDA – FUND usage

  • FIMSMGR_FTRATTS – Sets w/Type

  • FIMSMGR_FTRATTV – Type w/Values

  • FIMSMGR_FTVATTS – Valid Sets only

  • FIMSMGR_FTVATTT – Valid Types only


Slide43 l.jpg

Working with the Attributes

Putting the Attributes to work

  • Join Attribute Tables to Data tables via Microsoft Access

  • Key field(s) for join dependent on defined FOAPAL relationship of attribute and data being queried

  • Once joined, all attributes TYPE, SET, VALUES and descriptions are available for selecting, summarizing, printing, etc.



Slide45 l.jpg

BANNER

ATTRIBUTES

Thanks for your attention!

Questions ???????


ad