1.21.3 Employer Details

This topic provides information on Employer Details of EMP Upload Format.

Serial Number: 2

Segment Identification Number: 02DTL

Description: This segment is used for providing information related to Employer details

Attributes: Mandatory

Table 1-100 Employer Details

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEGMENTID	VARCHAR2	25	Mandatory	-	Segment ID - 02DTL
EMPSURNAME	VARCHAR2	100	Mandatory	-	Employee Sur Name
EMPNAME	VARCHAR2	100	Mandatory	-	Employee Name
BROKERCODE	VARCHAR2	25	Mandatory	-	Broker Code
FUNDID	VARCHAR2	25	Mandatory	-	Fund ID
VALUEDATE	DATE	7	Mandatory	-	Value Date
UNITHOLDERID	VARCHAR2	25	Mandatory	-	UnitHolder ID
EMPLOYEEID	VARCHAR2	25	Optional	-	Employee ID
EMPLYERID	VARCHAR2	25	Optional	-	Employer ID
TOTALCONTRIBUTION	VARCHAR2	30	Mandatory	-	Total Contribution
TOTALCONTRIBUTION	VARCHAR2	30	Mandatory	-	Basic Salary
EFFECTIVEEMPLOYEEPE RCENTAGE	VARCHAR2	30	Mandatory	-	Effective Employee Percentage
EFFECTIVEEMPLOYERPE RCENTAGE	VARCHAR2	30	Optional	-	Effective Employer Percentage
ADMINFEEPERCENTAGE	VARCHAR2	30	Mandatory	-	Admin Fee Percentage
ADMINFEE	VARCHAR2	30	Mandatory	-	Admin Fee
ADMINFEEFTERVAT	VARCHAR2	30	Mandatory	-	Admin Fee after VAT
FLATFEE	VARCHAR2	30	Mandatory	-	Flat Fee
BROKERFEEPERCENTAGE	VARCHAR2	30	Mandatory	-	Broker Percentage
BROKERFEEAMOUNT	VARCHAR2	30	Mandatory	-	Broker Fee Amount
BROKERFEEAMOUNTAFT ERVAT	VARCHAR2	30	Mandatory	-	Broker Fee Amount after VAT
TOTALDEDUCTIONS	VARCHAR2	30	Mandatory	-	Total Deductions
NETINVESTMENT	VARCHAR2	30	Mandatory	-	Net Investment
EMPLOYERCONTRIBUTION	NUMBER	30	Mandatory	-	Employer Contribution
EMPLOYEECONTRIBUTION	NUMBER	30	Mandatory	-	Employee Contribution
ADDINFO1	VARCHAR2	30	Mandatory	-	Addition Information 1
ADDINFO2	VARCHAR2	30	Mandatory	-	Additional Information 2
ADDINFO3	VARCHAR2	30	Mandatory	-	Additional Information 3