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

UOD_AWD_ATRB_VW

Award Attributes:: Descriptive header information for each proposal once a Purpose and Project-ID(s) have been assigned. Includes awards in "pre-award" status, through "awarded", "closed", etc. Similar to Proposal Attributes, but data continues to be updated across the life of the award; whereas Proposal Attributes are static as of the award date.
BUSINESS_UNIT Business Unit Example: UOD01
KEY Type: character Format: Upper Length: 5 Decimals: 0
Business Unit
 
CONTRACT_LINE_NUM Contract Line Num Example: 1
KEY Type: number Format: Upper Length: 3 Decimals: 0
Each offering appears on the contract as a distinct contract line number.For rows with a billing method of As-incurred, the system displays the contract line number corresponding to given cross-reference sequence number row.
 
CONTRACT_NUM Contract Example: SP4800-03-2-0332
KEY 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.
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: 32256
KEY Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
 
PERIOD Period Example: 2
KEY Type: number Format: Upper Length: 3 Decimals: 0
Calendar period (usually a year) within which a certain scope of the overall contract occurs. (NOT the Accounting period within a fiscal year.)
 
SETID SetID Example: UOD01
KEY Type: character Format: Upper Length: 5 Decimals: 0
Always = UOD01
 
ACCT_PLAN_ID Revenue Recognition Plan Example: R101
Type: character Format: Upper Length: 10 Decimals: 0
Scheme by which revenue is recognized and posted to General Ledger. Usually = R101= recognizing that revenue has been earned at the point that each expenditure has been made.
 
ADD_DT Customer Added On Example: 1/1/1951
Type: date Format: Upper Length: 10 Decimals: 0
Date customer added to the system
 
ADDR_SEQ_NUM_BILL Address Sequence Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Specifies which of this customer's addresses should be used for billing?
 
ADDR_SEQ_NUM_SHIP Address Sequence Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Specifies which of this customer's addresses should be used for shipping?
 
ADDR_SEQ_NUM_SOLD Address Sequence Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Specifies at which of this sponsor's addresses the contract was executed (including the reponsible individual there).
 
ADDRESS_SEQ_BRK Primary Address - Broker Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Primary address of the agency brokering the award.
 
ADDRESS_SEQ_IND Primary Address - Indirect Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Value of address for billing to indirect customer
 
ADDRESS_SEQ_NUM Address Sequence Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Customer address to which the invoice is to be sent. Accept the default value or select a different address sequence number
 
ADDRESS_SEQ_SHIP Primary Address - Ship To Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
indicates which address to ship to
 
ADHOC_OFFERING Ad hoc Offering Example: N
Type: character Format: Upper Length: 1 Decimals: 0
indicates if this offering is ad hoc or regular
 
ADJUSTED_AWD_AMT Adjusted Award Amt Example: 0
Type: number Format: Upper Length: 13 Decimals: 2
Monetary amount of an award after adjustments have been made.
 
ADJUSTMENT_AMT Adjustment Amount Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
Monetary amount by which a revision changes an award amount.
 
ALLOCATION_DONE Allocation is complete Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select this check box to initiate system edit checking to ensure that you have fully allocated the amount and discount to the active contract offerings.
 
AMOUNT Amount Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
Monetary amount of a transaction or budget.
 
AMOUNT_TOTAL Amount Total Example: 0
Type: signed number Format: Upper Length: 18 Decimals: 2
Total monetary amount- not populated at UD
 
APPLIES_TO Applies to Example: HDR
Type: character Format: Upper Length: 4 Decimals: 0
Default is HDR
 
APPROVAL_DATE Approval Date Example:
Type: date Format: Upper Length: 10 Decimals: 0
Date Award approved
 
AWARD_STATUS Award Status Example: ACP
Type: character Format: Upper Length: 3 Decimals: 0
Status of the award. Only two are used at UD: ACP=Accepted/Awarded, PRE=Pre-award.
 
AWARD_TYPE Award Type Example: GR
Type: character Format: Upper Length: 3 Decimals: 0
This field defaults to Grant when you generate the award. You may, however, select a different project type: Capital, Construction, Government, Internal, Research, Service, Training.
 
BEGIN_DT Begin Date Example: 10/1/2003
Type: date Format: Upper Length: 10 Decimals: 0
First date on which funds for this award are available.
 
