Data Standards for Assets and Resources

compared with
Current by Md Abdus Salam
on Sep 17, 2012 09:55.

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

Changes (4)

View Page History
* Insert the record

The transformation of parsed data is done by following some rules which are described in the following tables. The common characteristic is that each field of the record will be wrapped by specific xml tags which will help to fetch records and show to the user in the front end.


h3. Storage Structure of Asset "Faculty"

|| \# \\ || Column Data Element \\ || Type \\ || Size \\ || Description || Required \\ || Multivalued \\ || Structure \\ || Example \\ || Note \\ ||
| 1 \\ | id \\ | varchar \\ | 45 \\ | unique id that can differentiate an entity throughout the system | Yes \\ | No \\ | institutionId.profileTypeId.profileId | "1.1.178" \\ | |
| 2 \\ | profileId \\ | int \\ | 10 \\ | unique id of profile web page | Yes \\ | No \\ | \- \\ | \- \\ | profile id from the url |
\\ | \- \\ | |
| 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 \\ | |
| 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 | |
| 9 \\ | contactEmail \\ | varchar \\ | 255 \\ | email of the primary contact person of this asset \\ | No \\ | No \\ | email retrieved from the web page \\ | aswath@uta.edu | |
| 10 \\ | 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 |