|
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
|
