| Data element |
Definition |
AWARD_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The ending date for the awarded project period for the proposal, as defined by the sponsor.
The project period, or funding cycle, is a discrete period of time for which a sponsor has committed funds that can be expended by the University for the sponsored project. A project period may include one or more budget periods. |
|
BBR_AWARD_NUMBER
Format VARCHAR2 (30)
Indexed? Yes
May be Null? No
|
The alphanumeric identifier used internally by the BEN Billing and Receivable system to uniquely identify the proposal.
An Award Number is associated with only one INSTITUTION_NO. INSTITUTION_NO is the eight-digit sequence number used by the University to uniquely identify the proposal. For a given record, BBR_AWARD_NUMBER will not have the same value as the proposal's INSTITUTION_NO. |
BBR_AWARD_ORG
Format CHAR(4)
Indexed? Yes
May be Null? No
|
The 4-character code that identifies the organization responsible for the proposal.
To facilitate Organization-based security, BBR_AWARD_ORG is set to '.' if it would otherwise be null.
Values: Refer to the ORG_CODES table for values. |
|
BBR_PROJECT_ORG_CODE
Format CHAR(4)
Indexed? Yes
May be Null? No
|
The 4-character code that identifies the organization responsible for managing the fund. (Note: Funds are reflerred to as "Projects" in BEN Billing and Receivables)
To facilitate Organization-based security, BBR_PROJECT_ORG_CODE is set to '.' if it would otherwise be null.
Values: Refer to the ORG_CODES table for values. |
|
DAY_TO_SUBMIT
Format VARCHAR2 (20)
Indexed? No
May be Null? Yes
|
The number of days after the contract termination within which to submit the final report for the fund.
Values:
30 30 days after termination
60 60 days after termination
90 90 days after termination. |
|
EXTRACT_DATE
Format DATE
Indexed? Yes
May be Null? Yes
|
The date the award report log record was extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
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. |
|
FILED_BY
Format VARCHAR2 (300)
Indexed? No
May be Null? Yes
|
The first and last name of the person that submitted the report to the sponsor. |
|
FILED_DATE
Format DATE
Indexed? Yes
May be Null? Yes
|
The date on which the latest (most recent) 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.) |
|
FILED_DATE_ACCT_PERIOD
Format VARCHAR2 (15)
Indexed? Yes
May be Null? Yes
|
The Accounting Period stated in MON-YY format.
MON is the calendar month (stored in upper case), and YY is the calendar year.
Note that the beginning and ending dates of an ACCOUNTING_PERIOD are not the same as the first and last day of the calendar month.
Example: JUL-96 (July 1996, which occurs in fiscal year 1997). |
|
FILED_DATE_FISCAL_MONTH_SEQ
Format VARCHAR2 (2)
Indexed? Yes
May be Null? Yes
|
The month (or accounting period) of the fiscal year.
This field is used for sorting.
Examples: 01 (July); 11 (May). See also FISCAL_YEAR.
|
|
FILED_DATE_FISCAL_YEAR
Format VARCHAR2 (4)
Indexed? Yes
May be Null? Yes
|
The financial year.
Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.
Example: 1997 (fiscal year that began July 1, 1996, and ended June 30, 1997) |
|
FIN_REPORT_FREQUENCY
Format VARCHAR2 (240)
Indexed? No
May be Null? Yes
|
Indicates how often a report must be sent to the sponsor of the fund.
Values:
ANNUAL & FINAL REPORT BY SPECIFIC SCHEDULE
COORDINATE REPORT W INVOICE
COORDINATE REPORT W PI FINAL REPORT
ONLY MONTHLY
NO FINANCIAL REPORT REQUIRED
QUARTER ENDING (MAR, JUN, SEP, DEC)
QUARTER ENDING (FEB, MAY, AUG, NOV)
QUARTER ENDING (JAN, APR, JUL, OCT)
QUARTERLY & FINAL REPORT
SEMI-ANNUAL & FINAL REPORT |
|
FIN_RPT_DUE
Format DATE
Indexed? Yes
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.) |
|
FIN_RPT_DUE_ACCT_PERIOD
Format VARCHAR2 (15)
Indexed? Yes
May be Null? Yes
|
The Accounting Period stated in MON-YY format.
MON is the calendar month (stored in upper case), and YY is the calendar year.
Note that the beginning and ending dates of an ACCOUNTING_PERIOD are not the same as the first and last day of the calendar month.
Example: JUL-96 (July 1996, which occurs in fiscal year 1997). |
|
FIN_RPT_DUE_FISCAL_MONTH_SEQ
Format VARCHAR2 (2)
Indexed? Yes
May be Null? Yes
|
The month (or accounting period) of the fiscal year.
This field is used for sorting.
Examples: 01 (July); 11 (May). See also FISCAL_YEAR |
|
FIN_RPT_DUE_FISCAL_YEAR
Format VARCHAR2 (4)
Indexed? Yes
May be Null? Yes
|
The financial year.
Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.
Example: 1997 (fiscal year that began July 1, 1996, and ended June 30, 1997) |
|
FSRD
Format NUMBER
Indexed? No
May be Null? Yes
|
The Financial Statement Reported Direct amount. |
|
FSRI
Format NUMBER
Indexed? No
May be Null? Yes
|
The Financial Statement Reported Indirect amount. |
|
FSRT
Format NUMBER
Indexed? No
May be Null? Yes
|
The FSR total for the fund associated with this report. FSRT = FSRD + FSRI |
|
PROJECT_FUNDED_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes
|
The total funded amount. |
|
PROJECT_NUMBER
Format VARCHAR2 (30)
Indexed? No
May be Null? Yes
|
The 6-character fund code.
A fund is the unique identifier for a specific set of financial resources that needs tracking or management. (Note: Funds are reflerred to as "Projects" in BEN Billing and Receivables) FUND_CODE is the fourth segment of the Accounting Flexfield.
Values: Refer to the FUND_CODES table for values.
|
|
REPORT_FORMAT
Format VARCHAR2 (240)
Indexed? No
May be Null? Yes
|
Code that indicates the manner in which fund reports are presented to the sponsor.
Values:
ACCOUNT CONTINUATION
ADVANCE ACCOUNT
E FFR SF 425 FEDERAL FINANCIAL REPORT
E FSR-SF269
FFR SF 425 FEDERAL FINANCIAL REPORT
FSR-SF269
FSR-SF269, SF272
INTERNAL
NO REPORT REQUIRED
SF1034 & COMPLETION VOUCHER
SPONSOR
STANDARD
|
|
REPORT_STATUS_CODE
Format VARCHAR2 (240)
Indexed? No
May be Null? Yes
|
Brief report status description.
Values:
Dept. Detail Late
Early Termination
Extension Pending
Fund is a sub account to a Prime
Greater than 90 day Report Req
Late Fund Setup
PI Signature Needed/Pending
Revision
Sponsor Follow-Up" |
|
REPORT_STATUS_REASON
Format VARCHAR2 (4000)
Indexed? No
May be Null? Yes
|
Extended report status description. |
|
SEQUENCE_NO
Format NUMBER
Indexed? Yes
May be Null? No
|
The unique sequence number identifying the report record for a specific award. |
