Difference between revisions of "Education Details Uncategorised"
From IMSMA Wiki
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
− | {{Note | The Education child table for Education details is called ''mredetail'' and the entity type is called ''MRE_DETAIL''. }} | + | {{Note | The Education child table for Education details is called ''mredetail'', the target is called ''Mredetailversion'' and the entity type is called ''MRE_DETAIL''. }} |
{| | {| | ||
|- valign="top" | |- valign="top" | ||
Line 8: | Line 8: | ||
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name' | ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name' | ||
|- | |- | ||
− | | Audience Age Info || Single-select || | + | | Audience Age Info || Single-select || agerangeenum_guid|| Age Range || AgeRange |
|- | |- | ||
| Military Audience || Single-select || audiencemilitary_guid || AudienceMilitary || AudienceMilitary | | Military Audience || Single-select || audiencemilitary_guid || AudienceMilitary || AudienceMilitary | ||
Line 14: | Line 14: | ||
| Mine Action Personnel Audience || Single-select || audiencepersonnel_guid || AudiencePersonnel || AudiencePersonnel | | Mine Action Personnel Audience || Single-select || audiencepersonnel_guid || AudiencePersonnel || AudiencePersonnel | ||
|- | |- | ||
− | | Audience || Single-select || | + | | Audience || Single-select || audiencetypeenum_guid|| Audience Type || AudienceType |
|- | |- | ||
| ''Inactive'' || - || audiencetypeother || || AudienceTypeOther | | ''Inactive'' || - || audiencetypeother || || AudienceTypeOther | ||
|- | |- | ||
− | | % Female || Numeric || | + | | % Female || Numeric || femalepercentage|| || FemalePercentage |
|- | |- | ||
− | | % Male || Numeric || | + | | % Male || Numeric || malepercentage|| || MalePercentage |
|- | |- | ||
− | | - || Parent || | + | | - || Parent || mre_guid|| || Mre |
|- | |- | ||
− | | - || String || | + | | - || String || mredetail_guid|| || Guid |
|- | |- | ||
| Education Sub Type || Single-select || mresubtypeenum_guid || MRESubType || MreSubType | | Education Sub Type || Single-select || mresubtypeenum_guid || MRESubType || MreSubType | ||
|- | |- | ||
− | | Education Type || Single-select || | + | | Education Type || Single-select || mretypeenum_guid|| MRE Type || MreType |
|- | |- | ||
− | | Where did the activity take place? || Place || | + | | Where did the activity take place? || Place || place_guid|| || Place |
|- | |- | ||
− | | Total Audience Number || Integer || | + | | Total Audience Number || Integer || totalaudience|| || TotalAudience |
|} | |} | ||
Latest revision as of 10:18, 1 November 2018
The Education child table for Education details is called mredetail, the target is called Mredetailversion and the entity type is called MRE_DETAIL. |
|