BI_MANAGES_REV Billing Manages Revenue Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Does the action of "billing" control the recognition of "revenue"? (Y/N)
 
BILL_PLAN_ID Billing Plan ID Example: B101
Type: character Format: Upper Length: 10 Decimals: 0
Each contract con contain multiple billing plans. You must select a contract number before you can search by billing plan ID.
 
BILL_TO_CUST_ID Customer Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Unique identifier of the customer/sponsor to be billed for this contract.
 
BILL_TO_FLG Bill To Customer Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Check the field to bill to customer
 
BILL_TYPE_ID Bill Type Identifier Example: GM
Type: character Format: Upper Length: 3 Decimals: 0
Represents the category of the product or service being billed.For example: Grants Management, Miscellaneous, Project Costing, Rent
 
BILLED_PREPAID_AMT Amount Billed for PPD Balance Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
Amount billed on prepaid portion of grant
 
BROKER_FLG Broker Customer Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Is this customer a broker? Brokers can place orders on behalf of a customer.
 
BUSINESS_UNIT_BI Billing Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Business Unit (Always = UOD01)
 
BUSINESS_UNIT_PC PC Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Business Unit (Always = UOD01)
 
CA_LINE_STATUS Obligation status Example: ACTIVE
Type: character Format: Upper Length: 1 Decimals: 0
Processing status for obligation. Either active, pending, or closed.
 
CA_PROC_STATUS Processing Status Example: A
Type: character Format: Upper Length: 1 Decimals: 0
CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
 
CA_STATUS Contract Status Example: A
Type: character Format: Upper Length: 24 Decimals: 0
Every contract that you create in PeopleSoft Contracts is associated with a contract status that has been mapped to a processing status of Pending, Active, or Closed.
 
CFDA_NBR CFDA Number Example: 0
Type: number Format: Upper Length: 6 Decimals: 3
"Catalog of Federal Domestic Assistance" number assigned to each funding opportunity by the federal sponsor.
 
CHG_ID Amendment Number Example: 0000000001
Type: character Format: Upper Length: 10 Decimals: 0
Change Package Identifier. This is sequenced from 1 to N for each contract.
CHG_STATUS Amendment Status Example: C
Type: character Format: Upper Length: 1 Decimals: 0
Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplie
 
CNTCT_SEQ_BILL Contact Sequence - Bill To Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Specifies which of the sponsor's contacts bills should be sent.
 
CNTCT_SEQ_NUM Contact Sequence Number Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Which of several contacts at an agency pertains to this award.
 
CNTCT_SEQ_OPAC OPAC Contact Sequence Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Date Init. Issue # Description 10/09/01 JJM DI-EDWONG-17 Project Gemini enhancements
 
CNTCT_SEQ_SOLD Primary Contact - Sold To Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Sponsor's representative who executed the contract on their behalf.
 
COMMENTS Comment Example: MODIFICATION NO. P00002 INCREASES THE AWARD BY $179,000 AND EXTENDS THE
Type: text Format: Upper Length: 0 Decimals: 0
Free-form comment.
 
COMPLIANT_POLICY Compliance with Inst. Policy Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Is Award compliant with institutional policy, yes or no.
 
CONTACT_ID Contact ID Example: 0
Type: character Format: Upper Length: 15 Decimals: 0
Contact Identifier for Treasury Contacts
 
CONTR_LEGAL_ENTITY Contract Legal Entity Example: UOD01
Type: character Format: Upper Length: 15 Decimals: 0
Aways = UOD01
 
CONTR_MSTR_FLG Master Contract Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select to designate this contract as a master. This checkbox is not available on Active contracts
 
CONTR_NET_AMT Net Amount Example: 0
Type: number Format: Upper Length: 27 Decimals: 3
The system updates this field to reflect the contract line's negotiated amount minus its discounts entered on the Negotiated Amount Allocation page
 
CONTR_TEMPLATE_FLG National or Global Contract Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Do you want to use the template?
 
CONTRACT_SIGN_DT Contract signed on Example: 10/1/2003
Type: date Format: Upper Length: 10 Decimals: 0
Date on which the contract was signed by the sponsor.
 
CONTRACT_TYPE Contract Type Example: OTHER
Type: character Format: Upper Length: 15 Decimals: 0
Contract types enable you to categorize your contracts for reporting purposes
 
