# Data Dictionary (DD) Template Version 5.4 -- 8/1/2008

A DD Template provides HUD a standard DD template for use in ***new***
database systems development. It provides a standard format for loading
data element information into a future Metadata Repository (MDR). A DD
template is required by the HUD System Development Methodology (SDM) as
specified in the SDM *Database Specifications Checklist* document. This
template defines the required format and contents for that DD
requirement. It will be filled out in two phases, initially after the
SDM Define System phase is completed and then it is completed after the
SDM Build System phase. The "When Required" column identifies which DD
template column should be completed during which phase.

This document describes the contents of the template; the actual
template is an Excel spreadsheet which contains the following fields:

+----------------+---------------------------------+--------+--------+
| **Template     | **Description**                 | **V    | **When |
| Column**       |                                 | alue** | Requ   |
|                |                                 |        | ired** |
|                |                                 | **     |        |
|                |                                 | Restri | (      |
|                |                                 | ction\ | Define |
|                |                                 | **     | or     |
|                |                                 | (blank | Build) |
|                |                                 | =      |        |
|                |                                 | none)  |        |
+================+=================================+========+========+
| ## H           | HUD IT system code. This        |        | Build  |
| UD System Code | identifies the system that the  |        |        |
|                | data element belongs to.        |        |        |
+----------------+---------------------------------+--------+--------+
| ## H           | HUD IT system name that         |        | Build  |
| UD System Name | identifies the system           |        |        |
+----------------+---------------------------------+--------+--------+
| **HUD DRM      | The HUD DRM Subject Area that   |        | Define |
| Subject Area** | the data element maps to. HUD   |        |        |
|                | DRM Subject Areas are           |        |        |
|                | documented in the HUD Target EA |        |        |
|                | Document,                       |        |        |
|                | <http://www.hud.gov/offices/c   |        |        |
|                | io/ea/newea/resources/eav5.pdf> |        |        |
+----------------+---------------------------------+--------+--------+
| **HUD DRM      | The HUD DRM Entity that the     |        | Define |
| Entity**       | data element maps to. HUD DRM   |        |        |
|                | Entities are documented in the  |        |        |
|                | HUD Target EA Document,         |        |        |
|                | <http://www.hud.gov/offices/c   |        |        |
|                | io/ea/newea/resources/eav5.pdf> |        |        |
+----------------+---------------------------------+--------+--------+
| **LDM Entity   | Name of entity in the Logical   |        | Define |
| Name**         | Data Model (LDM) that the data  |        |        |
|                | element is stored in.           |        |        |
+----------------+---------------------------------+--------+--------+
| **Data Element | The name of the data element or |        | Define |
| (DE) Name**    | attribute as represented in the |        |        |
|                | LDM. The most elementary unit   |        |        |
|                | of data that can be identified  |        |        |
|                | and described.                  |        |        |
+----------------+---------------------------------+--------+--------+
| **DE           | The description of the data     |        | Define |
| Description**  | contained in the data element.  |        |        |
+----------------+---------------------------------+--------+--------+
| **Physical     | The name of the table in which  |        | Build  |
| Table Name**   | the proposed physical data      |        |        |
|                | element will reside.            |        |        |
+----------------+---------------------------------+--------+--------+
| **Physical     | The name of the proposed        |        | Build  |
| Data Element   | physical data element.          |        |        |
| Name**         |                                 |        |        |
+----------------+---------------------------------+--------+--------+
| **Data Type**  | Database data element type,     |        | Define |
|                | i.e. Integer, Char, DateTime.   |        |        |
+----------------+---------------------------------+--------+--------+
| **Max Length** | Maximum length of the data that | N      | Define |
|                | can be stored in the data       | umeric |        |
|                | element.                        | value  |        |
+----------------+---------------------------------+--------+--------+
| **Precision    | Precision of numeric data       | N      | Build  |
| (numeric)**    | element; the number of decimal  | umeric |        |
|                | places.                         | value  |        |
+----------------+---------------------------------+--------+--------+
| **Primary      | Answers the question: Is this   | Y or N | Define |
| key?**         | data element the primary or     |        |        |
|                | part of the primary key for the |        |        |
|                | table that the data element is  |        |        |
|                | a part of?                      |        |        |
+----------------+---------------------------------+--------+--------+
| **Foreign      | Answers the question: Is this   | Y or N | Define |
| key?**         | data element a foreign or part  |        |        |
|                | of a foreign key for the table  |        |        |
|                | that the data element is a part |        |        |
|                | of?                             |        |        |
+----------------+---------------------------------+--------+--------+
| **Listed or    | The valid values for this data  |        | Define |
| Enumerated     | element if the data element     |        |        |
| Values**       | value is constrained.           |        |        |
+----------------+---------------------------------+--------+--------+
| **Default      | The default value for this data |        | Define |
| Value**        | element if no value is entered  |        |        |
|                | at the time the record is       |        |        |
|                | created.                        |        |        |
+----------------+---------------------------------+--------+--------+
| **Required?**  | Answers the question: Is the    | Y or N | Define |
|                | data element required to        |        |        |
|                | contain data when the record is |        |        |
|                | created?                        |        |        |
+----------------+---------------------------------+--------+--------+
| **Read-only?** | Answers the question: Does this | Y or N | Define |
|                | data element contain read only  |        |        |
|                | or static data?                 |        |        |
+----------------+---------------------------------+--------+--------+
| # Integrit     | # The depen                     | #      | #      |
| y Requirements | dence of the data element on th |        | Define |
|                | e existence of another data ele |        |        |
|                | ment and, if so, what the requi |        |        |
|                | rements of the dependency are.  |        |        |
+----------------+---------------------------------+--------+--------+
| # Forma        | # Data format re                | #      | #      |
| t Requirements | quirements (i.e., Social Securi |        | Define |
|                | ty number must include dashes). |        |        |
+----------------+---------------------------------+--------+--------+
| **Security     | The security classification of  |        | Define |
| Cl             | the data element.               |        |        |
| assification** |                                 |        |        |
+----------------+---------------------------------+--------+--------+
| #              | # The constraints on th         | #      | #      |
| Business Rules | e data element's value based on |        | Define |
|                |  a business requirement (e.g.,  |        | /Build |
|                | a purchase order number may not |        |        |
|                |  be created if the customer\'s  |        |        |
|                | credit rating is not adequate). |        |        |
+----------------+---------------------------------+--------+--------+
| # Data         | # I                             | #      | #      |
|  Source System | f this data element originates  |        | Define |
|                | from another system, enter that |        |        |
|                |  system name, table name, and d |        |        |
|                | ata element name in this field. |        |        |
+----------------+---------------------------------+--------+--------+
| # Data         | # The form, law                 | #      | #      |
| Source Require | or act, HUD requirement that th |        | Define |
| ment Reference | is data element meets or comes  |        |        |
|                | from, if applicable. Some possi |        |        |
|                | ble examples are; *Sponsor Addr |        |        |
|                | ess Street Name* from HUD-40112 |        |        |
|                |  (form), or Section of Act 504  |        |        |
|                | (2) (a), *Education Institution |        |        |
|                |  Name* (Congressional act), or  |        |        |
|                | *Type of Assistance Transaction |        |        |
|                | * from the Federal Funding Acco |        |        |
|                | untability and Transparency Act |        |        |
+----------------+---------------------------------+--------+--------+
| **XML Tag**    | The XML tag for this data       |        | Build  |
|                | element if the data element is  |        |        |
|                | part of an XML document.        |        |        |
+----------------+---------------------------------+--------+--------+
| **Logical      | The full business name used at  |        | Define |
| Business       | HUD to identify this element    |        |        |
| English Name** | and which corresponds to the    |        |        |
|                | data dictionary data element.   |        |        |
+----------------+---------------------------------+--------+--------+
| **Data Steward | Name and email contact          |        | Build  |
| Name**         | information for the data        |        |        |
|                | element owning HUD Data         |        |        |
|                | Steward. Contact the EA Team    |        |        |
|                | (<ea.team.support@hud.gov>) for |        |        |
|                | information about the current   |        |        |
|                | Data Stewards at HUD.           |        |        |
+----------------+---------------------------------+--------+--------+

