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

program dimension

(PLT_DIM_PROGRAM) No description available.

general ledger star schemas

monthly balances

operating ledger star schemas

monthly snapshots
actual transactions
budget transactions
commitment transactions


individual column descriptions (PLT_DIM_PROGRAM)

Column Name Column Description
Program Key Primary key uniquely identifying each row in the program dimension.
Program 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).
Program 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).
Program Level 1 The highest level (level 1) of the summarization of program codes as they correspond to the Rensselaer Plan.
Program Level 1 Description The description of the highest level (level 1) program code.
Program Level 2 Level 2 of the summarization of program codes as they correspond to the Rensselaer Plan.
Program Level 2 Description The description of the level 2 program code.
Program Level 3 Level 3 of the summarization of program codes as they correspond to the Rensselaer Plan.
Program Level 3 Description The description of the level 3 program code.
Program Termination Date For terminated program codes, the date the program code became invalid.
Program Status The current status (e.g. Active, Inactive, etc.) of the program code.
EOY Begin Date The beginning date of the program hierarchy for the fiscal year (for the year end the activity was changed).
EOY End Date The ending date of the program hierarchy for the fiscal year (for the year end the activity was changed).
EOY Program Level 1 The highest level (level 1) of the summarization of program codes as they correspond to the Rensselaer Plan, for each fiscal year in which the program hierarchy changes.
EOY Program Level 1 Description The description of the highest level (level 1) program code, for each fiscal year in which the program hierarchy changes.
EOY Program Level 2 Level 2 of the summarization of program codes as they correspond to the Rensselaer Plan, for each fiscal year in which the program hierarchy changes.
EOY Program Level 2 Description The description of the level 2 program code, for each fiscal year in which the program hierarchy changes.
EOY Program Level 3 Level 3 of the summarization of program codes as they correspond to the Rensselaer Plan, for each fiscal year in which the program hierarchy changes.
EOY Program Level 3 Description The description of the level 3 program code, for each fiscal year in which the program hierarchy changes.
EOY Program Termination Date For terminated program codes, the date the program code became invalid, for each fiscal year in which the program hierarchy changes.
EOY Program Status The current status (e.g. Active, Inactive, etc.) of the program code, for each fiscal year in which the program hierarchy changes.
Commitment Area No description available.
EOY Commitment Area No description available.