CORPORATE_CUST_ID Corporate Customer Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Unique number assigned to corporate customer
 
CORPORATE_SETID SetID Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Always = UOD01
 
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_SHR_SPNSR_REQ Required by Sponsor Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Does the sponsor require "cost share" (Y/N)?
 
COTERMINATION Contains Cotermination Lines Example: N
Type: character Format: Upper Length: 1 Decimals: 0
PSIRS-KK
 
CREDIT_CHECK Credit Check Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Indicates automatic credit check off or on
 
CRSPD_CUST_ID Correspondence Customer Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Uniquely identifies an organization to whom official correspondence is directed.
 
CRSPD_SETID SetID Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Always = UOD01
 
CURRENCY_CD Currency Code Example: USD
Type: character Format: Upper Length: 3 Decimals: 0
Currency Code
 
CUST_ID Customer ID Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Uniquely identifies an organization that purchases goods or services from the University. This is the sold-to customer (the customer organization that places orders / sponsors the activity). May or may not be same as Bill/ship.
 
CUST_LEVEL Customer Level Example: R
Type: character Format: Upper Length: 1 Decimals: 0
Category of customer
 
CUST_STATUS Customer Status Example: A
Type: character Format: Upper Length: 1 Decimals: 0
Select Active or Inactive. You cannot post pending items to inactive customer accounts in PeopleSoft Receivables.
 
CUST_STATUS_DT Customer Status Date Example: 1/1/1951
Type: date Format: Upper Length: 10 Decimals: 0
Date customer status was changed
 
CUSTOMER_TYPE Customer Type Example: 1
Type: character Format: Upper Length: 1 Decimals: 0
Iidentifies customer categories in your reports. For example, User 1 might represent your manufacturing customers, User 2 your retail customers, and so forth
 
DATE_LAST_MAINT Date Last Maintained Example: 8/31/2004
Type: date Format: Upper Length: 10 Decimals: 0
Date customer record last updated
 
DESCR Description Example: DLA DPTAC FY04
Type: character Format: Mixed Length: 30 Decimals: 0
Description
 
DESCR200 Long Description Example: Delaware Procurement Technical Assistance Center
Type: character Format: Upper Length: 254 Decimals: 0
Description
 
DESCR254_MIXED More Information Example: Delaware Procurement Technical Assistance Center
Type: character Format: Mixed Length: 254 Decimals: 0
Description of length 254
 
DESCR3 Description Example: Rate Based
Type: character Format: Mixed Length: 30 Decimals: 0
Description of length 254
 
DFR_REV_PROCESSED Booked to Deferred Revenue Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Was this contract booked to deferred revenue
 
EMPLID EmplID Example: 32256
Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
END_DT End Date Example: 9/30/2005
Type: date Format: Upper Length: 10 Decimals: 0
Last date of period in given project
 
END_DT2 End Date Example: 9/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
Last date of period in given project
 
FA_SPNSR_BASE_ID Sponsor Base Example: MTDC
Type: character Format: Upper Length: 5 Decimals: 0
Basis on which the F&A (facilities & administration) rate is determined. Values include: MTDC=Modified Total Direct Cost; SLNWG=Salary & wages; FXTDC=Fixed total direct cost; NOFA=No F&A; BRTOL=Bartol (old grants); REU=Research expense for undergraduate.
 
FOREIGN_FLAG Foreign Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Indicates Foreign
 
GM_AMT_FLO_THRU Amount Example: 179000
Type: number Format: Upper Length: 13 Decimals: 2
Dollar amount of flow through
 
GM_BEGIN_DT Begin Date Example: 10/1/2003
Type: date Format: Upper Length: 10 Decimals: 0
Begin Date of contract
 
GM_CFDA_NUM CFDA Number Example: 12.002
Type: character Format: Upper Length: 10 Decimals: 0
Catalog of Federal Domestic Assistance Number: assigned to each funding opportunity by the federal sponsor and typically identified in program announcements and award notices.
GM_CS_DTL_FLAG Cost Sharing Detail Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Indicates if cost share detail is included
 
GM_END_DT End Date Example: 9/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
End date of contract
 
GM_FEDERAL_FLAG Federal Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Indicates federal source
 
GM_METHOD_PAYMENT Method of Payment Example: CST
Type: character Format: Upper Length: 3 Decimals: 0
Indicates which type of bill is being processed
 
