cra by cuiliqing

VIEWS: 15 PAGES: 5

									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

								
To top