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

UOD_PRP_ATRB_VW

Proposal Attributes: Descriptive header information for each proposal at the Pre-award stage. Shows the status (eg. draft, pending, awarded, withdrawn,...)
Decimals: 0
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.
 
EMPLID2 App/Emp ID Example:
KEY Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
 
PROPOSAL_ID Proposal ID Example: 0027080004
KEY Type: character Format: Upper Length: 25 Decimals: 0
Unique identifier of a proposal.
 
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.
 
ACCOMPLISH_RENEWAL Accomplishment Based Renewal Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if contract is accomplish based renewal
 
ADDRESS_SEQ_NUM Address Sequence Number Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Represents the sequence in which multiple addresses are recorded.
 
APPROVAL_DATE Approval Date Example:
Type: date Format: Upper Length: 10 Decimals: 0
Date proposal appoved
 
APPROVAL_DT Date of Approval Example:
Type: date Format: Upper Length: 10 Decimals: 0
Date the incentive related to the proposal was approved
 
APPROVED_BY EMPLID Approved By Example:
Type: character Format: Upper Length: 11 Decimals: 0
EMPLID of person approving the proposal
 
AWARD_TYPE Award Type Example: GR
Type: character Format: Upper Length: 3 Decimals: 0
Type of reward, contract,Purchase order, grant.
 
BEGIN_DT Begin Date Example: 11/30/1999
Type: date Format: Upper Length: 10 Decimals: 0
Begin Date
 
COMPLIANT_POLICY Compliance with Inst. Policy Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if proposal is compliant with institutional policy
 
CONTACT_ID Contact ID Example: 42779
Type: character Format: Upper Length: 15 Decimals: 0
Contact Identifier for Treasury Contacts
CONTRACT_NUM Contract Example: PRE-0901354-1201
Type: character Format: Mixed Length: 25 Decimals: 0
Unique identifier of a single contract. Same as "reference award number". Assigned at the point that the contract is awarded.
 
COST_SHR_SPNSR_REQ Required by Sponsor Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Does the sponsor require "cost share" (Y/N)?
 
CREATION_DT Creation Date Example: 6/26/2004
Type: date Format: Upper Length: 10 Decimals: 0
The firsd date on which the first form creating a proposal was filed.
 
CURRENCY_CD Currency Code Example: USD
Type: character Format: Upper Length: 3
Currency Code
 
CUST_ID Customer ID Example: 0937
Type: character Format: Upper Length: 15 Decimals: 0
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bil
 
DATE_DUE_TYPE Due Date Type Example: RCPT
Type: character Format: Upper Length: 4 Decimals: 0
Indicates if proposal due date is receipt or postmark
 
DAYS_ELAPSED Days Elapsed Example: 89
Type: number Format: Upper Length: 4 Decimals: 0
Days elapsed since proposal submitted
DESCR20A Short Description Example: (D) PUBLIC ALLIES/AM
Type: character Format: Mixed Length: 20 Decimals: 0
Short Description
 
DESCR254 Long Description Example: Public Allies Delaware
Type: character Format: Mixed Length: 254 Decimals: 0
Description of length 254
 
DESCR254_MIXED More Information Example: Public Allies Delaware
Type: character Format: Mixed Length: 254 Decimals: 0
More Information Description
 
DIRECT_NONPER_COST Direct - Non Personnel Cost Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Total Direct Cost - Non Personnel
 
DIRECT_PERS_COST Direct - Personnel Cost Example: 0
Type: signed number Format: Upper Length: 12 Decimals: 2
Total Personnel Direct Cost
 
DUE_DT Due Date Example: 6/28/2004
Type: date Format: Upper Length: 10 Decimals: 0
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled s
 
DUE_DT_TIME Due Date Time Example:
Type: time Format: Upper Length: 15 Decimals: 0
Time of Day Proposal is due
EFFORT_PCT Effort Percentage Example: 10.00
Type: number Format: Upper Length: 6 Decimals: 2
Percent of effort committed to proposal
 
EMPLID EmplID Example: 32256
Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
 
EMPLID_OLD Previous Employee ID Example: 32256
Type: character Format: Upper Length: 11 Decimals: 0
Previoue Employee ID
 
END_DT End Date Example: 2/29/2000
Type: date Format: Upper Length: 10 Decimals: 0
End Date of Proposal
 
FA_COST_REQ FA Cost Requested Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if FA Cost request
 
FOREIGN_APP_COMP Foreign Application/Component Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if foreign application component
 