**Data Element Descriptions Guidance**

Precise and unambiguous data definitions or description are one of the
most critical aspects of ensuring data sharing. It is essential that
there is explicit understanding regarding the meaning of data. One
primary way for ensuring that the data's meaning is clearly understood
is by the data description. Therefore, it is required that every data
element have a well-formed definition, one that is clearly understood by
every user.

This section contains the guidelines for providing good data elements
descriptions. This section is from guidance provided by the HUD, Office
of the Chief Financial Officer (OCFO) in the document named, *Data
Element Naming Conventions and Guidelines*, Version 2.3, September 2000.

### Rules {#rules .unnumbered}

A data definition shall:

-   Be unique

-   Be stated in the singular

-   State what the concept is, not only what it is not

-   Be stated as a descriptive phrase or sentence(s)

-   Contain only commonly understood abbreviations

-   Be expressed without embedding definitions of other data elements or
    underlying concepts

### Guidelines {#guidelines .unnumbered}

A data definition should:

-   State the essential meaning of the concept

-   Be precise and unambiguous

-   Be concise

-   Be able to stand alone

-   Be expressed without embedding rationale, functional usage, domain
    information, or procedural information

-   Avoid circular reasoning

-   Use the same terminology and consistent logical structure for
    related definitions

## Detailed description 

