Award SDO Version 2

This service data object contains attributes that are specific in creating an award.

QName: {http://xmlns.oracle.com/apps/projects/grantsManagement/award/service/awardServiceV2/}AwardHeaderForCreate

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Award Personnel Version 2

Contains

Award Funding SDO Version 2

Contains

Award Descriptive Flexfield

Contains

Award or Award Project Attachment Version 2

Contains

Award Budget Period Version 2

Contains

Award Translation Version 2

Contains

Award Project SDO Version 2

Contains

Award Reference Type Version 2

Contains

Award Funding Source

Contains

Award Terms and Conditions Version 2

Contains

Award Keyword Version 2

Contains

Award Organization Credit Version 2

Contains

Award Certification Version 2

Contains

Award Assistance Listing Numbers Version 2

Handled by

Award Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

Attachment

Award or Award Project Attachment Version 2

This service data object contains attachment attributes for the award and award project.

AwardBudgetPeriod

Award Budget Period Version 2

This service data object contains award budget period attributes such as budget period name, start date and end date.

AwardCertification

Award Certification Version 2

This service data object contains certification attributes of the award.

AwardCfda

Award Assistance Listing Numbers Version 2

This service data object contains attributes specific to award federal domestic assistance program.

AwardFunding

Award Funding SDO Version 2

This service data object contains award funding attributes such as funding issue type, funding issue name.

AwardFundingSource

Award Funding Source

Service data object that contains both external and internal funding source information for the award.

AwardHeaderDFF

Award Descriptive Flexfield

This service data object contains user-defined attributes for the award.

AwardHeaderTranslation

Award Translation Version 2

This service data object contains translatable award attributes such as award description which can be updated.

AwardId

long

The unique internal identifier of the award.
  • Primary Key

AwardKeyword

Award Keyword Version 2

This service data object contains attributes specific to award keyword.

AwardName

string

Name of the award.

AwardNumber

string

Number of the award.

AwardOrganizationCredit

Award Organization Credit Version 2

This service data object contains attributes specific to award organization credit.

AwardOwningOrganizationId

long

The unique identifier of the award organization.

AwardOwningOrganizationName

string

An organization that owns awards within an enterprise. An organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting for the award.

AwardPersonnel

Award Personnel Version 2

This service data object contains award personnel attributes such as person name, role.

AwardProject

Award Project SDO Version 2

This service data object contains award project attributes such as project name, project number.

AwardPurpose

string

Description of an activity that the award is funding, for example, Research or Clinical trial.

AwardPurposeCode

string

Description of an activity that the award is funding, for example, Research or Clinical trial.

AwardReference

Award Reference Type Version 2

This service data object contains reference type attributes that serve as a reference for the award. For example, proposal identification.

AwardTerm

Award Terms and Conditions Version 2

This service data object contains attributes of the terms and conditions associated to the award.

AwardTypeCode

string

Classification of an award, for example, Federal grants or Private grants.

AwardTypeName

string

Classification of an award, for example, Federal grants or Private grants.

BillPlanName

string

Name of the bill plan associated with the contract line for the award.

BillSetNumber

decimal

Billing set number is used to group invoices

BillToContactEmail

string

Contact person Email from the Bill-To Customer Site

BillToContactId

long

Contact person Identifier from the Bill-To Customer Site

BillToContactName

string

Contact person from the Bill-To Customer Site

BillToSite

string

Customer site where the invoices should be sent to and is responsible for the payment

BillToSiteUseId

long

Customer site Identifier where the invoices should be sent to and is responsible for the payment

BillingCycle

string

Billing cycle represents the frequency at which invoices are created for this bill plan.

BurdenScheduleFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Fixed date for firm burden schedules.

BurdenScheduleId

long

The unique identifier of the burden schedule.

BurdenScheduleName

string

Name of the burden schedule assigned at the award level.

BusinessUnitId

long

The unique identifier of the award business unit.

BusinessUnitName

string

A unit of an enterprise that performs one or many business functions that can be rolled up in a management hierarchy. An award business unit is one within which the award is created.

CloseDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date past the end date of the award. Transactions for the award can be entered up to this date.

ContractLineName

string

Name of the contract line created for the award contract.

ContractStatus

string

Status of the award.

ContractTypeId

long

The unique identifier of the contract type.

ContractTypeName

string

Name of the contract created for the award.

CurrencyCode

string

Currency code representing the award currency. The currency code is a three-letter ISO code associated with a currency.

Description

string

Description of the award.

DocumentNumber

string

The unique identifier of the letter of credit document issued to the award.

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

End date of the award.

EventFormat

string

The name of the format that is the source of the columns, text, and layout used to group events on an invoice line.

ExpandedAuthorityFlag

boolean

If enabled, indicates the award funding is authorized to be spent across budget periods, that is, funds are carried over from one period to another. If this is not enabled, then funding amount cannot be carried forward to the next budget period, which is known as restricted authority spending.

FederalInvoiceFormat

string

This field stores and indicates federal invoice format that is used for bill presentment purpose.

FlowThroughAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Amount funded to the primary award that is associated with the subaward.

FlowThroughFederalFlag

boolean

Indicates if the primary award is funded by a federal agency.

FlowThroughFromDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start date of the primary award, which is associated with the subaward.

FlowThroughPrimarySponsorId

long

The unique identifier of the primary sponsor for flow-through awards.

FlowThroughPrimarySponsorName

string

Name of the primary sponsor funding the main award, which is associated with the subaward.

FlowThroughPrimarySponsorNumber

string

Number of the primary sponsor funding the main award, which is associated with the subaward.

FlowThroughReferenceAwardName

string

Name of the primary award received from the primary sponsor, which is associated with the subaward.

FlowThroughToDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

End date of the primary award, which is associated with the subaward.

GeneratedInvoiceStatus

string

Generated Invoice Status

GeneratedInvoiceStatusCode

string

Generated Invoice Status Code

InstitutionComplianceApprovalDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Indicates if the award is compliant with the policy set forth by the Institution.

InstitutionComplianceFlag

boolean

Indicates if the award is compliant with the institution policy and no conflict of interest exists.

InstitutionComplianceReviewCompletedFlag

boolean

Indicates if the conflict of interest review is completed.

InstitutionId

long

The unique identifier of the institution.

InstitutionName

string

Organizational entity that is receiving the funding.

IntellectualPropertyDescription

string

Description of the intellectual property.

IntellectualPropertyReportedFlag

boolean

Indicates if intellectual property such as patents and trademarks, is reported for the award.

InvHdrGroupingOptions

string

The award invoice grouping option for this award.

InvHdrGroupingOptionsName

string

The award invoice grouping option for this award.

InvoiceMethod

string

The name of the method to calculate invoice amounts for the bill plan associated with the contract line for this award project.

LaborFormat

string

The name of the format that is the source of the columns, text, and layout used to group labor items on an invoice line.

LegalEntityId

long

The unique identifier of the legal entity.

LegalEntityName

string

Recognized party with given rights and responsibilities by legislation. Owns the award being displayed.

LetterOfCreditFlag

boolean

Indicates the award is issued under a letter of credit.

NetInvoiceFlag

boolean

The net invoice flag for this award.

NonLaborFormat

string

The name of the format that is the source of the columns, text, and layout used to group nonlabor items on an invoice line.

ObjectVersionNumber

int

Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

PaymentTerms

string

Terms used to schedule payments and calculate due dates, discount dates, and discount amounts for each invoice.

PreAwardDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date prior to the start date of the award. Transactions for the award can be entered from this date.

PreAwardGuaranteedFundingSource

string

Additional information on guaranteed funding source associated with the preaward spending authorization.

PreAwardSpendingAllowedFlag

boolean

Indicates spending is allowed before the award is received.

PreviousAwardAccomplishmentRenewFlag

boolean

Indicates if the renewal of a previous award is based on any accomplishment.

PreviousAwardBUId

long

The unique identifier of the business unit of the previous award.

PreviousAwardBUName

string

Name of the business unit that owns the previous award.

PreviousAwardId

long

The unique identifier of the previous award.

PreviousAwardInProgressRenewFlag

boolean

Indicates if a previous award is being renewed.

PreviousAwardName

string

Name of the previous award associated with the award.

PreviousAwardNumber

string

The number of the previous award.

PrincipalInvestigatorEmail

string

E-mail of the person assigned to the award.

PrincipalInvestigatorId

long

The unique identifier of the person, in human resources, identified as the principal investigator.

PrincipalInvestigatorName

string

Principal investigator assigned to the award project.

PrincipalInvestigatorNumber

string

Number of the person selected from Human Resources to administer and manage awards.

RevenueMethod

string

The name of the method used to calculate revenue amounts for the revenue plan associated with the contract line for this award project.

RevenuePlanName

string

Name of the revenue plan associated with the contract line for the award.

ShipToSite

string

Ship-to Site Use Location

ShipToSiteUseId

long

Ship-to Site Use ID

SourceTemplateId

long

The unique identifier of the award template that is used to create the award.

SourceTemplateName

string

Name of the template that is used to create an award. An award template is a standard award created for use in creating other awards.

SourceTemplateNumber

string

The number of the award template that is used to create the award.

SponsorAwardNumber

string

Award number tracked by the sponsor.

SponsorId

long

The unique identifier of the primary sponsor.

SponsorName

string

Name of the sponsor, who is also the customer, funding the award.

SponsorNumber

string

Number of the sponsor related to the customer from TCA.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start date of the award.

Status

string

Status of the award.

TotalAwardAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Total funding amount granted for the award.

TransactionTypeId

long

Invoice Transaction Type ID

TransactionTypeName

string

Transaction type name