Difference between revisions of "Organisations Uncategorised"
From IMSMA Wiki
| Line 12: | Line 12: | ||
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name | ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name | ||
|- | |- | ||
| − | | Contact Name || String || | + | | Contact Name || String || contactname|| || ContactName |
|- | |- | ||
| − | | Last Updated Date || Date || | + | | Last Updated Date || Date || dataentrydate|| || DataEntryDate |
|- | |- | ||
| − | | Email || String || | + | | Email || String || email || || Email |
|- | |- | ||
| − | | Fax Number || String || | + | | Fax Number || String || fax || || Fax |
|- | |- | ||
| − | | Country Structure || Country Structure || | + | | Country Structure || Country Structure || gazetteer_guid|| || Gazetteer |
|- | |- | ||
| Active || Boolean || isactive || || Active | | Active || Boolean || isactive || || Active | ||
|- | |- | ||
| − | | Mobile Phone Number || String || | + | | Mobile Phone Number || String || mobile || || Mobile |
|- | |- | ||
| − | | - || String || | + | | - || String || org_guid|| || Guid |
|- | |- | ||
| − | | Organisation ID || String || | + | | Organisation ID || String || org_localid|| || LocalId |
|- | |- | ||
| − | | Address || String || | + | | Address || String || orgaddress|| || Address |
|- | |- | ||
| Category || Single-select || orgcategoryenum_guid || Organisation Category || Category | | Category || Single-select || orgcategoryenum_guid || Organisation Category || Category | ||
|- | |- | ||
| − | | Name || String || | + | | Name || String || orgname|| || Name |
|- | |- | ||
| ''Calculated''|| String || orgstatus || || Status | | ''Calculated''|| String || orgstatus || || Status | ||
|- | |- | ||
| − | | Other || String || | + | | Other || String || other || || Other |
|- | |- | ||
| Parent || Parent || parentorg_guid || || ParentOrganisation | | Parent || Parent || parentorg_guid || || ParentOrganisation | ||
|- | |- | ||
| − | | Phone Number || String || | + | | Phone Number || String || phone || || Phone |
|- | |- | ||
| − | | Radio || String || | + | | Radio || String || radio || || Radio |
|- | |- | ||
| − | | Website URL || String || | + | | Website URL || String || websiteurl|| || WebsiteUrl |
|} | |} | ||
|} | |} | ||
| Line 60: | Line 60: | ||
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name | ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name | ||
|- | |- | ||
| − | | Accreditation Type || Single-select || | + | | Accreditation Type || Single-select || accreditationenum_guid|| Accreditation Type || Accreditationtype |
|- | |- | ||
| − | | Accreditation Status || Single-select || | + | | Accreditation Status || Single-select || accreditationstatusenum_guid|| Accreditation Status || Accreditationstatus |
|- | |- | ||
| − | | - || Parent || | + | | - || Parent || org_guid|| || Organisation |
|- | |- | ||
| − | | - || String || | + | | - || String || orgaccreditationinfo_guid|| || Guid |
|} | |} | ||
|} | |} | ||
{{NavBox Data Dictionary}} | {{NavBox Data Dictionary}} | ||
[[Category:NAA]] | [[Category:NAA]] | ||
Revision as of 12:38, 15 October 2016
 |
The Country structure table is called organisation and the entity is called Organisation.
The Organisation Competence table is called orgaccreditationinfo and it is not possible to make CDFs for Organisation Competence. |
|
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
| ||||||||||||||||||||||||||||||
