SAD_BR_TSTR_NLD

(SQL Table)
 Index Back

BRON test/hegiscode relations

BRON test/hegiscode relations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

Prompt Table: SA_TEST_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

Prompt Table: HEGIS_CODE_TBL

4 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External Academic Level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)
5 SAD_BR_NT2_ST_NLD Character(2) VARCHAR2(2) NOT NULL NT2 Result from
6 SAD_BR_NT2_END_NLD Character(2) VARCHAR2(2) NOT NULL NT2 Result to