VIEWS: 15 PAGES: 5 POSTED ON: 10/30/2011 Public Domain
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<=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 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg., Contribution 1 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 >= 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<=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 rounded off to two decimal places. Eg., rounded off to two decimal places. Eg., contribution 1 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 >= 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<=21. i.e., The amount should be Length<=21. i.e., The amount should be of values in fields "Control Total for rounded off to two decimal places. Eg., rounded off to two decimal places. Eg., Tier 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 >= 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<=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 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<=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 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