GM_SAL_DTL_FLAG Salary Detail Report Example: N
Type: character Format: Upper Length: 1 Decimals: 0
indicates if salary detail is included
 
GR_INTELL_PROP_RPT Intellectual Property Reported Example: N
Type: character Format: Upper Length: 1 Decimals: 0
indicates if intellectual property is included
 
GRANTS_SPONSOR_FLG Grants Management Sponsor Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
indicates that customer is a grant sponsor
GROSS_AMT Gross Invoice Amount Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
gross amount billed on invoice
 
HOLD_UPDATE_SW Hold Update Switch Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Allows or disallows updates
 
INCLUDE_OLT Limit Override Example: N
Type: character Format: Upper Length: 1 Decimals: 0
allows or disallows override
 
INDIRECT_CUST_FLG Indirect Customer Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Indicates that customer is indirect
 
INITIAL_AWD_AMT Initial Award Amt Example: 0
Type: number Format: Upper Length: 13 Decimals: 2
Amount of initial award before revisions
 
INSTID Institution ID Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Always=UOD01
 
LAST_ACCT_PLAN_NBR Last Acct Plan Number Used Example: 101
Type: number Format: Upper Length: 3 Decimals: 0
last account plan number used
 
LAST_BILL_PLAN_NBR Last Bill Plan Number Used Example: 101
Type: number Format: Upper Length: 3 Decimals: 0
last bill plan number used
 
LAST_MAINT_OPRID Last Maintained By Operator ID Example: tkachick
Type: character Format: Upper Length: 30 Decimals: 0
research personnel that made the change
 
LAST_UPDATE_DT Last Updated Example: 6/26/2004
Type: date Format: Upper Length: 10 Decimals: 0
Date on which the award was most recently updated.
 
LASTUPDDTTM Last Update Date/Time Example: 10/05/2004 2:55:12PM
Type: date-time Format: Seconds Length: 26 Decimals: 0
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
 
LASTUPDOPRID Last Update User ID Example: rash
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.
 
LEGAL_REVIEW_FLG Legal Review Flag Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Indicates if legal review has occurred
 
LIMIT_AMOUNT Limit Amount Example: 358000
Type: signed number Format: Upper Length: 28 Decimals: 3
The funding limit amount provided by the sponsor from the contract bill line.
LIST_PRICE List Price Example: 0
Type: signed number Format: Upper Length: 17 Decimals: 4
price of line item
 
LOC_INDICATOR Letter of Credit Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if the sponsor uses letter of credit to provide funding for awards
 
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 this is a NIH Modular grant
 
NAME Name Example: Smith,John A
Type: character Format: Name Length: 50 Decimals: 0
Employee name (Last,First Middle)
 
NAME1 Name 1 Example: Defense Logistic Agency
Type: character Format: Mixed Length: 40 Decimals: 0
The sponsor name.
 
NAMESHORT Short Name Example: DLA
Type: character Format: Mixed Length: 10 Decimals: 0
Short name of sponsor
NET_AMOUNT Net Amount Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
 
OFFERING_CATEGORY Offering Category Example: GRANTS
Type: character Format: Upper Length: 20 Decimals: 0
When defining an offering (good or service), you can associate it with an offering category
 
OFFERING_ID Offering ID Example: RATE_BASED
Type: character Format: Upper Length: 20 Decimals: 0
ID for the type of offering (good or service).
 
OPAC_INTERFACE OPAC Interface Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if your company is a U.S. Federal entity and requires the U.S. Department of Treasury's OPAC interface.
 
OPRID_ENTERED_BY Entered By Example: geh
Type: character Format: Upper Length: 30 Decimals: 0
Operator-ID (not EmplID) of OVPR staff member who awarded the contract.
 
PERCENTAGE Percentage Example: 0
Type: signed number Format: Upper Length: 7 Decimals: 2
percentage complete
 
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)
 
PREPAID_FLAG Prepaid offering Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Prepaid good or service
 
PRICING_STRUCTURE Price Type Example: RATE
Type: character Format: Upper Length: 4 Decimals: 0
Select the price type to be used for this offering. Amount: Percent:Rate:
 
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: BUEC33211404000
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.
 
