A
A. DATABASES
Information Fields
Structure for database: C:\PROJECTS\PROJECTS.dbf
Field Field Name Type Width Description
1 CTY_CODE Character 2 County Code
2 CITY_CODE Character 2 City Code
3 DIST_NO Character 2 District Number
4 TYPE_DIST Character 2 Type of District
5 BLDG_NO Character 4 Building Number
6 PROJ_NO Character 3 Project Number
7 REV_NO Character 8 Review Number
8 PROJMGR Character 3 Project Manager's Initials
9 TYPEA Logical 1 Type A Project
10 TYPEB Logical 1 Type B Project
11 INITLETTER Date 8 Initial Letter Date
12 NEW Logical 1 New Building
13 MFRBLDG Logical 1 Manufactured Building
14 ADD Logical 1 Addition
15 ALT Logical 1 Alteration
16 SDV Logical 1 Site Development
17 ASB Logical 1 Asbestos
18 TOX Logical 1 Toxic Substance Abatement/Control
19 TOX1 Character 1 Toxic Substance Type
20 MAS Logical 1 Masonry
21 ROF Logical 1 Roofing
22 DOR Logical 1 Doors or Windows
23 FIN Logical 1 Finishes
24 SPEC Logical 1 Specialties
25 SPECCON Logical 1 Special Construction
26 CON Logical 1 Conveying Systems
27 HVC Logical 1 Heating-Ventilating-Air Conditioning
28 PLU Logical 1 Plumbing
29 ELE Logical 1 Electrical
30 D_CONTACT Date 8 Date of Initial Contact by District
31 COMMAPPR Date 8 Commissioner's Approval Date
32 ESTCOST Numeric 9 Estimated – Project Cost
33 FINCOST Numeric 9 Final – Project Cost
34 SA4TOSA Date 8 SA4 Sent to State Aid
35 FCRTOSA Date 8 Final Cost Report Sent to State Aid
36 BOCES_SPAC Logical 1 Involves BOCES Space
37 SFREORG Logical 1 District Subject to Reorganization
38 SPECED_CR Logical 1 Adds Special Ed. Classroom Space
39 REQ_LRP Logical 1 Requires Long-Range Plan
40 REQ_PRELIM Logical 1 Requires Preliminary Submission
41 REQ_EFPE Logical 1 Requires Eval. of Exist. Building
42 REQ_SITEAP Logical 1 Requires Site Approval
43 FIN_APP Logical 1 Requires Final Application
44 BUS_FAC Logical 1 Bus Facility
45 CSICODES Character 30 CSI Codes
46 UPDATE Date 8 Update date
47 REVISION Date 8 SA4 Revision Date
48 HAZ_WASTE Character 3 Hazardous Waste Type
49 APPR_FUND Numeric 9 Approved Funding Amount
50 TQ Logical 1 Temporary Quarters
51 DB Logical 1 Discovered Building
52 SEC6A1 Logical 1 Section 6A1 Applies
53 SEC6A2 Logical 1 Section 6A2 Applies
54 REMARKS Character 29 Remarks
55 GRANT_TYPE Character 3 Estimated – Grant Type 1
56 GRANT_AMT Numeric 9 Estimated – Grant Amount 1
57 PERMITID Character 7 Building Permit ID No.
58 LEASE Logical 1 Leased Building
59 SEC155_7 Logical 1 Section 155.7 Applies
60 NONSKOOL Logical 1 Non-school Facility
61 INEL_AID Logical 1 Project Ineligible for State Aid
62 INELAIDAMT Numeric 9 Amount Ineligible for State Aid
63 REVIEWER Character 3 SA4 Reviewed by
64 CAPK6NA Numeric 5 Capacity K - 6 (New or Add.)
65 CAPK6AR Numeric 5 Capacity K - 6 (Alt. or Recon.)
66 CAP79NA Numeric 5 Capacity 7 - 9 (New or Add.)
67 CAP79AR Numeric 5 Capacity 7 - 9 (Alt. or Recon.)
68 CAP712NA Numeric 5 Capacity 7 - 12 (New or Add.)
69 CAP712AR Numeric 5 Capacity 7 - 12 (Alt. or Recon.)
70 CAPSEDNA Numeric 4 Cap. Spec. Ed. Detached (New/Add)
71 CAPSEDAR Numeric 4 Cap. Spec. Ed. Detached (Alt/Rec.)
72 CAPSEANA Numeric 4 Cap. Spec. Ed. Attached (New/Add.)
73 CAPSEAAR Numeric 4 Cap. Spec. Ed. Attached (Alt/Rec.)
74 BBC_NOTES Numeric 9 Estimated – Bonds/BANs/Cap Notes
75 BUDG_APP Numeric 9 Estimated – Budgetary Appropriation
76 CRF Numeric 9 Estimated – Capital Reserve Fund
77 CON_ALTREC Numeric 9 Est. Construction Cost- Alt. or Recon.
78 CON_NEWADD Numeric 9 Est.Construction Cost-
New or Addition
79 INC_ALTREC Numeric 9 Est. Incidental Cost- Alt. or Recon.
80 INC_NEWADD Numeric 9 Est. Incidental Cost- New or Addition
81 TOTAL_BOND Numeric 9 Total Bonding Amount
82 FBPR Logical 1 Final Building Project Report Req'd?
83 TOT_ALTREC Numeric 9 Estimated – Total Cost-
Alter. or Reconstruction
84 TOT_NEWADD Numeric 9 Estimated – Total Cost-
New or Addition
85 GIFT_AMT Numeric 9 Estimated – Amount of gift
86 FCRTOPM Date 8 Date FCR sent to project manager
87 FCRFROMPM Date 9 Date FCR returned from proj. mgr
88 NOTES Character 36 Comment field on Log Book screen
89 PRCOMMENTS Memo 10 Prelim. review comments
90 COMPLSUBM Date 8 Project complete, ready for review
91 ARCHORI Date 8 Construction review start
92 ARCHFIN Date 8 Construction review approval
93 ENGORI Date 8 Mechanical review start
94 ENGFIN Date 8 Mechanical review approval
95 ARCHINITO Character 3 Initial construction review architect
96 ARCHINITF Character 3 Final construction review architect
97 ENGINITO Character 3 Initial mechanical review engineer
98 ENGINITF Character 3 Final mechanical review engineer
99 LARCCONDAT Date 8 Last contact with A/E firm
100 LENGCONDAT Date 8 Last contact with A/E firm
101 LARCCONINI Character 3 Last architect to contact A/E
102 LENGCONINI Character 3 Last engineer to contact A/E
103 FINARCCOMM Logical 1 Construction comments (yes or no)
104 FINENGCOMM Logical 1 Mechanical Comments (yes or no)
105 ABC_NEWADD Numeric 9 Final – building cost - new/add
106 AIC_NEWADD Numeric 9 Final – incidental cost - new/add
107 TC_NEWADD Numeric 9 Final – Total cost - new/add
108 ABC_ALTREC Numeric 9 Final – building cost - alt/rec
109 AIC_ALTREC Numeric 9 Final – incidental cost - alt/rec
110 TC_ALTREC Numeric 9 Final – Total cost - alt/rec
111 FCR_REVIEW Character 3 Initial of FCR reviewer
112 FCR_DATE Character 8 FCR approval date
113 APPRMAIL Date 8 Commissioner's approval mailed
114 PARTLCO Logical 1 Partial certificate of occupancy
115 ANTICOMPL Date 8 Anticipated completion
116 STOREBOX Numeric 4 Storage box
117 PAECODE Character 13 Consultant architect/engineer code
118 SUBSCOMPL Date 8 Substantial completion
119 NOTES_2 Character 50 Notes 2
120 TOTAL CRF Numeric 9 Total Capital Reserve Fund
121 TOTAL BAPP Numeric 9 Total Budgetary Appropriation
122 TOTAL OTH Numeric 9 Total Other
123 AUTHORIZED Logical 1 Approved by the voters
124 SPEDAUTHOR Date 8 Special Education Authorization
125 VOTERAUTH Date 8 Voter authorization date
126 TECHAMOUNT Numeric 9 Technology portion of the project
127 TECHINELIG Numeric 9 Technology Work – Ineligible for
Building Aid
128 MISSINFO Character 5 Missing information
129 FCR WAIVER Date 8 Final Cost Report waived until
130 CON AWARD Date 8 Contract award date
131 MCA NEWADD Numeric 10 Maximum cost allowance – New/add.
132 MCA ALTREC Numeric 10 Maximum cost allowance – Alt./recon.
133 MCA CON NA Numeric 10 Max. cost allow. – Construction
New/addition
134 MCA CON AR Numeric 10 Max. cost allow. – Construction
Alteration/reconstruction
135 MCA INC NA Numeric 10 Max. cost allow. – Incidental
New/addition
136 MCA INC AR Numeric 10 Max. cost allow. – Incidental
Alteration/reconstruction
137 MAXCOSTALL Numeric 10 Maximum theoretical cost allowance
138 AC NEWADD Numeric 10 Approved cost allowance – New/add.
139 AC ALTREC Numeric 10 Approved cost allowance – Alt./recon.
140 AC CON NA Numeric 10 Approved cost allowance –
construction, New/Addition
141 AC CON AR Numeric 10 Approved cost allowance –
construction, Alt/Reconstruction
142 AC INC NA Numeric 10 Approved cost allowance –
incidental, New/Addition
143 AC INC AR Numeric 10 Approved cost allowance –
incidental, Alt/Reconstruction
144 APPCOSTALL Numeric 10 Approved cost allowance total
145 METAL DET Numeric 3 Metal detector project
146 RESCUE Numeric 10 “not used”
147 GRANT TYP2 Character 7 Grant type 2
148 GRANT AMT2 Numeric 9 Grant 2 amount
149 FINALRCD Date 8 Final cost report received
150 VOTERAUTH2 Date 8 Second voter authorization date
151 PPU Numeric 5 period of probable usefulness
152 CC_NEWADD Numeric 9 Contract - Construction, New/Add
153 CC_ALTREC Numeric 9 Contract - Construction, Alt/Reconst.
154 CI_NEWADD Numeric 9 Contract - Incidental, New/Add
155 CI_ALTREC Numeric 9 Contract - Incidental, Alt/Reconst
156 CT_NEWADD Numeric 9 Contract - Total New/Add Costs
157 CT_ALTREC Numeric 9 Contract – Total Alt/Reconst. Costs
158 CONTCOST Numeric 9 Contract Award –
Total Construction Cost
159 DASNY_FIN Logical 1 Dormitory Authority Financing
160 INT_RATE Numeric 7 Financing interest rate
161 PROSPAMORT Logical 1 Prospective amortization
162 EMERGENCY Logical 1 Emergency project
163 CON_AWRDRD Date 8 Contract Award Date Certification
received
164 GRANT_TYP3 Character 7 Estimated – Grant Type 3
165 GRANT_AMT3 Numeric 9 Estimated - Grant Amount 3
166 CBBC_NOTES Numeric 9 Contract – Bonds, BANs, and
Capital Notes
167 TBBC_NOTES Numeric 9 Final – Bonds, BANs, and
Capital Notes
168 C BUDG_APP Numeric 9 Contract – Budgetary Appropriation
169 TBUDG_APP Numeric 9 Final – Budgetary Appropriation
170 C_CRF Numeric 9 Contract – Capital Reserve Fund
171 T_CRF Numeric 9 Final – Capital Reserve Fund
172 TGRANT_AMT Numeric 9 Final – Grant Amount 1
173 CGRANT_AMT Numeric 9 Construction – Grant Amount 1
174 CGRANTAMT2 Numeric 9 Construction – Grant Amount 2
175 TGRANTAMT2 Numeric 9 Final – Grant Amount 2
176 CGRANTAMT3 Numeric 9 Construction – Grant Amount 3
177 TGRANTAMT3 Numeric 9 Final – Grant Amount 3
178 CAPPR_FUND Numeric 9 Contract – Approved Funding
179 TAPPR_FUND Numeric 9 Final – Approved Funding
180 CGIFT_AMT Numeric 9 Contract – Gift Amount
181 TGIFT_AMT Numeric 9 Final – Gift Amount
182 SMCITYDEBT Logical 9 Exceeds small city debt limit
183 CAPOUT100K Logical 9 Capital Outlay Project < $100,000
184 PRJMGRORI Date 9 Initial Project Manager Review
185 PRJMGRFIN Date 9 Final Project Manager Review
186 PRJMGRINIO Character 9 Initial Project Manager
187 PRJMGRINIF Character 9 Final Project Manager
188 CERT_APP Logical 1 Certificate of Apportionment Issued
189 SUBREORG Logical 1 Eligible for reorganization incentive
190 EPC_COSTS Numeric 9 Energy Performance Contract Costs
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- c the shipyard is required to provide the provisioning
- word 2010 and office 2010 basics keyboard shortcuts
- dept for the blind
- iso 14289 1 pdf ua sample report
- vista scheduling enhancements technical manual
- this guide to onscreen editing has three main sections 1
- complete list of ascii codes format word document www
Related searches
- getting a loan to build a house
- what makes a man a man
- what makes a house a home
- a new way to buy a car
- make a resume for a job
- what is a theme of a story
- getting a loan to start a business
- is buying a house a good idea
- writing a will without a lawyer
- is a citation a charge
- is a citation a crime
- a reason a season a lifetime printable