Docstoc

NPS-Lite-FileFormat_Sub_Contribution

Document Sample
NPS-Lite-FileFormat_Sub_Contribution Powered By Docstoc
					                          NL-OO/NL-AO - Subscriber Contribution File-Forma
          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.) ne
          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 with
  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 NL-AO/NL-CC header associated with the Batch Header will be present after the Batch Header.
                (iv) The details of the subscriber associated with the NL-AO/NL-CC will be present after each NL-AO/NL-CC H
                (v) The second NL-AO/NL-CC header (if present) will be present after the last Subscriber detail record of the fi

          M - Mandatory
          O - Optional


                                                              File Header Record
Sr. No       Field Name       Data Type        Size         M/O               M/O              Valid Values
                                                         Regular (R)     Correction (C)
         1 Line Number        INTEGER           9             M                 M         1




         2 Record Type          CHAR            2             M                 M         FH



         3 Uploaded By          CHAR            1             M                 M          'X' OR 'Y'



         4 NL-OO/NL-AO        INTEGER           7             M                 M
           Reg. No.
         5 Number of        INTEGER      9         M               M          1
           Batches




         6 FH Record        INTEGER     20         M               M
           Hash


         7 FVU Version       CHAR        9         M               M




         8 FVU File Level   INTEGER     20         M               M
           Hash



         9 Filler            CHAR        9         O               O

     10 Filler              INTEGER     20         O               O

     11 Filler               CHAR        9         O               O

     12 Filler              INTEGER     20         O               O




                                                Batch Header Record
Sr. No        Field Name    Data Type   Size      M/O             M/O              Valid Values
                                               Regular (R)   Correction (C)
         1 Line Number      INTEGER      9         M               M




         2 Record Type       CHAR        2         M               M          BH
 3 Batch Number        INTEGER   9    M   M   1




 4 Contribution File    CHAR     1    M   M   R - Original File C-
   Type                                       Correction File


 5 NL-OO/NL-AO         INTEGER   7    M   M
   Reg. No.




 6 Date of file         Date     8    M   M
   creation




 7 Batch Id            INTEGER   20   M   M




 8 Transaction Id      INTEGER   13       M




 9 Total No. of NL-    INTEGER   9    M   M
   AO/NL-CC
   Headers


10 No. of              INTEGER   9    M   M
   subscribers
   contribution
   records in the
   file
     11 Control Total for   DECIMAL     20,2       M               M
        Co-Contribution




     12 Control Total for   DECIMAL     20,2       M               M
        Subscriber’s
        contribution




     13 Filler              DECIMAL     20,2       O               O          NULL

     14 Grand Total         DECIMAL     20,2       M               M




     15 Batch Header        INTEGER     20         M               M
        Record Hash




                                                                                   NL-AO/NL-CC Header Re
Sr. No       Field Name     Data Type   Size      M/O             M/O              Valid Values
                                               Regular (R)   Correction (C)
         1 Line Number      INTEGER      9         M               M




         2 Record Type       CHAR        2         M               M          DH
3 Batch Number        INTEGER    9     M   M   1




4 NL-AO/NL-CC         INTEGER    9     M   M
  Serial Number




5 NL-AO/NL-CC          CHAR     10     M   M
  Reg. No.




6 Total No Of         INTEGER    9     M   M
  Subscribers




7 Control Total for   DECIMAL   20,2   M   M
  Co-Contribution




8 Control Total for   DECIMAL   20,2   M   M
  Subscriber’s
  contribution
      9 Filler             DECIMAL     20,2       O               O          NULL
     10 NL-AO/NL-CC        INTEGER      20        M               M
        Header Record
        Hash




                                                                                         Subscriber Details R
Sr. No       Field Name    Data Type   Size      M/O             M/O              Valid Values
                                              Regular (R)   Correction (C)
         1 Line Number     INTEGER      9         M               M




         2 Record Type      CHAR        2         M               M          SD


         3 Batch Number    INTEGER      9         M               M          1




         4 NL-AO/NL-CC     INTEGER      9         M               M
           Serial Number




         5 Serial No.      INTEGER      9         M               M




         6 PRAN            INTEGER     12         M               M
 7 Co-Contribution   DECIMAL   20,2   M   M
   amount




 8 Subscriber’s      DECIMAL   20,2   M   M
   contribution
   amount




 9 Filler            DECIMAL   20,2           NULL
10 Total             DECIMAL   20,2   M   M
   Contribution
   amount for the
   subscriber




