Schema GrantAppl_v_0_4.xsd

schema location:  GrantAppl_v_0_4.xsd
attribute form default:  unqualified element form default: qualified
Elements 

 

 

 

Address  GrantBudget  GrantFiscalAgent  OrgName 
Constituency  GrantContact  GrantGeneral  OtherOrgs 
Distribution  GrantContext  GrantRequest  OtherSources 
Expenses  GrantDocument  GrantSummary  Personnel 
GrantApplData  GrantDocuments  GrantTask  Phone 
GrantApplication  GrantEvaluation  GrantWorkplan  Revenue 
GrantApplications  GrantExtensibles  IncomeStatement  Source 
GrantBudget  GrantField  Operations 

 

 
element GrantApplication             MAIN Navigator:

diagram
properties
content complex
children CRMApplicationID CRMKinteraID GLApplicationID ApplicationType InitiativeID InitiativeName GrantProgramID GrantProgramName OrgName GrantGeneral GrantRequest GrantContext GrantWorkplan GrantDocuments GrantEvaluation GrantExtensibles
used by
element GrantApplications
annotation
documentation 
Container of an individual grant application


element Address
diagram
properties
content complex
children CRMAddrID GLAddrID AddressType Addr1 Addr2l City State Zip County Province Country
used by
elements GrantContact GrantFiscalAgent

element Address/CRMAddrID
diagram
type xs:string
properties
isRef 0
content simple

element Address/GLAddrID
diagram
type xs:string
properties
isRef 0
content simple

element Address/AddressType
diagram
type restriction of xs:string
properties
isRef 0
content simple
facets
enumeration 
enumeration Mailing
enumeration Billing
enumeration Business
enumeration Summer
enumeration Alternate

element Address/Addr1
diagram
type xs:string
properties
isRef 0
content simple

element Address/Addr2l
diagram
type xs:string
properties
isRef 0
content simple

element Address/City
diagram
type xs:string
properties
isRef 0
content simple

element Address/State
diagram
type xs:string
properties
isRef 0
content simple

element Address/Zip
diagram
type xs:string
properties
isRef 0
content simple

element Address/County
diagram
type xs:string
properties
isRef 0
content simple

element Address/Province
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
(non-USA)

element Address/Country
diagram
type xs:string
properties
isRef 0
content simple

element Constituency
diagram
properties
content complex
children ConstituencyType Distribution
used by
element GrantContext

element Constituency/ConstituencyType
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
ethnic, gender, age, disabled

element Distribution
diagram
properties
content complex
children Group CurrentRatio TargetRatio
used by
element Constituency

element Distribution/Group
diagram
type xs:string
properties
isRef 0
content simple

element Distribution/CurrentRatio
diagram
type xs:double
properties
isRef 0
content simple

element Distribution/TargetRatio
diagram
type xs:string
properties
isRef 0
content simple

element Expenses
diagram
properties
content complex
children Personnel Operations
used by
element IncomeStatement

element GrantApplData
diagram
properties
content complex
children Version FileType CRC GrantApplications
annotation
documentation 
Container for File

element GrantApplData/Version
diagram
type xs:string
properties
isRef 0
content simple

element GrantApplData/FileType
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Test | Production | Adjustment

element GrantApplData/CRC
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Cyclic Redundancy Check

element GrantApplication/CRMApplicationID
diagram
type xs:string
properties
isRef 0
content simple

element GrantApplication/CRMKinteraID
diagram
properties
isRef 0
annotation
documentation 
ID of Kintera Client to insure uniqueness of CRM ID

element GrantApplication/GLApplicationID
diagram
type xs:string
properties
isRef 0
content simple

element GrantApplication/ApplicationType
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
LOI, Application, FollowUp

element GrantApplication/InitiativeID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Broad Program Area

element GrantApplication/InitiativeName
diagram
type xs:string
properties
isRef 0
content simple

element GrantApplication/GrantProgramID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Specific Grant Program

element GrantApplication/GrantProgramName
diagram
type xs:string
properties
isRef 0
content simple

element GrantApplications
diagram
properties
content complex
children GrantApplication
used by
element GrantApplData
annotation
documentation 
Container for all orgs

element GrantBudget
diagram
properties
content complex
children Type IncomeStatement Period InKindResources
used by
element GrantRequest
annotation
documentation 
Current, Proposed, requested

element GrantBudget/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Current, proposed, requested

element GrantBudget/Period
diagram
type xs:string
properties
isRef 0
content simple

element GrantBudget/InKindResources
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact
diagram
properties
content complex
children CRMContactID CRMKinteraID GLContactID ContactRole Greeting Prefix NameFirst NameMiddle NameLast Suffix Phone eMail Address
used by
element OrgName

element GrantContact/CRMContactID
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/CRMKinteraID
diagram
properties
isRef 0
annotation
documentation 
ID of Kintera Client to insure uniqueness of CRM ID

element GrantContact/GLContactID
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/ContactRole
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
CEO/ Chair/ DO/ Payee

