UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 3/29/2005.

UOD_PRP_BUD_VW

Proposal Budget: Specifies budgeted amounts for each item of each project within the proposal. Budgets are as stated in the proposal and do not reflect changes made after awarded.
BUDGET_ID Budget ID Example: 1
KEY Type: character Format: Upper Length: 10 Decimals: 0
Budget ID for a given proposal
 
BUDGET_LN Budget Line Number Example: 10
KEY Type: number Format: Upper Length: 6 Decimals: 0
Line number within proposal budget
 
BUDGET_PERIOD_GM Budget Period Example: 1
KEY Type: number Format: Upper Length: 3 Decimals: 0
Budget period within proposal
 
BUDGET_PERIOD_GM_E Budget Period Example: 1
KEY Type: number Format: Upper Length: 3 Decimals: 0
Budget period within proposal
 
BUSINESS_UNIT Business Unit Example: UOD01
KEY Type: character Format: Upper Length: 5 Decimals: 0
Business Unit
 
DEPTID Department Example: 02708
KEY Type: character Format: Upper Length: 10 Decimals: 0
Identifies the administrative budget unit controling one or more Purposes. Some entries are not actual departments, but are merely nodes on a tree that organizes departments into a hierarchy for reporting purposes.
 
PROPOSAL_ID Proposal ID Example: 0027080004
KEY Type: character Format: Upper Length: 25 Decimals: 0
Unique identifier of a proposal.
 
SEQ_NUM Sequence Example: 1
KEY Type: number Format: Upper Length: 3 Decimals: 0
Sequence number
 
SUB_PROP_NBR Proposal Project Example: BUEC43211400000
KEY Type: character Format: Upper Length: 15 Decimals: 0
A Project-ID within a Proposal or Award.
 
VERSION_ID Version ID Example: V1
KEY Type: character Format: Upper Length: 7 Decimals: 0
Identifies the version of this proposal/award to which this row pertains.
 
AMOUNT_1ST_DAY First Day Charge Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Charge for first day of keeping animalls
 
AMOUNT_DAILY_CHARG Subsequent Day Charge Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Charge for subsequent days of keeping animals
 
ANIMALS_PER_CAGE Animals per Cage Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Animals per cage
 
ANNUAL_FRINGE_AMT Annual Fringe Amt Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Fringe Amount to charge against personnel lines
 
ANNUAL_SALARY_GM Annualized Salary Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Annualized Salary
 
ANTICIPATED_AMT Anticipated Amount Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Anticipated amount
 
APPT_TYPE_ACADEMIC Academic Appointment Type Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if person is on and Academic Appointment
 
APPT_TYPE_CALENDAR Calendar Appointment Type Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if person is on a calendar year appointment
 
APPT_TYPE_MONTHS Months for Appointment Type Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Number of months included in appointment
 
APPT_TYPE_SUMMER Summer Appointment Type Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if this is a summer appointment
 
BEGIN_DT Begin Date Example: 10/1/1999
Type: date Format: Upper Length: 10 Decimals: 0
Begin Date
BEGIN_DT2 Begin Date Example: 10/1/1999
Type: date Format: Upper Length: 10 Decimals: 0
Begin Date
 
BEGIN_DT3 Begin Date Example: 10/1/1999
Type: date Format: Upper Length: 10 Decimals: 0
Begin Date
 
BUDGET_AMT Total Direct Budget Example: 52000
Type: signed number Format: Upper Length: 12 Decimals: 2
Total Direct Budget amount
 
BUDGET_AMT_E Total Direct Budget Example: 52000
Type: signed number Format: Upper Length: 12 Decimals: 2
Total Direct Budget Amount
 
BUDGET_CATEGORY Budget Category Example: SUPL
Type: character Format: Upper Length: 6 Decimals: 0
Budget Category, Personnel, supplies, equipment, etc
 
BUDGET_LN_E Budget Line Number Example: 10
Type: number Format: Upper Length: 6 Decimals: 0
Line number within proposal budget
 
CONTACT_ID Contact ID Example:
Type: character Format: Upper Length: 15 Decimals: 0
Contact Identifier for Treasury Contacts
 
COST_LIV_INCR_PCT Cost of Living Increase Pct Example: 0
Type: signed number Format: Upper Length: 7 Decimals: 2
The percentage increase due to "cost of living" that will be applied to pertinent lines across the life of the contract.
 
COST_LIV_INCR_PCTE Cost of Living Increase Pct Example: 0
Type: signed number Format: Upper Length: 7 Decimals: 2
The percentage increase due to "cost of living" that will be applied to pertinent lines across the life of the contract.
 
COST_SHARE_FA_AMT Institution Cost Share FA Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Amount of Instiutions cost share for FA
 
COST_SHARE_IN_AMT Institution Cost Share Direct Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Amount of direct costs that institution will cost share
 
COST_SHARE_PCT Cost Share Percent Example: 0
Type: number Format: Upper Length: 6 Decimals: 2
Percent of cost share in proposal
 
