Penn Computing

University of Pennsylvania
Penn Computing << go backback
FUND_CODES_HISTORY Table    Tables and Data Elements   General Ledger Home   Data Warehouse Home

FUND_CODES_HISTORY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



ACCOUNT_END

Indexed - no
Format - date (7)
May be null? yes

The last date when the Fund Code may be used to track financial activity for the sponsored research project. Depending on the sponsor's financial reporting requirements, the same Fund Code may be used throughout the time for which the sponsor has made award for a project (the funding cycle, usually one to five years) or only for one Budget Period. See also ACCOUNT_START, CURRENT_BUDGET_END, and END_DATE. (Unlike CURRENT_BUDGET_END, ACCOUNT_END does not necessarily change as additional funding segments are received.)

Account End is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 8/31/2005

Before Oct. 1, 2000, this data element was known as Project_End_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:
List of values not available.

ACCOUNT_START

Indexed - no
Format - date (7)
May be null? yes

For sponsored project funds, the first date when the Fund Code may be used to track financial activity for the sponsored research project. Depending on the sponsor's financial reporting requirements, the same Fund Code may be used throughout the time for which the sponsor has made award for a project (the funding cycle, usually one to five years) or only for the Budget Period. See also CURRENT_BUDGET_END, and ACCOUNT_END_DATE.

Account Start is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 9/01/1994

Before Oct. 1, 2000, this data element was known as Contract_Start_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:
List of values not available.
ADJ_PERIOD_END_DATE

Indexed - no
Format - date (7)
May be null? yes

The date by which all adjusting entries must be made after the end of the project and prior to close out of the grant. This date is calculated based on when the final report is due to the sponsor relative to the ACCOUNT_END. The date calculation will round up or down so that the ADJ_PERIOD_END_DATE will always coincide with the end of a BEN Financials Accounting Period. This date is determined as follows:

1. The calculation of the Adjustment Period first categorizes the grant based on the number of days the University has to submit the final report after the p roject ends. When the number of days to submit the final report (FUND_CODES. DAYS_TO_SUBMIT_FINAL_RPT_CODE) is 30, the grant is considered a 15-day grant. When the number of days is 60, the grant is considered a 30-day grant. When the number of days is anything else (includes those with 90 days to submit, an unspecified number of days, or no final report required), the grant is considered a 60-day grant.

2. Then, based on the ACCOUNT_END, the system calculates the Adjustment Period. For 15-day grants, the ADJ_PERIOD_END_DATE is calculated by adding 15 days to the ACCOUNT_END. This provides a 15 day Adjustment Period for end users and a 15 day Reporting Period for ORS to prepare the final report. For 30-day grants, when the ACCOUNT_END falls within the first 9 days of the month, the ADJ_PERIOD_END_DATE is set to the end of the accounting period associated with the month in which the ACCOUNT_END occurs (the "current accounting period"). For 30-day grants in which the ACCOUNT_END falls on the 10th of the month or after, the ADJ_PERIOD_END_DATE is set to the end of the following accounting period. For 60-day grants, when the ACCOUNT_END falls within the first 9 days of the month, the ADJ_PERIOD_END_DATE is set to the end of the "next accounting period" (the one after the period associated with the calendar month in which the ACCOUNT_END occurs). For 60-day grants, when the ACCOUNT_END falls on the 10th of the month or after, the ADJ_PERIOD_END_DATE is set to the end of the period which follows the "next accounting period".

3. In cases where the calculated ADJ_PERIOD_END_DATE would be before the beginning of the present General Ledger accounting structure (July 1, 1996), the date will default to June 30, 1996. In cases where the calculated ADJ_PERIOD_END_DATE falls beyond the BEN Financials calendar, the date will be the last day of the calendar month in which that calculated date would fall (i.e., if the ACCOUNT_END is 9/15/2000 for a grant with 60 days to report, the ADJ_PERIOD_END_DATE should default to 10/31/2000).

