Crosswalks

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)

Name
Email address
Comments