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 Each Record (including last record) must start on new line and must end with a newline character.
4 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'.
5 For all fields of type 'Amount', the decimal point with precision value 2 will be explicit and needs to be mentioned within the file.
6 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 line Length should be less than or equal to 9 Length should be less than or equal to 9
in the file. For File Header Record value digits. digits. Must NOT be - '0', 'NULL',
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', 'Special
Characters'. 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 be - 'NULL', 'Space', 'Numeric character', be - 'NULL', 'Space', 'Numeric
Office '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 NOT
records present in the file. This will be - 'NULL', 'Space','Negative Number', be - 'NULL', 'Space','Negative Number',
always be equal to 1.This field is a 'Special Characters'. '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 line Can only be a numeric character I.e. Must NOT Can only be a numeric character I.e. Must
in the file be - '0', 'NULL', 'Space', 'Special Characters', NOT be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', 'Negative Characters', 'Decimal', 'Non-numeric
Number'. Length should be less than or equal character', 'Negative Number'. Length should
to 9 digits. 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', 'Special
Characters'. 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 NOT
Correction File be - 'NULL', 'Space', 'Numeric character', 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 equal
should be in DDMMYYYY format 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 7 uniqueness uniqueness
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 correction
NPSCAN on successful processing of type of file.Should be the transaction id
an original file. 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 DDO
Headers for the corresponding batch header Header Records present for the 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 all
the file headers.Count should be >= 1 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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
Government’s of values in field "Control Total for Tier 1 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
Contribution Government’s Contribution" across all 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
DDO records. 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be >= 0.00 Value should be Decimal. Must be >=
0.00

12 Control Total for DECIMAL 20,2 M M The value here should be same as sum Length<=21. i.e., The amount should be Length<=21. i.e., The amount should be
Subscriber’s mandatory of values in field "Control Total for Tier 1 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
contribution Subscriber’s mandatory contribution" 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
across all DDO records of the PAO. 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be >= 0.00 Value should be Decimal. Must be >=
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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
of values in fields "Control Total for Tier rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
1 Government’s Contribution " and 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
"Control Total for Tier 1 Subscriber’s 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
mandatory contribution" in the Batch numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Header Value should be Decimal. Must be >= 0.00 Value should be Decimal. Must be >=
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 line Can only be a numeric character I.e. Must NOT Can only be a numeric character I.e. Must
in the file be - '0', 'NULL', 'Space', 'Special Characters', NOT be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', 'Negative Characters', 'Decimal', 'Non-numeric
Number'. Length must e less than or equal to 9 character', 'Negative Number'. Length must e
digits 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', 'Special
Characters'. 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 be
'0', 'NULL', 'Space', 'Special Characters', - '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 contribution Can only be a numeric character I.e. Must NOT Can only be a numeric character I.e. Must
details for each DDO Header. be - '0', 'NULL', 'Space', 'Special Characters', NOT be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', 'Negative Characters', 'Decimal', 'Non-numeric
Number'. Length must be less than or equal to character', 'Negative Number'. Length must e
9 digits 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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
Government’s of values in field "Tier 1 Government’s rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
Contribution Contribution amount" across all 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
Subscriber records of the DDO. 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be > 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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
Subscriber’s mandatory of values in field "Subscriber’s Tier 1 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
contribution mandatory contribution amount" across 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
all Subscriber records of the DDO. 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be > 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 line Can only be a numeric character I.e. Must NOT Can only be a numeric character I.e. Must
in the file be - '0', 'NULL', 'Space', 'Special Characters', NOT be - '0', 'NULL', 'Space', 'Special
'Decimal', 'Non-numeric character', 'Negative Characters', 'Decimal', 'Non-numeric
Number'. Length should be less than or equal character', 'Negative Number'. Length should
to 9 digits. 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 be
'0', 'NULL', 'Space', 'Special Characters', - '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 Characters',
'Decimal', 'Non-numeric character', 'Decimal', 'Non-numeric character',
'Negative Number'. 'Negative Number'.

5 Serial No. INTEGER 9 M M Serial No. assigned to each SD Record. Should start with '1'. Can only be a Should start with '1'. Can only be a
Running serial number starting with 1. numeric character I.e. Must NOT be '0', numeric character I.e. Must NOT be '0',
'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 Number Can only be a numeric character I.e. Must Can only be a numeric character I.e.
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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
Contribution amount subscriber’s Tier I account rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be > 0.00 Value should be Decimal. Must be >
0.00

8 Subscriber’s mandatory DECIMAL 20,2 M M Self contribution to individual Length<=21. i.e., The amount should be Length<=21. i.e., The amount should be
contribution amount subscriber’s Tier I account rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be > 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<=21. i.e., The amount should be Length<=21. i.e., The amount should be
amount for the of values in fields "Government’s Tier 1 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg.,
subscriber Contribution amount" and "Subscriber’s 50.75 Must NOT be '0', 'NULL', 'Space', 50.75 Must NOT be '0', 'NULL', 'Space',
Tier 1 mandatory contribution amount" 'Special Characters', 'Decimal', 'Non- 'Special Characters', 'Decimal', 'Non-
for each subscriber. numeric character', 'Negative Number'. numeric character', 'Negative Number'.
Value should be Decimal. Must be > 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 be
Arrear. Must be null if type of less than or equal to 75 characters 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