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

activity dimension

(PLH_DIM_ACTIVITY) No description available.

general ledger star schemas

monthly balances

operating ledger star schemas

monthly snapshots
actual transactions
budget transactions
commitment transactions


individual column descriptions (PLH_DIM_ACTIVITY)

Column Name Column Description
Activity Key Primary key uniquely identifying each row in the activity dimension.
Activity 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).
Activity 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).
Activity A code that associates dollar amounts of individual transactions to Rensselaer Plan goals.
Activity Description A description corresponding to an activity code, which associates dollar amounts of individual transactions to Rensselaer Plan goals.
Activity Termination Date If present, the date on which the activity code became invalid.
Activity Status The current status (e.g. Active, Inactive, etc.) of the activity code.
Institute Priority No description available.