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