GM_SOURCE_INCOME Source Example:
Type: character Format: Mixed Length: 30 Decimals: 0
Descriptive Source of Income
 
GR_INTELL_PROP_RPT Intellectual Property Reported Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if intellectual property reported in proposal
 
LAST_UPDATE_DT Last Updated Example: CNVGM000
Type: date Format: Upper Length: 10 Decimals: 0
Date on which the proposal was most recently updated.
 
LASTUPDOPRID Last Update User ID Example: 6/26/2004
Type: character Format: Mixed Length: 30 Decimals: 0
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
 
MAJOR_SUBDIVISION Major Subdivision ID Example: 02700
Type: character Format: Upper Length: 10 Decimals: 0
Department-ID associated with each project.
 
MODULAR_FLG NIH Modular Grant Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if a NIH Modular Grant
 
NAME Name Example: Smith,John A
Type: character Format: Name Length: 50 Decimals: 0
Employee name (Last,First Middle)
 
PGM_INCOME_PB Program Income Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if there will be program income related to this proposal
 
PI_CHANGE_IND PI Change Indicator Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Has the Primary Principal Investigator been changed? (Y/N)
 
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: BUEC43211700000
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.
 
PROP_RECEIVED_DATE Proposal Received Date Example:
Type: date Format: Upper Length: 10 Decimals: 0
Date Proposal was received by the Sponsor
 
PROPOSAL_ID_SPNSR Sponsor Proposal ID Example:
Type: character Format: Upper Length: 30 Decimals: 0
Proposal Id assigned by the Sponsor
 
PROPOSAL_RFP_REF Solicitation/RFP Number Example:
Type: character Format: Mixed Length: 30 Decimals: 0
RFP Number related to proposal
 
PROPOSAL_STATUS_GR Proposal Status Example: NEW
Type: character Format: Upper Length: 4 Decimals: 0
Stage of Proposal, new,pending, declined, awarded,withdrawn
PROPOSAL_TYPE Proposal Type Example:
Type: character Format: Upper Length: 3 Decimals: 0
Predefined, institution specific proposal types
 
PURPOSE Purpose Example: PUBSV
Type: character Format: Upper Length: 5 Decimals: 0
Identifying code for one of 15 categories of university functions (eg. PUBSV=Public service; RSCH!=Fderal research; ACDSP= Acadedmic support;...)
 
RENEWAL Renewal in Progress Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Is this a renewal of an existing contrat? (Y/N)
 
REVIEW_COMP Review Completed Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Has "review" been completed? (Y/N)
 
ROW_NUMBER Row_Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Row Number of Proposal
 
SUB_PROP_NBR Proposal Project Example: BUEC33211404000
Type: character Format: Upper Length: 15 Decimals: 0
A Project-ID within a Proposal or Award.
 
SUBMIT_STATUS Proposal Submission Status Example:
Type: character Format: Upper Length: 4 Decimals: 0
Submission status, submitted or pending
TITLE56 Short Title Example: (D) PUBLIC ALLIES/AMERICORPS
Type: character Format: Mixed Length: 56 Decimals: 0
Literal name of the Proposal or Award.
 
TOTAL_BUDGET_AMT Total Budget Example: 60000
Type: signed number Format: Upper Length: 12 Decimals: 2
Total proposal budget amount
 
TOTAL_FA_COST Total FA Budget Example: 30600
Type: signed number Format: Upper Length: 12 Decimals: 2
Total FA budget per proposal
 
Fields deemed insignificant at UD, or of limited use to general campus users.
BUSINESS_UNIT_AWD Business Unit
CONTINUATION_FLAG Continuation Flag
DATE_FROM Date From
DATE_TO Date To
DESCR150_MIXED Description
DISCLOSURE_FLAG Disclosure Permission Statemen
GR_SOURCE_FUNDING Guaranteed Source of Funding
MAILING_INSTRUCT Mailing Instructions
PRE_PROPOSAL_NBR Pre-Proposal Number
PREV_CONTRACT_NUM Previous Project/Grant
PRIMARY_SPNSR_ID Primary Sponsor
PROPOSAL_PRE_ALLOW Pre-award Spending Allowed
SBIR_FLAG SBIR Fast Track
SOLICITATION_TITLE Solicitation Title
STTR_FLAG STTR Fast Track
TRANSMISSION_CODE Transmission Code
US_TIME_ZONES Time Zones for the U.S.