11 Contribution       CHAR      1     M   M   C,A,0,2
   Type



12 Contribution      INTEGER    2     M   M
   Month




13 Contribution      INTEGER    4     M   M
   Year
14 Remarks          CHAR     75   M   M




15 Subscriber      INTEGER   20   O   O
   Detail Record
   Hash
ion File-Format For NPS-Lite



character.
Type', 'Upload Type' etc.) need to be mentioned
 specified as 'FH' and not 'fh'.
  needs to be mentioned within the file.




nt after the Batch Header.
 after each NL-AO/NL-CC Header record.
scriber detail record of the first NL-AO/NL-CC header.




                       Description                    Validations (Regular File)          Validations (Correction File)

             Running sequence number for Length should be less than or equal           Length should be less than or
             each line in the file. For File to 9 digits.                              equal to 9 digits. Must NOT be -
             Header Record value will be 1 Must NOT be - '0', 'NULL', 'Space',         '0', 'NULL', 'Space', 'Special
                                             'Special Characters', 'Decimal', 'Non-    Characters', 'Decimal', 'Non-
                                             numeric character', 'Negative             numeric character', 'Negative
                                             Number'.                                  Number'.For File Header record
                                             For File Header record value must         value must always be equal to '1'.
                                             always be equal to '1'.
             Value should be "FH"            Only Value allowed is "FH". Must NOT be   Only Value allowed is "FH". Must
             signifying "File Header" record - 'NULL', 'Space', 'Numeric character',   NOT be - 'NULL', 'Space', 'Numeric
                                               'Special Characters'.                   character', 'Special Characters'.

             Value should be "X" for NL-     Value should be equal to "X" or "Y".      Value should be equal to "X" or
             OO upload and "Y" for NL-AO Must NOT be - 'NULL', 'Space',                "Y". Must NOT be - 'NULL',
             upload                          'Numeric character', 'Special             'Space', 'Numeric character',
                                             Characters'.                              'Special Characters'.
             Reg. No. of the uploading       Only numeric values are allowed.          Only numeric values are allowed.
             entity.                         Must NOT be - '0', 'NULL', 'Space',       Must NOT be - '0', 'NULL',
                                             'Special Characters', 'Decimal',          'Space', 'Special Characters',
             If NL-OO uploads the file , NL- 'Alphabets', 'Negative Number'.           'Decimal', 'Alphabets', 'Negative
             OO Reg. No. should be           Length should be exactly 7 digits for     Number'. Length should be
             entered in this field.          NL-OO/NL-AO Reg. No.                      exactly 7 digits for NL-OO/NL-AO
                                                                                       Reg. No.
             If NL-AO uploads the file , NL-
             AO Reg. No. should be
             entered in this field.
Number of batches will contain      Value must be = 1.                         Value must be = 1.
the value for the total number      Value should be Numeric and Must           Value should be Numeric and
of batch records present in the     NOT be - 'NULL', 'Space','Negative         Must NOT be - 'NULL',
file. This will always be           Number', 'Special Characters'.             'Space','Negative Number',
equal to 1.This field is a                                                     'Special Characters'.
provision for future use if
more than one batches per
file are required.

Must be NULL for the file       Must be Null for input file to the FVU.        Must be Null for input file to the FVU.
prepared. The hash value of
the record created and
appended by the FVU.
Must be NULL for the input file Must be Null for input file to the FVU.        Must be Null for input file to the FVU.
to FVU. The FVU version is
appended by FVU. This field is
used during validation in
NPSCAN system

Must be NULL for the input file     Must be NULL for input file to FVU. This   Must be NULL for input file to FVU.
to FVU. The hash value of the       value is calculated and appended by        This value is calculated and
each record and the File            FVU.                                       appended by FVU.
calculated and appended by
FVU.
This is a filler field for future   Will be Spaces                             Will be Spaces
use
This is a filler field for future   Will be Spaces                             Will be Spaces
use
This is a filler field for future   Will be Spaces                             Will be Spaces
use
This is a filler field for future   Will be Spaces                             Will be Spaces
use




          Description                     Validations (Original File)             Validations (Correction File)

Running sequence number for Can only be a numeric character I.e.             Can only be a numeric character I.e.
each line in the file       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
                                    Length should be less than or equal to 9 Number'. Length should be less than
                                    digits.                                  or equal to 9 digits.

