ASI Panel 1998-99～2007-08

Table name	Contents
Common variables	Common variables over all tables.
asipanYEARa	Establishment characteristics (A).
asipanYEARb	Establishment characteristics (B).
asipanYEARc	Fixed assets.
asipanYEARd	Working capital and loans.
asipanYEARe	Employment and labor cost.
asipanYEARf	Other expenses.
asipanYEARg	Other incomes.
asipanYEARh	Input items - indigenous items consumed.
asipanYEARi	Input items - directly imported items only(consumed).
asipanYEARj	Products and by-products(manufactured by the unit).
State code	State and Union Territory(UT) code.

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