CRA - File Format PAO Contribution Upload SRS - Ver 1.0 (Vol 2)
PAO - Subscriber Contribution File-Format to prepare text file. File created with this format will be input to FVU.
This file format is to prepare the contribution file {text (.txt) file} which will be an input to File Validation Utility (FVU). File upload
to NPSCAN system can be done only after this .txt file is passed through the FVU
General Notes for All Upload Types and Record Types:
1 File should be generated in ASCII Format with "txt" as filename extension.
2 The input file will be a delimited file. Each field in the file will be caret ^ seperated.
3 The constant values as mentioned in the file format below (values of fields viz. 'Record Type', 'Upload Type' etc.) need to be mentioned
in BLOCK letters only. i.e. value of field 'Record Type' in case of 'File Header' should be specified as 'FH' and not 'fh'.
4 For all fields of type 'Amount', the decimal point with precision value 2 will be explicit and needs to be mentioned within the file.
5 The created text file will be in the following format:
(i) The first line of the file will be the File Header.
(ii) The first Batch header will be present after the File Header.
(iii) The first DDO header associated with the Batch Header will be present after the Batch Header.
(iv) The details of the subscriber associated with the DDO will be present after each DDO Header record.
(v) The second DDO header (if present) will be present after the last Subscriber detail record of the first DDO header.
M - Mandatory O - Optional
File Header Record
Sr. No Field Name Data Type Size M/O M/O Valid Values Description Validations (Regular File) Validations (Correction File)
Regular Correction
(R) (C)
1 Line Number INTEGER 9 M M 1 Running sequence number for each Length should be less than or equal to 9 Length should be less than or equal to 9
line in the file. For File Header Record digits. digits. Must NOT be - '0', 'NULL',
value will be 1 Must NOT be - '0', 'NULL', 'Space', 'Space', 'Special Characters', 'Decimal',
'Special Characters', 'Decimal', 'Non- 'Non-numeric character', 'Negative
numeric character', 'Negative Number'. Number'.For File Header record value
For File Header record value must always must always be equal to '1'.
be equal to '1'.
2 Record Type CHAR 2 M M FH Value should be "FH" signifying "File Only Value allowed is "FH". Must NOT be - Only Value allowed is "FH". Must NOT be -
Header" record 'NULL', 'Space', 'Numeric character', 'Special 'NULL', 'Space', 'Numeric character',
Characters'. 'Special Characters'.
3 Uploaded By CHAR 1 M M 'P' Value should be "P" Value should be equal to "P". Must NOT Value should be equal to "P". Must NOT
P-Pay & Accounts Office be - 'NULL', 'Space', 'Numeric character', be - 'NULL', 'Space', 'Numeric
'Special Characters'. character', 'Special Characters'.
4 PAO Reg.No. INTEGER 7 M M Pay & Accounts Office Identification Only numeric values are allowed. Must Only numeric values are allowed. Must
Number. NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Characters', 'Decimal', 'Alphabets', Characters', 'Decimal', 'Alphabets',
'Negative Number'. Length should be 'Negative Number'. Length should be
exactly 7 digits for PAO Reg.No. exactly 7 digits for PAO Reg.No.
5 Number of Batches INTEGER 9 M M 1 Number of batches will contain the Value must be = 1. Value must be = 1.
value for the total number of batch Value should be Numeric and Must NOT Value should be Numeric and Must
records present in the file. This will be - 'NULL', 'Space','Negative Number', NOT be - 'NULL', 'Space','Negative
always be equal to 1.This field is a 'Special Characters'. Number', 'Special Characters'.
provision for future use if more than
one batches per file are required.
6 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
7 Filler CHAR 9 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
8 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
9 Filler CHAR 9 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
10 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
11 Filler CHAR 9 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
12 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
NSDL Confidential 419
CRA - File Format PAO Contribution Upload SRS - Ver 1.0 (Vol 2)
Batch Header Record
Sr. No Field Name Data Type Size M/O M/O Valid Values Description Validations (Original File) Validations (Correction File)
Regular Correction
(R) (C)
1 Line Number INTEGER 9 M M Running sequence number for each Can only be a numeric character I.e. Must Can only be a numeric character I.e. Must
line in the file NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Characters', 'Decimal', 'Non-numeric Characters', 'Decimal', 'Non-numeric
character', 'Negative Number'. Length should character', 'Negative Number'. Length
be less than or equal to 9 digits. should be less than or equal to 9 digits.
2 Record Type CHAR 2 M M BH Value should be "BH" (Batch Header) Only Value allowed = "BH". Must NOT be - Only Value allowed = "BH". Must NOT be -
for the batch header record 'NULL', 'Space', 'Numeric character', 'Special 'NULL', 'Space', 'Numeric character',
Characters'. 'Special Characters'.
3 Batch Number INTEGER 9 M M 1 Value should indicate batch no. of the Length should be less than or equal to 9 Length should be less than or equal to 9
current batch. digits. digits.
Must NOT be - '0', 'NULL', 'Space', Must NOT be - '0', 'NULL', 'Space',
'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
4 Contribution File Type CHAR 1 M M R - Original File C- R / C. R - Original, C - Correction Value should be equal to "R". Must NOT Value should be equal to "C". Must
Correction File be - 'NULL', 'Space', 'Numeric character', NOT be - 'NULL', 'Space', 'Numeric
'Special Characters'. character', 'Special Characters'.
5 PAO Reg.No. INTEGER 7 M M Pay & Accounts Office Identification Only numeric values are allowed. Must Only numeric values are allowed. Must
Number NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Characters', 'Decimal', 'Alphabets', Characters', 'Decimal', 'Alphabets',
'Negative Number'. Length should be 'Negative Number'. Length should be
exactly equal to 7 digits. exactly equal to 7 digits.
6 Date of file creation Date 8 M M Date of creation of the '.txt' file. Date Can only be a numeric character I.e. Must Can only be a numeric character I.e.
should be in ddmmyyyy format. NOT be - '0', 'NULL', 'Space', 'Special Must NOT be - '0', 'NULL', 'Space',
Characters', 'Decimal', 'Non-numeric 'Special Characters', 'Decimal', 'Non-
character', 'Negative Number'.Length numeric character', 'Negative
should be exactly equal to 8 digits. Date Number'.Length should be exactly
should be in DDMMYYYY format equal to 8 digits. Date should be in
DDMMYYYY format
7 Batch Id INTEGER 20 M M Identification number to be specifed to Will be validated at central system for Will be validated at central system for
uniquely identify every batch. The first uniqueness uniqueness
7 digit should be the PAO Reg.No.
This 20 digit should be unique across
all files - regular or correction type of
files uploaded by PAO
8 Transaction Id INTEGER 13 O M Unique Transaction Id generated by Should be NULL for an original file. Mandatory Field in case of
NPSCAN on successful processing of correction type of file.Should be the
an original file. transaction id of the original file (file for
which correction file is being uploaded)
9 Total No. of DDO INTEGER 9 M M No of DDO Headers present in the file Should be equal to total number of DDO Should be equal to total number of
Headers for the corresponding batch header Header Records present for the DDO Header Records present for the
corresponding batch. Count should be >= corresponding batch. Count should be
1 >= 1
10 No. of subscribers INTEGER 9 M M Total number of Subscriber Detail Should be same as sum of values in field Should be same as sum of values in
contribution records in records across all DDO headers "Total No Of Subscribers" across all DDO field "Total No Of Subscribers" across
the file headers.Count should be >= 1 all DDO headers.Count should be >= 1
NSDL Confidential 420
CRA - File Format PAO Contribution Upload SRS - Ver 1.0 (Vol 2)
11 Control Total for DECIMAL 20,2 M M The value here should be same as sum Length= Value should be Decimal. Must be >=
0.00 0.00
12 Control Total for DECIMAL 20,2 M M The value here should be same as sum Length= Value should be Decimal. Must be >=
0.00 0.00
13 Filler DECIMAL 20,2 O O NULL Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
14 Grand Total DECIMAL 20,2 M M The value here should be same as sum Length= Value should be Decimal. Must be >=
0.00 0.00
15 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
DDO Header Record
Sr. No Field Name Data Type Size M/O M/O Valid Values Description Validations (Regular File) Validations (Correction File)
Regular Correction
(R) (C)
1 Line Number INTEGER 9 M M Running sequence number for each Can only be a numeric character I.e. Must Can only be a numeric character I.e. Must
line in the file NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Characters', 'Decimal', 'Non-numeric Characters', 'Decimal', 'Non-numeric
character', 'Negative Number'. Length must e character', 'Negative Number'. Length must
less than or equal to 9 digits e less than or equal to 9 digits
2 Record Type CHAR 2 M M DH Value should be "DH" for the DDO Only Value allowed = "DH". Must NOT be - Only Value allowed = "DH". Must NOT be -
header record 'NULL', 'Space', 'Numeric character', 'Special 'NULL', 'Space', 'Numeric character',
Characters'. 'Special Characters'.
3 Batch Number INTEGER 9 M M 1 Value should indicate batch no. of the Length should be less than or equal to 9 Length should be less than or equal to 9
current batch. digits. digits.
Value should be Numeric. Must NOT be - Value should be Numeric. Must NOT
'0', 'NULL', 'Space', 'Special Characters', be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', Characters', 'Decimal', 'Non-numeric
'Negative Number'. character', 'Negative Number'.
4 DDO Serial Number INTEGER 9 M M Running sequence number for each Length should be less than or equal to 9 Length should be less than or equal to 9
DDO header record in the file digits. digits.
Value should be Numeric and negative Value should be Numeric and negative
values are not accepted. Should be in values are not accepted. Should be in
sequence sequence
5 DDO Reg.No. CHAR 10 M M Reg.No. of DDO. Specifies the 10 Character Reg.No. of the Specifies the 10 Character Reg.No. of
DDO. Should be all CAPITALS. the DDO. Should be all CAPITALS.
NSDL Confidential 421
CRA - File Format PAO Contribution Upload SRS - Ver 1.0 (Vol 2)
6 Total No Of Subscribers INTEGER 9 M M Total number of subscribers Can only be a numeric character I.e. Must Can only be a numeric character I.e. Must
contribution details for each DDO NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Header. Characters', 'Decimal', 'Non-numeric Characters', 'Decimal', 'Non-numeric
character', 'Negative Number'. Length must be character', 'Negative Number'. Length must
less than or equal to 9 digits e less than or equal to 9 digits
7 Control Total for Tier 1 DECIMAL 20,2 M M The value here should be same as sum Length 0 Value should be Decimal. Must be > 0
8 Control Total for Tier 1 DECIMAL 20,2 M M The value here should be same as sum Length 0.00 Value should be Decimal. Must be >
0.00
9 Filler DECIMAL 20,2 O O NULL Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
10 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
Subscriber Details Record
Sr. No Field Name Data Type Size M/O M/O Valid Values Description Validations (Regular File) Validations (Correction File)
Regular Correction
(R) (C)
1 Line Number INTEGER 9 M M Running sequence number for each Can only be a numeric character I.e. Must Can only be a numeric character I.e. Must
line in the file NOT be - '0', 'NULL', 'Space', 'Special NOT be - '0', 'NULL', 'Space', 'Special
Characters', 'Decimal', 'Non-numeric Characters', 'Decimal', 'Non-numeric
character', 'Negative Number'. Length should character', 'Negative Number'. Length
be less than or equal to 9 digits. should be less than or equal to 9 digits.
2 Record Type CHAR 2 M M SD Value "SD" (Subscriber Detail) for Value should be 'SD - Must NOT be 'NULL', Value should be 'SD - Must NOT be 'NULL',
Subscriber Detail record 'Space', 'Numeric character'. 'Space', 'Numeric character'.
3 Batch Number INTEGER 9 M M 1 Value should indicate batch no. of the Length should be less than or equal to 9 Length should be less than or equal to 9
current batch. digits. digits.
Value should be Numeric. Must NOT be - Value should be Numeric. Must NOT
'0', 'NULL', 'Space', 'Special Characters', be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', Characters', 'Decimal', 'Non-numeric
'Negative Number'. character', 'Negative Number'.
4 DDO Serial Number INTEGER 9 M M Sequence number specified in the Length should be less than or equal to 9 Length should be less than or equal to 9
corresponding DDO header record in digits. digits.
the file. Value should be Numeric. Must NOT be Value should be Numeric. Must NOT be
'0', 'NULL', 'Space', 'Special Characters', '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', Characters', 'Decimal', 'Non-numeric
'Negative Number'. character', 'Negative Number'.
5 Serial No. INTEGER 9 M M Serial No. assigned to each SD Should start with '1'. Can only be a Should start with '1'. Can only be a
Record. Running serial number starting numeric character I.e. Must NOT be '0', numeric character I.e. Must NOT be '0',
with 1. 'NULL', 'Space', 'Special Characters', 'NULL', 'Space', 'Special Characters',
'Decimal', 'Non-numeric character', 'Decimal', 'Non-numeric character',
'Negative Number'. 'Negative Number'.
NSDL Confidential 422
CRA - File Format PAO Contribution Upload SRS - Ver 1.0 (Vol 2)
6 PRAN INTEGER 12 M M Permanent Retirement Account Can only be a numeric character I.e. Must Can only be a numeric character I.e.
Number NOT be '0', 'NULL', 'Space', 'Special Must NOT be '0', 'NULL', 'Space',
Characters', 'Decimal', 'Non-numeric 'Special Characters', 'Decimal', 'Non-
character', 'Negative Number'. numeric character', 'Negative Number'.
7 Government’s DECIMAL 20,2 M M Government contribution to individual Length 0.00 Value should be Decimal. Must be >
0.00
8 Subscriber’s mandatory DECIMAL 20,2 M M Self contribution to individual Length 0.00 Value should be Decimal. Must be >
0.00
9 Filler DECIMAL 20,2 NULL Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
10 Total Contribution DECIMAL 20,2 M M The value here should be same as sum Length 0.00 Value should be Decimal. Must be >
0.00
11 Contribution Type CHAR 1 M M A/C Value is 'C' for Contribution(Regular) Value must be 'C' for Value must be 'C' for
and 'A' for Arrears Contribution(Regular) and 'A' for Arrear. Contribution(Regular) and 'A' for Arrear.
Values other than 'A' or 'C' is not allowed Values other than 'A' or 'C' is not
allowed
12 Contribution Month INTEGER 2 M M Fixed length. mm. E.g. 01 for Length should be exactly equal to 2 digits. Length should be exactly equal to 2
January.Mandatory if type of Value should be Numeric. Must NOT be digits. Value should be Numeric. Must
contribution is Regular.Optional if type '0', 'NULL', 'Space', 'Special Characters', NOT be '0', 'NULL', 'Space', 'Special
of contribution is Arrear. 'Decimal', 'Non-numeric character', Characters', 'Decimal', 'Non-numeric
'Negative Number'. character', 'Negative Number'.
13 Contribution Year INTEGER 4 M M Fixed length. yyyy. E.g. 2005 Length should be exactly equal to 4 digits. Length should be exactly equal to 4
Mandatory if type of contribution is alue should be Numeric. Must NOT be '0', digits. alue should be Numeric. Must
Regular. Optional if type of contribution 'NULL', 'Space', 'Special Characters', NOT be '0', 'NULL', 'Space', 'Special
is Arrear. 'Decimal', 'Non-numeric character', Characters', 'Decimal', 'Non-numeric
'Negative Number'. character', 'Negative Number'.
14 Remarks CHAR 75 M M Mandatory if type of contribution is Length of the remarks entered should be Length of the remarks entered should
Arrear. Must be null if type of less than or equal to 75 characters be less than or equal to 75 characters
contribution is Regular.
15 Filler INTEGER 20 O O Must be NULL for the input file to FVU. Must be NULL for the input file to FVU. Must be NULL for the input file to FVU.
NSDL Confidential 423