Value should be "BH" (Batch         Only Value allowed = "BH". Must NOT be Only Value allowed = "BH". Must
Header) for the batch header        - 'NULL', 'Space', 'Numeric character', NOT be - 'NULL', 'Space', 'Numeric
record                              'Special Characters'.                   character', 'Special Characters'.
Value should indicate batch     Length should be less than or equal      Length should be less than or
no. of the current batch.       to 9 digits.                             equal to 9 digits.
                                 Must NOT be - '0', 'NULL', 'Space',      Must NOT be - '0', 'NULL',
                                'Special Characters', 'Decimal', 'Non-   'Space', 'Special Characters',
                                numeric character', 'Negative            'Decimal', 'Non-numeric
                                Number'.                                 character', 'Negative Number'.

R / C. R - Original, C -        Value should be equal to "R". Must       Value should be equal to "C".
Correction                      NOT be - 'NULL', 'Space', 'Numeric       Must NOT be - 'NULL', 'Space',
                                character', 'Special Characters'.        'Numeric character', 'Special
                                                                         Characters'.
If NL-OO uploads the file , NL- Only numeric values are allowed.         Only numeric values are allowed.
OO Reg. No. should be           Must NOT be - '0', 'NULL', 'Space',      Must NOT be - '0', 'NULL',
entered in this field.          'Special Characters', 'Decimal',         'Space', 'Special Characters',
                                'Alphabets', 'Negative Number'.          'Decimal', 'Alphabets', 'Negative
If NL-AO uploads the file , NL- Length should be exactly equal to 7      Number'. Length should be
AO Reg. No. should be           digits.                                  exactly equal to 7 digits.
entered in this field.
Date of creation of the '.txt'  Can only be a numeric character I.e.     Can only be a numeric character
file. Date should be in         Must NOT be - '0', 'NULL', 'Space',      I.e. Must NOT be - '0', 'NULL',
ddmmyyyy format.                'Special Characters', 'Decimal', 'Non-   'Space', 'Special Characters',
                                numeric character', 'Negative            'Decimal', 'Non-numeric
                                Number'.Length should be exactly         character', 'Negative
                                equal to 8 digits. Date should be in     Number'.Length should be
                                DDMMYYYY format                          exactly equal to 8 digits. Date
                                                                         should be in DDMMYYYY format

Batch Id generated and        This value will be generated and           This value will be generated and
appended by the               appended by FPU                            appended by FPU
FPU.Identification Key in
case of duplicate file upload
by NL-OO/NL-AO.
Unique Transaction Id         Should be NULL for an original file.       Mandatory Field in case of
generated by NPS-Lite on                                                 correction type of file.Should be
successful processing of an                                              the transaction id of the original
original file.                                                           file (file for which correction file is
                                                                         being uploaded)

No of NL-AO/NL-CC Headers Should be equal to total number of       Should be equal to total number
present in the file for the NL-AO/NL-CC Header Records             of NL-AO/NL-CC Header
corresponding batch header  present for the corresponding batch.   Records present for the
                            Count should be >= 1                   corresponding batch. Count
                                                                   should be >= 1
Total number of Subscriber      Should be same as sum of values in Should be same as sum of
Detail records across all NL-   field "Total No Of Subscribers"    values in field "Total No Of
AO/NL-CC headers                across all NL-AO/NL-CC             Subscribers" across all NL-
                                headers.Count should be >= 1       AO/NL-CC headers.Count should
                                                                   be >= 1
        The value here should be            Length<=21. i.e., The amount should      Length<=21. i.e., The amount
        same as sum of values in field      be rounded off to two decimal places.    should be rounded off to two
        "Control Total for Co-              Eg., 50.75 Must NOT be '0', 'NULL',      decimal places. Eg., 50.75 Must
        Contribution" across all NL-        'Space', 'Special Characters',           NOT be '0', 'NULL', 'Space',
        AO/NL-CC records.                   'Decimal', 'Non-numeric character',      'Special Characters', 'Decimal',
                                            'Negative Number'.                       'Non-numeric character',
                                            Value should be Decimal. Must be >=      'Negative Number'.
                                            0.00                                     Value should be Decimal. Must
                                                                                     be >= 0.00

        The value here should be            Length<=21. i.e., The amount should      Length<=21. i.e., The amount
        same as sum of values in field      be rounded off to two decimal places.    should be rounded off to two
        "Control Total for Subscriber’s     Eg., 50.75 Must NOT be '0', 'NULL',      decimal places. Eg., 50.75 Must
        contribution" across all NL-        'Space', 'Special Characters',           NOT be '0', 'NULL', 'Space',
        AO/NL-CC header records.            'Decimal', 'Non-numeric character',      'Special Characters', 'Decimal',
                                            'Negative Number'.                       'Non-numeric character',
                                            Value should be Decimal. Must be >=      'Negative Number'.
                                            0.00                                     Value should be Decimal. Must
                                                                                     be >= 0.00

        This is a filler field for future   Will be Spaces                           Will be Spaces
        use
        The value here should be            Length<=21. i.e., The amount should      Length<=21. i.e., The amount
        same as sum of values in            be rounded off to two decimal places.    should be rounded off to two
        fields "Control Total for Co-       Eg., 50.75 Must NOT be '0', 'NULL',      decimal places. Eg., 50.75 Must
        Contribution " and "Control         'Space', 'Special Characters',           NOT be '0', 'NULL', 'Space',
        Total for Subscriber’s              'Decimal', 'Non-numeric character',      'Special Characters', 'Decimal',
        contribution" in the Batch          'Negative Number'.                       'Non-numeric character',
        Header                              Value should be Decimal. Must be >       'Negative Number'.
                                            0.00                                     Value should be Decimal. Must
                                                                                     be > 0.00

        The Hash Code of the Record. Must be Null for FVU.Mandatory for              Must be Null for FVU.Mandatory for
        Record level hash is         uploaded file in the central system.            uploaded file in the central system.
        appended by the FVU and
        Mandatory in uploaded File




