Page 90 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table INC_EXP_INFO

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
5 UNION_CODE 5 CHAR(2) Y
6 INST_CODE 6 CHAR(4) Y
CHAR(2) Y
7 INCOME_ID 7
8 INCOME VARCHAR2(30)
9 AMOUNT_INC NUMBER(12,2)
10 EXPENDITURE VARCHAR2(30)
11 AMOUNT_EXP NUMBER(12,2)
12 COM_ID VARCHAR2(15)

Table INST_ADD_INFO
Col # Column Name Data Type Not Null? Comments
NUMBER(4) Y
1 YEAR 1
CHAR(2) Y
2 DIV_CODE 2
3 DIST_CODE 3 CHAR(2) Y
CHAR(2) Y
4 THANA_CODE 4
5 UNION_CODE 5 CHAR(2) Y
CHAR(4) Y
6 INST_CODE 6
7 FUND NUMBER(12,2)
8 FUND_GENERAL NUMBER(12,2)
9 FLOOD NUMBER(12,2)
10 SPACE NUMBER(3)
11 AMOUNT NUMBER(12,2)
12 COM_ID VARCHAR2(15)
13 BANK_NAME VARCHAR2(15)
14 BR_NAME VARCHAR2(15)
15 BR_DIS NUMBER(2)

Table INST_INFO

Col # Column Name Data Type Not Null? Comments

1 YEAR 1 NUMBER(4) Y
2 DIV_CODE 2 CHAR(2) Y
CHAR(2) Y
3 DIST_CODE 3
4 THANA_CODE 4 CHAR(2) Y
CHAR(2) Y
5 UNION_CODE 5
6 MAUZA_CODE CHAR(3)
7 INST_CODE 6 CHAR(4) Y
8 INST_TYPE_CODE CHAR(2) Y

- 83 -