COST_SHARE_PCT_E Cost Share Percent Example: 0
Type: number Format: Upper Length: 6 Decimals: 2
Percent of cost share in proposal
 
COST_SHARE_TP_AMT Third Party Cost Share Direct Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Amount of cost share provided by third party
CURRENCY_CD Currency Code Example: USD
Type: character Format: Upper Length: 3 Decimals: 0
Currency Code
 
DAYS_ELAPSED Days Elapsed Example: 1835
Type: number Format: Upper Length: 4 Decimals: 0
Days elapsed since proposal budget submitted
 
DESCR Description Example: CONVERSION
Type: character Format: Mixed Length: 30 Decimals: 0
Description
 
DESCR_E Description Example: Supplies
Type: character Format: Mixed Length: 30 Decimals: 0
Description
 
DESCR254 Long Description Example: New Castle County Council Grant Funds Program
Type: character Format: Mixed Length: 254 Decimals: 0
Description of length 254
 
EMPLID EmplID Example: 32256
Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
 
END_DT End Date Example: 9/30/2050
Type: date Format: Upper Length: 10 Decimals: 0
End Date of Period One Budget
 
END_DT2 End Date Example: 9/30/2050
Type: date Format: Upper Length: 10 Decimals: 0
End Date of Period Two Budget
 
END_DT3 End Date Example: 9/30/2050
Type: date Format: Upper Length: 10 Decimals: 0
End Date of Period Three Budget
 
FIXED_FRINGE_AMT Fixed Fringe Amt Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Fixed Fringe Amt (instead of calculated)
 
FIXED_SALARY_AMT Fixed Salary Amt Example: 0
Type: number Format: Upper Length: 11 Decimals: 2
Fixed Salary Amt(instead of calculated)
 
FRINGE_AMT Fringe Amount Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Amount of Fringe Benefits included in proposal
 
FRINGE_RATE Fringe Rate Example: 0
Type: number Format: Upper Length: 6 Decimals: 2
Rate of Fringe Benefits
 
GM_SOURCE_INCOME Source Example:
Type: character Format: Mixed Length: 30 Decimals: 0
Description of Source Income
 
INCL_IN_PROPOSAL Include in Proposal Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if source income to be included in proposal
 
INSTID Institution ID Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Always=UOD01
 
MAJOR_SUBDIVISION Major Subdivision ID Example: 02700
Type: character Format: Upper Length: 10 Decimals: 0
Department-ID associated with each project.
 
MAP_DETAIL_FLG Map Detail Lines Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if detail lines to be included
 
MAP_MODULAR_LN Map Modular Line Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if modular line to be included
 
MERIT_INCR_PCT Merit Increase Pct Example: 0
Type: signed number Format: Upper Length: 7 Decimals: 2
Percent of merit increase
 
NUMBER_OF_ANIMALS Number of Animals Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Number of animals per cage
 
PERCENTAGE Percentage Example: 100
Type: signed number Format: Upper Length: 7 Decimals: 2
Total percent of effort
 
PRIMARY_FLAG Primary Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Is this individual the "Primary" Principal Investigator? (Y/N)
 
PROJECT_ID Project Example: BUEC43211400000
Type: character Format: Upper Length: 15 Decimals: 0
Chartfield which identifies contract and grant activities and facilities projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg. ARTC372111) indicating fiscal year, building, or other coded details.
 
QTY_GM Quantity Example: 0
Type: number Format: Upper Length: 9 Decimals: 2
Quantity included in line
 
ROW_NUMBER Row_Number Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Row number of proposal
 
SPONSOR_AMT Sponsor Direct Example: 52000
Type: signed number Format: Upper Length: 12 Decimals: 2
Direct cost charged to sponsor
 
SPONSOR_FA_AMT Sponsor FA Amt Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
FA Costs charged to Sponsore
TARGET_BUDGET_AMT Target Sponsor Budget Example: 52000
Type: signed number Format: Upper Length: 12 Decimals: 2
Amount of target budget
 
TITLE56 Short Title Example: NCC LOCAL SUPPORT
Type: character Format: Mixed Length: 56 Decimals: 0
Literal name of the Proposal or Award.
 
UNIT_COST Unit Cost Example: 0
Type: signed number Format: Upper Length: 16 Decimals: 4
Price per unit
 
WAIVED_FA_CLC_MTHD Waived F&A Calc Method Example: I
Type: character Format: Upper Length: 1 Decimals: 0
This field allows a user to defined whether waived facilities and administrative costs are determined by subtracting the budgeted/funded amount from the institution amount or from the sponsor amount.
 
Fields deemed insignificant at UD, or of limited use to general campus users.
APPT_TYPE Appointment Type
COST_LIV_INCR_DT Cost of Living Increase Date
DESCR_2 Description
DESCRLONG Description
DESCRLONG_E Description
EMPL_RCD Empl Rcd Nbr
MERIT_INCR_DT Merit Increase Date