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:
|
STATUS | String | VARCHAR(1) | Mandatory | - | Could be either:
|
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:
|
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:
|
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
|
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) | - | - |
|
Parent topic: Appendix A - Upload File Formats A