Difference between revisions of "Organisations Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Note | The Country structure table is called ''organisation'' and the entity is called ''Organisation''.
+
{{Note | The Country structure table is called ''organisation'', the entity is called ''Organisation'', the target is called ''Organisation'' and the maXML artifact is [[Organisations Artifact|Organisation]].
The Organisation Competence table is called ''orgaccreditationinfo'' and it is not possible to make CDFs for Organisation Competence.}}
+
The Organisation Competence table is called ''orgaccreditationinfo'' (there is no target) and it is not possible to make CDFs for Organisation Competence.}}
  
 
{|
 
{|
Line 10: Line 10:
 
! colspan="5" | organisation
 
! colspan="5" | organisation
 
|-
 
|-
! scope="col" | DIM_label || scope="col" | wiki_Data_type || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
+
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 
|-
 
|-
| Contact Name || String ||  ContactName ||  || ContactName
+
| Contact Name || String ||  contactname||  || ContactName
 
|-
 
|-
| Last Updated Date || Date ||  DataEntryDate ||  || DataEntryDate
+
| Last Updated Date || Date ||  dataentrydate||  || DataEntryDate
 
|-
 
|-
| Email || String ||  Email ||  || Email
+
| Email || String ||  email ||  || Email
 
|-
 
|-
| Fax Number || String ||  Fax ||  || Fax
+
| Fax Number || String ||  fax ||  || Fax
 
|-
 
|-
| Country Structure || Country Structure ||  Gazetteer_GUID ||  || Gazetteer
+
| Country Structure || Country Structure ||  gazetteer_guid||  || Gazetteer
 
|-
 
|-
 
| Active || Boolean ||  isactive ||  || Active
 
| Active || Boolean ||  isactive ||  || Active
 
|-
 
|-
| Mobile Phone Number || String ||  Mobile ||  || Mobile
+
| Mobile Phone Number || String ||  mobile ||  || Mobile
 
|-
 
|-
| - || String ||  Org_GUID ||  || Guid
+
| - || String ||  org_guid||  || Guid
 
|-
 
|-
| Organisation ID || String ||  Org_LocalID ||  || LocalId
+
| Organisation ID || String ||  org_localid||  || LocalId
 
|-
 
|-
| Address || String ||  OrgAddress ||  || Address
+
| Address || String ||  orgaddress||  || Address
 
|-
 
|-
 
| Category || Single-select ||  orgcategoryenum_guid || Organisation Category || Category
 
| Category || Single-select ||  orgcategoryenum_guid || Organisation Category || Category
 
|-
 
|-
| Name || String ||  OrgName ||  || Name
+
| Name || String ||  orgname||  || Name
 
|-
 
|-
| Status || String ||  orgstatus ||  || Status
+
| ''Inactive''|| String ||  orgstatus ||  || Status
 
|-
 
|-
| Other || String ||  Other ||  || Other
+
| Other || String ||  other ||  || Other
 
|-
 
|-
 
| Parent || Parent ||  parentorg_guid ||  || ParentOrganisation
 
| Parent || Parent ||  parentorg_guid ||  || ParentOrganisation
 
|-
 
|-
| Phone Number || String ||  Phone ||  || Phone
+
| Phone Number || String ||  phone ||  || Phone
 
|-
 
|-
| Radio || String ||  Radio ||  || Radio
+
| Radio || String ||  radio ||  || Radio
 
|-
 
|-
| Website URL || String ||  WebsiteURL ||  || WebsiteUrl
+
| Website URL || String ||  websiteurl||  || WebsiteUrl
 
|}
 
|}
 
|}
 
|}
Line 58: Line 58:
 
! colspan="5" | orgaccreditationinfo
 
! colspan="5" | orgaccreditationinfo
 
|-
 
|-
! scope="col" | DIM_label || scope="col" | wiki_Data_type || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
+
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 
|-
 
|-
| Accreditation Type || Single-select ||  AccreditationEnum_GUID || Accreditation Type || Accreditationtype
+
| Accreditation Type || Single-select ||  accreditationenum_guid|| Accreditation Type || Accreditationtype
 
|-
 
|-
| Accreditation Status || Single-select ||  AccreditationStatusEnum_GUID || Accreditation Status || Accreditationstatus
+
| Accreditation Status || Single-select ||  accreditationstatusenum_guid|| Accreditation Status || Accreditationstatus
 
|-
 
|-
| - || Parent ||  Org_GUID ||  || Organisation
+
| - || Parent ||  org_guid||  || Organisation
 
|-
 
|-
| - || String ||  OrgAccreditationInfo_GUID ||  || Guid
+
| - || String ||  orgaccreditationinfo_guid||  || Guid
 
|}
 
|}
 
|}
 
|}
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 10:17, 1 November 2018

Note.jpg The Country structure table is called organisation, the entity is called Organisation, the target is called Organisation and the maXML artifact is Organisation.

The Organisation Competence table is called orgaccreditationinfo (there is no target) and it is not possible to make CDFs for Organisation Competence.

Uncategorised.png

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
Inactive 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

Uncategorised.png

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