organization history dimension
(OLM_DIM_ORGANIZATION_HISTORY) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (OLM_DIM_ORGANIZATION_HISTORY)
| Column Name | Column Description |
|---|---|
| Organization History Key | Primary key uniquely identifying each row in the organization history dimension. This dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| Organization Key | Foreign key used to recast fact records into a historical organizational hierarchy. This dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Chart of Accounts | A code representing the individual chart of accounts for a particular reporting entity within Rensselaer (i.e. 9 = Troy Chart of Accounts; H = Hartford Chart of Accounts). The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Chart of Accounts Description | The description corresponding to the chart of accounts for a particular reporting entity within Rensselaer (e.g. Rensselaer at Hartford, Rensselaer at Troy). The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Portfolio | The 1st level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Portfolio Description | The description corresponding to the portfolio code (e.g. Administration, School of Engineering, Human Resources, etc.). The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Portfolio Financial Manager | The name of the financial manager responsible for the portfolio. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Department | The 2nd level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Department Description | The description corresponding to the department code (e.g. Campus Facilities and Facilities Design, Chemical Engineering, General Benefits Administration, etc.). The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Department Financial Manager | The name of the financial manager responsible for the department. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Unit | The 3rd level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Unit Description | The description corresponding to the unit code. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Unit Financial Manager | The name of the financial manager responsible for the unit. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Section | The 4th level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Section Description | The description corresponding to the section code. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Section Financial Manager | The name of the financial manager responsible for the section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization | The 5th level in the organizational hierarchy of academic or administrative entities within the Institute, representing an area of financial responsibility within an organizational section. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization Description | The description corresponding to the sub-section code. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization Financial Manager | The name of the financial manager responsible for the sub-section. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization Status | The historical status (e.g. Active, Inactive, Terminated, Retired, etc.) of the organization at the lowest (data-entry) level of the hierarchy. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization Termination Date | The termination date of the organization at the lowest (data-entry) level of the hierarchy. The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
| History - Organization Begin Date | The date on which the given organizational hierarchy was effective. |
| History - Organization End Date | The date on which the given organizational hierarchy was no longer effective. |
| History - Organization Type | The type of entity that the organization corresponds to (e.g. Academic School, Administrative, Center, etc.). The Organization History dimension records the organizational hierarchy for a given point in time (as defined by the History Organization Begin Date and History Organization End Date columns). |
