BB RESEARCH VOLUME DETAIL Table
View exposing detailed research volume measures by fiscal year, supervisor, general ledger category, and cost collector including primary and secondary budget and actual measures used for research budget and performance reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_FLAG |
Admin flag as provided by the source. |
VARCHAR2 |
2 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_OBJECT_DEPARTMENT_NAME |
Cost object department name as provided by the source. |
VARCHAR2 |
40 |
COST_OBJECT_SCHOOL_NAME |
Cost object school name as provided by the source. |
VARCHAR2 |
40 |
DEPARTMENT_NAME |
Department name as provided by the source. |
VARCHAR2 |
40 |
FISCAL_YEAR |
Fiscal year as provided by the source. |
VARCHAR2 |
4 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
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 |