To facilitate the understanding of the rules and the guidelines for the
construction of well-formed data definitions, explanations and examples
are provided below. Each rule and guideline is followed by a short
explanation of its meaning. Examples are given to support the
explanations. In all cases, a good example is provided to exemplify the
explanation. When deemed beneficial, a poor, but commonly used, example
is given to show how a definition should not be constructed. A statement
of rationale follows the examples to further explain the differences
between the two.

### Rules {#rules-1 .unnumbered}

-   A data definition shall be unique.

```{=html}
<!-- -->
```
-   EXPLANATION: Each definition shall be distinguishable from every
    other definition within the data dictionary in which it appears.
    This ensures that specificity is retained. One or several
    characteristics that are expressed in the definition must
    differentiate the concept to be defined from other concepts.

-   EXAMPLE:

1.  Good definitions:

    "Goods Dispatch Date" - The date on which goods are dispatched by a
    given party.

    "Goods Receipt Date" - The date on which goods are received by a
    given party.

```{=html}
<!-- -->
```
2.  Poor definitions:

    "Goods Dispatch Date" - The date on which the goods are delivered.

    "Goods Receipt Date" - The date on which the goods are delivered.

-   REASON: The definition "The date on which the goods are delivered"
    cannot be used for both data elements "Goods Receipt Date" and
    "Goods Dispatch Date." Instead, each definition must be different.

```{=html}
<!-- -->
```
-   A data definition shall be stated in the singular.

```{=html}
<!-- -->
```
-   EXPLANATION: The concept expressed by the data definition shall be
    expressed in the singular. An exception is made if the concept
    itself is plural.

-   EXAMPLE:

1.  Good definition:

    "Article Number" - A reference number that identifies an article.

```{=html}
<!-- -->
```
2.  Poor definition:

    "Article Number" - Reference number identifying articles.

-   REASON: The poor definition uses the plural word "articles;" this is
    ambiguous because it could imply that an "article number" refers to
    more than one article.

```{=html}
<!-- -->
```
-   A data definition shall state what the concept is, not only what it
    is not.

```{=html}
<!-- -->
```
-   EXPLANATION: When constructing definitions, the concept cannot be
    defined exclusively by stating what the concept is not.

-   EXAMPLE:

1.  Good definition:

    "Freight Cost Amount" - The cost amount that is incurred by a
    shipper when moving goods from one place to another.

    2\. Poor definition:

    "Freight Cost Amount" - The costs that are not related to packing,
    documentation, loading, unloading, and insurance.

-   REASON: The poor definition does not specify what is included in the
    meaning of the data.

```{=html}
<!-- -->
```
-   A data definition shall be stated as a descriptive phrase or
    sentence(s).

```{=html}
<!-- -->
```
-   EXPLANATION: A phrase is necessary to form a precise definition that
    includes the essential characteristics of the concept. Simply
    stating one or more synonym(s) is insufficient. Simply restating the
    words of the name in a different order is insufficient. If more than
    a descriptive phrase is needed, use complete, grammatically correct
    sentences.

-   EXAMPLE:

1.  Good definition:

    "Agent Name" - The name of the party authorized to act on behalf of
    another party.

    2\. Poor definition:

    "Agent Name" - Representative.

-   REASON: "Representative" is a near-synonym of the data element name,
    which is not adequate for a definition.

```{=html}
<!-- -->
```
-   A data definition shall contain only commonly understood
    abbreviations.

```{=html}
<!-- -->
```
-   EXPLANATION: Understanding the meaning of an abbreviation, including
    acronyms and initialisms, is usually confined to a certain
    environment. In other environments, the same abbreviation can cause
    misinterpretation or confusion. Therefore, to avoid ambiguity, full
    words, not abbreviations, shall be used in the definition.

    An exception to this rule may be made if an abbreviation is commonly
    understood, such as "i.e." and "e.g.," or if an abbreviation is more
    readily understood than the full form of the complex term and has
    been adopted as a term in its own right, such as "radar," which
    stands for "radio detecting and ranging."

    All acronyms must be expanded on the first occurrence.

-   EXAMPLE 1:

1.  Good definition:

    "Tide Height" - The vertical distance from mean sea level (MSL) to a
    specific tide level.

    2\. Poor definition:

    "Tide Height" - The vertical distance from MSL to a specific tide
    level.

-   REASON: The poor definition is unclear because the acronym MSL is
    not commonly understood; some users may need to refer to other
    sources to determine what it represents. Without the full word,
    finding the term in a glossary may be difficult or impossible.

-   EXAMPLE 2:

1.  Good definition:

    "Unit of Density Measurement" - The unit employed when measuring the
    concentration of matter in terms of mass per unit (m.p.u.) volume,
    e.g., pound per cubic foot; kilogram per cubic meter.

    2\. Poor definition:

    "Unit of Density Measurement" - The unit employed when measuring the
    concentration of matter in terms of m.p.u. volume, e.g., pound per
    cubic foot; kilogram per cubic meter.

-   REASON: M.p.u. is not a common abbreviation and its meaning may not
    be understood by some users. The abbreviation should be expanded to
    full words.

```{=html}
<!-- -->
```
-   A data definition shall be expressed without embedding the
    definitions of other data elements or of underlying concepts.

```{=html}
<!-- -->
```
-   EXPLANATION: The definition of a second data element or of a related
    concept should not appear in the definition of the primary data
    element. Definitions of terms should be provided in an associated
    glossary. If the second definition is necessary, it may be attached
    by a note at the end of the primary definition's main text or as a
    separate entry in the dictionary. Related definitions can be
    accessed through relational attributes, e.g., cross-reference.

-   EXAMPLE 1:

1.  Good definition:

    "Sample Type Code" - The code that identifies the kind of sample.

    2\. Poor definition:

    "Sample Type Code" - The code that identifies the kind of sample
    collected. A sample is a small specimen taken for testing. It can be
    either an actual sample for testing, or a quality control sample. A
    quality control sample is a surrogate sample taken to verify results
    of actual samples.

-   REASON: The poor definition contains two extraneous definitions
    embedded within it. They are the definitions of "sample" and of
    "quality control sample."

-   EXAMPLE 2:

