# Presentation: 879450

## PIC

- Development - Buildings And Units

## Creating The Building And Unit Inventory

- PIC - D -

## Choosing A Building Type In PIC Development

- The key to choosing which type of building you have in PIC is to answer the following questions:
- Does the building have more than one unit
- Yes: Go to question 2
- No: Go to Example A” (Single Family)
- Does the physical address use an apartment or unit number
- Yes: Go to question 3
- No: Go to question 5
- Does the building have one outside front entrance to the units
- Yes: Go to question 4
- No:  Go to question 6

*Remember:*
*“**Physical address” is the address you give to 911*
* “**Mailing address” is the address for things sent to you*

- PIC - D -

## Choosing A Building Type In PIC Development (cont)

- Does the building use an elevator for tenants?
- Yes: Go to Example “E” (Elevator Structure)
- No: Go to Example “D” (Multi-family/Walkup)
- Does the building have more than two units?
- Yes: Go to Example “C” (Row/Townhouse)
- No:  Go to Example “B” (Semi-Detached)
- Does the building have more than two units?
- Yes: Go to Example “G” (Row/Townhouse with unit numbers)
- No: Go to Example “F” (Semi-Detached with unit numbers)

- PIC - D -

## Example A - SF Detached

| Example A (SF - Single Family Home) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | 1 | 1 | N | 202 Fir St |
| A single family structure will have one building with one entrance in the building table and one unit in the unit table.  Leave door number blank in the unit table (it will be ignored in addresses). |  |  |  |  |

- PIC - D -

## Example B - Semi-detached (SD)

| Example B (SD –Semi-Detached/Duplex/2-Flat) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | 2 | 1 | N | 202 Fir St, 204 Fir St. |
| A semi-detached structure will have one building with two entrances in the building table and one unit in the unit table for each entrance. Leave door number blank in the unit table (it will be ignored in the addresses.) |  |  |  |  |

- PIC - D -

## Example C - Row/Townhouse Dwelling

- PIC - D -

## Slide 8

| Example C (RW—Row or Townhouse) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | More than 2 | 1 | N | 202, 204 206 Fir St. |
| 
A row or townhouse structure will have one building with more than two entrances in the building table and one unit in the unit table for each entrance.  Leave the door number blank in the unit table (it will be ignored in addresses). |  |  |  |  |

- PIC - D -

## Example D - Walk Up/Multifamily Apartment

| Example  D (WU – Multifamily or Walkup: no elevator) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | 1 | More than 1 | Y | 202 Fir St 3B |
| A Multifamily or walkup structure will have one building with one outside entrance and more than one unit per entrance in the building table.  It will have the same number of units listed in the unit table for that entrance.  Fill in “door number” in the unit table with the apartment number, it will be added to the end of the physical street address in the building table. |  |  |  |  |

- PIC - D -

## Walk Up/Multifamily (cont)

- PIC - D -

## Example E - Multifamily Elevator Structure

| Example E (ES – Multifamily Elevator Structure) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | 1 | More than 1 | Y | 202 Fir St 3B |
| An elevator structure (a multifamily or walkup structure with an elevator) will have one building with one outside entrance and more than one unit per entrance in the building table.  It will have the same number of units listed in the unit table for that entrance.  Fill in the “door number” in the unit table with the apartment number, it will be added to the end of the physical street address in the building table. |  |  |  |  |

- PIC - D -

## Buildings And Entrances

- PIC - D -

## Slide 13

| Example  F (SD—Semi-Detached with “apartment” numbers) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | 2 | 1 | N | 202 Fir St #B |
| A semi-detached structure will have one building with two entrances in the building table and one unit in the unit table for each entrance.  Leave door number blank in the unit table (it will be ignored in addresses). |  |  |  |  |

