|
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerStatusAccess |
| | List of statuses for partners. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PAcquisitionAccess |
| | This table is used to describe how a partner first came into contact with the organisation. Which department entered them. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PAddresseeTypeAccess |
| | Ex. Fam - Family, SM - Single Male, etc. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PTitleAccess |
| | Titles available for use. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerClassesAccess |
| | The class a partner is (PERSON, UNIT, etc. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerAccess |
| | This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PRecentPartnersAccess |
| | The partners a user has been working with recently. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerGraphicAccess |
| | Any graphic associated to a partner can be stored here. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PLocationAccess |
| | Address and other data related to that address. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PLocationTypeAccess |
| | Types of address e.g. home, business. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerLocationAccess |
| | Links partners with locations (addresses) and has specific info about the link (e.g. date effective) More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerAttributeCategoryAccess |
| | Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category). More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerAttributeTypeAccess |
| | Holds various Partner Attribute Types. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerAttributeAccess |
| | Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.UUnitTypeAccess |
| | General information about the unit such as unit type and entry conference. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PUnitAccess |
| | Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.UmUnitStructureAccess |
| | This contains parent/child relationships. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFamilyAccess |
| | Contains details about a family in Partnership with us. May have P_Person records linked to it. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PtMaritalStatusAccess |
| | This table contains the codes indicating someones marital status. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.POccupationAccess |
| | List of occupations with codes. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPersonAccess |
| | DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDenominationAccess |
| | List of denomination codes for churches. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PChurchAccess |
| | Specific information about a church which is a partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBusinessAccess |
| | List of businesses with codes. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.POrganisationAccess |
| | Details of an organisation. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBankAccess |
| | Details of an bank. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PVenueAccess |
| | Details of a venue. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBankingTypeAccess |
| | Tells of what type this banking-detail is (bank-account, visa, mastercard, etc. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBankingDetailsAccess |
| | Any bank details for a partner can be stored in this table. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerBankingDetailsAccess |
| | Links p_partner table with p_banking_details table for many to many relationship. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBankingDetailsUsageTypeAccess |
| | Usage type information for Banking Details. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PBankingDetailsUsageAccess |
| | Links p_partner - p_banking_details combination to a usage type. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerTaxDeductiblePctAccess |
| | Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PTypeAccess |
| | List of all possible special types for a partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PTypeCategoryAccess |
| | This table contains the codes that indicate the categories of partner (special) types. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerTypeAccess |
| | Types assigned to each partner. Also known as special types. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PRelationCategoryAccess |
| | This table contains the codes that indicate the categories of relations (grouping). More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PRelationAccess |
| | List of relationships between partners. Relations occur in one direction only. The relation code is used in the p_partner_relationship record. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerRelationshipAccess |
| | Relationships between pairs of partners. Among other relationships, this also relates the FAMILY class partners to the PERSON class partners to indicate members of a family. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerLedgerAccess |
| | Used to keep track of partner keys. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PMembershipAccess |
| | Details of a membership. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerMembershipAccess |
| | membership of a partner More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerMembershipPaidAccess |
| | There is a record for each payment of a membership, or hours served. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDataLabelAccess |
| | This table is used to define data labels for individual use in each office. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDataLabelUseAccess |
| | This table defines where a data label is used and the order the labels appear in. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDataLabelValuePartnerAccess |
| | This table holds the label values for partner related data. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDataLabelLookupCategoryAccess |
| | This table holds the categories that can be used for data label values. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PDataLabelLookupAccess |
| | This table holds all lookup values that can be used for data label values. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PTaxAccess |
| | Tax reference numbers. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PInterestCategoryAccess |
| | Categories for Area of Interest. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PInterestAccess |
| | Area of Interest. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerInterestAccess |
| | Partner Area of Interest. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerMergeAccess |
| | Partner merge history. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PReminderCategoryAccess |
| | This table contains the codes that indicate the categories of reminders. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerReminderAccess |
| | A reminder that can be linked to a Partner or Partner contact. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerGiftDestinationAccess |
| | Tracks the current gift destination for the Partner and maintains a history. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerShortCodeAccess |
| | Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PProcessAccess |
| | Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PStateAccess |
| | A particular state within a process which can apply to a Partner. Each state will probably need to have an Idle state to indicate when no state applies. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PActionAccess |
| | A particular action within a process which can be performed on a Partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerStateAccess |
| | A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to them. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerActionAccess |
| | A particular action which has been or needs to be applied to a Partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFirstContactAccess |
| | Lookup table for First Contact Codes (ie. how did person first hear about us) More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerSetAccess |
| | Defines a Partner set. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerSetPartnerAccess |
| | Places Partners in a Partner set. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerCommentAccess |
| | Allows multiple as well as arbitrary-length partner comments. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PProposalSubmissionTypeAccess |
| | Submission type for foundation proposals e.g. EMAIL, LETTER. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFoundationAccess |
| | Foundations - a type of ORGANISATION for fundraising proposals. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFoundationProposalStatusAccess |
| | Foundation proposal status codes and descriptions. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFoundationProposalAccess |
| | Proposals submitted to a Foundation. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFoundationProposalDetailAccess |
| | A proposal may be for more than one project or key ministry. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFoundationDeadlineAccess |
| | The month and day of reviews so that proposals can be sent in time. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PFileInfoAccess |
| | Store information about the physical location of a file linked into Petra. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerFileAccess |
| | Link file with a partner. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PmPersonFileAccess |
| | Link file with a person. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PPartnerContactFileAccess |
| | Link file with a partner contact. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PConsentHistoryAccess |
| | Keeps track of all data changes for GDPR. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PConsentChannelAccess |
| | All possible channels to get data changes and consent. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PConsentPurposeAccess |
| | Purposes for consent, for which the data may be used. More...
|
| |
| class | Ict.Petra.Server.MPartner.Partner.Data.Access.PConsentHistoryPermissionAccess |
| | The history of consent for personal data. More...
|
| |
1.9.4