1.  Good definition:

    "Issuing Bank Documentary Credit Number" - The reference number that
    is assigned by the issuing bank to a documentary credit.

    2\. Poor definition:

    "Issuing Bank Documentary Credit Number" - The reference number that
    is assigned by the issuing bank to a documentary credit. A
    documentary credit is a document in which a bank states that it has
    issued a documentary credit under which the beneficiary is to obtain
    payment, acceptance, or negotiation on compliance with certain terms
    and conditions and against presentation of stipulated documents and
    such drafts as may be specified.

-   REASON: The poor definition contains a concept definition, which
    should be included in a glossary.

### Guidelines {#guidelines-1 .unnumbered}

-   A data definition should state the essential meaning of the concept.

```{=html}
<!-- -->
```
-   EXPLANATION: All primary characteristics of the concept that are
    represented should appear in the definition at the relevant level of
    specificity for the context. The inclusion of non-essential
    characteristics should be avoided. The level of detail necessary is
    dependent upon the needs of the system user and the environment.

-   EXAMPLE 1: (Intended context: any form of transportation)

1.  Good definition:

    "Consignment Loading Sequence Number" - The number that indicates
    the sequence in which consignments are loaded onto a means of
    transport or piece of transport equipment.

    2\. Poor definition:

    "Consignment Loading Sequence Number" - The number that indicates
    the sequence in which consignments are loaded onto a truck.

-   REASON: In the intended context, consignments can be transported by
    various transportation modes, e.g., trucks, vessels, or freight
    trains. Consignments are not limited to trucks for transport.

-   EXAMPLE 2:

1.  Good definition:

    "Invoice Amount" - The total sum that is charged on an invoice.

    2\. Poor definition:

    "Invoice Amount" - The total sum of all chargeable items mentioned
    on an invoice, taking into account deductions on one hand, such as
    allowances and discounts, and additions on the other hand, such as
    charges for insurance, transport, handling, etc.

-   REASON: The poor definition includes extraneous material.

```{=html}
<!-- -->
```
-   A data definition should be precise and unambiguous.

```{=html}
<!-- -->
```
-   EXPLANATION: The exact meaning and interpretation of the defined
    concept should be apparent from the definition. A definition should
    be clear enough to allow only one possible interpretation.

-   EXAMPLE:

1.  Good definition:

    "Shipment Receipt Date" - The date upon which the shipment is
    received by the receiving party.

    2\. Poor definition:

    "Shipment Receipt Date" - The date upon which the shipment is
    delivered.

-   REASON: The poor definition does not specify what determines a
    "delivery." "Delivery" could be understood as either the act of
    unloading a product at the intended destination or as the point at
    which the intended customer actually obtains the product. It is
    possible that the intended customer never receives the product that
    has been unloaded or that the customer may receive the product days
    after it was unloaded at the site.

```{=html}
<!-- -->
```
-   A data definition should be concise.

```{=html}
<!-- -->
```
-   EXPLANATION: The definition should be brief and comprehensive.
    Extraneous qualifying phrases such as "for the purpose of this data
    dictionary" or "terms to be described" shall be avoided.

-   EXAMPLE:

1.  Good definition:

    "Character Set Name" - The name given to the set of phonetic or
    ideographic symbols in which data is encoded.

    2\. Poor definition:

    "Character Set Name" - The name given to the set of phonetic or
    ideographic symbols in which data is encoded, for the purpose of
    this data dictionary, or, as used elsewhere, the capability of
    systems hardware and software to process data encoded in one or more
    scripts.

-   REASON: In the poor definition, all of the phrases that follow
    "...data is encoded" are extraneous, qualifying phrases.

```{=html}
<!-- -->
```
-   A data definition should be able to stand alone.

```{=html}
<!-- -->
```
-   EXPLANATION: The meaning of the concept should be apparent from the
    definition. Additional explanations or references should not be
    necessary to understand the meaning of the definition.

-   EXAMPLE:

1.  Good definition:

    "School Location City Name" - The name of the city where the school
    is situated.

    2\. Poor definition:

    "School Location City Name" - See school site.

-   REASON: The poor definition does not stand alone; it requires the
    aid of a second definition (school site) to understand the meaning
    of the first.

```{=html}
<!-- -->
```
-   A data definition should be expressed without embedding rationale,
    functional usage, domain information, or procedural information.

```{=html}
<!-- -->
```
-   EXPLANATION: Although they are often necessary, such statements do
    not belong in the definition because they contain information
    extraneous to the purpose of the definition. If deemed useful, such
    expressions may be placed in other data element attributes.

    \(1\) The rationale for a given definition should not be included as
    part of the definition, e.g., if a data element uses miles instead
    of kilometers, the reason should not be indicated in the definition.

    \(2\) Functional usage such as "this data element should not be used
    for..." should not be included in the definition.

    \(3\) Remarks about procedural aspects, such as "this data element
    is used in conjunction with data element 'xxx,'" should not appear
    in the definition; instead, use "related data reference" and "type
    of relationship."

```{=html}
<!-- -->
```
-   

```{=html}
<!-- -->
```
-   EXAMPLE:

1.  Good definition:

    "Data Field Label" - The identification of a field in an index,
    thesaurus, query, database, etc.

    2\. Poor definition:

    "Data Field Label" - The identification of a field in an index,
    thesaurus, query, database, etc., which is provided for units of
    information such as abstracts and columns within tables.

-   REASON: The poor definition contains remarks about functional usage.
    The phrases starting with "which is provided for..." must be
    excluded from the definition and placed in another attribute, if it
    is necessary information.

```{=html}
<!-- -->
```
-   A data definition should avoid circular reasoning.

```{=html}
<!-- -->
```
-   EXPLANATION: Two definitions shall not be defined in terms of each
    other. A definition should not use another concept's definition as
    its definition. This results in a situation where a concept is
    defined with the aid of another concept that is, in turn, defined
    with the aid of the given concept.

-   EXAMPLE: (Two data elements with poor definitions.)

1.  "Employee ID Number" - The number assigned to the employee.

2.  "Employee Name" - The employee who has been assigned the employee ID
    number.

-   REASON: Each definition refers to the other for its meaning. The
    meaning is not given in either definition.

```{=html}
<!-- -->
```
-   A data definition should use the same terminology and consistent
    logical structure for related definitions.

```{=html}
<!-- -->
```
-   EXPLANATION: A common terminology and syntax should be used for
    similar or associated definitions.

-   EXAMPLE: (Two data elements with good definitions. Both definitions
    pertain to related concepts and, therefore, have the same logical
    structure and similar terminology.)

1.  "Goods Dispatch Date" - The date on which the goods were dispatched
    by a

    given party.

2.  "Goods Receipt Date" - The date on which the goods were received by
    a

    given party.

-   REASON: Using the same terminology and syntax facilitates
    understanding. Otherwise, users wonder whether some difference is
    implied by the use of synonymous terms and variable syntax.

**Data Dictionary Template Sample**

The following is a sample utilizing this DD Template discussed above for
the HUD National Housing Locator System (NHLS). The NHLS is a
web-enabled system allowing HUD's staff and partners to access rental
housing databases for available temporary housing.

