1.36 Campaign Upload

This topic provides information on Campaign Upload.

Serial Number: 1

Segment Identification Number: 00CMP

Description: This is used to capture campaign upload details.

Attributes: Mandatory

Table 1-151 Campaign Upload

Field Name (as expected in the file)	Data type	Length	Attributes	Values
SEGMENTID	VARCHAR2	80	-	Segment ID - 00CMP
SEQUENCENUMBER	NUMBER	10	-	Sequence Number (either sequence number or process ID should be unique)
PROCESSID	VARCHAR2	50	-	Process ID (either sequence number or process ID should be unique)
BULKCLIENTCODE	VARCHAR2	12	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	-	Import File Name
UPLOADMODE	VARCHAR2	1	-	Mode of operation which has to be performed on the record
CAMPAIGNCODE	VARCHAR2	10	Mandatory	Campaign Code
CAMPAIGNNAME	VARCHAR2	60	Mandatory	Campaign Name
CAMPAIGNTYPES	VARCHAR2	1	Mandatory	Campaign Types. Valid Values are: A - Account Opening Date T - Transaction Date L - Loyality B - Birth Day Campaign
STARTDATE	DATE	-	Mandatory	Campaign code start date
ENDDATE	DATE	-	Mandatory	Campaign code end date
INVESTORTYPE	VARCHAR2	1	Optional	Investor type. Valid Values are: I - individual C - Corporate
INVESTORCATEGORY	VARCHAR2	2	Optional	Investor category
COMMUNICATIONMODE	VARCHAR2	2	Optional	Communication mode
OCCUPATION	VARCHAR2	3	Optional	Occupation
MAXINVESTMENTAMOUNT	NUMBER	30,12	-	Maximum investment amount Value should be greater than zero and greater than minimum investment amount
ACTIVITYBASEDON	VARCHAR2	1	-	Activity Based on.Valid values are T - Transaction Date A - Account Opening Date B - Birth Day
ACTIVITYFROMPERIOD	DATE	-	Optional	Activity from period
ACTIVITYTOPERIOD	DATE	-	Optional	Activity to period
AGERANGEFROM	NUMBER	-	Optional	Age Range From
AGERANGETO	NUMBER	-	Optional	Age Range To
BIRTHDAYCONCEPTS	VARCHAR2	50	Optional	Birth Day concepts - Comma separated string
BENEFITCOUNTER	NUMBER	-	Mandatory	Benefit counter
FUNDORFUNDTYPE	NUMBER	38	Optional	Fund or Fund type
PERIOD	VARCHAR2	1	Optional	Period
RSPDATE	VARCHAR2	10	Optional	RSP Date
RSP	VARCHAR2	1	Optional	RSP
USERID	VARCHAR2	320	Mandatory	Indicates the user ID who has entered the latest record
AUTH_STAT	VARCHAR2	1	Optional	Authorisation status
BIRTHDAYMONTH	VARCHAR2	50	Optional	Birth Day Month - comma separated string