This column is updated with any changes to either the ACCOUNT_END or DAYS_TO_SUBMIT_FINAL_REPORT_CODE for the fund. There may therefore be discrepancies between data in this column and that stored in the column of the same name in the FUND_FREEZE and FUND_FREEZE_HISTORY tables, which is updated only as freeze actions for the fund occur.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.).

Examples: For a 30-day grant with ACCOUNT_END of 10/1/1999, ADJ_PERIOD_END_DATE is 10/29/1999. For a 60-day grant with ACCOUNT_END of 10/1/1999, ADJ_PERIOD_END_DATE is 11/30/1999. For 30-day grant with ACCOUNT_END of 10/10/1999, ADJ_PERIOD_END_DATE is 11/30/1999. For a 60-day grant with ACCOUNT_END of 10/10/1999, ADJ_PERIOD_END_DATE is 12/31/1999.

Values:
List of values not available.
BILLING_FORMAT_CODE

Indexed - yes
Format - char (6)
May be null? yes

Code that indicates the format in which the bill for the fund is rendered.

Examples: 1 (Standard invoice); 7 (Automatic payment).

Values:
1   Standard invoice (formerly 11, Direct Billing)
2   Standard per terms (formerly 13, Other, including 
    advance payments)
3   Federal 270 (formerly 30, Advance other)
4   Federal 1034 (formerly 10, NAVY; 17, ARMY)
5   Federal Other
6   Sponsor Format (formerly 02, Grants earning TIF 
    interest)
7   Automatic Payment

BILLING_FREQ_CODE

Indexed - yes
Format - varchar2 (52)
May be null? yes

Code that indicates how often, or on what schedule, the fund is billed.

Examples: AD (100% in advance); PS (In advance by payment schedule)

Values:
AD   100% in advance (formerly 01)
QA   Quarterly in advance (formerly 04)
PS   In advance by payment schedule (formerly 06)
PI   Coordinate with PI (formerly 07)
M    Monthly reimbursement (formerly 12)
Q1   Quarterly reimbursement (Jan, Apr, Jul, Oct)
Q2   Quarterly reimbursement (Feb, May, Aug, Nov)
Q3   Quarterly reimbursement (Mar, Jun, Sep, Dec) - 
     (formerly 19, 24, 25)
20   Automatic (no invoice required ); 100% in 
     advance (formerly 21)
21   Automatic (no invoice required); Q1
22   Automatic (no invoice required); Q2
23   Automatic (no invoice required); Q3
24   Automatic (no invoice required); Automatic 
     Monthly in advance (formerly 23)
25   Automatic (no invoice required); Automatic by 
     schedule (formerly 26)

BUDGET_ENTRY_ALLOWED

Indexed - no
Format - char (1)
May be null? yes

Indicates whether the budget journal entries may be posted to accounts with this FUND_CODEvalue.

See also FUND_CODES/ENABLED.

Examples: Y (Budget journal entries may be entered for the FUND_CODE); N (Budget journal entries may not be entered for the FUND_CODE)

Values:
Y  Budget journal entries may be entered for the 
   FUND_CODE.
N  Budget journal entries may not be entered for the 
   FUND_CODE.
CFDA_NUMBER

Indexed - no
Format - char (6)
May be null? yes

The 6-character number used for federal reporting on grant funds according to the Catalog of Federal Domestic Assistance.

Example: 93.371

Values:
List of values not available.

CURRENT_BUDGET_END

Indexed - no
Format - date (7)
May be null? yes

The end date for the latest (last, current, or future) budget period for the fund (FUND_CODE). Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment. Each funding increment has a budget period, a discrete period of time for which a fund sponsor has committed funds that can be expended by the University for an agreed upon purpose. See also ACCOUNT_END and END_DATE.

Current Budget End is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 8/31/1998

Before Oct. 1, 2000, this data element was known as Contract_End_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:
List of values not available.
DATE_FUND_ESTABLISHED

Indexed - no
Format - date (7)
May be null? yes

The date fund the fund was established.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 8/9/1920 (for fund 461087)