<table style="width:100%;">
<colgroup>
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
<col style="width: 3%" />
</colgroup>
<tbody>
<tr class="odd">
<td>HUD System Code</td>
<td>HUD System Name</td>
<td>HUD DRM Subject Area</td>
<td>HUD DRM Entity</td>
<td>LDM Entity Name</td>
<td>Data Element (DE) Name</td>
<td><p>DE Description</p>
<p>(Part 1)</p></td>
<td><p>DE Description</p>
<p>(Part 2)</p></td>
<td>Physical Table Name</td>
<td>Physical Data Element Name</td>
<td>Data Type</td>
<td>Max Length</td>
<td>Precision (decimal places)</td>
<td>Primary key? Y/N</td>
<td>Foreign key? Y/N</td>
<td>Listed or Enumerated Values</td>
<td>Default Value</td>
<td>Required?</td>
<td>Read-only?</td>
<td>Integrity Requirements</td>
<td>Format Requirements</td>
<td>Security Classification</td>
<td><p>Business Rules</p>
<p>(Part One)</p></td>
<td><p>Business Rules</p>
<p>(Part Two)</p></td>
<td>Data Source System</td>
<td>Data Source Requirement Reference</td>
<td>XML Tag</td>
<td>Logical Business English Name</td>
<td>Data Steward Name</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property ID</td>
<td>Table’s primary key is an assigned unique identification. This is a
required field.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>PROPERTYID</td>
<td>Number</td>
<td>20</td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>N/A</td>
<td>Case Property ID</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property Type Text</td>
<td>Text that describes the property type.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>PROPERTYTYPE</td>
<td>Varchar2</td>
<td>100</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The 'type' variable in &lt;Identification&gt; element</td>
<td>Case Property Type</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property Address Text</td>
<td>Street address of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>ADDRESS</td>
<td>Varchar2</td>
<td>255</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;Address1&gt; element</td>
<td>Case Address</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property City Name Text</td>
<td>City of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>CITY</td>
<td>Varchar2</td>
<td>50</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;City&gt; element</td>
<td>Case City Name</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property State Code</td>
<td>State of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>STATE</td>
<td>Varchar2</td>
<td>5</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;State&gt; element</td>
<td>Case Property State</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property Zip Code</td>
<td>ZIP Code of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>ZIP</td>
<td>Varchar2</td>
<td>10</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;Zip&gt; element</td>
<td>Case Property ZIP Code</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property County Text</td>
<td>County of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>COUNTY</td>
<td>Varchar2</td>
<td>100</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>N/A</td>
<td>Case Property County</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property Country Code</td>
<td>Country of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>COUNTRY</td>
<td>Varchar2</td>
<td>5</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;Country&gt; element</td>
<td>Case Property Country</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property Phone Number</td>
<td>Phone number of the property.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>PHONE</td>
<td>Varchar2</td>
<td>30</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;Phone&gt; element</td>
<td>Case Property Phone Number</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Housing Project</td>
<td>Case Property</td>
<td>Case Property URL</td>
<td>URL of the property description website.</td>
<td></td>
<td>CASE_PROPERTY</td>
<td>URL</td>
<td>Varchar2</td>
<td>500</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Sensitive</td>
<td colspan="2">Data is acquired from the NHLS_PROPERTY table when the
user adds properties to a citizen's case.</td>
<td>NHLS</td>
<td>Data obtain from the NHLS_PROPERTY table</td>
<td>The &lt;Comment&gt; element</td>
<td>Case Property URL</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Identifier</td>
<td>Table’s primary key is an assigned unique identification. This is a
required field.</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>CONTACTID</td>
<td>Number</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td></td>
<td></td>
<td>Y</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact Identifier</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact First Name Text</td>
<td>First name of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>FIRSTNAME</td>
<td>Varchar2</td>
<td>50</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Exec Dir First Name</td>
<td>PHA Contact First Name</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Middle Name Text</td>
<td>Middle name of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>MIDDLENAME</td>
<td>Varchar2</td>
<td>50</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact Middle Name</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Last Name Text</td>
<td>Last name of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>LASTNAME</td>
<td>Varchar2</td>
<td>50</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Exec Dir Last Name</td>
<td>PHA Contact Last Name</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Address1 Text</td>
<td>First line of the Public Housing Authority's address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>ADDRESS1</td>
<td>Varchar2</td>
<td>255</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Physical Address 1</td>
<td>PHA Contact Address1</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Address2 Text</td>
<td>Second line of the Public Housing Authority's address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>ADDRESS2</td>
<td>Varchar2</td>
<td>255</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Physical Address 2</td>
<td>PHA Contact Address2</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact City Text</td>
<td>City of the Public Housing Authority's address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>CITY</td>
<td>Varchar2</td>
<td>50</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Physical City</td>
<td>PHA Contact City</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact State Code</td>
<td>State of the Public Housing Authority's address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>STATE</td>
<td>Varchar2</td>
<td>5</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Physical State Code</td>
<td>PHA Contact State</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Zip Code</td>
<td>ZIP code of the Public Housing Authority's address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>ZIP</td>
<td>Varchar2</td>
<td>10</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td><p>Physical Basic Zip;</p>
<p>Physical Zip Extension</p></td>
<td>PHA Contact ZIP Code</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Phone Number</td>
<td>Office phone number of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>PHONE</td>
<td>Varchar2</td>
<td>30</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Phone</td>
<td>PHA Contact Phone Number</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Mobile Number</td>
<td>Mobile phone number of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>MOBILE</td>
<td>Varchar2</td>
<td>30</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact Mobile Number</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Fax Number</td>
<td>Fax number of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>FAX</td>
<td>Varchar2</td>
<td>30</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Fax</td>
<td>PHA Contact FAX Number</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Title Text</td>
<td>Title of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>TITLE</td>
<td>Varchar2</td>
<td>255</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact Title</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Agency Name Text</td>
<td>Formal Name assigned to the Public Housing Authority</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>AGENCY</td>
<td>Varchar2</td>
<td>255</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Formal HA Name</td>
<td>PHA Contact Agency</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Latitude</td>
<td>Float value of the latitudinal coordinate in degrees.</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>LATITUDE</td>
<td>Float</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be a valid latitudinal reference based on the
contact address obtained from HUD Geocoding processing.</td>
<td>PIH</td>
<td>Data obatined from HUD Geocoding service based on address from the
PIH PIC sytem.</td>
<td>N/A</td>
<td>PHA Contact Latitude</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Longitude</td>
<td>Float value of the longitudinal coordinate in degrees.</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>LONGITUDE</td>
<td>Float</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be a valid latitudinal reference based on the
contact address obtained from HUD Geocoding processing.</td>
<td>PIH</td>
<td>Data obatined from HUD Geocoding service based on address from the
PIH PIC sytem.</td>
<td>N/A</td>
<td>PHA Contact Longitude</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Region Text</td>
<td>Region of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>REGION</td>
<td>Varchar2</td>
<td>100</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Region Code</td>
<td>PHA Contact Region</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Email Text</td>
<td>E-mail address of the Public Housing Authority contact</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>EMAIL</td>
<td>Varchar2</td>
<td>100</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>Email Address</td>
<td>PHA Contact Email</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact PHA Code</td>
<td>HUD housing authority code issued to the Public Housing
Authority</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>HACODE</td>
<td>Varchar2</td>
<td>10</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>HA Code</td>
<td>PHA Contact PHA Code</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="odd">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact Type Text</td>
<td>Type of Public Housing Authority</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>TYPE</td>
<td>Varchar2</td>
<td>20</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact Type</td>
<td>PIH, Dallas Blair</td>
</tr>
<tr class="even">
<td>P254</td>
<td>NHLS</td>
<td>Rental Assistance</td>
<td>Public Housing Agency</td>
<td>PHA Contacts</td>
<td>PHA Contact County Name Text</td>
<td>County of the Public Housing Authority’s address</td>
<td></td>
<td>PHA_CONTACTS</td>
<td>COUNTY</td>
<td>Varchar2</td>
<td>100</td>
<td></td>
<td>N</td>
<td>N</td>
<td></td>
<td></td>
<td>N</td>
<td>N</td>
<td>N/A</td>
<td>N/A</td>
<td>Public</td>
<td colspan="2">Data must be current data from the PIH system. Non
current data will be updated or removed.</td>
<td>PIH</td>
<td>Data obatined from the PIH PIC system.</td>
<td>N/A</td>
<td>PHA Contact County</td>
<td>PIH, Dallas Blair</td>
</tr>
</tbody>
</table>