grant dimension
(PLS_DIM_GRANT) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLS_DIM_GRANT)
| Column Name | Column Description |
|---|---|
| Grant Key | Primary key uniquely identifying each row in the grant dimension. |
| Grant Code | The code assigned to a grant that associates the grant with one or more funds. |
| Grant Status | The current status (e.g. Active, Inactive, etc.) of the grant. |
| Project Start Date | The start date of the grant period. |
| Project End Date | The end date of the grant period. |
| Grant Termination Date | The date after which no expenditures can be posted to be grant. |
| Grant Title Short | The abbreviated title of the grant. |
| Grant Title Long | The title of the grant. |
| Sponsor ID | The code (typically an EIN or Federal Tax ID Number) that uniquely identifies the sponsor awarding the grant. |
| Sponsor Name | The name of the grant sponsor. |
| Sponsor Contact | The sponsor contact person associated with the grant. |
| Previous Contract ID | The external number referencing the contract or PO number provided by the previous sponsor awarding the grant. Maintains both the current and previous values if the sponsor identification is changed. |
| Current Contract ID | The external number referencing the contract or PO number provided by the current sponsor awarding the grant. Maintains both the current and previous values if the sponsor identification is changed. |
| Previous Principal Investigator | The name of the previous grant principal investigator. Maintains both the current and previous values as the principal investigator of the grant is changed. |
| Current Principal Investigator | The name of the current grant principal investigator. Maintains both the current and previous values as the principal investigator of the grant is changed. |
| Previous CFDA Number | The previous number for the Catalog of Federal Domestic Assistance (CFDA). Maintains both the current and previous values as the CFDA Number of the grant is changed. |
| Previous CFDA Title | The previous title for the Catalog of Federal Domestic Assistance (CFDA) Number. Maintains both the current and previous values as the CFDA title of the grant is changed. |
| Previous Federal Agency Name | The previous federal agency name corresponding to the Catalog of Federal Domestic Assistance (CFDA) Number. Maintains both the current and previous values as the federal agency name is changed. |
| Current CFDA Number | The current number for the Catalog of Federal Domestic Assistance (CFDA). Maintains both the current and previous values as the CFDA Number of the grant is changed. |
| Current CFDA Title | The current title for the Catalog of Federal Domestic Assistance (CFDA) Number. Maintains both the current and previous values as the CFDA title of the grant is changed. |
| Current Federal Agency Name | The current federal agency name corresponding to the Catalog of Federal Domestic Assistance (CFDA) Number. Maintains both the current and previous values as the federal agency name is changed. |
| Maximum Funding Amount | The maximum amount of funding committed by the sponsor for the grant. |
| Cumulative Funding Amount | No description available. |
| Grant Administrator | No description available. |
| Proposal Code | The proposal code corresponding to the grant. |
| Grant - Home Portfolio | No description available. |
| Grant - Home Portfolio Description | No description available. |
| Grant - Home Portfolio Financial Manager | No description available. |
| Grant - Home Department | No description available. |
| Grant - Home Department Description | No description available. |
| Grant - Home Department Financial Manager | No description available. |
| Grant - Home Unit | No description available. |
| Grant - Home Unit Description | No description available. |
| Grant - Home Unit Financial Manager | No description available. |
| Grant - Home Section | No description available. |
| Grant - Home Section Description | No description available. |
| Grant - Home Section Financial Manager | No description available. |
| Grant - Home Organization | No description available. |
| Grant - Home Organization Description | No description available. |
| Grant - Home Organization Financial Manager | No description available. |
| Grant - Home Organization Status | No description available. |
| Grant - Home Organization Termination Date | No description available. |
| Grant - Home Organization Type | No description available. |
| Grant - Home Organization Effective Date | No description available. |