Values:
List of values not available.
DAYS_TO_SUBMIT_FINAL_RPT_CODE

Indexed - yes
Format - char (2)
May be null? yes

The number of days after the contract termination within which to submit the final report for the fund.

Example: 30 (30 days after termination)

Values:
30     30 days after termination
60     60 days after termination
90     90 days after termination

DONOR_RESTRICT_OBJECT

Indexed - no
Format - char (4)
May be null? yes

Code for the object or set of objects that reflects the Treasurer's Office interpretation of donor restrictions on endowment and gift funds. This code applies to funds beginning with the number 4 (endowments) or 6 (gifts).
Values:
List of values not available.

DONOR_RESTRICT_ORG

Indexed - no
Format - char (4)
May be null? yes

The code for the organization or set of organizations to which this fund is restricted based on donor stipulation.

See also the definition under FUND_CODES / PENN_RESTRICT_ORG.

Values:
List of values not available.
DONOR_RESTRICT_PROGRAM

Indexed - no
Format - char (4)
May be null? yes

Code that indicates the program or set of programs to which this fund is restricted based on donor stipulation.

See also FUND_CODES / PENN_RESTRICT_PROGRAM.

Values:
Refer to the PROGRAM_CODES table for values.
ENABLED

Indexed - no
Format - char (1)
May be null - yes

Indicates whether the FUND_CODE may be used in BEN Financials transactions.

