Column Name |
Definition |
Location in N-PEARS |
Helpful Notes |
external_coalition_id |
Unique numeric identifier for each coalition |
|
Create any number that is unique to reference the Coalition throughout the template. It does not matter what number you use, as long as it is not already used in this sheet. |
name |
Name of the coalition |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Partnership/Coalition Name |
|
level |
Geographic level of the coalition |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Geographic Level(s) of Partnership/Coalition |
These values will need to match the keys indicated in the level section of the Key Mapping sheet.To support multiple levels for a coalition, input a comma separated list of the levels in the column. |
sector |
Sector of the coalition |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Sectors Represented |
These values will need to match the keys indicated in the sector section of the Key Mapping sheet. To add multiple sectors to a coalition, insert a separate row with the same external ID and name, but with a different sector. Coalitions can have multiple sectors. The level does not need to be re-entered. |
sector_other |
If other sector was selected, this is the sector specified by the user |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Sectors Represented > Other Sectors |
|
num_members |
Number of members in the coalition |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Sectors Represented > Number of Members |
|
accomplishments |
Accomplishments of the coalition |
Coordination and Collaboration > Multisector Partnerships/Coalitions > Describe Key Activities Conducted with the Partnership/Coalition |
Note that this is the same as the Key Activities text box within the system. |
Level
Key | Level |
| national | National |
| multi-state | Multi-State |
| state-territory | State/Territory |
| local | Local |
| tribal | Tribal |
Sector
Key | Sector |
| agriculture | Agriculture |
| childcare | Childcare |
| commercial-marketing | Commercial marketing |
| community-design | Community design |
| education | Education |
| food-industry | Food industry |
| food-retailers | Food retailers |
| government | Government |
| media | Media |
| public-health-and-healthcare | Public health and healthcare |
| public-safety | Public safety |
| transportation | Transportation |
| other | Other |