SAD_BR_VAUX_NLD(SQL View) |
Index Back |
|---|
| SELECT DISTINCT GRD.EMPLID ,%Substring(CAST(%Dateout(TRM.TERM_END_DT) as CHAR(10)),1,4) AS ACAD_YEAR ,%Substring(HGCD.SCC_LOB_CODE_NLD, 1, 4) AS SAD_BR_EX_CRSE_NLD ,CASE WHEN (GRD.CRSE_GRADE_OFF = 'VR' AND TSTCAT.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT.SSR_TST_EXAMTP_NLD = 'E') THEN 'V' ELSE CASE WHEN (GRD.SSR_GRD_ATTR_NLD = 'E') THEN 'I' ELSE CASE WHEN (GRD.SSR_GRD_ATTR_NLD <> 'E') THEN 'G' END END END AS SAD_BR_APL_DPL_NLD ,CASE WHEN (GRD.SSR_GRD_NO_CAL_NLD = 'N' AND TSTCAT.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT.SSR_TST_EXAMTP_NLD = 'E') THEN 'N' ELSE 'Y' END AS SAD_BR_DPL_SBJ_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'S' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND SG1.CRSE_GRADE_OFF in ('V' ,'O' ,'G')) , ' ') AS SAD_BR_RS_SCEX_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'S' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , ' ') AS SAD_BR_GR_SCEX_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'CE1' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'C' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , ' ') AS SAD_BR_GRA_CE1_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'CE2' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'C' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , ' ') AS SAD_BR_GRA_CE2_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'CE3' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'C' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , ' ') AS SAD_BR_GRA_CE3_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'EN1' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'E' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , '') AS SAD_BR_FI_GRA1_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'EN2' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'E' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , '') AS SAD_BR_FI_GRA2_NLD ,%Coalesce( ( SELECT DISTINCT SG1.CRSE_GRADE_OFF FROM PS_SSR_STD_GRD_NLD SG1, PS_SSR_TST_SES_NLD TSTSES1, PS_SSR_TST_CAT_NLD TSTCAT_3 WHERE SG1.INSTITUTION = TSTSES1.INSTITUTION AND SG1.ACAD_CAREER = TSTSES1.ACAD_CAREER AND SG1.STRM = TSTSES1.STRM AND SG1.SESSION_CODE = TSTSES1.SESSION_CODE AND SG1.SSR_TST_ID_NLD = TSTSES1.SSR_TST_ID_NLD AND SG1.SSR_TST_DATE_NLD = TSTSES1.SSR_TST_DATE_NLD AND SG1.SSR_SECTION_NLD = TSTSES1.SSR_SECTION_NLD AND SG1.EMPLID = GRD.EMPLID AND SG1.INSTITUTION = GRD.INSTITUTION AND SG1.ACAD_CAREER = GRD.ACAD_CAREER AND SG1.STRM = GRD.STRM and TSTSES1.SSR_EXA_SES_NLD = 'EN3' and TSTCAT_3.SSR_TST_ID_NLD = SG1.SSR_TST_ID_NLD AND TSTCAT_3.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT_3.SSR_TST_EXAMTP_NLD = 'E' AND TSTCAT_3.HEGIS_CODE = TSTCAT.HEGIS_CODE AND ((SG1.SSR_GRD_ATTR_NLD = 'E' AND GRD.SSR_GRD_ATTR_NLD = 'E') OR (SG1.SSR_GRD_ATTR_NLD <> 'E' AND GRD.SSR_GRD_ATTR_NLD <> 'E')) AND SG1.CRSE_GRADE_OFF > ' ' AND SG1.SSR_GRD_NO_CAL_NLD <> 'W' AND %substring (SG1.CRSE_GRADE_OFF, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')) , '') AS SAD_BR_FI_GRA3_NLD ,CASE WHEN (TSTCAT.SSR_TST_EXAMTP_NLD <> 'E') THEN (%Sql(SAD_BR_VA_CRSE_HEGIS_SUBST_NLD, (%Sql(SAD_BR_VA_SEL_PARENTEN_NLD, TSTCAT.SSR_TST_ID_NLD, TRM.TERM_BEGIN_DT)), TRM.TERM_BEGIN_DT)) ELSE TSTCAT.HEGIS_CODE END AS HEGIS_CODE ,CASE WHEN (TSTCAT.SSR_TST_EXAMTP_NLD <> 'E') THEN (%Sql(SAD_BR_VA_SEL_PARENTEN_NLD, TSTCAT.SSR_TST_ID_NLD, TRM.TERM_BEGIN_DT)) ELSE TSTCAT.SSR_TST_ID_NLD END AS SSR_TST_ID_NLD ,GRD.GRADE_DT , CASE WHEN (TSTCAT.SSR_TST_CAT_TP_NLD = 'C' AND TSTCAT.SSR_TST_EXAMTP_NLD = 'E') THEN 'Y' ELSE 'N' END AS SAD_BR_CMP_SET_NLD , TSTCAT.SSR_TST_EXAMTP_NLD , TSTCAT.SSR_TST_CAT_TP_NLD , TRM.TERM_BEGIN_DT , TRM.TERM_END_DT , TRM.STRM FROM PS_SSR_STD_GRD_NLD GRD JOIN PS_TERM_TBL TRM ON TRM.INSTITUTION = GRD.INSTITUTION AND TRM.ACAD_CAREER = GRD.ACAD_CAREER AND TRM.STRM = GRD.STRM JOIN PS_SSR_TST_SES_NLD TSTSES ON GRD.INSTITUTION = TSTSES.INSTITUTION AND GRD.ACAD_CAREER = TSTSES.ACAD_CAREER AND GRD.STRM = TSTSES.STRM AND GRD.SESSION_CODE = TSTSES.SESSION_CODE AND GRD.SSR_TST_ID_NLD = TSTSES.SSR_TST_ID_NLD AND GRD.SSR_TST_DATE_NLD = TSTSES.SSR_TST_DATE_NLD AND GRD.SSR_SECTION_NLD = TSTSES.SSR_SECTION_NLD JOIN PS_SSR_TST_CAT_NLD TSTCAT ON GRD.SSR_TST_ID_NLD = TSTCAT.SSR_TST_ID_NLD AND TSTCAT.EFFDT = ( SELECT MAX(TSTCAT_1.EFFDT) FROM PS_SSR_TST_CAT_NLD TSTCAT_1 WHERE TSTCAT_1.SSR_TST_ID_NLD = TSTCAT.SSR_TST_ID_NLD AND TSTCAT_1.EFFDT <= TRM.TERM_BEGIN_DT) JOIN PS_SSR_HEGISCD_NLD HGCD ON TSTCAT.HEGIS_CODE = HGCD.HEGIS_CODE AND HGCD.EFFDT = ( SELECT MAX(HGCD1.EFFDT) FROM PS_SSR_HEGISCD_NLD HGCD1 WHERE HGCD1.HEGIS_CODE = HGCD.HEGIS_CODE AND HGCD1.EFFDT <= TRM.TERM_BEGIN_DT) WHERE TSTCAT.EFF_STATUS = 'A' AND GRD.SSR_GRD_NO_CAL_NLD <> 'W' AND GRD.CRSE_GRADE_OFF > ' ' AND TSTCAT.SSR_TST_EXAMTP_NLD IN ('S' ,'C' ,'E') AND TSTCAT.SAD_BR_PAPER_NLD = 'N' AND ((TSTCAT.SSR_TST_EXAMTP_NLD = 'E') OR (TSTCAT.SSR_TST_EXAMTP_NLD = 'S' AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_TST_CAT_NLD TSTCAT_2 WHERE TSTCAT_2.SSR_TST_ID_NLD IN ( SELECT DISTINCT SG.SSR_TST_ID_NLD FROM PS_SSR_STD_GRD_NLD SG WHERE SG.EMPLID = GRD.EMPLID AND SG.INSTITUTION = GRD.INSTITUTION AND SG.ACAD_CAREER = GRD.ACAD_CAREER AND SG.STRM = GRD.STRM AND SG.CRSE_GRADE_OFF > ' ' AND SG.SSR_GRD_NO_CAL_NLD <> 'W' ) AND TSTCAT_2.HEGIS_CODE = HGCD.HEGIS_CODE AND TSTCAT_2.SSR_TST_EXAMTP_NLD = 'E')) OR (TSTCAT.SSR_TST_EXAMTP_NLD = 'C' AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_TST_CAT_NLD TSTCAT_4 WHERE TSTCAT_4.SSR_TST_ID_NLD IN ( SELECT DISTINCT SG2.SSR_TST_ID_NLD FROM PS_SSR_STD_GRD_NLD SG2 WHERE SG2.EMPLID = GRD.EMPLID AND SG2.INSTITUTION = GRD.INSTITUTION AND SG2.ACAD_CAREER = GRD.ACAD_CAREER AND SG2.STRM = GRD.STRM AND SG2.CRSE_GRADE_OFF > ' ' AND SG2.SSR_GRD_NO_CAL_NLD <> 'W' ) AND TSTCAT_4.HEGIS_CODE = HGCD.HEGIS_CODE AND TSTCAT_4.SSR_TST_EXAMTP_NLD IN ('E', 'S') ))) AND ((NOT EXISTS( SELECT 'X' FROM PS_SSR_STD_GRD_NLD SG5 WHERE GRD.INSTITUTION = SG5.INSTITUTION AND GRD.ACAD_CAREER = SG5.ACAD_CAREER AND GRD.STRM = SG5.STRM AND GRD.SESSION_CODE = SG5.SESSION_CODE AND GRD.SSR_TST_ID_NLD = SG5.SSR_TST_ID_NLD AND GRD.SSR_SECTION_NLD = SG5.SSR_SECTION_NLD AND GRD.SSR_GRD_ATTR_NLD = SG5.SSR_GRD_ATTR_NLD AND SG5.SSR_GRD_NO_CAL_NLD = 'N' ) ) OR (GRD.SSR_TST_DATE_NLD = ( SELECT MAX(SSR_TST_DATE_NLD) FROM PS_SSR_STD_GRD_NLD SG5 WHERE GRD.INSTITUTION = SG5.INSTITUTION AND GRD.ACAD_CAREER = SG5.ACAD_CAREER AND GRD.STRM = SG5.STRM AND GRD.SESSION_CODE = SG5.SESSION_CODE AND GRD.SSR_TST_ID_NLD = SG5.SSR_TST_ID_NLD AND GRD.SSR_SECTION_NLD = SG5.SSR_SECTION_NLD AND GRD.SSR_GRD_ATTR_NLD = SG5.SSR_GRD_ATTR_NLD AND SG5.SSR_GRD_NO_CAL_NLD = 'N'))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ACAD_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
| 3 | SAD_BR_EX_CRSE_NLD |
Character(4) | VARCHAR2(4) NOT NULL | Exam Subject |
| 4 | SAD_BR_APL_DPL_NLD |
Character(1) | VARCHAR2(1) NOT NULL |
Appl. result exam subject
D=Dispensation G=In exam Year I=Exchanged for Diploma V=Passed without Grade |
| 5 | SAD_BR_DPL_SBJ_NLD | Character(1) | VARCHAR2(1) NOT NULL | Diploma Subject |
| 6 | SAD_BR_RS_SCEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Result Schoolexam
G=Good O=Insufficient V=Adequate |
| 7 | SAD_BR_GR_SCEX_NLD | Number(3,0) | SMALLINT NOT NULL | Grade School Exam |
| 8 | SAD_BR_GRA_CE1_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central Exam 1 |
| 9 | SAD_BR_GRA_CE2_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central exam 2 |
| 10 | SAD_BR_GRA_CE3_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central Exam 3 |
| 11 | SAD_BR_FI_GRA1_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 1 |
| 12 | SAD_BR_FI_GRA2_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 2 |
| 13 | SAD_BR_FI_GRA3_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 3 |
| 14 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL | HEGIS Code |
| 15 | SSR_TST_ID_NLD | Character(8) | VARCHAR2(8) NOT NULL | Test ID |
| 16 | GRADE_DT | Date(10) | DATE | Grade Date |
| 17 | SAD_BR_CMP_SET_NLD | Character(1) | VARCHAR2(1) NOT NULL | Complete set field |
| 18 | SSR_TST_EXAMTP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Test examination type
B=Combination Grade C=Central End Exam E=End Exam Q=Qualification S=School Exam U=Partial Qualification |
| 19 | SSR_TST_CAT_TP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Test Type : Test or Calculated Result
C=Calculated Result T=Test |
| 20 | TERM_BEGIN_DT | Date(10) | DATE | Term Begin Date |
| 21 | TERM_END_DT | Date(10) | DATE | Term Ending Date |
| 22 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |