Difference between revisions of "Organisations Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{Note | The Country structure table is called ''organisation'' and the entity is called ''Organisation''. The Organisation Competence table is called ''orgaccreditationinfo''...")
 
Line 10: Line 10:
 
! colspan="5" | organisation
 
! colspan="5" | organisation
 
|-
 
|-
! scope="col" | DIM_category || scope="col" | DIM_label || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
+
! scope="col" | DIM_label || scope="col" | wiki_Data_type || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
 
|-
 
|-
| Uncategorised || Contact Name ||  ContactName ||  || ContactName
+
| Contact Name || String ||  ContactName ||  || ContactName
 
|-
 
|-
| Uncategorised || Last Updated Date ||  DataEntryDate ||  || DataEntryDate
+
| Last Updated Date || Date ||  DataEntryDate ||  || DataEntryDate
 
|-
 
|-
| Uncategorised || Email ||  Email ||  || Email
+
| Email || String ||  Email ||  || Email
 
|-
 
|-
| Uncategorised || Fax Number ||  Fax ||  || Fax
+
| Fax Number || String ||  Fax ||  || Fax
 
|-
 
|-
| Uncategorised || Country Structure ||  Gazetteer_GUID ||  || Gazetteer
+
| Country Structure || Country Structure ||  Gazetteer_GUID ||  || Gazetteer
 
|-
 
|-
| Uncategorised || Active ||  isactive ||  || Active
+
| Active || Boolean ||  isactive ||  || Active
 
|-
 
|-
| Uncategorised || Mobile Phone Number ||  Mobile ||  || Mobile
+
| Mobile Phone Number || String ||  Mobile ||  || Mobile
 
|-
 
|-
| Uncategorised || - ||  Org_GUID ||  || Guid
+
| - || String ||  Org_GUID ||  || Guid
 
|-
 
|-
| Uncategorised || Organisation ID ||  Org_LocalID ||  || LocalId
+
| Organisation ID || String ||  Org_LocalID ||  || LocalId
 
|-
 
|-
| Uncategorised || Address ||  OrgAddress ||  || Address
+
| Address || String ||  OrgAddress ||  || Address
 
|-
 
|-
| Uncategorised || Category ||  orgcategoryenum_guid || Organisation Category || Category
+
| Category || Single-select ||  orgcategoryenum_guid || Organisation Category || Category
 
|-
 
|-
| Uncategorised || Name ||  OrgName ||  || Name
+
| Name || String ||  OrgName ||  || Name
 
|-
 
|-
| Uncategorised || Status ||  orgstatus ||  || Status
+
| Status || String ||  orgstatus ||  || Status
 
|-
 
|-
| Uncategorised || Other ||  Other ||  || Other
+
| Other || String ||  Other ||  || Other
 
|-
 
|-
| Uncategorised || Parent ||  parentorg_guid ||  || ParentOrganisation
+
| Parent || String ||  parentorg_guid ||  || ParentOrganisation
 
|-
 
|-
| Uncategorised || Phone Number ||  Phone ||  || Phone
+
| Phone Number || String ||  Phone ||  || Phone
 
|-
 
|-
| Uncategorised || Radio ||  Radio ||  || Radio
+
| Radio || String ||  Radio ||  || Radio
 
|-
 
|-
| Uncategorised || Website URL ||  WebsiteURL ||  || WebsiteUrl
+
| Website URL || String ||  WebsiteURL ||  || WebsiteUrl
 +
|}
 +
|}
 +
 
 +
{|
 +
|- valign="top"
 +
|
 +
[[Image:Uncategorised.png|100px]]
 +
|
 +
{| class="wikitable sortable"
 +
! colspan="5" | orgaccreditationinfo
 +
|-
 +
! scope="col" | DIM_label || scope="col" | wiki_Data_type || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
 +
|-
 +
| Accreditation Type || Single-select ||  AccreditationEnum_GUID || Accreditation Type || Accreditationtype
 +
|-
 +
| Accreditation Status || Single-select ||  AccreditationStatusEnum_GUID || Accreditation Status || Accreditationstatus
 +
|-
 +
| - || Parent ||  Org_GUID ||  || Organisation
 +
|-
 +
| - || String ||  OrgAccreditationInfo_GUID ||  || Guid
 
|}
 
|}
 
|}
 
|}
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 15:46, 10 March 2016

Note.jpg 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.

Uncategorised.png

organisation
DIM_label wiki_Data_type DB_Column Enumcategory PojoMethod_name
Contact Name String ContactName ContactName
Last Updated Date Date DataEntryDate DataEntryDate
Email String Email Email
Fax Number String Fax Fax
Country Structure Country Structure Gazetteer_GUID Gazetteer
Active Boolean isactive Active
Mobile Phone Number String Mobile Mobile
- String Org_GUID Guid
Organisation ID String Org_LocalID LocalId
Address String OrgAddress Address
Category Single-select orgcategoryenum_guid Organisation Category Category
Name String OrgName Name
Status String orgstatus Status
Other String Other Other
Parent String parentorg_guid ParentOrganisation
Phone Number String Phone Phone
Radio String Radio Radio
Website URL String WebsiteURL WebsiteUrl

Uncategorised.png

orgaccreditationinfo
DIM_label wiki_Data_type DB_Column Enumcategory PojoMethod_name
Accreditation Type Single-select AccreditationEnum_GUID Accreditation Type Accreditationtype
Accreditation Status Single-select AccreditationStatusEnum_GUID Accreditation Status Accreditationstatus
- Parent Org_GUID Organisation
- String OrgAccreditationInfo_GUID Guid