AO/NL-CC Header Record
                   Description                    Validations (Regular File)            Validations (Correction File)

        Running sequence number for Can only be a numeric character I.e.             Can only be a numeric character I.e.
        each line in the file       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
                                            Length must be less than or equal to 9   Number'. Length must be less than
                                            digits                                   or equal to 9 digits

        Value should be "DH" for the        Only Value allowed = "DH". Must NOT be Only Value allowed = "DH". Must
        NL-AO/NL-CC header record           - 'NULL', 'Space', 'Numeric character', NOT be - 'NULL', 'Space', 'Numeric
                                            'Special Characters'.                   character', 'Special Characters'.
Value should indicate batch      Length should be less than or equal      Length should be less than or
no. of the current batch.        to 9 digits.                             equal to 9 digits.
                                 Value should be Numeric. Must NOT        Value should be Numeric. Must
                                 be - '0', 'NULL', 'Space', 'Special      NOT be - '0', 'NULL', 'Space',
                                 Characters', 'Decimal', 'Non-numeric     'Special Characters', 'Decimal',
                                 character', 'Negative Number'.           'Non-numeric character',
                                                                          'Negative Number'.
Running sequence number for Length should be less than or equal           Length should be less than or
each NL-AO/NL-CC header     to 9 digits.                                  equal to 9 digits.
record in the file          Value should be Numeric and                   Value should be Numeric and
                            negative values are not accepted.             negative values are not accepted.
                            Should be in sequence                         Should be in sequence


                                If NL-AO Reg. No. is entered : Only       If NL-AO Reg. No. is entered :
If NL-OO uploads the file , NL- numeric values are allowed. Must          Only numeric values are allowed.
AO Reg. No. should be           NOT be - '0', 'NULL', 'Space', 'Special   Must NOT be - '0', 'NULL',
entered in this field.          Characters', 'Decimal', 'Alphabets',      'Space', 'Special Characters',
                                'Negative Number'. Length should be       'Decimal', 'Alphabets', 'Negative
If NL-AO uploads the file , NL- exactly equal to 7 digits.                Number'. Length should be
CC Reg. No. should be                                                     exactly equal to 7 digits.
entered in this field.          If NL-CC Reg. No. is entered : 10
                                character NL-CC Reg. No. should be        If NL-CC Reg. No. is entered : 10
                                entered.Should be all CAPITALS.           character NL-CC Reg. No. should
                                Should follow RCC validations             be entered.Should be all
                                                                          CAPITALS. Should follow RCC
                                                                          validations

Total number of subscribers      Can only be a numeric character I.e.     Can only be a numeric character I.e.
contribution details for each    Must NOT be - '0', 'NULL', 'Space',      Must NOT be - '0', 'NULL', 'Space',
NL-AO/NL-CC Header.              'Special Characters', 'Decimal', 'Non-   'Special Characters', 'Decimal', 'Non-
                                 numeric character', 'Negative Number'.   numeric character', 'Negative
                                 Length must be less than or equal to 9   Number'. Length must be less than
                                 digits                                   or equal to 9 digits

