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.

Google Online Preview   Download