Page 94 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Col # Column Name Data Type Not Null? Comments
19 GP5 NUMBER(3)
20 GP4 NUMBER(3)
21 GP3 NUMBER(3)
22 GP2 NUMBER(3)
23 GP1 NUMBER(3)

Table SPECIAL_SUB

Col # Column Name Data Type Not Null? Comments
NUMBER(4) Y
1 YEAR 1
2 DIV_CODE 2 CHAR(2) Y
CHAR(2) Y
3 DIST_CODE 3
4 THANA_CODE 4 CHAR(2) Y
5 UNION_CODE 5 CHAR(2) Y
CHAR(4) Y
6 INST_CODE 6
7 SUBJECT_ID 7 CHAR(1) Y
8 ST_NO_T NUMBER(4)
9 ST_NO_F NUMBER(4)
10 COM_ID VARCHAR2(15)

Table STUDENT_NO

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
CHAR(2) Y
4 THANA_CODE 4
CHAR(2) Y
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y
VARCHAR2(2) Y
7 CLASS_NAME 7
8 GROUP_NAME 8 CHAR(1) Y
9 NO_STUDENT_T NUMBER(5)
10 NO_STUDENT_F NUMBER(5)
11 STIPEND_ST NUMBER(5)
12 NO_PRESENT_T NUMBER(5)
13 NO_PRESENT_F NUMBER(5)
14 NO_REPEAT_T NUMBER(3)
15 NO_REPEAT_F NUMBER(3)
16 TRANSFER_IN NUMBER(2)
17 TRANSFER_OUT NUMBER(2)
18 NO_SEC_APP NUMBER(2)
19 NO_SEC_NAPP NUMBER(2)
20 COM_ID VARCHAR2(15)
22 REMARK NUMBER(1)

- 87 -