Georgia CHECS Snapshot Report Troubleshooting

Import Data Field (GPA_tier_hist_import) 

J1 Data Field (GPA_Tier_Hist) 

Notes 

OPEID_OF_REPORTING_INSTITUTION  

Not Mapped 

SSN 

Biograph_Master.ssn 

This is only used to aid in matching data, no data is imported or updated 

FNAME 

Not Mapped 

LNAME 

Not Mapped 

DOB 

Not Mapped 

ID_NUM 

ID_NUM 

Used in matching existing rows and creating new rows 

GTID 

GA_TEST_ID

HS_GRAD_DATE 

Not Mapped 

SCHOLAR_MOST_RECENT_CALC_DATE 

TIER_DTE if Configuration_tabl = 'HS' 

Convert to date/time: format will be: 

MMDDYYYY 

SCHOLAR_MOST_RECENT_TERM_WITH_GPA_DATA 

MOST_RECENT_YEAR_WITH_GPA_DATA 

MOST_RECENT_TERM_WITH_GPA_DATA if Configuration_tabl = 'HS' 

Use GPA_TERM_DEF to translate 

SCHOLAR_GPA_CALC_OF_MOST_RECENT_TERM 

MOST_RECENT_TERM_GPA if Configuration_tabl = 'HS' 

Convert from varchar(5) to numeric(4,3)  

1.234 

SCHOLAR_TOTAL_ATTEMPTED_HOURS 

TIER_ATT_HRS 

Convert from varchar(7) to numeric(6,3)  

123.456 

SCHOLAR_TOTAL_QUALITY_POINTS 

TIER_QTY_PTS if Configuration_tabl = 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

SCHOLAR_TOTAL_GPA_HOURS 

TIER_GPA_HRS if Configuration_tabl = 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

SCHOLAR_TOTAL_PAID_HOURS 

TOTAL_HRS_PAID if Configuration_tabl = 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

SCHOLAR_COMBINED_PAID_HOURS 

COMBINED_HRS_PAID 

Convert from varchar(7) to numeric(6,3)  

123.456 

SCHOLAR_CHKPNT 

(TIER_CDE,TIER_SEQ_NUM)  

if Configuration_tabl = 'HS' 

Translate using GPA_Tier_Def and populate the tier_seq_num as needed  

SCHOLAR_MOST_RECENT_CHKPNT_GPA 

TIER_GPA if Configuration_tabl = 'HS' 

Convert from varchar(5) to numeric(4,3)  

1.234 

SCHOLAR_MOST_RECENT_CHKPNT_CALC_TERM  

YR_CDE, TRM_CDE if Configuration_tabl = 'HS' 

Use GPA_TERM_DEF to translate 

HOPE_SCHOLAR_GPA_ELIGIBILITY 

ST_GPA_ELIGIBILITY_DEF_APPID TIER_ELIGIBLE if Configuration_tabl = 'HS' 

Use ST_GPA_Eligibility_Def to get the APPID and set tier_eligible as defined in the table for the selected APPID 

TIER_ELIGIBLE_CHNG 

Update the same as existing logic (if possible) 

ZELL_MILLER_SCHOLAR_GPA_ELIGIBILITY 

Do not map. 

Use ST_GPA_Eligibility_Def to get the APPID and set tier_eligible as defined in the table for the selected APPID 

GRANT_MOST_RECENT_CALC_DATE 

TIER_DTE if Configuration_tabl <> 'HS' 

Convert to date/time: format will be: 

MMDDYYYY 

GRANT_MOST_RECENT_TERM_WITH_GPA_DATA 

MOST_RECENT_YEAR_WITH_GPA_DATA 

MOST_RECENT_TERM_WITH_GPA_DATA if Configuration_tabl <> 'HS' 

Use GPA_TERM_DEF to translate 

GRANT_GPA_CALC_OF_MOST_RECENT_TERM 

MOST_RECENT_TERM_GPA if Configuration_tabl <> 'HS' 

Convert from varchar(5) to numeric(4,3)  

1.234 

GRANT_TOTAL_QUALITY_POINTS 

TIER_QTY_PTS if Configuration_tabl <> 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

GRANT_TOTAL_GPA_HOURS 

TIER_GPA_HRS if Configuration_tabl <> 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

GRANT_TOTAL_PAID_HOURS 

TOTAL_HRS_PAID if Configuration_tabl <> 'HS' 

Convert from varchar(7) to numeric(6,3)  

123.456 

HOPE_GRANT_CHECKPOINT 

(TIER_CDE,TIER_SEQ_NUM)  

if Configuration_tabl = 'HG' 

Translate using GPA_Tier_Def and populate the tier_seq_num as needed 

HOPE_GRANT_MOST_RECENT_CHKPNT_GPA 

TIER_GPA if Configuration_tabl = 'HG' 

Convert from varchar(5) to numeric(4,3)  

1.234 

HOPE_GRANT_MOST_RECENT_CHKPNT_CALC_TERM 

YR_CDE, TRM_CDE if Configuration_tabl = 'HG' 

Use GPA_TERM_DEF to translate 

HOPE_GRANT_GPA_ELIGIBILITY 

ST_GPA_ELIGILILITY_DEF_APPID TIER_ELIGIBLE if Configuration_tabl = 'HG' 

Use ST_GPA_Eligibility_Def to get the APPID and set tier_eligible as defined in the table for the selected APPID 

ZELL_MILLER_CHECKPOINT 

(TIER_CDE,TIER_SEQ_NUM)  

if Configuration_tabl = 'ZM' 

Translate using GPA_Tier_Def and populate the tier_seq_num as needed 

ZELL_MILLER_MOST_RECENT_CHKPNT_GPA 

TIER_GPA if Configuration_tabl = 'ZM' 

Convert from varchar(5) to numeric(4,3)  

1.234 

ZELL_MILLER_MOST_RECENT_CHKPNT_CALC_TERM 

YR_CDE, TRM_CDE if Configuration_tabl = 'ZM' 

Use GPA_TERM_DEF to translate 

ZELL_MILLER_GPA_ELIGIBILITY 

ST_GPA_ELIGIBILITY_DEF_APPID TIER_ELIGIBLE if Configuration_tabl = 'ZM' 

Use ST_GPA_Eligibility_Def to get the APPID and set tier_eligible as defined in the table for the selected APPID 

TIER_ERN_HRS 

Not updated set to 0.00 

SCHOLARSHIP_EXPIRATION

MMDDCCYY

INITIAL_ELIGIBILITY_HOPE_SCHOLARSHIP

IHI = Initial HOPE Ineligible

IHE = Initial HOPE Eligible

INITIAL_ELIGIBILITY_ZELL_MILLER_SCHOLARSHIP

IZE = Initial Zell Miller Eligible

NEE = Zell Miller Scholarship Ineligible

INITIAL_ELIGIBILITY_HOPE_ZELL_MILLER_SCHOLARSHIP

MMDDCCYY