Conversion Test – May 20, 2009



Conversion Test – May 20, 2009

Pre-requisites

Set up the CTOOL for RHRCOMM, RPRAWRD, RORSAPR

Create .dat extract files and copy to correct folder

RHRCOMM – For De Anza

• Get into SQLPLUS

• Build AIDY_CODE crosswalk in CTOOL

• @rhrcomm_cvt_create – drop and create rhrcomm_cvt

• !sqlldr username/password rhrcomm_cvt.ctl

o Loaded 33 records

• Checked rhrcomm_cvt to make sure everything was loaded into the right columns correctly

• @rhrcomm_convert – N to C

o 33 pidm errors – checked CURCERR for job 8 for errors

o Had to uncheck the generated_id on CTL in the CTOOL and run convert again

• @rhrcomm_convert – E to C

o 2 pidm errors

• Check that RHRCOMM is empty – it is

• NOTE: DISABLE RT_RHRCOMM_USERACTIVIT_INSUPD trigger in Banner 8.x so activity date isn’t wiped out with today’s date – it’ll mess up the sort on RHACOMM if we don’t

• @rhrcomm_convert – C to I – loaded 31 records

• Checked RHACOMM for ID 11269807 and it looked good

• NOTE: ENABLE RT_RHRCOMM_USERACTIVIT_INSUPD trigger in Banner 8.x

• RUN Create_RORSTAT_records_for_RHRCOMM script and commit

o Created 9 rorstat records for 0809

RPRAWRD – For De Anza

• Get into SQLPLUS

• Build FUND_CODE crosswalk table in CTOOL

• @rprawrd_cvt_create – drop and create rprawrd_cvt

• !sqlldr username/password rprawrd_cvt.ctl

o Loaded 686 records

• RUN script to delete fund codes we don’t want to take to Banner

For De Anza…

delete from rprawrd_cvt

where convert_fund_code in ('85001','85003','85006','85008','85009','85011','85012','85013','85015','85016','85017','85020','85021');

For Foothill…

Use correct set of fund codes above!!

• Checked rprawrd_cvt to make sure everything was loaded into the right columns correctly

o Bringing over non paid and accepted awards – Cindy says OK

o Set up RTVFSRC, RTVFTYP, RFRBASE in Banner

• @rprawrd_convert – N to C

o 4 pidm errors

o 686 invalid activity date

o Fixed CTOOL activity date

• @rhrcomm_convert – E to C

o 4 pidm errors

• Changed CTOOL to use awst_date for all the amount dates

• Recreate rprawrd_cvt

• Reload rprawrd_cvt – 686 records

• @rprawrd_convert – N to C

o 4 pidm errors

• Add 0708 on ROAINST

• Add “ACPT” to RTVAWST

• @rprawrd_convert – C to I – loaded 682 records

• Checked RPAAWRD for ID 11227604 and it looked good but it loaded funds not in RFRBASE

• RUN Create_RORSTAT_records_for_RPRAWRD script and commit

o Created 306 rorstat records for 0708

RORSAPR – for both colleges

• Get into SQLPLUS

• Build RTVSAPR crosswalk table in CTOOL

• Set up RTVSAPR in Banner

• @rorsapr_cvt_create – drop and create rorsapr_cvt

• !sqlldr username/password rprawrd_cvt.ctl

o Loaded 54 records

• Checked rorsapr_cvt to make sure everything was loaded into the right columns correctly

• @rorsapr_convert – N to C

o 6 pidm errors

• @rprawrd_convert – C to I – loaded 48 records

• Checked RORSAPR for a couple IDs and it looked good

RPRAWRD – For De Anza

We took the rprawrd_cvt.dat and changed the year from 2008 to 2007 so we could convert into CONV the same awards for another year so we could see how multiple aid years show on the forms.

• @rprawrd_cvt_create – drop and create rprawrd_cvt

• !sqlldr username/password rprawrd_cvt.ctl

o Loaded 686 records

• RUN script to delete fund codes we don’t want to take to Banner

For De Anza…

delete from rprawrd_cvt

where convert_fund_code in ('85001','85003','85006','85008','85009','85011','85012','85013','85015','85016','85017','85020','85021');

For Foothill…

Use correct set of fund codes above!!

• @rprawrd_convert – N to C

o 6 pidm errors

• @rprawrd_convert – C to I – loaded 680 records

• RUN Create_RORSTAT_records_for_RPRAWRD script and commit

o Created rorstat records for 0607

• Checked RPAAWRD for ID 11227604 and it looked good but it loaded funds not in RFRBASE

RHAPBAW showed funds in ASC aid year order

RHIAFSH showed funds in DESC aid year order

RHRCOMM – for Foothill

• @rhrcomm_cvt_create – drop and create rhrcomm_cvt

• !sqlldr username/password rhrcomm_cvt.ctl

o Loaded 29 records

• @rhrcomm_convert – N to C

• NOTE: DISABLE RT_RHRCOMM_USERACTIVIT_INSUPD trigger in Banner 8.x so activity date isn’t wiped out with today’s date – it’ll mess up the sort on RHACOMM if we don’t

• @rhrcomm_convert – C to I – loaded 29 records

• NOTE: ENABLE RT_RHRCOMM_USERACTIVIT_INSUPD trigger in Banner 8.x

• RUN Create_RORSTAT_records_for_RHRCOMM script and commit

RPRAWRD – For Foothill

• @rprawrd_cvt_create – drop and create rprawrd_cvt

• !sqlldr username/password rprawrd_cvt.ctl

o Loaded 383 records

• RUN script to delete fund codes we don’t want to take to Banner

For De Anza…

delete from rprawrd_cvt

where convert_fund_code in ('85001','85003','85006','85008','85009','85011','85012','85013','85015','85016','85017','85020','85021');

For Foothill…

Use correct set of fund codes above!!

• @rprawrd_convert – N to C

o 5 pidm errors

• @rprawrd_convert – C to I – loaded 378 records

• RUN Create_RORSTAT_records_for_RPRAWRD script and commit

o Created rorstat records for 0708

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download