ORA_PURPOSE Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

ORA_PURPOSE Table

Explanation
Lookup table for ORA purpose codes for proposals and awards. For example, the description that corresponds to ORA purpose code "01" is "RESEARCH."

Common Uses

• Displaying the description of the ORA purpose instead of the ORA purpose code that appears in a related table. ("Don't show the codes in the report. Show the English instead.")

ORA_PURPOSE_CODE

ORA_PURPOSE_CODE

AWARD

PROPOSAL

• ORA_PURPOSE_CODE is a code used by the ORA system to indicate the purpose of the grant or contract. It is not the same as the BEN Financials FUND_PURPOSE_CODE, whose decoded values are stored in the PURPOSE_CODES table.

ORA_PURPOSE Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home