Organisations Uncategorised

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.

organisation DIM Label Data type Database column name Enumcategory Pojo 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 Calculated String orgstatus Status Other String other Other Parent Parent parentorg_guid ParentOrganisation Phone Number String phone Phone Radio String radio Radio Website URL String websiteurl WebsiteUrl

orgaccreditationinfo DIM Label Data type Database column name Enumcategory Pojo 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