ASI Panel 1998-99〜2007-08
YEAR: 9899 for 1998-99, 9900 for 1999-00, 0001 for 2000-01, 0102 for 2001-02, 0203 for 2002-03,
0304 for 2003-04, 0405 for 2004-05, 0506 for 2005-06, 0607 for 2006-07, 0708 for 2007-08.
Common variables over all tables
Name |
Type |
Description |
Unit |
id | int |
Sequential number |
|
year | char(4) |
9899 for 1998-99, 9900 for 1999-00, 2001 for 2000-01, 2002 for 2001-02, 2003 for 2002-03,
2004 for 2003-04, 2005 for 2004-05, 2006 for 2005-06, 2007 for 2006-07, 2008 for 2007-08.
|
|
Factory_id | char(8) |
Establishment identification code. The 6th and 7th characters show state code. |
|
state |
char(2) |
Sate code |
|
block | char(1) |
Block code: 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', and 'J'. |
|
mult | float |
Multiplier. |
|
Establisment characteristics (A): asipanYEARa
Name |
Type |
Description |
Unit |
scheme_code | int |
Scheme code, 1: census sector, 2: sample sector |
|
nic4 | char(4) |
4-digit NIC98 code |
|
nic5 | char(5) |
5-digit NIC98 code |
|
sec | int |
Sector. 1: rural, 2: urban. |
|
ro_sro | int |
RO/SRO code |
num_units | int |
Number of units |
|
status_units | int |
Status of units, |
|
| |
1: Open |
|
| |
2: Close |
|
| |
3: NOP |
|
| |
4: Deleted(found non-existent within 3 years |
|
| |
5: Non-response due to closure but in existence and owner/
occupier is not traceable
| |
| |
6: Non-response due to non existence now and owner
not traceable |
|
| |
7: Non-response due to relavant records are with
court/income tax department etc.
|
|
| |
8: Non-response due to recalcirtant/refuse to submit the return
|
|
| |
9: Non-response due to factory under prosecution in respect of
earlier ASI
|
|
| |
10: Non-response due to other reasons
|
|
| |
11: Deleted(found non-existent more than 3 years
|
|
| |
12: Deleted due to deregistration
|
|
| |
13: Deleted due to out of coverage i.e. defence, oil storage,
technical
|
|
| |
14: Deleted due to identical with PSL number
|
|
| |
15: Deleted due to any other reason
|
|
working_day_mfg | int |
Number of working days: manufacturing |
Days |
working_day_nonmfg | int |
Number of working days: non-manufacturing |
Days |
working_day_total | int |
Number of working days: total |
Days |
cost | int |
Total cost of production |
Rupees |
To top
Establisment characteristics (B): asipanYEARb
Name |
Type |
Description |
Unit |
organisation | int |
Type of organization, |
|
| |
1: Individual proprietorship
|
|
| |
2: Joint family(HUF)
|
|
| |
3: Partnership
|
|
| |
4: Public limitted company
|
|
| |
5: Private limitted company
|
|
| |
6: Government departmental enterprice
(excluding khadi, handloom)
|
|
| |
7: Public corporation by special act of parliament or state
legislature of PSU
|
|
| |
8: Khadi and village industries comission
|
|
| |
9: Handlooms
|
|
| |
10: Co-operative society
|
|
| |
19: Others(including trusts, wakf boards etc.)
|
|
ownership | int |
Type of ownership, |
| |
1: Wholly central government
|
|
| |
2: Wholly state and/or local government
|
|
| |
3: Central government and state and/or local government jointly
|
|
| |
4: Joint sector public
|
|
| |
5: Joint sector private
|
|
| |
6: Wholly private ownership
|
|
num_units | int |
Number of units the company owns |
Number |
units_in_same_state | int |
How many units located in the same state |
Number |
init_year | int |
Year of initial production |
|
ac_year_start | date |
Accounting year(from) |
|
ac_year_end | date |
Accounting year(to) |
|
months | int |
Number of months of operation |
Months |
ac_system | int |
Does your unit have computerised accounting system?
1: yes, 2: no
|
|
asi_data | int |
Can your unit supply ASI data in computer floppy?
1: yes, 2: no
|
|
To top
Fixed assets: asipanYEARc
Name |
Type |
Description |
Unit |
asset_id | int |
Type of assets, |
|
| |
1: Land
|
|
| |
2: Building
|
|
| |
3: Plant and machinery,
|
|
| |
4: Transport equipment
|
|
| |
5: Computer equipment including software
|
|
| |
6: Pollution control equipment
|
|
| |
7: Others
|
|
| |
8: Total tangible assets(sum over 2 to 7)
|
|
| |
9: Capital work in progress
|
|
| |
10: Total(1 + 8 + 9)
|
|
gross_opening | float |
Gross opening stocks |
Rupees |
gross_revaluation | float |
Gross increases in stocks due to revaluation during the year
|
Rupees |
gross_addition | float |
Acquisition of assets during the year |
Rupees |
gross_deduction | float |
Deduction and adjustment during the the year |
Rupees |
gross_closing | float |
Gross closing stocks
(gross_opening + gross_revaluation + gross_addition -
gross_deduction)
|
Rupees |
dep_begining | float |
Depreciation of assets up to year begining |
Rupees |
dep_during | float |
Depreciation of assets during the year |
Rupees |
dep_end | float |
Depreciation of assets up to year end
(dep_begining + dep_during)
|
Rupees |
net_opening | float |
Net opening stocks
(gross_opening - dep_begining)
|
Rupees |
net_closing | float |
Net closing stocks
(gross_closing - dep_end)
|
Rupees |
To top
Working capital and loans: asipanYEARd
Name |
Type |
Description |
Unit |
cap_id | int |
Type of working capital and loans |
|
| |
1: Raw materials and components and packing materials |
|
| |
2: Fuels and lubricants |
|
| |
3: Spares, stores and others |
|
| |
4: Sub-total(1 to 3) |
|
| |
5: Semi-finished goods/work in progress |
|
| |
6: Finished goods |
|
| |
7: Total inventory(4 to 6) |
|
| |
8: Cash in hand in hand and at bank |
|
| |
9: Sundry debtors |
|
| |
10: Other current assets |
|
| |
11: Total current assets(7 to 10) |
|
| |
12: Sundry creditors |
|
| |
13: Over draft, cash credit, other short terms loam from banks
and other financial institutions |
|
| |
14: Other current liabilities |
|
| |
15: Total current liabilities(12 to 14) |
|
| |
16: Working capital(11 minus 15) |
|
| |
17: Outstanding loans
(excluding interest but including deposits) |
|
cap_opening | float |
Opening value |
Rupees |
cap_closing | float |
Closing value |
Rupees |
To top
Employment and labor cost: asipanYEARe
Name |
Type |
Description |
Unit |
labor_id | int |
Type of labor |
|
| |
1. Male workers employed directly
|
|
| |
2. Female workers employed directly
|
|
| |
3. Child workers employed directly
|
|
| |
4. Workers employed directly(1 + 2 + 3)
|
|
| |
5. Workers employed through contracts
|
|
| |
6. Total waorkers(4 + 5)
|
|
| |
7. Supervisory and managerial staff
|
|
| |
8. Other employees
|
|
| |
9. Unpaid family members/proprietor/coop. members
|
|
| |
10. Total emplyees(6 + 7 + 8 + 9)
|
|
man_days_mfg | float |
Man days worked(manufacturing) |
Man days |
man_days_nonmfg | float |
Man days worked(non-manufacturing) |
Man days |
man_days_total | float |
Man days worked(total = manufacturing + non-manufacturing) |
Man days |
man | float |
Average number of persons worked |
Persons |
days_paid | float |
Number of mandays paid for |
Days |
wage | float |
Wages/salaries |
Rupees |
bonus | float |
Bonus |
Rupees |
fund | float |
Contribution to provident and other funds |
Rupees |
welfare | float |
Workman and staff welfare expenses |
Rupees |
To top
Other expenses: asipanYEARf
Name |
Type |
Description |
Unit |
work_by_other | float |
Work done by others on materials supplied
by the industrial undertaking |
Rupees |
rep_building | float |
Repair and maintenance of building |
Rupees |
rep_plant_mac | float |
Repair and maintenance of plant and machinery |
Rupees |
rep_plant_pollution | float |
Repair and maintenance of pollution control equipment |
Rupees |
rep_other | float |
Repair and maintenance of other fixed assets |
Rupees |
operating | float |
Operating expenses |
Rupees |
non_operating | float |
Non-operating expenses(excluding insurance charges) |
Rupees |
insurance | float |
Insurance charges |
Rupees |
rent_plant_mac | float |
Rent paid for plant and machinery anad other fixed assets |
Rupees |
total | float |
Total expenses
(work_by_other + rep_building + rep_plant_mac +
rep_plant_pollution + rep_other + operating + non_operating +
insurance + rent_plant_mac) |
Rupees |
rent_building | float |
Rent paid for buldings |
Rupees |
rent_land_nontang | float |
Rent paid for land on lease or royalties on mines,
quarries and similar assets
|
Rupees |
interest | float |
Interset paid |
Rupees |
pur_val_goods | float |
Purchase value of goods sold in the same condition
as purchased
|
Rupees |
To top
Other incomes: asipanYEARg
Name |
Type |
Description |
Unit |
income_service | float |
Income from services(industrial/non industrial
including work done for others on materials
supplied by them and sale value of waste left by the party)
|
Rupees |
var_stock | float |
Variation in stock of semi-finished goods
(closing stocks minus opening stocks against item 5 in block D)
|
Rupees |
val_elec_gen | float |
Value of electricity generated and sold
|
Rupees |
val_own_construction | float |
Value of own construction
|
Rupees |
net_balance | float |
Net balance of goods sold in the same condition
as purchased
(sale_val_goods of block G minus pur_val_goods of block F)
|
Rupees |
rev_rent_plant_mac | float |
Rent received for plant and machinery and other
fixed assets
|
Rupees |
total_rev | float |
Total receipts(income_service + var_stock + val_elec_gen +
val_own_construction + net_balance + rev_rent_plant_mac)
|
Rupees |
rev_rent_building | float |
Rent received for buildings
|
Rupees |
rev_rent_land_nontang | float |
Rent received for land on lease or royalties on
mines, quarries and similar assets
|
Rupees |
rev_interest | float |
Interest received
|
Rupees |
sale_val_goods | float |
Sale value of goods sold in the same condition as purchased
|
Rupees |
To top
Input items - indigenous items consumed: asipanYEARh
Name |
Type |
Description |
Unit |
item_id | int |
Item serial number.
|
|
asicc | char(5) |
5-digit ASICC code
|
|
| |
99201: Other basic items(indigenous)
|
|
| |
99901: Total basic items
|
|
| |
99203: Non-basic chemicals - all kinds
|
|
| |
99908: Packing items
|
|
| |
99904: Electricty own generated(in kWh)
|
|
| |
99905: Electricty purchased and consumed(in kWh)
|
|
| |
99906: Petrol, diesel, oil, lubricants consumed
(only value is available)
|
|
| |
99907: Coal consumed
|
|
| |
99204: Other fuel consumption(only value is available)
|
|
| |
99220: Consumable store(only value is available)
|
|
| |
99920: Total non-basic items(99203 + 99908 + 99904 + 99905 +
99906 + 99907 + 99204 + 99220: only value is available)
|
|
| |
99930: Total inputs(99901 + 99920: only value is available)
|
|
| |
item_id = 23: Any additional requirement of electricity
(unmet demand) in kWh
|
|
unit | int |
Unit of quantity
|
|
qty | float |
Quantity consumed
|
Quantity |
val | float |
Purchase value
|
Rupees |
price | float |
Rate per unit
|
Rupees |
To top
Input items - directly imported items only: asipanYEARi
Name |
Type |
Description |
Unit |
sl_no | int |
Item code
|
|
item_id | int |
Item serial number.
|
|
asicc | char(5) |
5-digit ASICC code
|
|
| |
99221: Other items imported(only value is available)
|
|
| |
99940: Total imports(consumed) (only value is available)
|
|
unit | int |
Unit of quantity
|
|
qty | float |
Quantity consumed
|
Quantity |
val | float |
Purchase value
|
Rupees |
price | float |
Rate per unit
|
Rupees |
To top
Products and by-products(manufactured by the unit): asipanYEARj
Name |
Type |
Description |
Unit |
item_id | int |
Item serial number.
|
|
asicc | char(5) |
5-digit ASICC code
|
|
| |
99921: Other products/by-products(only value is available)
|
|
| |
99995: Total(only value is available)
|
|
unit | int |
Unit of quantity
|
|
qty_produce | float |
Quantity manufactured
|
Quantity |
qty_ship | float |
Quantity sold
|
Quantity |
val_sales | float |
Gross sale value(including subsidy received)
|
Rupees |
excise_duty | float |
Distributed expenses - excise duty
|
Rupees |
sales_tax | float |
Distributed expenses - sales tax
|
Rupees |
others | float |
Distributed expenses - others
|
Rupees |
total | float |
Distributed expenses - total
(excise_duty + sales_tax + others)
|
Rupees |
price_basic | float |
Per unit net sale value
: (val_sales - total) / q_ship
|
Rupees |
val_basic | float |
Ex-factory value of output
: basic_price x q_produce
|
Rupees |
To top
State code
State/Union Territory Name | Codes |
Andaman & N. Island | 35 |
Andhra Pradesh | 28 |
Arunachal Pradesh | 12 |
Assam | 18 |
Bihar | 10 |
Chandigarh(U.T.) | 04 |
Chattisgarh | 22 |
Dadra & Nagar Haveli | 26 |
Daman & Diu | 25 |
Delhi | 07 |
Goa | 30 |
Gujarat | 24 |
Haryana | 06 |
Himachal Pradesh | 02 |
Jammu & Kashmir | 01 |
Jharkhand | 20 |
Karnataka | 29 |
Kerala | 32 |
Lakshadweep | 31 |
Madhya Pradesh | 23 |
Maharashtra | 27 |
Manipur | 14 |
Meghalaya | 17 |
Mizoram | 15 |
Nagaland | 13 |
Orissa | 21 |
Pondicherry | 34 |
Punjab | 03 |
Rajasthan | 08 |
Sikkim | 11 |
Tamil Nadu | 33 |
Tripura | 16 |
Uttar Pradesh | 09 |
Uttaranchal | 05 |
West Bengal | 19 |