2.8 Fund Entity Upload Format

This topic provides the information about Fund Entity Upload Format.

Using this interface, user can upload the fund entity details by mapping funds to entities along with the allowed/disallowed transaction types.

Operations such as NEW, EDIT, DELETE, AUTHORIZE, AMEND and CLOSE are supported in this Interface.

Segment Identification Number

Table 2-65 Segment Identification Number

Segment Identification Number	Description	Segment Mandatory / Optional?
00FEN	This segment is used to provide Information related to Fund Entity Details	Mandatory
01TXN	This segment is used to provide information related to Fund Entity Transaction Details	Optional

Fund Entity Details

This section is used to provide information related to Fund Entity Details.

Serial Number: 1

Segment Identification Number: 00FEN

Description: This segment is used to populate Fund Entity Details.

Table 2-66 Fund Entity Details

Field Name	Data type	Length	Mandatory/ Optional	Characteristics/rules	Values
PROCESSID	VARCHAR2	50	Mandatory	-	Unique value to process interface
SEGMENTID	VARCHAR2	20	Mandatory	-	00FEN
SEQUENCENUMBER	NUMBER	22	Mandatory	-	Sequence Number
BULKCLIENTCODE	VARCHAR2	12	Mandatory	-	Bulk client code
IMPORTFILENAME	VARCHAR2	255	Mandatory	-	BulkFundEntityImport. xls
UPLOADMODE	VARCHAR2	1	Mandatory	-	Represents the action code: N - New E - Edit D - Delete A - Authorize O - Reopen C - Close
FUNDID	VARCHAR2	6	Mandatory	-	Represents a unique identification for each fund in the system. Fundid column of funddemographic stbl
ENTITYTYPE	VARCHAR2	2	Mandatory	-	Type of entity that is to be associated with the selected Fund
ENTITYID	VARCHAR2	12	Mandatory	-	Represents the Entity ID to be mapped to the Fund maintained
RESTRICTIVELIST	NUMBER	22	Optional	-	1 - Yes 0 - No
RESTRICTIONCODE	VARCHAR2	2	Optional	-	Maintenance in paramstbl for paramcode 'RESTRICTIONCD'
REMARKS	VARCHAR2	255	Optional	-	Remarks
USER_ID	VARCHAR2	15	Mandatory	-	User Id

Fund Entity Transaction Details

This section is used to provide information related to Fund Entity Transaction Details, which is optional.

Serial Number: 2

Segment Identification Number: 01TXN

Description: This segment is added to populate Fund entity Transaction Details.

Table 2-67 Fund Entity Transaction Details

Field Name	Data type	Length	Mandatory/ Optional	Characteristics/rules	Values
PROCESSID	VARCHAR2	50	Mandatory	-	Unique value to process interface
SEGMENTID	VARCHAR2	20	Mandatory	-	01TXN
SEQUENCENUMBER	NUMBER(10)	10	Mandatory	-	Sequence Number
FUNDID	VARCHAR2	6	Mandatory	-	Represents a unique identification for each fund in the system. Fund id column of funddemographicstbl
ENTITYTYPE	VARCHAR2	2	Mandatory	-	Type of entity that is to be associated with the selected Fund
ENTITYID	VARCHAR2	12	Mandatory	-	Represents the Entity ID to be mapped to the Fund maintained
TRANSACTIONTYPE	VARCHAR2	2	Mandatory	-	Represents the valid transaction types available for the fund