RESEARCH CC ASSIGNMENT Table
Stores assignments linking research cost collectors to fiscal years, assignment types, master projects, and organizational/research department context. Each row represents a cost-collector assignment used to attribute research financial activity to departments and organizations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSIGNMENT_TYPE |
Type of assignment describing how the cost collector is associated with research activity (as defined by source). |
VARCHAR2 |
20 |
COST_COLLECTOR_FY_KEY |
Composite or surrogate key identifying the cost collector for a specific fiscal year. |
VARCHAR2 |
48 |
COST_COLLECTOR_KEY |
Identifier for the cost collector independent of fiscal year. |
VARCHAR2 |
48 |
FISCAL_YEAR |
Four-digit fiscal year associated with the cost collector assignment. |
VARCHAR2 |
4 |
MASTER_PROJECT_NUMBER |
Master project number associated with the research cost collector (as defined by source). |
VARCHAR2 |
28 |
ORGANIZATION_KEY |
Identifier for the organization associated with the research cost collector assignment. |
VARCHAR2 |
10 |
ORGANIZATION_NAME |
Name of the organization associated with the research cost collector assignment. |
VARCHAR2 |
40 |
RESEARCH_VOLUME_DEPT_KEY |
Identifier for the research volume department associated with the assignment. |
VARCHAR2 |
10 |
RESEARCH_VOLUME_DEPT_NAME |
Name of the research volume department associated with the assignment. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |