Variable pages · IRS 990 Master Concordance

PF_AX51_TRANSF_FR_CE_ADDR_ZIP

Postal code

Description
Foreign Address - Postal code
Table
PF-P99-T51-TRANSFER-FROM-CE (many)
Part
Auxiliary schedules and attachments (statements filed with the 990-PF)
Location
F990-PF-PART-99-AUX-SCHED-51
Type
text
Scope
PF – 990-PF
Database
F990PF
Forms
PF
6 / 8
xpaths observed / mapped
1.6k
filings with a value
2009–2024
tax years observed
0 + 3 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
▲ warnValues have the ZIP format92.4% of values match ^(99999|999999999|99999-9999)$
✓ passStored as textdata type is text
✓ passNo placeholder valuesno all-zero / all-nine placeholders among the most common values

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoTransfersFrmControlledEntities/TransfersFromControlledEntGrp/USAddress/ZIPCdmany-to-one table, but 71% of values sit in no repeating element✓ accepted
noteGenuine repeating group (XSD maxOccurs > 1; repeat_root is the group when a filing has several rows); most filings have one instance.
MANY_NOT_REPEATINGⓘ infoTransfersFrmControlledEntities/FromControlledEntity/AddressUS/ZIPCodemany-to-one table, but 70% of values sit in no repeating element✓ accepted
noteGenuine repeating group: other elements of the same table repeat within filings (TY2009-2024); this element of an older or newer schema did not repeat in the filings observed.
MANY_NOT_REPEATINGⓘ infoTransfersFrmControlledEntities/TransfersFromControlledEntGrp/USAddress/ZIPCodemany-to-one table, but 76% of values sit in no repeating element✓ accepted
noteGenuine repeating group: other elements of the same table repeat within filings (TY2009-2024); this element of an older or newer schema did not repeat in the filings observed.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1TransfersFrmControlledEntities/FromControlledEntity/AddressUS/ZIPCodePF2009–20121320.123%28.8%
x2TransfersFrmControlledEntities/FromControlledEntity/AddressForeign/PostalCodePF2010–201280.00751%
x3TransfersFrmControlledEntities/TransfersFromControlledEntGrp/USAddress/ZIPCodePF2013–2013510.111%23.5%
x4TransfersFrmControlledEntities/TransfersFromControlledEntGrp/ForeignAddress/PostalCodePF2013–201350.0109%
x5TransfersFrmControlledEntities/TransfersFromControlledEntGrp/USAddress/ZIPCdPF2014–20241,2600.141%26.4%
x6TransfersFrmControlledEntities/TransfersFromControlledEntGrp/ForeignAddress/ForeignPostalCdPF2014–20241240.0174%27.4%
x7TransfersFrmControlledEntities/FromControlledEntity/ForeignAddress/PostalCodePFnot observed0
x8TransfersFrmControlledEntities/FromControlledEntity/USAddress/ZIPCodePFnot observed0

% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.

Coverage by tax year

Filings’09’10’11’12’13’14’15’16’17’18’19’20’21’22’23’24
x114303949
x2323
x351
x45
x5676069697196145158174189162
x6645510101718121720
Fill rate: % of all filings of the return type (largest xpath)
990-PF1<1<1<1<1<1<1<1<1<1<1<1<1<1<1<1

Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.

Values

FormatFilingsShare
999991,38687.2%
999999999825.2%
AA9-9999462.9%
AA99999161.0%
AA99AA90.6%
AA9 9AA80.5%

Format of the values: 9 a digit, A a letter.

Example filings

Tax yearReturnXpathOrganizationValue
2024990PFx6The David and Lucile Packard FoundationKY11104XML
2024990PFx5SMITH RICHARDSON FOUNDATION INC27408XML
2013990PFx4Gordon E & Betty I Moore Foundation22440XML
2013990PFx3THE JOHN BERTRAM HOUSE INC01907XML
2012990PFx2The David and Lucile Packard FoundationJE48PWXML
2012990PFx1STUDENT AGENCIES FOUNDATION INC14850XML