The value here should be         Length<=21. i.e., The amount should      Length<=21. i.e., The amount
same as sum of values in field   be rounded off to two decimal places.    should be rounded off to two
"Co-Contribution amount"         Eg., 50.75 Must NOT be 'NULL',           decimal places. Eg., 50.75 Must
across all Subscriber records    'Space', 'Special Characters',           NOT be 'NULL', 'Space', 'Special
of the NL-AO/NL-CC.              'Decimal', 'Non-numeric                  Characters', 'Decimal', 'Non-
                                 character','Negative Number'.            numeric character', 'Negative
                                 Value should be Decimal. Must be >=      Number'.
                                 0.00                                     Value should be Decimal. Must
                                                                          be >=0.00

The value here should be         Length<=21. i.e., The amount should      Length<=21. i.e., The amount
same as sum of values in field   be rounded off to two decimal places.    should be rounded off to two
"Subscriber’s contribution       Eg., 50.75 Must NOT be '0', 'NULL',      decimal places. Eg., 50.75 Must
amount" across all Subscriber    'Space', 'Special Characters',           NOT be '0', 'NULL', 'Space',
records of the NL-AO/NL-CC.      'Decimal', 'Non-numeric character',      'Special Characters', 'Decimal',
                                 'Negative Number'.                       'Non-numeric character',
                                 Value should be Decimal. Must be         'Negative Number'.
                                 >=0.00                                   Value should be Decimal. Must
                                                                          be >=0.00
       Filler field for future use.     Should be spaces                          Should be spaces
       The Hash Code of the Record.     Must be Null for FVU Mandatory for        Must be Null for FVU Mandatory for
       Record level hash is             SAM/SCM and uploaded file in the          SAM/SCM and uploaded file in the
       appended by the FVU and          central system.                           central system.
       Mandatory in SAM/SCM and
       uploaded File




Subscriber Details Record
                 Description                   Validations (Regular File)            Validations (Correction File)

       Running sequence number for Can only be a numeric character I.e.          Can only be a numeric character I.e.
       each line in the file       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
                                        Length should be less than or equal to 9 Number'. Length should be less than
                                        digits.                                  or equal to 9 digits.

       Value "SD" (Subscriber Detail) Value should be 'SD - Must NOT be           Value should be 'SD - Must NOT be
       for Subscriber Detail record   'NULL', 'Space', 'Numeric character'.       'NULL', 'Space', 'Numeric character'.

       Value should indicate batch                                        Length should be less than or
                                        Length should be less than or equal
       no. of the current batch.        to 9 digits.                      equal to 9 digits.
                                        Value should be Numeric. Must NOT Value should be Numeric. Must
                                                                          NOT be - '0', 'NULL', 'Space',
                                        be - '0', 'NULL', 'Space', 'Special
                                                                          'Special Characters', 'Decimal',
                                        Characters', 'Decimal', 'Non-numeric
                                        character', 'Negative Number'.    'Non-numeric character',
                                                                          'Negative Number'.
       Sequence number specified in Length should be less than or equal Length should be less than or
       the corresponding NL-AO/NL- to 9 digits.                           equal to 9 digits.
       CC header record in the file. Value should be Numeric. Must NOT Value should be Numeric. Must
                                     be '0', 'NULL', 'Space', 'Special    NOT be '0', 'NULL', 'Space',
                                     Characters', 'Decimal', 'Non-numeric 'Special Characters', 'Decimal',
                                     character', 'Negative Number'.       'Non-numeric character',
                                                                          'Negative Number'.

       Serial No. assigned to each      Should start with '1'. Can only be a   Should start with '1'. Can only be
       SD Record. Running serial        numeric character I.e. Must NOT be     a numeric character I.e. Must
       number starting with 1.          '0', 'NULL', 'Space', 'Special         NOT be '0', 'NULL', 'Space',
                                        Characters', 'Decimal', 'Non-numeric   'Special Characters', 'Decimal',
                                        character', 'Negative Number'.         'Non-numeric character',
                                                                               'Negative Number'.
       Permanent Retirement             Can only be a numeric character I.e. Can only be a numeric character
       Account Number                   Must NOT be '0', 'NULL', 'Space',      I.e. Must NOT be '0', 'NULL',
                                        'Special Characters', 'Decimal', 'Non- 'Space', 'Special Characters',
                                        numeric character', 'Negative          'Decimal', 'Non-numeric
                                        Number'.                               character', 'Negative Number'.