Examples: Y (FUND_CODE may be used in BEN Financials transactions); N (FUND_CODE may not be used in BEN Financials transactions

For a FUND_CODE with ENABLED set to N, the END_DATE is the last day the FUND_CODE was allowed to be used in BEN Financials transactions. A FUND_CODE that has ENABLED set to N may have it re-set to Y at a later date.

See also END_DATE.

Values:
Y  FUND_CODE may be used in BEN Financials 
   transactions.
N  FUND_CODE may not be used in BEN Financials 
   transactions.
END_DATE

Indexed - no
Format - date (7)
May be null - yes

The last date when the FUND_CODE may be used in BEN Financials transactions. END_DATE is populated only for the funds that are no longer ENABLED. The value for END_DATE will be null for ENABLED funds -- the value will never be a future date. If a fund was not enabled is enabled again, its END_DATE will be set to null when it is re-enabled.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 1/30/97

FEDERAL_FLAG

Indexed - no
Format - char (1)
May be null? yes

Indicates whether the financial resources for the FUND_CODE are provided by the fund sponsor, or by the U.S. federal government via the fund sponsor. The value should be null if the FUND_CODE value does not start with ‘5’.

Values:
Y (the FUND_CODE tracks ‘federal flow through’ dollars, 
  provided by the U.S. federal government via the fund sponsor)
N (the FUND_CODE tracks financial resources provided by the fund 
  sponsor itself)
[null] (the FUND_CODE does not apply to a sponsored project)
FIRST_FINANCIAL_REPORT_DUE

Indexed - no
Format - date (7)
May be null? yes

The date on which the first financial report for the fund was due.

Values:
List of values not available.
      

FUND_CODE

Indexed - no
Format - char (6)
May be null? no

The 6-character fund code. A fund is the unique identifier for a specific set of financial resources that needs tracking or management.

FUND_CODE is the fourth segment of the Accounting Flexfield.

Examples: 520139 (DERMATOLOGY FDN); 020112 (WILLIAM PENN FOUNDATION).

Values:
Refer to the FUND_CODES table for values.
FUND_DESC

Indexed - no
Format - char (30)
May be null? yes

The description that corresponds to the FUND_CODE.

Examples: DERMATOLOGY FDN (520139); WILLIAM PENN FOUNDATION (020112).

Values:
Refer to the FUND_CODES table for values.
FUND_LONG_DESCRIPTION

Indexed - no
Format - char (70)
May be null? yes

The long description that corresponds to the FUND_CODE. This description is used for Supplement C reporting.

Example: Dermatology Foundation (520139)

Values:
List of values not available.

FUND_PURPOSE_CODE

Indexed - yes
Format - char (2)
May be null? yes

The 2-character code identifying the primary purpose of fund expenditures.

Examples: 01 (Instruction), NA (Not applicable). NA is used for "parent" funds and other funds where purpose does not really apply (for example, capital gifts, annuities). UN (Unknown) is the default

Values:
01 Instruction (for example, School Specific "Dean's 
   Fund")
10 Sponsored Research
11 Other, Separately Budgeted Research (for example, 
   URF {University Research Foundation}, RFDF 
   {Research Facilities Development Fund}, 
   Technology Transfer, Research Matching Program, 
   Insurance Fund)
20 Libraries
30 Student Aid (for example, University Fellowship)
40 Student Services
50 Extension & Public Service
60 Auxiliary Enterprise:  Dormitories
61 Auxiliary Enterprise:  Bookstore
62 Auxiliary Enterprise:  Dining Services
63 Auxiliary Enterprise:  Intercollegiate Athletics
64 Auxiliary Enterprise:  Other
70 Hospitals & Clinics:   Medical
71 Hospitals & Clinics:   Dental
72 Hospitals & Clinics:   Veterinary
73 Hospitals & Clinics:   Nursing
80 Independent Operations
90 Management and General (for example, Debt 
   Service, Employee Benefits Pool)
92 Fundraising
93 Maintenance & Operation of Facilities (for 
   example, Deferred Maintenance)
NA Not applicable (for example, General 
   Unrestricted, Anticipated revenue & expense, 
   Capital Construction Fund, other 02XXXX funds, 
   Loan funds, annuities, capital gifts funds, 
   agency)
   NA is used for "parent" funds and other funds 
   where purpose does not really apply (for example, 
   capital gifts, annuities) UN is the default.
UN unknown, to be assigned later
FUND_RESPONSIBLE_ORG

Indexed - no
Format - char (4)
May be null? yes

The organization responsible for managing the fund. Many organizations may use the same fund, but only one organization -- the FUND_RESPONSIBLE_ORG -- is accountable for managing the fund. Those who are authorized to access records for the FUND_RESPONSIBLE_ORGmay access all records for the fund, regardless of the value for the Organization segment of the Accounting_Flexfield for the record.

Examples: 0011 (NYC Penn Club); 0215 (French Institute)


Values:

Refer to the ORG_CODES table for values.

FUND_SPONSOR_CODE

Indexed - yes
Format - varchar2 (5)
May be null? yes

The 5-character code that identifies the external organization that sponsors the fund. (The code comes from PennERA, the system used at Penn since August 26, 2003 to track information on sponsored project awards.) The value should be null if the FUND_CODE value does not start with ‘5’.

Codes less than or equal to 599999 were assigned to the sponsor by InfoEd (the vendor of the PennERA software). Codes greater than or equal to 60000 were assigned to the sponsor by the Office of Research Services.

See also LEGACY_FUND_SPONSOR_CODE.

Examples: 09470 (National Institutes of Health); 62776 (Society for Ambulatory Anesthesia).

Values:
Refer to the FUND_SPONSORS table for values.
GRANT_GIFT_EXTERNAL_ID

Indexed - no
Format - char (20)
May be null?yes

For a sponsored project fund (whose FUND_CODE begins with '5'), the
GRANT_GIFT_EXTERNAL_ID contains the sequence number used by the
University to uniquely identify the proposal for the grant or contract
whose awarded funding is tracked by the FUND_CODE. For most proposals,
the value is an 8-digit number, which might or might not include one
leading zero. For program project proposals, the value is an 8-digit
number with no leading zeroes. For sub-project proposals, the value is
a 7-digit number greater than or equal to '7000000'.
GRANT_GIFT_EXTERNAL_ID is a foreign key to the PennERA Proposal Tracking
system (and the PennERA Proposals data collection in the Warehouse).

For all funds that are not sponsored project funds, the value of
GRANT_GIFT_EXTERNAL_ID is null.

Examples: [null], '02768000', '10000108', '7000112'

Values:
List of values not available.
INTERNAL_DESIGNATED_CODE

Indexed - no
Format - char (4)
May be null? yes

Indicates the University organization responsible for determining how internally designated funds may be spent.

See also PENN_RESTRICT_ORG and PENN_RESTRICT_PROGRAM.

Values:
List of values not available.
INVESTMENT_REV_TREATMENT_CODE

Indexed - yes
Format - char (1)
May be null? yes

Indicates the disposition of income, gains, and losses, and determines under which net asset class the fund's investment income, gains, and losses are to be recorded. Applicable for endowment funds only.

Examples: 1 (True/Term - permanently restricted); 4 (FFE: Income and gain are unrestricted )

Values:
1  True/Term (permanently restricted):
   If investment is permanently restricted,
      income and gain are temporarily restricted.
   If investment is temporarily restricted or 
      unrestricted, income and gain are 
      unrestricted.
2  True with income and gain reinvested:
   If investment is permanently restricted,
      income is permanently restricted and gain is 
      temporarily restricted.
   If investment is temporarily restricted or 
      unrestricted, income and gain are 
      unrestricted.
3  True when income and gain reinvested - income 
      and gain are permanently restricted
4  FFE:  income and gain are unrestricted
5  Income is temporarily restricted and gain is 
     permanently restricted
LAST_FIN_RPT_DATE

Indexed - no
Format - date (7)
May be null? yes

The date on which the last financial report for the fund was filed.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 4/23/97

Values:
List of values not available.
  
LAST_UPDATE_DATE

Indexed - yes
Format - date
May be null? no

The date this program code record was last updated in BEN Financials.


Values:

List of values not available.
LAST_UPDATED_BY

Indexed - no
Format - varchar2 (50)
May be null?yes

The BEN Financials user name of the user that last updated this program code record. This may be an individual BEN Financials user's user name, or that of an automatic system process.


Values:

List of values not available.
LEGACY_FUND_SPONSOR_CODE

Indexed - yes
Format - char (4)
May be null? yes

The 4-character code that identifies the external organization that sponsors the fund. This code was formerly used in the General Ledger, and is currently used only in BRIM (the Billing and Receivables Information Management system used by the Office of Research Services). The value should be null if the FUND_CODE value does not start with ‘5’.

See also FUND_SPONSOR_CODE.

Examples: 1110 (National Institutes of Health); 4306 (Society for Ambulatory Anesthesia).

Values:
Refer to the LEGACY_FUND_SPONSORS table for values.
LOC_REPORTING_STATUS

Indexed - no
Format - char (1)
May be null? yes

The one-character code that indicates the report status designated by the sponsor for Letter of Credit reporting for the fund.

Example: A (Active)

Values:
A     Active
I     Inactive
C     Closed
N     Not reportable
LOC_TRANSACTION_ID

Indexed - no
Format - char (20)
May be null? yes

The Federal control number needed for Letter of Credit reporting for the fund.
Values:
List of values not available.
NEXT_FIN_RPT_DUE_DATE

Indexed - no
Format - date (7)
May be null? yes

Indicates the next date a report on the fund is due to the sponsor.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 8/31/98

Values:
List of values not available.
ORA_REVIEW_FLAG

Indexed - no
Format - char (1)
May be null? yes

Indicates whether this fund is under review by Resarch Services. (In the past, the reveiw was done by the Office of Research Administration, or ORA, which later became part Research Services.)

Examples: Y (Fund is under review); [Null] (Fund has been reinstated or was never under review)

Values:
Y   Fund is under review
[Null]   Fund has been reinstated or was never under
    review
PENN_RESTRICT_ORG

Indexed - no
Format - char (4)
May be null? yes

The code for the organization or set of organizations that this fund is restricted to based on Penn's stipulations (in addition to the donor's stipulations).

See also the definitions for FUND CODES /DONOR_RESTRICT_ORG.

Examples: 0001 (Gen University); 0728 (Financial Aid)

Values:
List of values not available.
PENN_RESTRICT_PROGRAM

Indexed - no
Format - char (2)
May be null? yes

Indicates additional Program restrictions on the fund added by Penn to the donor's restrictions. A program is an activity or work process commonly defined across the University for tracking a program's activity across Schools and Centers (or across organizations within a school or center). COA_Program is the sixth segment of the Accounting Flexfield.

Examples: 7311 (Alumni Relations); 0001 (Discretionary); 3000 (Service)

See also the definitions for FUND_CODES / DONOR_RESTRICT_PROGRAM.

Values:
Refer to the PROGRAM_CODES table for values.
PI_NAME

Indexed - no
Format - char (30)
May be null? yes

The name of the faculty/staff member who is the investigator responsible for the use of the fund. (This is usally the same as the name of the principal investigator for the entire sponsored project, but not always -- in cases where money for a project is split among more than one fund, different investigators may be responsible for different funds.)

PI_NAME is formatted as LASTNAME,FNAME MI and is stored in upper case. PI_NAME is populated only for funds for grants and contracts, its value is null for other funds.

Example: CLEMENS,SAMUEL L

Values:
List of values not available.
POSTING_ALLOWED

Indexed - no
Format - char (1)
May be null? yes

Indicates whether manual journal entries may be posted to accounts with this FUND_CODEvalue. See also FUND_CODES/ENABLED.

Examples: Y (Manual journal entries may be posted for the FUND_CODE; N (Manual journal entries may not be posted for the FUND_CODE

Values:
Y   Manual journal entries may be posted for the 
    FUND_CODE.
N   Manual journal entries may not be posted for the 
    FUND_CODE.
REPORT_FORMAT_CODE

Indexed - yes
Format - char (2)
May be null? yes

Code that indicates the manner in which fund reports are presented to the sponsor.

Examples: 00 (No Report Required); 01 (Standard)

Values:
00     No Report Required
01     Standard
02     Sponsor
03     E FSR-SF269
04     FSR-SF269
05     FSR-SF269, SF272
06     Internal
07     SF1034 & Completion Voucher
REQUIRED_FIN_RPT_FREQ_CODE

Indexed - yes
Format - char (2)
May be null? yes

Indicates how often a report must be sent to the sponsor of the fund.

Examples: NO (No Financial Report Required); F (Final Report Only)


Values:
NO     No Financial Report Required
A      Annual and Final Report
F      Final Report Only
S      Semi-Annual and Final Report
Q      Quarterly and Final Report
I      Coordinate report with Invoice
PI     Coordinate report with PI
SC     by specific schedule
Q1     Fiscal quarter (Jan, Apr, Jul, Oct)
Q2     Fiscal quarter (Feb, May, Aug, Nov)
Q3     Calendar quarter (Mar, Jun, Sep, Dec)
RESTRICT_RECLASS_CODE

Indexed - yes
Format - char (1)
May be null? yes

The one-character code that indicates how the fund's income is reclassified (that is, the method of unrestricting revenue or assets).

Examples: A (Automatic); M (Manual); T (Time-based)

Values:
A     Automatic
M     Manual
T     Time-based
SFS_CATEGORY_CODE

Indexed - no
Format - char (4)
May be null? yes

The four character code that indicates, for funds used in undergraduate tuition, which school may use the fund, with restriction information.

Examples: 6000 (CAMPFD/NO SCH RESTR/NO RESTR); 6131 (NCAMPFD/SEAS/SPENDABLE RESTR)

Values:
Refer to the FUND_SFS_CATEGORY_CODE table for values.
START_DATE

Indexed - no
Format - date (7)
May be null - yes

The first date when the FUND_CODE may be used in BEN Financials transactions.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose Regional Settings of the Control Panel, select the Data tab and specify Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.)

Example: 1/30/97

 

FUND_CODES_HISTORY Table    Tables and Data Elements   General Ledger Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania