Data Standards for Assets and Resources

compared with
Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (27)

View Page History
| 6 \\ | data \\ | text \\ | \- \\ | complete html of the web page is crawled and stored in this field \\ | Yes \\ | No \\ | \- \\ | \- \\ | |
| 7 \\ | contactName \\ | varchar \\ | 255 \\ | name of the primary contact person of this asset \\ | No | No \\ | full name of the person  retrieved from the web page | Dr. Mohan J Kumar | |
| 8 \\ | contactRank \\ | varchar | 255 \\ | designation and affiliation of the primary contact person of this asset \\ | No | No | designation , affiliation retrieved from the web page | Professor-Computer Science & Engineering | |
| 9 8 \\ | contactPhone \\ | varchar | 45 \\ | contact phone of the primary contact person of this asset \\ | No | No | phone no retrieved from the web page \\ | 817-272-3610 | |
| 10 9 \\ | contactEmail \\ | varchar | 255 \\ | email of the primary contact person of this asset \\ | No | No | email retrieved from the web page \\ | mkumar@uta.edu | |
| 110 \\ | address \\ | varchar | 255 \\ | physical address location of this asset \\ | Yes | No | physical address retrieved from the web page \\ | 500 UTA Blvd \\ | If address is not found in the web page, assign the default address name of the parent institution |
| 121 \\ | city \\ | varchar | 45 \\ | city where the asset is located  \\ | Yes | No | city name retrieved from the web page \\ | Arlington | If city name is not found in the web page, assign the default city name of the parent institution |
| 132 \\ | state \\ | varchar | 45 \\ | state where the asset is located \\ | Yes | No | state name retrieved from the web page \\ | TX | If state name is not found in the web page, assign the default state name of the parent institution |
| 143 \\ | zip \\ | varchar | 45 \\ | zip code where the asset is located \\ | Yes | No | zip code retrieved from the web page \\ | 76019 | If zip code is not found in the web page, assign the default zip code of the parent institution |
| 154 \\ | country \\ | varchar | 45 \\ | country where the asset is located \\ | Yes | No | currently only USA \\ | USA | |
| 165 \\ | lastUpdated \\ | datetime \\ | | date and time of last update done on this profile \\ | Yes | No | yyyy-mm-dd hh:mi:ss (24 hr) | 2012-08-20 12:41:13 | This information is parsed from top right corner of the web page |

h3. Storage Structure of Asset "Research Center"
| 6 \\ | data \\ | text \\ | \- \\ | complete html of the web page is crawled and stored in this field | Yes \\ | No \\ | \- \\ | \- \\ | |
| 7 \\ | contactName \\ | varchar \\ | 255 \\ | name of the primary contact person of this asset | No | No | full name of the person  retrieved from the web page | Dr. Lewis, Frank L. | |
| 8 \\ | contactRank \\ | varchar | 255 | designation and affiliation of the primary contact person of this asset | No | No | designation , affiliation retrieved from the web page | Professor-Automation & Robotics | |
| 9 8 \\ | contactPhone \\ | varchar | 45 | contact phone of the primary contact person of this asset | No | No | phone no retrieved from the web page | 817\- 272-5972 | |
| 10 9 \\ | contactEmail \\ | varchar | 255 | email of the primary contact person of this asset | No | No | email retrieved from the web page | lewis@uta.edu | |
| 110 \\ | address \\ | varchar | 255 | physical address location of this asset \\ | Yes | No | physical address retrieved from web page | 701 South Nedderman Drive | If address is not found in the web page, assign the default address of the parent institution |
| 121 \\ | city \\ | varchar | 45 | city where the asset is located | Yes | No | city name retrieved from web page | Arlington | If city name is not found in the web page, assign the default city name of the parent institution |
| 132 \\ | state \\ | varchar | 45 | state where the asset is located | Yes | No | state name retrieved from web page | TX | If state name is not found in the web page, assign the default state name of the parent institution |
| 143 \\ | zip \\ | varchar | 45 | zip code where the asset is located | Yes | No | zip code retrieved from web page | 76019 | If zip code is not found in the web page, assign the default zip code  of the parent institution |
| 154 \\ | country \\ | varchar | 45 | country where the asset is located | Yes | No | currently only USA | USA | |
| 165 \\ | lastUpdated \\ | datetime | | date and time of last update done on this profile \\ | Yes | No | yyyy-mm-dd hh:mi:ss (24 hr) | 2009-05-27 08:31:43  | This information is parsed from top right corner of the web page |

h3. Storage Structure of Asset "Technology"
| 6 \\ | data | text \\ | \- | complete html of the web page is crawled and stored in this field | Yes \\ | No \\ | \- \\
\\ | \- \\ | |
| 15 7 \\ | contactName | varchar \\ | 255 \\ | name of the primary contact person of this asset \\ | No \\ | No \\ | full name of the person  retrieved from the web page \\ | Dr. Aswath, Pranesh \\ | |
| 17 8 \\ | contactPhone \\ | varchar \\ | 45 \\ | contact phone of the primary contact person of this asset \\ | No \\ | No \\ | phone No retrieved from the web page \\ | \+1 817 272 7108 | |
| 18 9 \\ | contactEmail \\ | varchar \\ | 255 \\ | email of the primary contact person of this asset \\ | No \\ | No \\ | email retrieved from the web page \\ | aswath@uta.edu | |
| 190 \\ | address \\ | varchar \\ | 255 \\ | physical address location of this asset \\ | Yes \\ | No \\ | physical address retrieved from web page \\ | 500 West FIrst Street, Rm. 325 | If address is not found in the web page, assign the default address of the parent institution |
| 20 11 \\ | city \\ | varchar \\ | 45 \\ | city where the asset is located \\ | Yes \\ | No \\ | city name retrieved from web page \\ | Arlington \\ | If city name is not found in the web page, assign the default city name of the parent institution \\ |
| 21 12 \\ | state \\ | varchar \\ | 45 \\ | state where the asset is located \\ | Yes \\ | No \\ | state name retrieved from web page \\ | TX \\ | If state name is not found in the web page, assign the default state name of the parent institution |
| 22 13 \\ | zip \\ | varchar \\ | 45 \\ | zip code of the asset \\ | Yes \\ | No \\ | zip code retrieve from web page \\ | 76019 \\ | If zip code is not found in the web page, assign the default zip code  of the parent institution |
| 23 14 \\ | country \\ | varchar \\ | 45 \\ | country where the asset is located \\ | Yes \\ | No \\ | currently only USA \\ | USA \\ | |
| 24 \\ 15  | lastUpdated \\ | datetime \\ | | date & time of last update done on this profile | Yes \\ | No \\ | yyyy-mm-dd hh:mi:ss (24 hr) \\ | 2008-12-20 11:33:21 | This information is parsed from top right corner of the web page \\ |