Classes
class	BankTDSAccess
	auto generated More...

class	ContactTDSAccess
	auto generated More...

class	DataConsentTDSAccess
	auto generated More...

class	ExtractTDSAccess
	auto generated More...

class	PAcquisitionAccess
	This table is used to describe how a partner first came into contact with the organisation. Which department entered them. More...

class	PActionAccess
	A particular action within a process which can be performed on a Partner. More...

class	PAddresseeTypeAccess
	Ex. Fam - Family, SM - Single Male, etc. More...

class	PartnerAddressAggregateTDSAccess
	auto generated More...

class	PartnerContactSetupTDSAccess
	auto generated More...

class	PartnerEditTDSAccess
	auto generated More...

class	PartnerFindTDSAccess
	auto generated More...

class	PartnerImportExportTDSAccess
	auto generated More...

class	PartnerInfoTDSAccess
	auto generated More...

class	PartnerSetupTDSAccess
	auto generated More...

class	PBankAccess
	Details of an bank. More...

class	PBankingDetailsAccess
	Any bank details for a partner can be stored in this table. More...

class	PBankingDetailsUsageAccess
	Links p_partner - p_banking_details combination to a usage type. More...

class	PBankingDetailsUsageTypeAccess
	Usage type information for Banking Details. More...

class	PBankingTypeAccess
	Tells of what type this banking-detail is (bank-account, visa, mastercard, etc. More...

class	PBusinessAccess
	List of businesses with codes. More...

class	PChurchAccess
	Specific information about a church which is a partner. More...

class	PConsentChannelAccess
	All possible channels to get data changes and consent. More...

class	PConsentHistoryAccess
	Keeps track of all data changes for GDPR. More...

class	PConsentHistoryPermissionAccess
	The history of consent for personal data. More...

class	PConsentPurposeAccess
	Purposes for consent, for which the data may be used. More...

class	PDataLabelAccess
	This table is used to define data labels for individual use in each office. More...

class	PDataLabelLookupAccess
	This table holds all lookup values that can be used for data label values. More...

class	PDataLabelLookupCategoryAccess
	This table holds the categories that can be used for data label values. More...

class	PDataLabelUseAccess
	This table defines where a data label is used and the order the labels appear in. More...

class	PDataLabelValuePartnerAccess
	This table holds the label values for partner related data. More...

class	PDenominationAccess
	List of denomination codes for churches. More...

class	PFamilyAccess
	Contains details about a family in Partnership with us. May have P_Person records linked to it. More...

class	PFileInfoAccess
	Store information about the physical location of a file linked into Petra. More...

class	PFirstContactAccess
	Lookup table for First Contact Codes (ie. how did person first hear about us) More...

class	PFoundationAccess
	Foundations - a type of ORGANISATION for fundraising proposals. More...

class	PFoundationDeadlineAccess
	The month and day of reviews so that proposals can be sent in time. More...

class	PFoundationProposalAccess
	Proposals submitted to a Foundation. More...

class	PFoundationProposalDetailAccess
	A proposal may be for more than one project or key ministry. More...

class	PFoundationProposalStatusAccess
	Foundation proposal status codes and descriptions. More...

class	PInterestAccess
	Area of Interest. More...

class	PInterestCategoryAccess
	Categories for Area of Interest. More...

class	PLocationAccess
	Address and other data related to that address. More...

class	PLocationTypeAccess
	Types of address e.g. home, business. More...

class	PMembershipAccess
	Details of a membership. More...

class	PmPersonFileAccess
	Link file with a person. More...

class	POccupationAccess
	List of occupations with codes. More...

class	POrganisationAccess
	Details of an organisation. More...

class	PostcodeRegionsTDSAccess
	auto generated More...

class	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	PPartnerActionAccess
	A particular action which has been or needs to be applied to a Partner. More...

class	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	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	PPartnerAttributeTypeAccess
	Holds various Partner Attribute Types. More...

class	PPartnerBankingDetailsAccess
	Links p_partner table with p_banking_details table for many to many relationship. More...

class	PPartnerClassesAccess
	The class a partner is (PERSON, UNIT, etc. More...

class	PPartnerCommentAccess
	Allows multiple as well as arbitrary-length partner comments. More...

class	PPartnerContactFileAccess
	Link file with a partner contact. More...

class	PPartnerFileAccess
	Link file with a partner. More...

class	PPartnerGiftDestinationAccess
	Tracks the current gift destination for the Partner and maintains a history. More...

class	PPartnerGraphicAccess
	Any graphic associated to a partner can be stored here. More...

class	PPartnerInterestAccess
	Partner Area of Interest. More...

class	PPartnerLedgerAccess
	Used to keep track of partner keys. More...

class	PPartnerLocationAccess
	Links partners with locations (addresses) and has specific info about the link (e.g. date effective) More...

class	PPartnerMembershipAccess
	membership of a partner More...

class	PPartnerMembershipPaidAccess
	There is a record for each payment of a membership, or hours served. More...

class	PPartnerMergeAccess
	Partner merge history. More...

class	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	PPartnerReminderAccess
	A reminder that can be linked to a Partner or Partner contact. More...

class	PPartnerSetAccess
	Defines a Partner set. More...

class	PPartnerSetPartnerAccess
	Places Partners in a Partner set. More...

class	PPartnerShortCodeAccess
	Stores one or more short codes for a Partner (eg. a donor or recipient code for online giving system) More...

class	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	PPartnerStatusAccess
	List of statuses for partners. More...

class	PPartnerTaxDeductiblePctAccess
	Specifies the percentage of incoming gifts to this recipient that can be considered tax deductible. More...

class	PPartnerTypeAccess
	Types assigned to each partner. Also known as special types. More...

class	PPersonAccess
	DEPRECATED. USE P_FAMILY INSTEAD. Details of a person. A person must also have a related FAMILY class p_partner record. More...

class	PProcessAccess
	Refers to a process through which a Partner may go (eg. application, different status of donor - small->medium->big, etc) More...

class	PProposalSubmissionTypeAccess
	Submission type for foundation proposals e.g. EMAIL, LETTER. More...

class	PRecentPartnersAccess
	The partners a user has been working with recently. More...

class	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	PRelationCategoryAccess
	This table contains the codes that indicate the categories of relations (grouping). More...

class	PReminderCategoryAccess
	This table contains the codes that indicate the categories of reminders. More...

class	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	PTaxAccess
	Tax reference numbers. More...

class	PTitleAccess
	Titles available for use. More...

class	PtMaritalStatusAccess
	This table contains the codes indicating someones marital status. More...

class	PTypeAccess
	List of all possible special types for a partner. More...

class	PTypeCategoryAccess
	This table contains the codes that indicate the categories of partner (special) types. More...

class	PUnitAccess
	Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc. More...

class	PVenueAccess
	Details of a venue. More...

class	UmUnitStructureAccess
	This contains parent/child relationships. More...

class	UUnitTypeAccess
	General information about the unit such as unit type and entry conference. More...

Classes