| Example  G (RW—Row or Townhouse with “apartment” numbers) |  |  |  |  |
| --- | --- | --- | --- | --- |
| # of bldgs | #  entrances | Units/entrance | Use door no 
in unit table? | Example of an address |
| 1 | More than 2 | 1 | N | 202 Fir St #102 |
| A row or townhouse structure will have one building with more than two entrances in the building table and one unit in the unit table for each entrance.  Leave door number blank in the unit table (it will be ignored in addresses). |  |  |  |  |

- PIC - D -

## Non-Dwelling Units

- You must in include Non-Dwelling units so they can be inspected under PASS
- To convert a unit to a non dwelling unit:
- Select the unit in the “unit” tab
- Change unit type to “Non-dwelling”
- Follow prompts and click “save”

- PIC - D -

## Building And Unit Tabs That You Can Edit

- How to Edit the Building Address Line
- Select  the building in the “Building” tab
- Edit Building details as needed
- Click “Save”

- PIC - D -

## How To Remove The Door Numbers

- Door numbers **are not** used with:
- Single family  (SF)
- Semi-detached (SD)
- Row/Townhouse (RW)
- Door numbers **are** used with addresses for:
- Elevator Structures (ES)
- Walkup/Multifamily (WU)
- To remove door numbers:
- Select the unit in the “Unit” tab
- Delete the value in “Door Number”
- Click “Save”

- PIC - D -

## Building And Units 

- PIC B and U data uses five key fields as identifiers that cannot be edited, they are:
- Participant Code
- Development Number
- Building Number
- Building Number Entrance
- Unit Number

- PIC - D -

## Building And Units (cont)

- PHAs frequently request that key fields be changed
- To reset the B&U data to “draft” or delete it requires that we also delete all data which has a dependency to that B&U data
- This  currently involves public housing tenant data and Demo-Dispo applications but could involve other data in the future

- PIC - D -

## Examples:

- Approved PIC B&U data does not match B&U data in PHA’s systems.   PHA says it cannot change the numbers in its system
- The units are configured incorrectly such that a row house structure is listed with only one building entrance when it actually has several entrances, each with their own street address
- The PHA incorrectly entered a single 20-unit building with two entrances when it should have entered it as 2 separate 10-unit buildings with separate entrances. (The buildings were built several years apart but share a common wall, etc.)

- PIC - D -

## Examples (cont)

- The PHA entered and the FO approved 90 units located in ten buildings.  However, it should have been 90 units in nine buildings.  The units need to be moved and the extra building deleted
- The PHA uploaded part or all of its inventory with new key values but the old data is still there, causing a double count of those units
- PHA gets a new software vendor who insists that all of the buildings and units must be renumbered in a different way to be compatible with their software

- PIC - D -

## Examples (cont)

- PHA permanently modifies four 1-bedroom units (#1-4) into two 3-bedroom units (#1, 3). PHA wants to renumber the four units so no numbers are skipped in the surviving units (1and 2 vs 1 and 3)
- If a Field Office user erroneously creates a new PHA, there is no way to remove it
- If a Field Office user erroneously creates a new development, there is no way to remove it

- PIC - D -

## Removing Units From The Building And Unit Inventory

- PIC - D -

## How To Download Buildings And Units

- PIC Downloads submodule allows a PHA to download either the building or unit data for one or more of its developments into a .txt file that can then be inserted into a spreadsheet for review and analysis
- Once you have requested a download of either the Building and/or Unit data, you will be issued a “ticket” for the download
- PIC creates the download within 15 minutes or less
- To download the file when it is ready, click on the ticket number and choose your final destination for the download

- PIC - D -

## Slide 24

- PIC - D -

## Slide 25

- PIC - D -

## Slide 26

- PIC - D -

## Data Importing

- To bring the data into a spreadsheet:
- Choose FILE  OPEN
- Locate the file that you downloaded
- Change the “Files of Type” dropdown to “.txt”
- Click on the name “0000004160.txt” to select it
- Click “Open” to bring it into your spreadsheet
- See PIC Newsbrief MAY 2003, for additional details

- PIC - D -