1.31 Unit Holder Deal File Format

This topic provides information on Unit Holder Deal File Format.

Note:

For all imports of unit holder deal information, the external hand-off file containing the information must:
  • Always be named in the format “*.*”.
  • Always contain all information marked as mandatory in the table below.
  • Always contain the information in the exact format and serial order shown in the Field Name column (with values according to the validations mentioned) in the table below:

Table 1-146 Unit Holder Deal File Format

Field Name (as expected in the file) Data type Field length Attributes Characteristics/rules Values
SEQUENCENUMBER Number NUMBER(10) Mandatory - System generated sequence number for the records in the file
PROCESSID String VARCHAR(50) Mandatory -

The Process ID, along with the system generated sequence number, identifies the uploaded record uniquely.

Each file must have a unique Process ID. This should be same for all records within a file.

BULKCLIENTCODE String VARCHAR(12) Mandatory - The Code of the Bulk client.
IMPORTFILENAME String VARCHAR(255) Mandatory - Name of the file being uploaded should be specified. Each file must have a unique name.
UPLOADMODE String VARCHAR(1) Mandatory - Upload mode can be “N” for New unit holder uploads and ‘I’ for Incremental change.
AMCID String VARCHAR(12) Mandatory - The ID of the AMC for which the bulk client has maintained the default details. This should be same within a file for all the records.
DEALTRANSACTIONN UMBER String VARCHAR(16) Optional - Null for a new mode. It may or may not be passed for other modes.
UHIDORCIFNUMBER String VARCHAR(12) Mandatory - Could be any valid unit holder ID or CIF number maintained in the system.
APPLYATCIFLEVEL Number NUMBER(1) Optional -

Could be either 0- No or 1-Yes.

If not supplied, value to be taken from bulk client defaults

APPLYDEALAT String VARCHAR(1) Mandatory -
Could be any of the following values:
  • G - Group Level
  • P - Product Level
  • F - Fund Level
  • L - Load level
STATUS String VARCHAR(1) Mandatory -
Could be either:
  • A - Active or
  • C - Cancelled
EFFECTIVESTARTDATE date DATE Mandatory - The effective date from which the deal is applicable
EFFECTIVEENDDATE date DATE Optional - The effective date on which the deal ends. In case of null values it will take the default value as the system high date.
AUTHSTATUS String VARCHAR(1) Mandatory -
Could be either:
  • A - Authorized or
  • U - Unauthorized
LOADGROUPID String VARCHAR(16) Optional - Could be any valid group ID maintained in system.
FUNDID String VARCHAR(6) Optional - Could be any valid fund ID maintained in the system.
LOADID Number NUMBER(5) - - Could be any valid load ID maintained in the system.
LOADSLABDETAILS String VARCHAR(2000) - - Could be any valid slab details maintained for the load in the system. It should have the slab number and the return value. Field separator is "," and record separator is ";". slabno>, <returnvalue>;
DERIVEDLOADSLABDET AILS String VARCHAR(2000) - - Could be any valid slab details maintained for the derived load in the system. It has derived load ID, and return value. Field separator is "," and record separator is ";". <derivedloadid> ,<returnvalue>;
APPLYRETVALUETOALL SLABS Number NUMBER(1) - -
Could be either:
  • 0 - No
  • 1 - Yes
RETURNVALUE Number NUMBER(15,6) - - If the above field is ‘1’, then return value is applicable to all the slabs
PRODUCTID String VARCHAR2(10) - -

Could be any valid product ID maintained in the system. For UT it should be UT.

ALL – Option would be applicable for all products.

USERID String VARCHAR2(15) - - Represents the user ID who has entered the latest record
POLICYNUMBER String VARCHAR(16) - - Could be any valid Policy maintained in the system. For UT, it should be UT.
DealBasedOn String VARCHAR2(1) - -
  • I – Inclusion Percentage
  • A – Flat Rate Amount
  • P – Flat Rate Percentage