Page 96 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table TEACH_NO_QUAL

Col # Column Name Data Type Not Null? Comments
1 YEAR 1 NUMBER(4) Y
CHAR(2) Y
2 DIV_CODE 2
3 DIST_CODE 3 CHAR(2) Y
4 THANA_CODE 4 CHAR(2) Y
CHAR(2) Y
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y
7 EDU_QUALIFICATION 7 CHAR(1) Y
8 TEACH_NO_1ST_DIV NUMBER(2)
9 TEACH_NO_2ND_DIV NUMBER(2)
10 TEACH_NO_3RD_DIV NUMBER(2)
11 PTI_CAD_T NUMBER(2)
12 PTI_CAD_F NUMBER(2)
13 BED_BPED_T NUMBER(2)
14 BED_BPED_F NUMBER(2)
15 MPHIL_MS_T NUMBER(2)
16 MPHIL_MS_F NUMBER(2)
17 PHD_T NUMBER(2)
18 PHD_F NUMBER(2)
19 COM_ID VARCHAR2(15)
21 MANAGEMENT CHAR(1)
22 LEVEL_EDU CHAR(2)

Table TEC_TRAIN

Col # Column Name Data Type Not Null? Comments

1 YEAR 1 NUMBER(4) Y
CHAR(2) Y
2 DIV_CODE 2
CHAR(2) Y
3 DIST_CODE 3
4 THANA_CODE 4 CHAR(2) Y
CHAR(2) Y
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y
NUMBER(1) Y
7 HIGH_EDU 7
8 TOT NUMBER(2)
9 FEM NUMBER(2)
10 COM_ID VARCHAR2(15)
12 LEVEL_EDU CHAR(2)
13 MANAGEMENT CHAR(1)
14 STUDENT_TYPE CHAR(1)

- 89 -