Co-Contribution to individual        Length<=21. i.e., The amount should   Length<=21. i.e., The amount
subscriber’s Tier I account          be rounded off to two decimal places. should be rounded off to two
                                     Eg., 50.75 Must NOT be '0', 'NULL',   decimal places. Eg., 50.75 Must
                                     'Space', 'Special Characters',        NOT be '0', 'NULL', 'Space',
                                     'Decimal', 'Non-numeric character',   'Special Characters', 'Decimal',
                                     'Negative Number'.                    'Non-numeric character',
                                     Value should be Decimal. Must be      'Negative Number'.
                                     >0.00 for Contribution Type '0'. Must Value should be Decimal. Must
                                     be >=0 for other Contribution Types   be >0.00 for Contribution Type '0'.
                                                                           Must be >=0 for other
                                                                           Contribution Types
Self contribution to individual      Length<=21. i.e., The amount should Length<=21. i.e., The amount
subscriber’s Tier I account          be rounded off to two decimal places. should be rounded off to two
                                     Eg., 50.75 Must NOT be 'NULL',        decimal places. Eg., 50.75 Must
                                     'Space', 'Special Characters',        NOT be 'NULL', 'Space', 'Special
                                     'Decimal', 'Non-numeric character',   Characters', 'Decimal', 'Non-
                                     'Negative Number'.                    numeric character', 'Negative
                                     Value should be Decimal.Must be       Number'.
                                     >=0.00.                               Value should be Decimal.Must be
                                                                           >=0.00.

Filler field for future use.         Should be Spaces                         Should be Spaces
The value here should be             Length<=21. i.e., The amount should      Length<=21. i.e., The amount
same as sum of values in             be rounded off to two decimal places.    should be rounded off to two
fields "Co-Contribution              Eg., 50.75 Must NOT be 0, 'NULL',        decimal places. Eg., 50.75 Must
amount" and "Subscriber’s            'Space', 'Special Characters',           NOT be 0, 'NULL', 'Space',
mandatory contribution               'Decimal', 'Non-numeric character',      'Special Characters', 'Decimal',
amount" for each subscriber.         'Negative Number'.                       'Non-numeric character',
                                     Value should be Decimal.Value Must       'Negative Number'.
                                     be >0.00.                                Value should be Decimal.Value
                                                                              Must be >0.00.

Value is 'C' for Subscriber's      Value must be one of 'C','A','0','2' for   Value must be one of 'C','A','0','2'
Regular Contribution,'A' for       Contribution. Values other than            for Contribution. Values other
Arrears Contribution,'0' for Self- 'C','A','0','2' is not allowed             than 'C','A','0','2' is not allowed
Contribution and '2' for Govt-
Schemes Contribution.
Fixed length. mm. E.g. 01 for Length should be exactly equal to 2             Length should be exactly equal to
January.Mandatory if type of digits. Value should be Numeric.                 2 digits. Value should be
contribution is 'C'.Optional if    Must NOT be '0', 'NULL', 'Space',          Numeric. Must NOT be '0',
type of contribution is 'A' or '0' 'Special Characters', 'Decimal', 'Non-     'NULL', 'Space', 'Special
or '2'.                            numeric character', 'Negative              Characters', 'Decimal', 'Non-
                                   Number'.                                   numeric character', 'Negative
                                                                              Number'.


Fixed length. yyyy. E.g. 2005        Length should be exactly equal to 4      Length should be exactly equal to
Mandatory if type of                 digits. alue should be Numeric. Must     4 digits. alue should be Numeric.
contribution is 'C'. Optional if     NOT be '0', 'NULL', 'Space', 'Special    Must NOT be '0', 'NULL', 'Space',
type of contribution is 'A' or '0'   Characters', 'Decimal', 'Non-numeric     'Special Characters', 'Decimal',
or '2'.                              character', 'Negative Number'.           'Non-numeric character',
                                                                              'Negative Number'.
Mandatory if type of             Length of the remarks entered should Length of the remarks entered
contribution type is 'A' or '2'. be less than or equal to 75          should be less than or equal to 75
Optional if contribution type is characters                           characters
'C' or '1'.




The Hash Code of the Record. Must be Null for FVU Mandatory for       Must be Null for FVU Mandatory for
Record level hash is         SAM/SCM and uploaded file in the         SAM/SCM and uploaded file in the
appended by the FVU and      central system.                          central system.
Mandatory in uploaded File

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:11/23/2012
language:English
pages:16