One Purdue

Finance Crosswalks

Legend for Crosswalk
C = CSV file DE1 = Development Instance
E = Excel file QM1 = Quality Assurance / Testing Instance
T = fixed-length text file PE1 = Production Instance
Type Crosswalk
Object Code to GL Account
Instructions for downloading text file.
    T MQ1 700
    T PE1 100 Actual OnePurdue Finance Working Evironment
Fund/Department/Project to Fund/Cost Object (Cost Center, Fund Center, Internal Order, WBS Element) from Legacy Data
Instructions for downloading text file.
    T QM1 700
    T PE1 100 Actual OnePurdue Finance Working Evironment
OnePurdue External Billing (PSCD) Supplemental Crosswalk
  E   DE1 530 (Last updated 9/20/06, 7:40 a.m.)
      QM1 700
      PE1 100
DREF to Statistical Internal Order (AG, VET and CFS only)
Instructions for downloading text file.
    T QM1 700
    T PE1 100 Actual OnePurdue Finance Working Evironment

 

 

HR Crosswalks

Note: Production data began changing daily January 22, 2007, for these crosswalk tables. Therefore, pay particular attention to the “Last updated ...” date of the HR crosswalks to make sure you are viewing or downloading the most current versions.

Legend for Crosswalk
C = CSV file DE1 = Development Instance
E = Excel file QM1 = Quality Assurance / Testing Instance
T = fixed-length text file PE1 = Production Instance
Type Crosswalk
OnePurdue Job vs. Legacy Position Code
  E   PE1 100 Actual OnePurdue HR Working Environment

Note: This crosswalk will not be kept up to date after the Banner systems have been fully implemented.

OnePurdue Organizational Unit vs. Legacy Department Codes
C E T PE1 100 Actual OnePurdue HR Working Environment (Last updated 10/16/07, 8:30 p.m.)
OnePurdue Release 1 Production-Valid Time Administrator Codes
  E   PE1 100 (Last updated 3/21/07)
DREF to Statistical Internal Order (AG, VET and CFS only)
Instructions for downloading text file.
  E   PE1 100 (Last updated 6/4/07)

 

 

 

Purdue University, West Lafayette, IN 47907 USA, (765) 494-4600
© 2008 Purdue University. An equal access/equal opportunity university.
If you have trouble accessing this page because of a disability, please contact ITaP at itap@purdue.edu

PDF files can be viewed in Adobe Acrobat Reader.