| Data element |
Definition |
CARRYOVER_BALANCE
Indexed - yes
Format - number (9)
May be null? no |
The amount, in dollars, of the unliquidated obligation or
the unobligated balance.
Values:
0 - 999999999
|
CARRYOVER_SEQ
Indexed - yes
Format - number (9)
May be null? no |
The 9-digit number used to uniquely identify a record in
the AWARD_CARRYOVER table.
Values:
1 - 999999999
|
CARRYOVER_TYPE
Indexed - no
Format - char (1)
May be null? yes |
The 1-character code indicating whether the carryover balance is an unliquidated
obligation (O) or an unobligated balance (B).
An unliquidated obligation is a residual amount of authorized funding
from a prior budget period that is reserved and carried forward from the
SOURCE_FUND to the DESTINATION_FUND. It may be used solely for the payment
of obligations (posted encumbrances) that were not liquidated at the close
of the prior budget period but were encumbered during that budget period
and remain unpaid at the time of the carry forward. This amount was reported
to the sponsor in accordance with the sponsors reporting requirements.
One example of an unliquidated obligation is the purchase order amount
of items ordered before the end of a budget period but paid (liquidated)
after the end of that budget period. Another example is the obligated
balance of stipend or other trainee expense remaining at the end of a
budget period.
An unobligated balance is a residual amount of unspent funds from the
previous budget period of a sponsored project, which the sponsor has granted
to be carried over and to be used in the current authorized budget period
of the project. The balance is carried forward from the SOURCE_FUND to
the DESTINATION_FUND.
Values:
B unobligated balance
O unliquidated obligation
|
DESTINATION_AWARD_ID
Indexed - yes
Format - char (9)
May be null? yes |
The 9-digit number identifying the prime account for the award
that is receiving the carryover balance. (See also AWARD_ID in the AWARD
table.) Example: 270360201
Values:
000000000 - 999999999
|
DESTINATION_FUND
Indexed - yes
Format - char (6)
May be null? yes |
The 6-digit code identifying the fund that is receiving the
unliquidated obligation or unobligated balance from the SOURCE_FUND. A fund
uniquely identifies a specific set of financial resources that needs tracking
or management. Example: 539999
Values:
Refer to the FUND_CODES table for values.
|
DESTINATION_PROJECT_ID
Indexed - yes
Format - char (5)
May be null? yes |
The 5-digit number identifying the sponsored research project
that has the carryover balance. (This is the same as the first 5 digits
of the DESTINATION_AWARD_ID.). Example: 27036
Values:
00000 - 99999
|
DESTINATION_PROJECT_SEGMENT_ID
Indexed - no
Format - char (7)
May be null? yes |
The 7-digit number identifying the project segment that is
receiving the carryover balance. (This is the same as the first 7 digits
of the DESTINATION_AWARD_ID.) The first 5 digits identify the sponsored
research project. (See also DESTINATION_PROJECT_ID.) The last 2 digits identify
the funds supplement. Example: 2703602
Values:
0000000 - 9999999
|
LAST_ACTIVITY_DATE
Indexed - no
Format - date
May be null? yes |
The date this AWARD_CARRYOVER record was extracted from the
Research Services system and loaded into the 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. (To
specify the date format in Windows 95, choose the Regional Settings of the
Control Panel, select the Date tab and specify the Short date style. In
Windows, use the International option of the Control Panel. On the Macintosh,
use the Date & Time Control Panel.) Example: 12/14/1998
Values:
List of values not available.
|
SOURCE_FUND
Indexed - yes
Format - char (6)
May be null? yes |
The 6-digit code identifying the fund that had the unliquidated
obligation or unobligated balance remaining at the end of the prior budget
period. A fund uniquely identifies a specific set of financial resources
that needs tracking or management. (See also DESTINATION_FUND.) Example:
564736
Values:
Refer to the FUND_CODES table for values.
|
