PROGRAM_CODES_HISTORY Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

PROGRAM_CODES_HISTORY Table

Explanation
Contains historical information on programs, which are activities or work processes commonly defined across the University. Programs track an activity across schools and centers (or across organizations within a school or center). Program data available includes short and long descriptions of the program, the Facilities and Real Estate Services building code (if the program is a building), and information specific to programs that are capital projects.

Common Uses
Tracking historical changes in program code records.

PROGRAM_CODES

LAST_UPDATE_DATE

CAPITAL_PROJECT_YEAR
CERTIFIED_PROJECT_START_DATE
CHAMPS_PROJECT_ID
LAST_UPDATE_DATE
PLANNED_PROJECT_START_DATE
PROGRAM_CODE
PROJECT_DFD_NUMBER
RELATED_PROGRAM_CODE
SCHOOL_CENTER
SPACE_BUILDING_CODE

BALANCES

FUND_CODES

GL_FULL_OLD_TO_NEW

GL_PART_OLD_TO_NEW

ORG_OLD_TO_NEW

PARENT_PROGRAM_CODES

PROGRAM_CODES_HISTORY

SUMMARY_BALANCES

Cautions

• This table contains historical information for a program. To view the current record a program, use the PROGRAM_CODES table.
• There may be multiple rows for a given fund, as this table stores a snapshot of the program record as it appeared at the time of the extract to the Warehouse. Note that the table stores only the latest value of program attributes -- it does not represent changes over the course of one day. Therefore, the LAST_UPDATED_BY column displays only the last user to update the program record in the day. To sort all rows in chronological order, be sure to use a date format that includes time specification.
• When decoding a PROGRAM_CODE, decide whether you want the 60-character PROGRAM_DESC, or the 70-character PROGRAM_LONG_DESC.

PROGRAM_CODES_HISTORY Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home