Rensselaer global navigation
Rensselaer Polytechnic Institute RPInfo Search RPI Contact RPI Campus Directories Depts/Offices with web sites Degree Programs, Academic Schools

Rensselaer Data Warehouse Project

account dimension

(PLS_DIM_ACCOUNT) No description available.

general ledger star schemas

monthly balances

operating ledger star schemas

monthly snapshots
actual transactions
budget transactions
commitment transactions


individual column descriptions (PLS_DIM_ACCOUNT)

Column Name Column Description
Account Key Primary key uniquely identifying each row in the account dimension.
Account 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).
Account Chart of Account Description The description corresponding to the chart of accounts for a particular reporting entity within Rensselaer (e.g. Rensselaer at Hartford, Rensselaer at Troy).
Account Type Level 1 The highest level (level 1) of the summarization of accounts for budgeting, reporting and analytical purposes.
Account Type Level 1 Description The description of the highest level (level 1) of the summarization of accounts for budgeting, reporting and analytical purposes.
Account Type Level 2 Level 2 of the summarization of accounts for budgeting, reporting and analytical purposes.
Account Type Level 2 Description The description of level 2 of the summarization of accounts for budgeting, reporting and analytical purposes.
Account Level 1 The highest level (level 1) of account codes used for departmental budget activity, reporting and analysis.
Account Level 1 Description The description of the highest level (level 1) of account codes used for departmental budget activity, reporting and analysis.
Account Level 2 Level 2 of account codes used for departmental budget activity, reporting and analysis.
Account Level 2 Description The description of level 2 of account codes used for departmental budget activity, reporting and analysis.
Account Level 3 of account codes used for departmental budget activity, reporting and analysis.
Account Description The description of level 3 of account codes used for departmental budget activity, reporting and analysis.
Account Status The current status (e.g. Active, Inactive, etc.) of the account.
Account Line Category No description available.
Account Line Subcategory No description available.
EOY Account Begin Date The beginning date of the account hierarchy (for each fiscal year in which the account hierarchy changes).
EOY Account End Date The ending date of the account hierarchy (for each fiscal year in which the account hierarchy changes).
EOY Account Type Level 1 The highest level (level 1) of the summarization of accounts for budgeting, reporting and analytical purposes, for each fiscal year in which the account hierarchy changes.
EOY Account Type Level 1 Description The description of the highest level (level 1) of the summarization of accounts for budgeting, reporting and analytical purposes, for each fiscal year in which the account hierarchy changes.
EOY Account Type Level 2 Level 2 of the summarization of accounts for budgeting, reporting and analytical purposes, for each fiscal year in which the account hierarchy changes.
EOY Account Type Level 2 Description The description of level 2 of the summarization of accounts for budgeting, reporting and analytical purposes, for each fiscal year in which the account hierarchy changes.
EOY Account Level 1 The highest level (level 1) of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Level 1 Description The description of the highest level (level 1) of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Level 2 Level 2 of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Level 2 Description The description of level 2 of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Level 3 of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Description The description of level 3 of account codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the account hierarchy changes.
EOY Account Line Category No description available.
EOY Account Line Subcategory No description available.
EOY Account Termination Date For terminated accounts, the date the account became invalid, for each fiscal year in which the account hierarchy changes.
EOY Account Status The current status (e.g. Active, Inactive, etc.) of the account, for each fiscal year in which the account hierarchy changes.