ABDEFKLMN
1
PriorityStandardized Field (color = completed)Standardized Value (color = completed)NotesSource field (proc_Publication_Request.xlsx )Action [0=pull, 1=parse, 2=compute, 3=hardcode]Computation Method/Tools & FrameworksResponsible
2
Notice Skeleton
3
1noticeId71352Request Id0
4
1noticeTypeCode1Type of Solicitation Notice code [RR]TypeOfNotice0
5
1noticeTypeNameNoticePublic Hearing, Property Dispositions, Court Notices, Rules, Solicitation, Award, Solicitation, Intent to Award [RT]Descr [proc_Type_of_Notice.csv]0
6
1[??]sectionNamePublic Hearings and MeetingsType of Solicitation Notice [RT] [PD]. Can this be substituted by the type of notice field?SectionName0
7
1noticeTitle420 LEXINGTON AVENUE OFFICE SPACEShortTitle0
8
noticeDescriptionBid documents are available Monday through Friday, 9:00 a.m. to 4:00 p.m., for a $25.00 fee in the form of a money order or certified check made payable to NYCHA. Documents can also be obtained by registering with I-supplier and downloading documents.AdditionalDescription0
11
1[??]otherInfoThe services cannot be timely procured through competitive sealed bidding or competitive sealed proposals. DoITT is utilizing the Negotiated Acquisition Extension procurement source method to provide the services in order to continue to provide uninterrupted service.Are these only procurement related fields?OtherInfo [procPublicationRequestDMSSPortal Oct-Dec 2014.csv]0
12
1[??]printOutCITRIX XENAPP ENTERPRISE SOFTWARE SUPPORT SERVICES - Intergovernmental Purchase / Judgment required - PIN# 069141106001 - AMT: $138,375.00 - TO: Citrix Systems, Inc. 851 West Cypress Creek Road, Fort Lauderdale, Fl 33309 Term: 7/1/2013-6/30/2014 - E-PIN: 09613O0019001Are these only procurement related fields?Printout [procPublicationRequestDMSSPortal Oct-Dec 2014.csv]0
13
Organizationidentifier841AgencyCode0
14
nameDepartment of TransportationAgencyName0
15
classificationAgency
[Manually choose agency]
3
16
identifier141AgencyDivisionID0
17
parentOrganization841AgencyCode [AgencyDivision.csv]0
18
nameTraffic and PlanningDivisionName [AgencyDivision.csv]0
19
classificationAgency Division[Manually choose agency division]3
20
0[DCAS] Agency AbbreviationNCBAgencyAbbreviation0
21
0[??]noticeDateDate / TIMEThis needs to be located? How is this different from ad start date?NULL0
22
1noticeStartDateDATEStart Date0
23
1noticeEndDateDATEEnd Date0
24
25
Notice Skeleton Attributes [Stored in separate tables]
26
1
Notice Items [M]
noticeItem2, 7, 89Proposal: Extraction of notice items when present. Sometimes there are clear demarcations of items (e.g. "In the matter of"...), and sometimes there are not. If there are no separate items, the whole noticeDescription is treated as the item.NULL1
27
1itemDescription#2 IN THE MATTER OF a proposed revocable consent authorizing 140 West Street Condominium to construct, maintain and use a flood mitigation system components in the south sidewalk of Barclay Street, between West and Washington Streets, and in the west sidewalk of Washington Street, between Barclay and Vesey Streets, in the Borough of Manhattan....AdditionalDescription1
28
1ItemObjecta flood mitigation systemProposal: [RT] Identifies the details of the item, e.g. a flood mitigation system, a rehabilitation center, etc. For description, please see https://docs.google.com/document/d/1Jr-1DHzdHP0rH77F_Kl8q5HfvJvWiKrFRQwZgZvD3LE/editNULL2
29
1itemActionConstruct/Maintain/UseProposal: [RT] Identifies the class/action of the item, e.g. construction, maintainance. For description, please see https://docs.google.com/document/d/1Jr-1DHzdHP0rH77F_Kl8q5HfvJvWiKrFRQwZgZvD3LE/editNULL2
30
1itemAdminContextProposalProposal: [RT] Identifies the TYPE of item, e.g. proposal, application, intent to award, etc. Could also pull in procurement info. Procurement Category Description, Procurement Category Description code For description, please see https://docs.google.com/document/d/1Jr-1DHzdHP0rH77F_Kl8q5HfvJvWiKrFRQwZgZvD3LE/editNULL2
31
1itemDocumentContextVoteProposal: [RT] Describes how the item is being handled according to the document. Is it a vote? A public hearing? An issue to be reviewed? For description, please see https://docs.google.com/document/d/1Jr-1DHzdHP0rH77F_Kl8q5HfvJvWiKrFRQwZgZvD3LE/edit
32
Referenced Organization [M]
refOrganization6, 78, 897Proposal: [RT] Identifies the mentioned organizations/agencies in the notice and/or item text.NULL
33
identifier841NULL
34
nameDepartment of TransportationAdditionalDescription
35
classificationAgencyNULL
36
identifier141NULL
37
parentOrganization841NULL
38
nameTraffic and PlanningNULL
39
classificationAgency DivisionNULL
40
1
Referenced Addresses [M]
refAddress789, 8909, 89Proposal: [RT] All addresses stored in the same table. Referenced through a relational table (Below shown in full]NULL
41
1completeSpector Hall, 22 Reade Street, New York, NYAdditionalDescriptionShould use the NYC Geocoder [is there an entry reference ID that can be used instead of including all the forms?]
42
1nameSpector HallNULL
43
1address122 Reade StreetNULL
44
1address2NULL
45
1cityNew YorkNULL
46
1stateNYNULL
47
1zip10001NULL
48
1lat40.714264NULL
49
1long-74.004393NULL
50
1latLong40.714264, -74.004393NULL
51
1
Meeting Details [M]
meetingIdN 150021 PXMProposal: [RT] Store each meeting with a separate id in a separate table. The table would include the below field. Address would be stored in a separate tableNULL2Add to Meeting Object?
52
1startTimeDate / TIMESource is different for PAST and future notices.AdditionalDescription. NB. For future notices, this field is being implemented by DCAS.1
53
1endTimeDate / TIMESource is different for PAST and future notices.AdditionalDescription. NB. For future notices, this field is being implemented by DCAS.1
54
1meetingLocation789Note: [RT] Like all adresses, stored in separate table, and referenced through a relational table. Details shown below.NULL
55
1completeSpector Hall, 22 Reade Street, New York, NYAdditionalDescription. NB. For future notices, this field is being implemented by DCAS.1
56
1nameSpector Hall*can we condense this with one of the addresses for procurement? seems a waste to have empty address fields here and have to add more laterAdditionalDescription1
57
1address122 Reade StreetAdditionalDescription1
58
1address2AdditionalDescription1
59
1cityNew YorkAdditionalDescription1
60
1stateNYAdditionalDescription1
61
1zip10001AdditionalDescription1
62
1lat40.714264NULL2
63
1long-74.004393NULL2
64
1latLong40.714264, -74.004393NULL2
68
1referenceURL(text)AdditionalDescription1
69
1videoURL(text)AdditionalDescription1
70
71
Sub-Schemas
72
73
Public Hearing
74
1[??]meetingIdN 150021 PXM
Does the public hearing contain more fields than the meeting object? Does some of the meeting object field fit into the Public hearing object? Does this deserve to be it's own "sub-scema"?)
NULL2Add to Meeting Object?
75
76
Property Disposition
77
2Property Type CodeProposal: [RT] unique ID per type of property disposition. This should be borrowed from CategoryDescription and CategoryCode from the Procurement Database.NULL2
78
2Property DescriptionProposal: [RT] description per type of property disposition. This should be borrowed from CategoryDescription and CategoryCode from the Procurement Database.NULL2
79
2addressInquiry245
Note: [RT] Like all adresses, stored in separate table, and referenced through a relational table. Details shown below.
NULL-
80
2completeText: "Spector Hall, 22 Reade Street, New York, NY"Address of Request for procurementAddressToRequest-
81
2name“Spector Hall”AddressToRequest1
82
2address1“22 Reade Street”AddressToRequest1
83
2address2AddressToRequest1
84
2city“New York”AddressToRequest1
85
2state"NY"AddressToRequest1
86
2zipXXXXXAddressToRequest1
87
2lat(locationLat:"40.714264")needs to be computedNULL2
88
2long(locationLon:"-74.004393")needs to be computedNULL2
89
2latLong(Lat, Lon)needs to be computedNULL2
90
2[??]Address to Submit URLhttp://addresss.localNULL-
91
92
Court Notices
93
2[??]Court Body Name[Needs Example value]Note: These appear in the PDFs but do not appear anywhere else.NULL-
94
2[??]Court Body Code[Needs Example value]NULL-
95
2[??]Court County Name[Needs Example value]Note: These appear in the PDFs but do not appear anywhere else.NULL-
96
2[??]Court County Code [Needs Example value]NULL-
97
2[??]IA Part[Needs Example value]Note: These appear in the PDFs but do not appear anywhere else.NULL-
98
2[??]Court Index Number(number)Note: These appear in the PDFs but do not appear anywhere else.NULL-
99
2[??]Court - Type of notice[Needs Example value]Note: This might be duplicate. Do court types have their own special type of notice.NULL-
100
2Court Notice Body(text)NULL-
101
2URL related to notice (text)Note: This is a proposed field.NULL-
102
2Map Image[Needs Example value]Note: this is a proposed field. This would be an img file or attachment.NULL-
103
2pointOfContactNameBeverly G. MatthewsContactName from Proc0
104
2pointOfContactPhone2123413464Phone0
105
2pointOfContactEmailbeverly.matthews@acs.nyc.govEmail0