Organisations Uncategorised - Revision history

Alnaucler at 15:56, 14 July 2021

2021-07-14T15:56:44Z

← Older revision		Revision as of 17:56, 14 July 2021
Line 69:		Line 69:
	\|}		\|}
	\|}		\|}
			{{Note \| There is an '''inactive''' table called ''contact'' which had a Fkey to ''organisation'' in early versions of {{IMSMANG}}.}}
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 09:17, 1 November 2018

2018-11-01T09:17:11Z

← Older revision		Revision as of 11:17, 1 November 2018
Line 1:		Line 1:
	{{Note \| The Country structure table is called ''organisation'', the entity is called ''Organisation'' and the maXML artifact is [[Organisations Artifact\|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.}}

	{\|		{\|

Alnaucler at 08:57, 12 July 2017

2017-07-12T08:57:23Z

← Older revision		Revision as of 10:57, 12 July 2017
Line 36:		Line 36:
	\| Name \|\| String \|\| orgname\|\| \|\| Name		\| Name \|\| String \|\| orgname\|\| \|\| Name
	\|-		\|-
	\| ''~~Calculated~~''\|\| String \|\| orgstatus \|\| \|\| Status		\| ''Inactive''\|\| String \|\| orgstatus \|\| \|\| Status
	\|-		\|-
	\| Other \|\| String \|\| other \|\| \|\| Other		\| Other \|\| String \|\| other \|\| \|\| Other

Alnaucler at 19:55, 19 June 2017

2017-06-19T19:55:16Z

← Older revision		Revision as of 21:55, 19 June 2017
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'' 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'' and it is not possible to make CDFs for Organisation Competence.}}

Alnaucler at 11:38, 15 October 2016

2016-10-15T11:38:56Z

← Older revision		Revision as of 13:38, 15 October 2016
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 \|\| ~~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
	\|-		\|-
	\| ''Calculated''\|\| String \|\| orgstatus \|\| \|\| Status		\| ''Calculated''\|\| 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 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 \|\| ~~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]]

Alnaucler at 15:01, 17 June 2016

2016-06-17T15:01:37Z

← Older revision		Revision as of 17:01, 17 June 2016
Line 36:		Line 36:
	\| Name \|\| String \|\| OrgName \|\| \|\| Name		\| Name \|\| String \|\| OrgName \|\| \|\| Name
	\|-		\|-
	\| ''~~Inactive~~''\|\| String \|\| orgstatus \|\| \|\| Status		\| ''Calculated''\|\| String \|\| orgstatus \|\| \|\| Status
	\|-		\|-
	\| Other \|\| String \|\| Other \|\| \|\| Other		\| Other \|\| String \|\| Other \|\| \|\| Other

Alnaucler at 15:01, 17 June 2016

2016-06-17T15:01:00Z

← Older revision		Revision as of 17:01, 17 June 2016
Line 36:		Line 36:
	\| Name \|\| String \|\| OrgName \|\| \|\| Name		\| Name \|\| String \|\| OrgName \|\| \|\| Name
	\|-		\|-
	\| ~~Status~~ \|\| String \|\| orgstatus \|\| \|\| Status		\| ''Inactive''\|\| String \|\| orgstatus \|\| \|\| Status
	\|-		\|-
	\| Other \|\| String \|\| Other \|\| \|\| Other		\| Other \|\| String \|\| Other \|\| \|\| Other

Alnaucler at 16:29, 10 March 2016

2016-03-10T16:29:10Z

← Older revision		Revision as of 18:29, 10 March 2016
Line 10:		Line 10:
	! colspan="5" \| organisation		! colspan="5" \| organisation
	\|-		\|-
	! ~~scope="col" \| DIM_label \|\| scope="col" \|~~ 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
Line 58:		Line 58:
	! colspan="5" \| orgaccreditationinfo		! colspan="5" \| orgaccreditationinfo
	\|-		\|-
	! ~~scope="col" \| DIM_label \|\| scope="col" \|~~ 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

Alnaucler at 16:23, 10 March 2016

2016-03-10T16:23:56Z

← Older revision		Revision as of 18:23, 10 March 2016
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		! scope="col" \| DIM_label \|\| scope="col" \| Data type \|\| scope="col" \| DB_Column \|\| scope="col" \| Enumcategory \|\| scope="col" \| PojoMethod_name
	\|-		\|-
	\| Contact Name \|\| String \|\| ContactName \|\| \|\| ContactName		\| Contact Name \|\| String \|\| ContactName \|\| \|\| ContactName
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		! scope="col" \| DIM_label \|\| scope="col" \| Data type \|\| scope="col" \| DB_Column \|\| scope="col" \| Enumcategory \|\| scope="col" \| PojoMethod_name
	\|-		\|-
	\| Accreditation Type \|\| Single-select \|\| AccreditationEnum_GUID \|\| Accreditation Type \|\| Accreditationtype		\| Accreditation Type \|\| Single-select \|\| AccreditationEnum_GUID \|\| Accreditation Type \|\| Accreditationtype

Alnaucler at 14:48, 10 March 2016

2016-03-10T14:48:11Z

← Older revision		Revision as of 16:48, 10 March 2016
Line 40:		Line 40:
	\| Other \|\| String \|\| Other \|\| \|\| Other		\| Other \|\| String \|\| Other \|\| \|\| Other
	\|-		\|-
	\| Parent \|\| ~~String~~ \|\| parentorg_guid \|\| \|\| ParentOrganisation		\| Parent \|\| Parent \|\| parentorg_guid \|\| \|\| ParentOrganisation
	\|-		\|-
	\| Phone Number \|\| String \|\| Phone \|\| \|\| Phone		\| Phone Number \|\| String \|\| Phone \|\| \|\| Phone