IN_PAN (IN - Permanent Account Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IN PAN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IN_PAN
The country a linked concept is active or generally relevant for. Country scope IN (India)
Language-specific name. Monolingual name Permanent Account Number (hi), Permanent Account Number (en)
Language-specific short name. Monolingual short name IN - Permanent Account Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Permanent Account Number (PAN) is the ten-character code that the Indian Income Tax Department issues to every individual and entity with taxable income. It is required for tax returns, for opening bank accounts and for many contracts, and it forms part of the goods and services tax registration number.
Category of business identifiers. Identifier category Identification Number
Legacy property. A technical SAP code. SAP mapping STCD2

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
Regular expression/IN PAN/format Validates the format of the Indian Permanent Account Number (PAN), the tax identifier that every individual and entity with taxable income holds. The pattern accepts ten characters made up of five letters, four digits and a final check letter, where the fourth letter marks the type of holder. IDENTIFIER_FORMAT
^(\w\s*\.*-*){3}(P|F|C|H|A|T|B|L|J|G)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\w\s*\.*-*){1}$
Regular expression/IN PAN/natural person Identifies a Permanent Account Number that belongs to a natural person rather than to a company. In the ten-character number of five letters, four digits and a check letter, the fourth character shows the type of holder, and the letter P stands for an individual acting as proprietor. NATURAL_PERSON_IDENTIFICATION
^(\w\s*\.*-*){3}(P)(\w\s*\.*-*){1}(\d\s*\.*-*){4}(\w\s*\.*-*){1}$

Data quality rules

Data quality rule The country a linked concept is active or generally relevant for. Country scope Informal and comprehensive human-readable definition of a concept. Description Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
Identifier format inaccurate (PAN code (India))
REPRESENTATIONAL_CONSISTENCY
IN (India) The Indian PAN code consists of ten characters: five letters, four digits and one final letter. This rule checks whether the value is written exactly in that reference format and flags any whitespace, dot or hyphen that the format does not provide for. INFO IDEA(2020-01-01)
Identifier format invalid (PAN code (India))
REPRESENTATIONAL_CONSISTENCY
IN (India) The Indian Permanent Account Number (PAN) is composed of five letters, four numerical digits and a final letter. This rule checks conformance with that reference scheme, disregarding any whitespaces, hyphens or dots in the value. A typical PAN looks like AFZPK7190K, and the arrangement of letters and numbers is as follows.

The first three characters are three letters forming a sequence running from AAA to ZZZ. The fourth character represents the status of the PAN holder: P for an individual, F for a firm, C for a company, H for a Hindu Undivided Family, A for an Association of Persons, T for a trust, B for a Body of Individuals, L for a local authority, J for an artificial juridical person and G for government. The fifth character is the first character either of the surname of the person, in the case of a personal PAN card where the fourth character is P, or of the name of the entity, trust, society or organisation in the case of a company, Hindu Undivided Family, firm, Association of Persons, trust, Body of Individuals, local authority, artificial juridical person or government, that is where the fourth character is C, H, F, A, T, B, L, J or G. Characters six to nine are a sequential number running from 0001 to 9999, and the tenth character is a letter serving as a checksum that verifies the validity of the PAN.

ERROR RELEASED(2020-01-01)
Identifier missing (PAN code (India))
COMPLETENESS
IN (India) A business partner in India requires a PAN code, and this rule reports records in which it has not been maintained. INFO RELEASED(2024-04-16)
Inconsistency between PAN and GST number (India)
CONSISTENCY
IN (India) The Indian Permanent Account Number (PAN) is the tax identification number of the country and is ten characters long. The Indian GST number is built around it: a state code, then exactly the ten characters of the PAN, then a digit giving the number of entities registered under the same PAN, then the letter Z by default, and finally a checksum character that can be a digit or a letter.

This rule checks that both a PAN and an Indian GST number are present and that the ten characters inside the GST number are identical to the PAN. If they are not, either the PAN or the GST number is wrong.

ERROR RELEASED(2020-12-28)
Mandatory identifier not maintained (India)
COMPLETENESS
IN (India) A business partner in India should carry at least one of two identifiers: the PAN code or the GST number. If neither is available, the record is invalid. INFO RELEASED(2024-04-16)