PROPOSAL_ID Proposal ID Example: 0327080014
Type: character Format: Upper Length: 25 Decimals: 0
Unique identifier of a proposal.
 
PROPOSAL_PRE_ALLOW Pre-award Spending Allowed Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Is pre-award spending allowed? (Y/N)
 
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;...)
 
QTY Quantity Example: 1
Type: signed number Format: Upper Length: 17 Decimals: 4
Quantity of line item
 
REF_AWD_NUMBER Reference Award Number Example: SP4800-03-2-0332
Type: character Format: Mixed Length: 20 Decimals: 0
Award Number
 
REMIT_FROM_CUST_ID Remit From Customer Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Customer ID for customer that will pay
 
REMIT_FROM_SETID SetID Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Always UOD01
 
RENEWABLE Renewable Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if contract is renewable
 
RENEWAL Renewal in Progress Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Is this a renewal of an existing contrat? (Y/N)
 
REPORTS_TO_SPONSOR Reports To Sponsor Example: 1264
Type: character Format: Upper Length: 15 Decimals: 0
ID for Sponsor that receives reports.
REV_RECOG_METHOD Revenue Recognition Method Example: 1
Type: character Format: Mixed Length: 4 Decimals: 0
The revenue recognition method describes the nature of the revenue recognition that applies to contract lines that are linked to a revenue recognition plan.As Incurred, Apportionment, % Complete, and Milestone
 
REVIEW_COMP Review Completed Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Has "review" been completed? (Y/N)
 
RNW_CYCLE_NBR Renewal Package Cycle Example: 0
Type: number Format: Upper Length: 6 Decimals: 0
PSIRS-KK
 
RNW_LINKED Renewal Assigned to Schedule? Example: N
Type: character Format: Upper Length: 1 Decimals: 0
PSIRS-KK
 
RT_TYPE Rate Type Example: CRRNT
Type: character Format: Upper Length: 5 Decimals: 0
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
 
SHIP_TO_FLG Ship To Customer Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if bill should be sent to ship to customer
 
SINCE_DT Customer Since Example: 1/1/1951
Type: date Format: Upper Length: 10 Decimals: 0
Date customer was added.
 
SOLD_TO_CUST_ID Sold To Customer Example: 1253
Type: character Format: Upper Length: 15 Decimals: 0
Unique indentiifier for sold to customer
 
SOLD_TO_FLG Sold To Customer Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if bill should be sent to sold to customer
 
SOURCE_RNW_CYCLE Source Renewal Cycle Example: 0
Type: number Format: Upper Length: 6 Decimals: 0
PSIRS-KK
 
SPNSR_LEVEL Level Example: DIV
Type: character Format: Upper Length: 4 Decimals: 0
Define the levels within a sponsor organization with which your institution conducts business. Examples of sponsor level values may include Division, Primary, Program, Sub-Sponsor, or any other level that you may want to define.
 
SPNSR_TYPE Sponsor Type Example: FED
Type: character Format: Upper Length: 4 Decimals: 0
Define the types of sponsors with which your institution has relationships. Sponsor type values might include Federal Government, Business/Profit Entity, Campus-Related Organization, Foundation/Charitable Trust, Other Government Agency, or State.
 
START_DT2 Start Date Example: 10/1/2003
Type: date Format: Upper Length: 10 Decimals: 0
Start Date of Contract
 
SUB_PROP_NBR Proposal Project Example: BUEC33211404000
Type: character Format: Upper Length: 15 Decimals: 0
A Project-ID within a Proposal or Award.
 
TAX_EXEMPT_FLG Tax Exempt Flag Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select when incoming POs are tax exempt
 
THIRD_PARTY_FLG Third Party Flag Example: N
Type: character Format: Upper Length: 1 Decimals: 0
Select if third party customer.
 
TITLE56 Short Title Example: DLA DPTAC FY04
Type: character Format: Mixed Length: 56 Decimals: 0
Literal name of the Proposal or Award.
 
TOT_CONTR_AMT Gross value Example: 0
Type: number Format: Upper Length: 27 Decimals: 3
Amount entered in the Negotiated Amt field on the Contract General page appears
 
TOTAL_REDUCTIONS Total Discounts Example: 0
Type: signed number Format: Upper Length: 28 Decimals: 3
Equals the sum of all header and line discounts for amount-based contract lines you defined for this contract.
 
