Awards
The Awards resource is used to view awards.
Columns
| Name | Type | Description |
| AwardId [KEY] | Long | Unique identifier of the award. |
| AwardName | String | Name of the award. |
| AwardNumber | String | Number of the award. |
| BusinessUnitId | Long | Unique identifier of the business unit. |
| BusinessUnitName | String | 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. |
| CurrencyCode | String | Currency code representing the award currency. The currency code is a three-letter ISO code associated with a currency. |
| LegalEntityId | Long | Unique identifier of the legal entity of the award. |
| LegalEntityName | String | Recognized party with given rights and responsibilities by legislation. Owns the award being displayed. |
| SponsorId | Long | Unique identifier of the primary sponsor. |
| SponsorName | String | Name of the sponsor, who's also the customer, funding the award. |
| SponsorNumber | String | Number of the sponsor related to the customer from TCA. |
| StartDate | Date | Start date of the award. |
| EndDate | Date | End date of the award. |
| PrincipalInvestigatorId | Long | The unique identifier of the person, in human resources, identified as the principal investigator. |
| PrincipalInvestigatorName | String | Name of the person selected from Human Resources to administer and manage awards. |
| PrincipalInvestigatorNumber | String | Number of the person selected from Human Resources to administer and manage awards. |
| PrincipalInvestigatorEmail | String | E-mail of the person selected from Human Resources to administer and manage awards. |
| ExpandedAuthorityFlag | Bool | Indicates that the award funding is authorized to be spent across budget periods. |
| BurdenScheduleId | Long | Unique identifier of the burden schedule. |
| BurdenScheduleName | String | Name of the burden schedule assigned at the award level. |
| BurdenScheduleFixedDate | Date | Specific date used to determine the right set of burden multipliers for the award. |
| ContractTypeName | String | Name of the contract type of the award. |
| CloseDate | Date | Date past the end date of the award. Transactions for the award can be entered up to this date. |
| AwardType | String | Classification of an award, for example, Federal grants or Private grants. |
| DaysToClose | Long | Days to close of the award. |
| SponsorAwardNumber | String | Award number tracked by the sponsor. |
| 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. |
| AwardPurposeCode | String | Code of the award purpose. |
| AwardPurpose | String | Name of the award purpose. |
| Description | String | Brief description of the award. |
| SourceAwardName | String | Name of the source award. |
| InstitutionId | Long | The unique identifier of the institution. |
| InstitutionName | String | Organizational entity that's receiving the funding. |
| ContractLineName | String | Name of the contract line created for the award contract. When the award is submitted for approval, it's set to the default value, unless specified otherwise. The default value for ContractLineName is Line 1. |
| DocumentNumber | String | The unique identifier of the letter of credit document issued to the award. |
| LetterOfCreditFlag | Bool | Indicates whether the award is issued under a letter of credit. If the award sponsor is a Federal and Letter of Credit sponsor, then the default value is true. Otherwise, the default value is false. |
| RevenuePlanName | String | Name of the revenue plan associated with the contract line for the award. When the award is submitted for approval, it's set to the default value, unless specified otherwise. The default value for RevenuePlanName is Award Revenue Plan. |
| BillPlanName | String | Name of the bill plan associated with the contract line for the award. When the award is submitted for approval, it's set to the default value, unless specified otherwise. The default value for BillPlanName is Award Bill Plan. |
| LaborFormatId | Long | The unique identifier of the labor format that's the source of the columns, text, and layout used to group labor items on an invoice line. |
| LaborFormat | String | Name of the format that's the source of the columns, text, and layout used to group labor items on an invoice line. The default value for the labor format is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| EventFormatId | Long | The unique identifier of the format that's the source of the columns, text, and layout used to group events on an invoice line. |
| EventFormat | String | Name of the format that's the source of the columns, text, and layout used to group events on an invoice line. The default value for the event format is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| NonLaborFormatId | Long | The unique identifier of the format that's the source of the columns, text, and layout used to group nonlabor items on an invoice line. |
| NonLaborFormat | String | Name of the format that's the source of the columns, text, and layout used to group nonlabor items on an invoice line. The default value for the nonlabor format is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| RevenueMethodId | Long | The unique identifier of the method used to calculate revenue amounts for the revenue plan associated with the contract line for this award project. |
| RevenueMethod | String | Name of the method used to calculate revenue amounts for the revenue plan associated with the contract line for the award project. The default value for RevenueMethod is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| PaymentTermsId | Long | The unique identifier of the terms used to schedule payments and calculate due dates, discount dates, and discount amounts for each invoice. |
| PaymentTerms | String | Terms used to schedule payments and calculate due dates, discount dates, and discount amounts for each invoice. The default value for PaymentTerms is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| BillingCycleId | Long | Billing cycle represents the frequency at which invoices are created for this bill plan. |
| BillingCycle | String | Frequency at which invoices are created for the bill plan. The default value for BillingCycle is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| InvoiceMethodId | Long | The unique identifier of the method to calculate invoice amounts for the bill plan associated with the contract line for this award project. |
| InvoiceMethod | String | Name of the method to calculate invoice amounts for the bill plan associated with the contract line for the award project. The default value for InvoiceMethod is set to the value specified in the Manage Grants Business Unit Implementation Options page in the Setup and Maintenance work area. |
| NetInvoiceFlag | Bool | Indicates whether net invoicing is set on the contract. |
| InvoiceGroupingCode | String | The code of the invoice grouping method. |
| InvoiceGrouping | String | The name of the invoice grouping method. |
| BillSetNumber | Decimal | The billing set number used to group invoices. |
| GeneratedInvoiceStatusCode | String | Lookup code for the Generated Invoice Status. Valid values are D,S,or R. |
| GeneratedInvoiceStatus | String | Status set during the Generate Invoice process. Valid values are Draft, Submitted, or Released. |
| TransactionTypeId | String | Unique identifier of the Receivables Transaction Type for invoices and credit memos. |
| TransactionTypeName | String | Receivables transaction type for invoices and credit memos. |
| BillToSiteUseId | String | Unique identifier of the bill-to customer site that's responsible for receiving and paying the invoice amount. |
| BillToSite | String | The customer site where the invoices are sent. |
| BillToContactId | String | Unique identifier of the bill-to customer contact person on a bill plan. |
| BillToContactEmail | String | The email of the contact person from the bill-to customer site. |
| BillToContactName | String | The contact person of the bill-to customer. |
| ShipToSiteUseId | String | The unique identifier of the ship-to site. |
| ShipToSite | String | The ship-to site. |
| FederalInvoiceFormat | String | This field stores and indicates the federal invoice format that's used for bill presentment. |
| FederalInvoiceFormatCode | String | The unique identifier of the federal invoice format that's used for bill presentment. |
| ContractTypeId | Long | Unique identifier of the contract type. |
| ContractStatus | String | Status of the award contract. Valid values include Draft, Active, or Pending Approval. Set it to Pending Approval when submitting an award for approval using the PATCH method. If set to Active, the award is moved to the Active status. |
| CreatedBy | String | The user that created the award. |
| CreationDate | Datetime | The date when the award was created. |
| LastUpdatedBy | String | The user that last updated the award. |
| LastUpdateDate | Datetime | The date when the award was last updated. |
| InstitutionComplianceApprovalDate | Date | Approval date for the conflict of interest indicator. |
| InstitutionComplianceFlag | Bool | The conflict of interest indicator that specifies whether the award project complies with Institution policy. |
| InstitutionComplianceReviewCompletedFlag | Bool | The conflict of interest indicator that specifies whether compliance review is completed. |
| FlowThroughFromDate | Date | Start date of the primary award, which is associated with the subaward. |
| FlowThroughToDate | Date | End date of the primary award, which is associated with the subaward. |
| FlowThroughFederalFlag | Bool | Indicates if the primary award is funded by a federal agency. Valid values are true and false. |
| FlowThroughPrimarySponsorId | Long | Primary sponsor of the flow through funds. |
| FlowThroughPrimarySponsorName | String | Name of the primary sponsor of the flow through funds. |
| FlowThroughPrimarySponsorNumber | String | Number of the primary sponsor of the flow through funds. |
| FlowThroughReferenceAwardName | String | Name of the primary award received from the primary sponsor, which is associated with the subaward. |
| FlowThroughAmount | Decimal | Amount funded to the primary award that's associated with the subaward. |
| PreviousAwardBUId | Long | The unique internal identifier of a previous award business unit. |
| PreviousAwardBUName | String | Name of the business unit of the previous award. |
| PreviousAwardId | Long | The unique internal identifier of a previous award. |
| PreviousAwardName | String | Name of the previous award. |
| PreviousAwardNumber | String | Number of the previous award. |
| PreviousAwardInProgressRenewFlag | Bool | Indicates if a previous award is being renewed. Valid values are true and false. |
| PreviousAwardAccomplishmentRenewFlag | Bool | Indicates if the renewal of a previous award is based on any accomplishment. Valid values are true and false. |
| IntellectualPropertyDescription | String | Description of the intellectual property. |
| IntellectualPropertyReportedFlag | Bool | Indicates if intellectual property such as patents and trademarks, is reported for the award. Valid values are true and false. |
| PreAwardSpendingAllowedFlag | Bool | Indicates whether preaward spending is allowed. |
| PreAwardGuaranteedFundingSource | String | The guaranteed source of funding for the award. |
| PreAwardDate | Date | Date before the start date of an award. |
| ValidateStatus | String | Indicator that specifies the validation status of an award. The values are C - Complete, E - Error, W - Warning, P - Processing and N - Not Validated. |
| AwardValidationNeededFlag | Bool | Indicator that specifies whether the award should be validated. |
| LastValidated | Datetime | The date when the award is last validated. |
| SourceTemplateId | Long | Unique identifier of the source award template. |
| SourceTemplateName | String | Name of the source award template. |
| SourceTemplateNumber | String | Number of the source award template. |
| CreatedFrom | String | The method of creating the award, for example, FROM_TEMPLATE or BLANK. |
| AwardSource | String | The source from which the award is created, for example, from the UI or the REST service. |
| DateChangeRequestId | Long | The identifier of the process submitted to update the award dates and budget period dates. |
| ShipToAccountId | String | The ship-to account identifier of the customer who receives the goods and services. |
| ShipToAccountNumber | String | The ship-to account number of the customer who receives the goods and services. |
| BillToAccountId | String | The bill-to account identifier of the customer who's responsible for receiving and paying the invoice. |
| BillToAccountNumber | String | The bill-to account number of the customer who's responsible for receiving and paying the invoice. |
| Finder | String | finder |