Penn Computing

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

FUND_FREEZE_HISTORY Table - Data Element Index

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



Data Element Definition
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 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 and CURRENT_BUDGET_END in the FUND_CODES and BUDGET_PERIODS tables.

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 ACCOUNT_END. 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 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 only as freeze actions for the fund occur. There may therefore be discrepancies between data in this column and that stored in the column of the same name in the FUND_CODES table, which is recalculated with any change to either the ACCOUNT_END or DAYS_TO_SUBMIT_FINAL_REPORT_CODE for the fund.

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.

CFORM_FREEZE

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

Indicates the current freeze status of the C-Form transaction source. This applies to processing of C-Forms by the Accounts Payable department.

Examples: F (Fund is frozen for this transaction source)


Values:

F (Fund is frozen for this transaction source)

Null

CFORM_FREEZE_DATE

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

Indicates the date associated with the current freeze status for the C-Form transaction source. When the freeze status is null (indicating that the transaction source has never been frozen), the date will also be null.

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


Values:

List of values not available.

CFORM_REFREEZE_DATE

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

If the C-Form transaction source has been temporarily unfrozen by Research Services, this field indicates date when this source will be re-frozen.

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


Values:

List of values not available.

DAYS_TO_REPORT

Indexed - no
Format - varchar2 (3)
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

FEEDERS_FREEZE

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

Indicates the current freeze status for freeze applies to all transactions imported to the General Ledger from external systems (e.g., ProCard, mail services, telecomm, departmental service centers, etc.)

Examples: F (Fund is frozen for this transaction source)


Values:

F (Fund is frozen for this transaction source)

Null

FEEDERS_FREEZE_DATE

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

Indicates the date associated with the current freeze status for the Feeder transaction source. When the freeze status is null (indicating that the transaction source has never been frozen), the date will also be null.

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


Values:

List of values not available.

FEEDERS_REFREEZE_DATE

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

If the Feeders transaction source has been temporarily unfrozen by Research Services, this field indicates date when this source will be re-frozen.

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


Values:

List of values not available.

FUNCTION_OVERRIDE

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

This column will display either a Y or an N to indicate whether or not the Freeze Function Override flag has been set for this fund. When the Override flag has been turned "on", only the Office of Research Services can unfreeze transaction sources for this grant, even if the Adjustment Period has not yet ended.

Examples: Y (Override function has been set), N (No Override function has been set)


Values:

Y   Override has been set

N   No Override function has been set

FUND_CODE

Indexed - yes
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_FREEZE

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

Displays the overall Freeze Status of the fund, depending on the freeze status of each transaction source. In order to view funds that have no freeze information, perform an outer join to the FUND_CODES table (i.e., DWADMIN.FUND_FREEZE.FUND_CODE(+)=DWADMIN.FUND_CODES.FUND_CODE). This join already exists in the Business Objects universe.

Examples: N (Not Frozen - none of the transaction sources are currently frozen for this grant, although the fund has had freeze activity at some point in the past), P (Partially Frozen - at least one, but not all of the transaction sources are currently frozen for this grant), F (Fully Frozen - all of the transactions sources are currently frozen for this grant.overall freeze status, as on the BEN Financials reports)


Values:

N    Not Frozen

P    Partially Frozen

F    Fully Frozen

JE_FREEZE

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

Indicates the current freeze status for both manual journal entries and manual encumbrance entries.

Examples: F (Fund is frozen for this transaction source)


Values:

F (Fund is frozen for this transaction source)

Null

JE_FREEZE_DATE

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

Indicates the date associated with the current freeze status for the JE transaction source. When the freeze status is null (indicating that the transaction source has never been frozen), the date will also be null.

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


Values:

List of values not available.

JE_REFREEZE_DATE

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

If the JE transaction source has been temporarily unfrozen by Research Services, this field indicates date when this source will be re-frozen.

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


Values:

List of values not available.

LAST_UPDATE_DATE

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

The date this record was updated, by the user indicated in the USER_NAME column. Note that this field does include time specification as well. To properly sort records updated on the same day, be sure to pick a date format that includes time specification, and sort accordingly.

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


Values:

List of values not available.

PAYROLL_FREEZE

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

Indicates the current freeze status for activity from the payroll and salary management systems. This affects transactions sent from the payroll/salary management systems to BEN Financials.

Examples: F (Fund is frozen for this transaction source)


Values:

F (Fund is frozen for this transaction source)

Null

PAYROLL_FREEZE_DATE

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

Indicates the date associated with the current freeze status for the Payroll transaction source. When the freeze status is null (indicating that the transaction source has never been frozen), the date will also be null.

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


Values:

List of values not available.

PAYROLL_REFREEZE_DATE

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

If the Payroll transaction source has been temporarily unfrozen by Research Services, this field indicates date when this source will be re-frozen.

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


Values:

List of values not available.

PO_FREEZE

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

Indicates the current freeze status for the creation of new purchase orders.

Examples: F (Fund is frozen for this transaction source)


Values:

F (Fund is frozen for this transaction source)

Null

PO_FREEZE_DATE

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

Indicates the date associated with the current freeze status for the PO transaction source. When the freeze status is null (indicating that the transaction source has never been frozen), the date will also be null.

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


Values:

List of values not available.

USER_NAME

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

The BEN Financials user name of the user that performed the freeze transaction for this record, corresponding to the transaction source freeze date and LAST_UPDATE_DATE. This may be an individual BEN Financials user's user name, or that of an automatic system process.


Values:

List of values not available.

 
FUND_FREEZE_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