US_FLAG_CARRIER US Flag Carrier Required Example: Y
Type: character Format: Upper Length: 1 Decimals: 0
Select if customer is US FLAG Carrier
 
VERSION_ID Version ID Example: V1
Type: character Format: Upper Length: 7 Decimals: 0
Identifies the version of this proposal/award to which this row pertains.
 
Fields deemed insignificant at UD, or of limited use to general campus users.
ACCOMPLISH_RENEWAL Accomplishment Based Renewal
ALLOC_IN_PROGRESS Allocation In Progress
AMENDMENT_DT Amendment Date
APPROVAL_DT Date of Approval
APPROVED_BY EMPLID Approved By
AWARD_DT Award Date
BURDEN_PLAN Burden Plan
BUSINESS_UNIT_AWD Business Unit
CHG_CMP_DT Amend Completion Date
CNTCT_SEQ_SHIP Primary Contact - Ship To
CONSOL_BUS_UNIT Consolidation Business Unit
CUSTOMER_ALC Customer Agency Location Code
DESCR150_MIXED Description
DESCR150_TEXT Description
DESCR254 Long Description
DESCRFORMAL Formal Description
DESCRLONG Description
DESCRSHORT2 Short Description
DFR_REV_ACCT_DT Deferred Revenue Acctg Date
DISCOUNT_ID Discount ID
DST_ID Distribution Code
DTTM_STAMP Date/Time Stamp
EMPLID_OLD Previous Employee ID
END_DT4 End Date
FORMER_NAME_1 Former Name 1
FORMER_NAME_2 Former Name 2
GM_ADMIN_CNTCT Grant Adminstrator
GM_DEL_LOC_REFS_SW Delete LOC References
GM_LOC_SPONSOR_ID Letter of Credit Sponsor
GM_SOURCE_INCOME Source
GR_SOURCE_FUNDING Guaranteed Source of Funding
INTERDISCPLINE_USE Interdisciplinary Use
ISSUE_DT Issue Date
LOC_DOC_ID Letter of Credit Document ID
LOC_REFERENCE_ID Letter of Credit ID
MAST_CONTR_ID Master Contract #
NAME1_AC Name 1 Alternate Char Set
NAME2 Name 2
NAME2_AC Name 2 Alternate Char Set
NAME3 Name 3
NAME3_AC Name 3 Alternate Char Set
OFFERING_VAT_ID Offering VAT Identifier
OPRID User ID
PARENT_CONTR_ID Parent Contract
PO_REF Purchase Order Reference
PREV_CONTRACT_NUM Previous Project/Grant
PRIMARY_SPNSR_ID Primary Sponsor
PROPOSAL_RFP_REF Solicitation/RFP Number
PYMNT_TERMS_CD Payment Terms ID
REF_AWD_NUM2 Reference Award
REFER_TO_CUST_ID Refer To Customer
REFER_TO_SETID Refer To Setid
REGION_CD Region Code
RETAINAGE_ID Retainage ID
REVIEW_DAYS Review Days
REVISED_GROSS Revised Gross Amount
REVISED_NET Revised Net Amount
REVISED_REDUCT Revised Reductions
RNW_PKG_ID Renewal Schedule
ROLEUSER User ID
ROW_NUMBER Row_Number
SHIP_FROM_LOC Ship From Location
SHIP_TO_CUST_ID Ship To Customer
SOLICITATION_TITLE Solicitation Title
SOURCE_RNW_PKG_ID Source Renewal Schedule
SPNSR_AWARD_ID Sponsor Award ID
SPNSR_PROGRAM Program Type
START_DT Start Date
STOCK_SYMBOL Stock Symbol
SUBCUST_QUAL1 SubCustomer 1
SUBCUST_QUAL2 SubCustomer 2
TAX_CD Tax Code
TAX_EXEMPT_CERT Exemption Certificate
TAX_GROUP Tax Group
TAX_TRANS_SUB_TYPE Transaction Sub Type
TAX_TRANS_TYPE Transaction Type
TAXPAYER_ID Taxpayer ID
UNIT_OF_MEASURE Unit of Measure
VAT_DCLRTN_POINT Declaration Point
VENDOR_ID2 Vendor ID
VENDOR_SETID Vendor Set ID
WEB_URL Website URL