End-of-Year Process for Grades and Transcripts

This table lists the impact of grades and transcript rollover data for the End-of-year process.

Resource Name	Table Name	Column Name	DEX Element/Selection Rule	Impacted by EOY	Date/School Year Based Filters	Impact with parallel multiple School Years	Comments
TRANSCRIPT_CopyStoredGrades	STOREDGRADES	SECTIONID	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
TRANSCRIPT_CopyStoredGrades	STOREDGRADES	STUDENTID	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
TRANSCRIPT_StoredGrades	STUDENTS	SSN	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
TRANSCRIPT_StoredGrades	STUDENTS	STATE_STUDENTNUMBER	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
TRANSCRIPT_StoredGrades	STUDENTS	GRADE_LEVEL	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
TRANSCRIPT_StoredGrades	TERMS	ABBREVIATION		Yes	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SEC_X	EXPLANATION_CODE_COMBINED		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_CRS_X	COURSESDCID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_CRS_X	EXPLANATION_CODE_COMBINED		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SERVICE_ID_S	YEARID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SERVICE_ID_S	ELIG_FOR_HS		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SERVICE_ID_S	SERVICE_ID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SGR_X	STOREDGRADESDCID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_SGR_X	E0949_PF_CALC		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_TRM_C	TERMSDCID		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_TRM_C	FINAL_GRADE		No	Yes	No Impact
TRANSCRIPT_StoredGrades	S_TX_TRM_C	AAR_GRADECOLUMN_MAPPING		No	Yes	No Impact
TRANSCRIPT_StoredGrades	STOREDGRADES	DATESTORED		No	Yes	No Impact
TRANSCRIPT_StoredGrades	STOREDGRADES	POTENTIALCRHRS		No	Yes	No Impact
TRANSCRIPT_StoredGrades	STOREDGRADES	EARNEDCRHRS		No	Yes	No Impact
TRANSCRIPT_StoredGrades	STOREDGRADES	GRADE_LEVEL		No	Yes	No Impact
studentAcademicRecords	STUDENTS	STATE_STUDENTNUMBER	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
studentAcademicRecords	STUDENTS	GRADE_LEVEL	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	STUDENTSDCID		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	PERFORMANCE_INDICATOR		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	STATUS_DATE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	E1655_IBC_VENDOR_CODE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	INDICATOR_CODE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	E1733_IBC_CERT_RESULT		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	STUDENTSDCID		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E0791		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E0806		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	FIN_AID_APP_CODE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1736_TXFIRSTEARLYHS		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E3089_DIST_LEVEL_ACH_GRAD		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1562		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1589_MILITARY_ENLISTMENT		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1596_ASSOCIATE_DEGREE_IND		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1542_FHSP_DIST		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1541_FHSP_PART		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1563		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	STUDENTSDCID		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1541_FHSP_PART		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1544_STEM_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1545_BI_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1546_PS_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1547_AH_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1548_MS_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1544_STEM_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1545_BI_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1546_PS_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1547_AH_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_X	E1548_MS_END		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	STUDENTSDCID		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	PERFORMANCE_INDICATOR		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	STATUS_DATE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	E1655_IBC_VENDOR_CODE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	INDICATOR_CODE		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	E1733_IBC_CERT_RESULT		No	Yes	No Impact
studentAcademicRecords	S_TX_STU_PERF_ACKN_C	E1654_IBC_EXAM_FEE_AMT		No	Yes	No Impact
courseTranscripts	COURSES	crCOURSE_NUMBER		No	Yes	No Impact
courseTranscripts	SECTIONS	ID		No	Yes	No Impact
courseTranscripts	SECTIONS	SECTION_NUMBER		No	Yes	No Impact
courseTranscripts	SCHOOLSTAFF	ID		No	Yes	No Impact
courseTranscripts	USERS	LAST_NAME		No	Yes	No Impact
courseTranscripts	USERS	FIRST_NAME		No	Yes	No Impact
courseTranscripts	COURSESCOREFIELDS	COURSESDCID		No	Yes	No Impact
courseTranscripts	COURSESCOREFIELDS	ALT_COURSE_NUMBER		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	STOREDGRADESDCID		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	ATC_INDICATOR_CODE		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	COLLEGE_CREDIT_HOURS		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	DUAL_CREDIT		No	Yes	No Impact
courseTranscripts	S_TX_SGR_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
courseTranscripts	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
courseTranscripts	S_TX_SEC_X	E1058_ATC_INDICATOR		No	Yes	No Impact
courseTranscripts	S_TX_SEC_X	E1081_COLLEGE_CREDIT		No	Yes	No Impact
courseTranscripts	S_TX_SEC_X	E1011_DUAL_CREDIT		No	Yes	No Impact
courseTranscripts	S_TX_SEC_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
courseTranscripts	S_TX_CRS_X	COURSESDCID		No	Yes	No Impact
courseTranscripts	S_TX_CRS_X	E1058_ATC_INDICATOR		No	Yes	No Impact
courseTranscripts	S_TX_CRS_X	E1081		No	Yes	No Impact
courseTranscripts	S_TX_CRS_X	E1011_DUAL_CREDIT		No	Yes	No Impact
grades	SECTIONS	sec.TERMID		No	Yes	No Impact
grades	SECTIONS	sec.SCHOOLID		No	Yes	No Impact
grades	SECTIONS	sec.EXCLUDE_STATE_RPT_YN		No	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	STOREDGRADES	SECTIONID		No	Yes	No Impact
grades	STOREDGRADES	TERMID		No	Yes	No Impact
grades	TERMBINS	TERMID		Yes	Yes	No Impact
grades	TERMBINS	SCHOOLID		Yes	Yes	No Impact
grades	TERMBINS	DCID		Yes	Yes	No Impact
grades	TERMBINS	STORECODE		Yes	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	TERMS	PORTION		Yes	Yes	No Impact
grades	TERMS	ABBREVIATION		Yes	Yes	No Impact
grades	S_TRB_X	TERMBINSDCID		Yes	Yes	No Impact
grades	SECTIONS	TERMID		No	Yes	No Impact
grades	SECTIONS	SCHOOLID		No	Yes	No Impact
grades	SECTIONS	EXCLUDE_STATE_RPT_YN		No	Yes	No Impact
grades	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
grades	S_TX_SEC_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	S_TX_SEC_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
grades	COURSES	COURSE_NUMBER		No	Yes	No Impact
grades	COURSES	SCHED_DO_NOT_PRINT		No	Yes	No Impact
grades	S_TX_CRS_X	COURSESDCID		No	Yes	No Impact
grades	S_TX_CRS_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	COURSESCOREFIELDS	COURSESDCID		No	Yes	No Impact
grades	COURSESCOREFIELDS	ALT_COURSE_NUMBER		No	Yes	No Impact
grades	STUDENTS	STATE_EXCLUDEFROMREPORTING	selection rule	Yes	Yes	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	TERMS	ABBREVIATION		Yes	Yes	No Impact
grades	CC	STUDENTID		No	Yes	No Impact
grades	CC	SECTIONID		No	Yes	No Impact
grades	CC	SCHOOLID		No	Yes	No Impact
grades	CC	DATELEFT		No	Yes	No Impact
grades	CC	DATEENROLLED		No	Yes	No Impact
grades	S_STU_X	EXCLUDEFROMEDFI	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	S_TX_STU_STATE_GEN_C	STUDENTSDCID		No	Yes	No Impact
grades	S_TX_STU_STATE_GEN_C	E0787_ADA_CODE		No	Yes	No Impact
grades	S_TX_STU_STATE_GEN_C	ENTER_DATE		No	Yes	No Impact
grades	CALENDAR_DAY	cd.SCHOOLID		No	Yes	No Impact
grades	CALENDAR_DAY	cd.DATE_VALUE		No	Yes	No Impact
grades	CALENDAR_DAY	cd.INSESSION		No	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	ABBREVIATION		Yes	Yes	No Impact
grades	TERMS	PORTION		Yes	Yes	No Impact
grades	SECTIONS	TERMID		No	Yes	No Impact
grades	SECTIONS	SCHOOLID		No	Yes	No Impact
grades	SECTIONS	EXCLUDE_STATE_RPT_YN		No	Yes	No Impact
grades	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
grades	S_TX_SEC_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	S_TX_SEC_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
grades	COURSES	COURSE_NUMBER		No	Yes	No Impact
grades	COURSES	SCHED_DO_NOT_PRINT		No	Yes	No Impact
grades	S_TX_CRS_X	COURSESDCID		No	Yes	No Impact
grades	S_TX_CRS_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	COURSESCOREFIELDS	COURSESDCID		No	Yes	No Impact
grades	COURSESCOREFIELDS	ALT_COURSE_NUMBER		No	Yes	No Impact
grades	PGFINALGRADES	SECTIONID		No	Yes	No Impact
grades	STUDENTS	STATE_EXCLUDEFROMREPORTING	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	PGFINALGRADES	STUDENTID		No	Yes	No Impact
grades	PGFINALGRADES	GRADE		No	Yes	No Impact
grades	PGFINALGRADES	[PERCENT]		No	Yes	No Impact
grades	PGFINALGRADES	FINALGRADENAME		No	Yes	No Impact
grades	PGFINALGRADES	LASTGRADEUPDATE		No	Yes	No Impact
grades	PGFINALGRADES	DCID		No	Yes	No Impact
grades	PGFINALGRADES	COMMENT_VALUE		No	Yes	No Impact
grades	PGFINALGRADES	STUDENTID		No	Yes	No Impact
grades	PGFINALGRADES	SECTIONID		No	Yes	No Impact
grades	PGFINALGRADES	FINALGRADENAME		No	Yes	No Impact
grades	PGFINALGRADES	LASTGRADEUPDATE		No	Yes	No Impact
grades	PGFINALGRADES	DCID		No	Yes	No Impact
grades	SCHOOLS	SCHOOL_NUMBER		No	Yes	No Impact
grades	SCHOOLS	DCID		No	Yes	No Impact
grades	STANDARDGRADESECTION	SCHOOLSDCID		No	Yes	No Impact
grades	STANDARDGRADESECTION	YEARID		No	Yes	No Impact
grades	STANDARDGRADESECTION	STANDARDPERCENT		No	Yes	No Impact
grades	STANDARDGRADESECTION	STANDARDGRADE		No	Yes	No Impact
grades	STANDARDGRADESECTION	STUDENTSDCID		No	Yes	No Impact
grades	STANDARDGRADESECTION	SECTIONSDCID		No	Yes	No Impact
grades	STANDARDGRADESECTION	STORECODE		No	Yes	No Impact
grades	STANDARDGRADESECTION	LASTUPDATED		No	Yes	No Impact
grades	STANDARDGRADESECTION	STANDARDGRADESECTIONID		No	Yes	No Impact
grades	STUDENTS	STATE_EXCLUDEFROMREPORTING	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	STUDENTS	SSN	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	STUDENTS	STATE_STUDENTNUMBER	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	SECTIONS	DCID		No	Yes	No Impact
grades	SECTIONS	EXCLUDE_STATE_RPT_YN		No	Yes	No Impact
grades	TERMS	ID		Yes	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
grades	S_TX_SEC_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	S_TX_SEC_X	E1056_SECTIONIDEN_CALC		No	Yes	No Impact
grades	COURSES	COURSE_NUMBER		No	Yes	No Impact
grades	COURSES	SCHED_DO_NOT_PRINT		No	Yes	No Impact
grades	S_TX_CRS_X	COURSESDCID		No	Yes	No Impact
grades	S_TX_CRS_X	EXCLUDE_FROM_090		No	Yes	No Impact
grades	COURSESCOREFIELDS	COURSESDCID		No	Yes	No Impact
grades	COURSESCOREFIELDS	ALT_COURSE_NUMBER		No	Yes	No Impact
grades	SECTIONS	DCID		No	Yes	No Impact
grades	SECTIONS	TERMID		No	Yes	No Impact
grades	TERMS	ID		Yes	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	CC	SECTIONID		No	Yes	No Impact
grades	CC	STUDENTID		No	Yes	No Impact
grades	S_STU_X	EXCLUDEFROMEDFI	selection rule	No	No	Impacted	Student Identifying Information if modified after rollover, will impact the previous year submission as well
grades	S_TX_STU_STATE_GEN_C	STUDENTSDCID		No	Yes	No Impact
grades	S_TX_STU_STATE_GEN_C	E0787_ADA_CODE		No	Yes	No Impact
grades	S_TX_STU_STATE_GEN_C	ENTER_DATE		No	Yes	No Impact
grades	CALENDAR_DAY	SCHOOLID		No	Yes	No Impact
grades	CALENDAR_DAY	DATE_VALUE		No	Yes	No Impact
grades	CALENDAR_DAY	INSESSION		No	Yes	No Impact
grades	TERMS	YEARID		Yes	Yes	No Impact
grades	TERMS	SCHOOLID		Yes	Yes	No Impact
grades	TERMS	ABBREVIATION		Yes	Yes	No Impact
grades	TERMS	PORTION		Yes	Yes	No Impact
grades	SECTIONS	DCID		No	Yes	No Impact
grades	S_TX_SEC_X	SECTIONSDCID		No	Yes	No Impact
grades	COURSES	COURSE_NUMBER		No	Yes	No Impact
grades	TERMS	DCID		Yes	Yes	No Impact
grades	TERMS	DCID		Yes	Yes	No Impact