Allocation Lookup

Allocation

The code of the allocation.

Account

The account number corresponding to the general ledger account number used by the controller’s or treasurer’s office.

Account 2

The second account number corresponding to the general ledger account number used by the controller’s or treasurer’s office.

Short Name

The short name of the allocation.

Long Name

The long name of the allocation.

Long Name 2

Additional space for the long name of the allocation.

CFAE Purpose

The value in the CFAE Reporting Purpose field of tms_cfae_purpose corresponds to the row in the matrix part of the CFAE report. The CFAE Reporting Purpose table contains the actual line number that corresponds to the line on the matrix of the CFAE Report. Values in the CFAE Reporting Purpose table are hard-coded and can not be modified. The codes that are entered into the Allocation table determine where in the report the money linked to that allocation code will appear. If the CFAE Purpose Code is blank, any gifts to that allocation do not appear on the report. Drop-down list; values are validated against tms_cfae_purpose (FG).

CFAE Sub Code

Values in the CFAE Report Line drop-down list of the tms_cfae_sub_code table are hard-coded and can not be modified. These Report Line values indicate where the CAE Report will place the gift associated with this sub code line within the Gifts by donors for endowment section of the CAE Report. When you add a new CFAE Sub Code, make sure you select a CFAE Report Line value from the drop-down list. Failure to do so will result in the code will not appear on the CAE report. Drop-down list; values are validated against tms_cfae_sub_code (FI).

Restriction

Indicates whether there are any restrictions associated with the allocation. Drop-down list; values are validated against tms_restriction (SB).

Fund

The name of the fund associated with the allocation. Drop-down list; values are validated against tms_fund_code (EL).

Department

The department associated with the allocation. Drop-down list; values are validated against tms_alloc_department (J5).

Notify Dept

Indicates whether the allocation should be included in a department notification report. Such a report would be sent to contact persons on some regularly scheduled basis to inform them of new donations affecting their department. This report might be used for acknowledgment purposes or informational purposes. There must be a corresponding Advance entity ID number in the department table, which would hold the address of the contact person at the department.

Sub Dept

Sub department associated with the allocation. Drop-down list; values are validated against tms_alloc_sub_dept (YH).

School

The school associated with the allocation. Drop-down list; values are validated against tms_alloc_school (J2).

Campus

The campus code associated with the allocation. Drop-down list; values are validated against tms_campus (GN).

Agency

The agency code associated with the allocation. Drop-down list; values are validated against tms_agency (SC).

User Group

The name of the user group associated with the user that last modified the allocation. Drop-down list; values are validated against the zz_user_group database table.

Trans Group

Used in conjunction with allocation security, which restricts operators from using allocation codes that do not belong to their user group. The transfer code indicates the other user group that may access this allocation code when performing a reversal or modification.

Program Code

The program code associated with the allocation. Drop-down list; values are validated against tms_program (TB).

Purpose

The purpose associated with the allocation. Drop-down list; values are validated against tms_purpose (DN).

Division

The division associated with the allocation. Drop-down list; values are validated against tms_alloc_division (J6).

Steward Rep

The type and frequency of reporting requirements for an allocation. Drop-down list; values are validated against tms_steward_reporting (SH).

Alloc Fee

Indicates whether a fee applies to the allocation.

Alternate Fee

Indicates the alternate fee associated with the allocation. When a value is entered in Alt. Fee Min Amt., and a gift made to the Allocation is less than that amount, the Alternate Fee code specified is associated with the transaction. Drop-down list; values are validated against tms_alloc_fee_code (Y4). The value in this field may not be the same as the value in Alloc Fee.

Alternate Fee Min Amt

The minimum amount for gifts made to the allocation. When the amount of a transaction to the allocation is equal to or greater than this amount, the Allocation Fee code is associated with the transaction. When the amount of a transaction to the Allocation is less than the amount in this field, the Alternate Fee code is associated with the transaction.

Endow Pool

Identifies the pool to which the endowment is invested (e.g. General Endowment Pool, High Income Pool): or external manager, if externally funded. Drop-down list; values are validated against tms_endow_pool (SJ).

Endow Type

Identifies the endowment type (e.g. CFAE lumps student support together, whereas a user might elect to break this into “need-based scholarship,” “merit scholarship,” “graduate fellowship,” etc.). Drop-down list; values are validated against tms_endow_type (SK).

Naming

Identifies the status or availability of a naming opportunity. Drop-down list; values are validated against tms_alloc_naming table (SI).

Description

Text field can be used to hold a detailed description of the allocation code.

Comment

Text field can be used to hold additional information about this allocation. An example might be a reason for allocation creation, additional restrictions or special instructions.

Start Date

The start date for the allocation.

Stop Date

The stop date for the allocation.

Active

Indicates whether the allocation is active or not, independent of the start and stop dates. Hard-coded values include Active, Not Active and All.

Annual

Indicates whether the allocation is considered part of the Annual Fund. Hard-coded values include Annual, Not Annual and All.

Athletics

Indicates whether the allocation should be included in the Athletics category for CFAE reporting. Hard-coded values include Athletics, Not Athletics and All.

Extra Mural

Indicates whether the allocation should be included in the CAE report for the section that describes extra mural athletics.

Administrator ID

The Advance Entity ID number (must be a valid entry in the entity table) of the individual or contact that is responsible for the allocation code. Press F2 to perform an Entity lookup.

Steward ID

The Advance Entity ID number (must be a valid entry in the entity table) of the individual or contact that is the steward for the allocation code. Press F2 to perform an Entity lookup.

Acct School

The organizational unit associated with this allocation. Drop-down list; values are validated against tms_accounting_school (LJ).

Acct Dept

The organizational unit that is authorized to expend the funds associated with this allocation. Drop-down list; values are validated against tms_accounting_dept (LK).

Grant Type

Indicates whether an allocation is a gift fund or a grant fund. Drop-down list; values are validated against tms_gift_grant_type (LL).

Category 1

A value that classifies the gift allocation.  Drop-down list; values are validated against tms_category1 (VA).

Category 2

A value that classifies the gift allocation. Drop-down list; values are validated against tms_category2 (VB).

Category 3

A value that classifies the gift allocation. Drop-down list; values are validated against tms_category3 (VC).

Owners

The type of institution that owns this allocation. Used during claims generation to enforce matching policy rules for the matching policy type of institution. Values in this element are pre-defined. Please refer to the description of the Matching Policy form for additional information. If you do not use the optional matching policy logic (system option #20), this element is not used.

Alpha Sort

Used to enter a coding sequence to use for reporting purposes. For example, if the allocation code value is numeric, this field can be used to indicate the alpha sequence for certain reports.

Goal Amount

The dollar amount of a goal for the allocation code.

Fiscal Year

The type of fiscal year for the allocation. Drop-down list; values are validated against tms_fiscal_yr (DM).

Min Amount

The minimum funding amount required to fund the allocation.

Min Ach Date

The date the minimum funding amount was achieved.

Dist Start Date

The initial date that the money will be distributed.

Reference

The cross-reference code associated with the allocation.

Date Added

The date the allocation was added.

Date Modified

The date the allocation was most recently modified.