Skip to content

FATCA / CRS Reports — Fields consumed

Why this page is structured this way: This is the destination-first view for FATCA / CRS Reports. Engineers building an integration with this destination get the complete field list on one page. To see where each field originated in onboarding, follow the per-section links via the atlas overview.

  • 33 unique fields consumed by FATCA / CRS Reports.
  • Source spans sections: A, B, C, J, S, V.
  • 33 rows cite a public spec source; 0 are [industry typical].

Sorted by source_section, then field_id.

source_sectionfield_idfield_namedestination_field_namedestination_formatfrequencytransformationquirks_notesspec_source
AA-ckyc_numberCKYC NumberCKYC_KINCHAR(14)on-event[direct]annual cadence; CKYC KIN linked to FATCA record at KRA; helps dedupe across intermediariesSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-country_of_birthCountry of Birth (Section A duplicate)COB_ALTCHAR(2)on-event[direct]same as J05; broker captures in both places; ISO-3166 alpha-2; reconciled at uploadSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-date_of_birthDate of BirthDOBDATE YYYYMMDDon-eventformattedconverted to YYYY-MM-DD per CRS XML schema; passed in OECD ReportableAccount blockSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-full_nameFull NameACCOUNT_HOLDER_NAMEVARCHAR(200)on-event[direct]must match PAN-name; CRS XML requires “ResCountryCode + TIN + Name” keySEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-nationalityNationalityNATIONALITY_ISOCHAR(2)on-event[direct]ISO-3166 alpha-2; not the same as tax residence in FATCA/CRS; separate field on KRA templateSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-pan_numberPAN NumberINDIA_TIN_PANCHAR(10)on-eventuppercasePAN serves as India TIN for FATCA/CRS; uploaded as primary tax-identifier with country=INSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-place_of_birthPlace of Birth (Section A)POB_ALTVARCHAR(50)on-event[direct]same as J06; FATCA template uses Section J entry; Section A entry used for KRASEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
AA-residential_statusResidential StatusRES_STATUS_CODECHAR(2)on-eventlookup against RRI/NRI/FN/PIO drives whether self-certification mandatory and which template variantSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
BB-corr_address_line1Correspondence Address Line1RES_ADDR_L1VARCHAR(100)on-event[direct]captured in CRS XML AddressFix.Street; required for ReportableAccount blockSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
BB-corr_cityCorrespondence CityRES_CITYVARCHAR(50)on-event[direct]CRS City fieldSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
BB-corr_countryCorrespondence CountryRES_ADDRESS_COUNTRYCHAR(2)on-eventlookup against Raddress country used as indicia under CRS; non-IN addr triggers self-cert review even if J01=YSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
BB-corr_pincodeCorrespondence PincodeRES_POSTCODEVARCHAR(10)on-event[direct]CRS PostCode field; 6 digits for IN; varies for foreign addressesSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
CC-emailEmailCONTACT_EMAILVARCHAR(100)on-eventlowercasecontact channel; not itself indicia; used for self-cert refresh remindersSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
CC-mobile_numberMobile NumberCONTACT_MOBILEVARCHAR(15)on-event[direct]contact channel for FATCA discrepancy queries; foreign mobile triggers indicia reviewSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-citizenship_countryCitizenship CountryCITIZENSHIPCHAR(2)on-event[direct]annual cadence; multi-valued (dual citizens); each citizenship potentially triggers separate CRS reportingSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-country_of_birthCountry of BirthCOUNTRY_OF_BIRTHCHAR(2)on-event[direct]annual cadence; ISO-3166 alpha-2; US birth -> US-person rebuttable presumption requiring renunciation evidenceSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-fatca_declaration_dateFATCA Declaration DateDECLARATION_DATEDATE YYYYMMDDon-eventformattedannual cadence; must be within last 12 months; KRA validates < 1y for re-upload eligibilitySEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-fatca_declaration_placeFATCA Declaration PlaceDECLARATION_PLACEVARCHAR(50)on-event[direct]annual cadence; declaration city/town; free-textSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-fatca_signatureFATCA SignatureSIGNATURE_BLOBBLOBon-event[direct]annual cadence; digital (e-Sign hash) or scanned wet signature; uploaded as image/PDF attachment to KRASEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-is_tax_resident_of_india_onlyIndia-only Tax Residency FlagIND_TAX_RES_ONLYCHAR(1)on-event[direct]annual cadence (FATCA Form re-affirmed yearly); if Y, J08-J12 left blank; central upload to KRA effective Jul 1, 2024SEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-is_us_personUS Person StatusUS_PERSON_FLAGCHAR(1)on-event[direct]annual cadence; triggers FATCA W-9 equivalent; if Y, US TIN/SSN mandatory and J04 (green card) askedSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-place_of_birth_cityPlace of Birth CityPOB_CITYVARCHAR(50)on-event[direct]annual cadence; free-text city/town; cross-validated with passport place-of-birth where availableSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-tax_countryTax Residence CountryTAX_RES_COUNTRYCHAR(2)on-event[direct]annual cadence; ISO-3166 alpha-2; one row per country of tax residence (max 5)SEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-tax_country_seqTax Country SequenceTAX_RES_SEQNUMBER(1)on-event[direct]annual cadence; 1-5; if J01=N, repeat block per non-IN tax residenceSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-tax_id_numberForeign Tax ID Number (TIN)FOREIGN_TINVARCHAR(30)on-event[direct]annual cadence; TIN format varies by country; OECD TIN-online portal used for format check; uploaded to KRA per Feb 2024 circularSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-tax_id_typeTax ID TypeTIN_TYPECHAR(2)on-event[direct]annual cadence; TIN/SSN/EIN; required to disambiguate identifier when country issues multiple typesSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-tin_not_available_reasonTIN Not Available ReasonTIN_ABSENT_RSNCHAR(2)on-event[direct]annual cadence; A/B/C codes per OECD CRS schema; reason B (unable to obtain) requires explanationSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-us_green_card_holderUS Green Card HolderGREEN_CARD_FLAGCHAR(1)on-event[direct]annual cadence; required if J02=Y; green-card holders are US tax persons even if Indian-residentSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
JJ-us_tin_ssnUS TIN / SSNUS_TINCHAR(11)on-event[direct]annual cadence; 9-digit SSN or US TIN; mandatory if J02=Y; format US-XXX-XX-XXXX acceptedSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
SS-kra_pos_codeKRA POS CodeFATCA_POS_CODEVARCHAR(20)on-event[direct]intermediary POS code stamped on FATCA upload to KRA; allows traceback to RFI per Feb 2024 circularSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
VV-overseas_address_line1Overseas Address Line1OVERSEAS_ADDR_L1VARCHAR(100)on-event[direct]NRI overseas residential address; CRS account-holder addressSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
VV-overseas_countryOverseas CountryOVERSEAS_COUNTRYCHAR(2)on-event[direct]NRI overseas address country; mandatory CRS indicia for non-resident accountsSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12
VV-tax_residency_certificateTax Residency CertificateTRC_DOCUMENTBLOBon-event[direct]NRI-only; supporting document for foreign-tax-residence claim; uploaded if claiming DTAA treaty benefitsSEBI/HO/MIRSD/SECFATF/P/CIR/2024/12

2026-05-14


AI-generated and not legal advice. See the project README for full disclaimer.