element GrantContact/Greeting
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/Prefix
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/NameFirst
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/NameMiddle
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/NameLast
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/Suffix
diagram
type xs:string
properties
isRef 0
content simple

element GrantContact/eMail
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext
diagram
properties
content complex
children TargetPopulation NumberServed OtherOrgs NTEECoding Constituency RoleCommunityMembers RoleStaff RoleBoard RoleVolunteers
used by
element GrantApplication

element GrantContext/TargetPopulation
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext/NumberServed
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext/NTEECoding
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
needs modelling

element GrantContext/RoleCommunityMembers
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext/RoleStaff
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext/RoleBoard
diagram
type xs:string
properties
isRef 0
content simple

element GrantContext/RoleVolunteers
diagram
type xs:string
properties
isRef 0
content simple

element GrantDocument
diagram
properties
content complex
children Category ReceivedDate SummaryText Published DocumentType DocumentURL
used by
element GrantDocuments

element GrantDocument/Category
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Biographies of Key Staff,  Letter of Authority, 	Letters of Commitment , Budget Narrative, Names/ involvement of employess

element GrantDocument/ReceivedDate
diagram
type xs:dateTime
properties
isRef 0
content simple

element GrantDocument/SummaryText
diagram
type xs:string
properties
isRef 0
content simple

element GrantDocument/Published
diagram
type xs:string
properties
isRef 0
content simple

element GrantDocument/DocumentType
diagram
type xs:string
properties
isRef 0
content simple

element GrantDocument/DocumentURL
diagram
type xs:string
properties
isRef 0
content simple

element GrantDocuments
diagram
properties
content complex
children GrantDocument
used by
element GrantApplication

element GrantEvaluation
diagram
properties
content complex
children SuccessShortTerm SuccessLongTerm SuccessMetrics EvalAssignment EvalActionPlan SustainablePlan
used by
element GrantApplication
annotation
documentation 
note this is at summary level

element GrantEvaluation/SuccessShortTerm
diagram
type xs:string
properties
isRef 0
content simple

element GrantEvaluation/SuccessLongTerm
diagram
type xs:string
properties
isRef 0
content simple

element GrantEvaluation/SuccessMetrics
diagram
type xs:string
properties
isRef 0
content simple

element GrantEvaluation/EvalAssignment
diagram
type xs:string
properties
isRef 0
content simple

element GrantEvaluation/EvalActionPlan
diagram
type xs:string
properties
isRef 0
content simple

element GrantEvaluation/SustainablePlan
diagram
type xs:string
properties
isRef 0
content simple

element GrantExtensibles
diagram
properties
content complex
children GrantField
used by
element GrantApplication
annotation
documentation 
Custom fields

element GrantField
diagram
properties
content complex
children FieldName FieldType FieldContents
used by
element GrantExtensibles

element GrantField/FieldName
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
what new field is called

element GrantField/FieldType
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
text, date, number, binary

element GrantField/FieldContents
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent
diagram
properties
content complex
children CRMContactID CRMKinteraID GLContactID FiscalAgentRole Greeting Prefix NameFirst NameMiddle NameLast Suffix Phone eMail Address
used by
element OrgName

element GrantFiscalAgent/CRMContactID
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/CRMKinteraID
diagram
properties
isRef 0
annotation
documentation 
ID of Kintera Client to insure uniqueness of CRM ID

element GrantFiscalAgent/GLContactID
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/FiscalAgentRole
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
CEO/ Chair/ DO/ Payee

element GrantFiscalAgent/Greeting
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/Prefix
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/NameFirst
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/NameMiddle
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/NameLast
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/Suffix
diagram
type xs:string
properties
isRef 0
content simple

element GrantFiscalAgent/eMail
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral
diagram
properties
content complex
children ProjectName ApplicationDate TypeFundingRequest Renewal RenewalID ProposalSummary GoalsForFundingPeriod GeographicArea RelatePublishedInterests OpportunitiesAddressed FitWithMission Issues
used by
element GrantApplication

element GrantGeneral/ProjectName
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/ApplicationDate
diagram
type xs:dateTime
properties
isRef 0
content simple

element GrantGeneral/TypeFundingRequest
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
General Operating, Startup, Project/Program, Endowment, Technical Assistance, Capital, Other

element GrantGeneral/Renewal
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/RenewalID
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/ProposalSummary
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/GoalsForFundingPeriod
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/GeographicArea
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/RelatePublishedInterests
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/OpportunitiesAddressed
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/FitWithMission
diagram
type xs:string
properties
isRef 0
content simple

element GrantGeneral/Issues
diagram
type xs:string
properties
isRef 0
content simple

element GrantRequest
diagram
properties
content complex
children GrantBudget GrantSummary
used by
element GrantApplication

element GrantSummary
diagram
properties
content complex
children TotalBudget TotalRequest PeriodStart PeriodStartYear PeriodEnd PeriodEndYear TargetFundingDate OtherSources
used by
element GrantRequest

element GrantSummary/TotalBudget
diagram
type xs:double
properties
isRef 0
content simple
default 0
annotation
documentation 
should equal total proposed expenses

element GrantSummary/TotalRequest
diagram
type xs:double
properties
isRef 0
content simple
annotation
documentation 
should equal proposed income "This Grant"

element GrantSummary/PeriodStart
diagram
type xs:string
properties
isRef 0
content simple

element GrantSummary/PeriodStartYear
diagram
type xs:string
properties
isRef 0
content simple

element GrantSummary/PeriodEnd
diagram
type xs:string
properties
isRef 0
content simple

element GrantSummary/PeriodEndYear
diagram
type xs:string
properties
isRef 0
content simple

element GrantSummary/TargetFundingDate
diagram
type xs:dateTime
properties
isRef 0
content simple

element GrantTask
diagram
properties
content complex
children TaskType TaskDescription TaskAssigned TaskDueDate TaskStatus TaskNotes
used by
element GrantWorkplan

element GrantTask/TaskType
diagram
properties
isRef 0
annotation
documentation 
Milestone, Deliverable, Activity

element GrantTask/TaskDescription
diagram
type xs:string
properties
isRef 0
content simple

element GrantTask/TaskAssigned
diagram
type xs:string
properties
isRef 0
content simple

element GrantTask/TaskDueDate
diagram
type xs:dateTime
properties
isRef 0
content simple

element GrantTask/TaskStatus
diagram
type xs:string
properties
isRef 0
content simple

element GrantTask/TaskNotes
diagram
type xs:string
properties
isRef 0
content simple

element GrantWorkplan
diagram
properties
content complex
children GrantTask
used by
element GrantApplication

element IncomeStatement
diagram
properties
content complex
children Revenue Expenses
used by
element GrantBudget

element Operations
diagram
properties
content complex
children Type Amount
used by
element Expenses

element Operations/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Rent, Utilities, Supplies, Other

element Operations/Amount
diagram
type xs:double
properties
isRef 0
content simple

element OrgName
diagram
properties
content complex
children OrganizationName CRMKinteraID CRMOrgID GLOrgID ParentOrgID ParentGLOrgID ParentOrgRelationship GrantContact GrantFiscalAgent
used by
element GrantApplication
annotation
documentation 
ID of applicant

element OrgName/OrganizationName
diagram
type xs:string
properties
isRef 0
content simple

element OrgName/CRMKinteraID
diagram
properties
isRef 0
annotation
documentation 
ID of Kintera Client to insure uniqueness of CRM ID

element OrgName/CRMOrgID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Either CRM or GL ID required - defines PK

element OrgName/GLOrgID
diagram
type xs:string
properties
isRef 0
content simple

element OrgName/ParentOrgID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
this defaults to org profile but can be overwritten at grant level

element OrgName/ParentGLOrgID
diagram
type xs:string
properties
isRef 0
content simple

element OrgName/ParentOrgRelationship
diagram
type xs:string
properties
isRef 0
content simple

element OtherOrgs
diagram
properties
content complex
children RelationToOtherOrgs RoleOtherOrgs
used by
element GrantContext

element OtherOrgs/RelationToOtherOrgs
diagram
type xs:string
properties
isRef 0
content simple

element OtherOrgs/RoleOtherOrgs
diagram
type xs:string
properties
isRef 0
content simple

element OtherSources
diagram
properties
content complex
children AddtionalFundingNeeds Source
used by
element GrantSummary

element OtherSources/AddtionalFundingNeeds
diagram
type xs:string
properties
isRef 0
content simple

element Personnel
diagram
properties
content complex
children Type Amount
used by
element Expenses

element Personnel/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
FT, PT, Professinal fees

element Personnel/Amount
diagram
type xs:double
properties
isRef 0
content simple

element Phone
diagram
properties
content complex
children PhoneType PhoneNumber
used by
elements GrantContact GrantFiscalAgent

element Phone/PhoneType
diagram
type restriction of xs:string
properties
isRef 0
content simple
facets
enumeration 
enumeration Main
enumeration Fax
enumeration Home
enumeration Office
enumeration Mobile

element Phone/PhoneNumber
diagram
type xs:string
properties
isRef 0
content simple

element Revenue
diagram
properties
content complex
children Income
used by
element IncomeStatement

element Revenue/Income
diagram
properties
isRef 0
content complex
children Type Amount

element Revenue/Income/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
This Grant, Other Grants, Fees, United Way, Interest, Other

element Revenue/Income/Amount
diagram
type xs:double
properties
isRef 0
content simple

element Source
diagram
properties
content complex
children SourceName SourceAmount SourceStatus
used by
element OtherSources

element Source/SourceName
diagram
type xs:string
properties
isRef 0
content simple

element Source/SourceAmount
diagram
type xs:double
properties
isRef 0
content simple

element Source/SourceStatus
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Requested, Committed, Received, Contingent


XML Schema documentation generated with XMLSpy Schema Editor http://www.altova.com/xmlspy