1.22.2 FATCA Maintenance Header Details

This topic provides information on FATCA Maintenance Header Details.

Serial Number: 1

Segment Identification Number: 00FAT

Description: This segment is used for providing information related to FATCA Maintenance header Details.

Attributes: Mandatory

Table 1-102 FATCA Maintenance Header Details

Field Name (as expected in the file) Data type Length Attributes Characteristics/rules Values
SEGMENTID VARCHAR2 20 Mandatory - Segment ID - 00FAT
SEQUENCENUMBER NUMBER 10 Mandatory - Sequence Number
PROCESSID VARCHAR2 50 Mandatory - Process ID
BULKCLIENTCODE VARCHAR2 12 Mandatory - Bulk Client Code
IMPORTFILENAME VARCHAR2 255 Mandatory - Import File Name
UPLOADMODE VARCHAR2 1 Mandatory - Mode of operation which has to be performed on the record
FATCAREFNO VARCHAR2 16 Mandatory - Represents the FATCA Reference Number
FATCAENTITYTYPE VARCHAR2 2 Mandatory - Represents the FATCA Entity Type
FATCAENTITYID VARCHAR2 12 Mandatory - Represents the FATCA Entity ID
FATCAENTITYNAME VARCHAR2 100 Mandatory - Represents the FATCA Entity name
FATCAENTITYCATTYPE VARCHAR2 1 Mandatory - Represents the FATCA Entity Category type
FATCACLASSIFICATION VARCHAR2 25 Mandatory - Represents the FATCA Classification
FATCACLASSIFICATIONREASON VARCHAR2 25 Mandatory - Represents the FATCA Classification Reason
FATCACOMPLAINTREASON VARCHAR2 255 Optional - Represents the FATCA Complaint Reason
AUTH_STAT VARCHAR2 1 Mandatory - Represents the Authorisation Status:
  • A - Authorised
  • U - Unauthorised
USERID VARCHAR2 15 Mandatory - Represents the user ID who has entered the latest record
REPORTABLE NUMBER 1 Optional - FATCA Reportable - Yes/No
WITHHOLDABLE NUMBER 1 Optional - FATCA Withholdable - Yes/No