BB RESEARCH VOLUME SUMMARY Table
View exposing summarized research volume measures by fiscal year, supervisor, general ledger category, school, and department including primary and secondary budget and actual measures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_FLAG |
Admin flag as provided by the source. |
VARCHAR2 |
2 |
DEPARTMENT_NAME |
Department name as provided by the source. |
VARCHAR2 |
40 |
FISCAL_YEAR |
Fiscal year as provided by the source. |
VARCHAR2 |
4 |
GL_CATEGORY |
Gl category as provided by the source. |
VARCHAR2 |
50 |
PRIMARY_CUMULATIVE_AMOUNT |
Primary cumulative amount as provided by the source. |
NUMBER |
18,2 |
PRIMARY_FISCAL_YEAR_BUDGET |
Primary fiscal year budget as provided by the source. |
NUMBER |
18,2 |
PRIMARY_FYTD_AMOUNT |
Primary fytd amount as provided by the source. |
NUMBER |
18,2 |
SCHOOL_NAME |
School name as provided by the source. |
VARCHAR2 |
40 |
SECONDARY_CUMULATIVE_AMOUNT |
Secondary cumulative amount as provided by the source. |
NUMBER |
18,2 |
SECONDARY_FISCAL_YEAR_BUDGET |
Secondary fiscal year budget as provided by the source. |
NUMBER |
18,2 |
SECONDARY_FYTD_AMOUNT |
Secondary fytd amount as provided by the source. |
NUMBER |
18,2 |
SUPERVISOR_MIT_ID |
Business identifier for the supervisor mit. |
VARCHAR2 |
9 |
SUPERVISOR_NAME |
Supervisor name as provided by the source. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |