1.15.1 Segment Identification Number

This topic provides detailed information on authrep upload format of segment identification number.

Table 1-84 Segment Identification Number

Field Name	Data type	Field Length	Attributes	Characteristics/rules	Values
SEQUENCENUMBER	NUMBER	10	Mandatory	-	Sequence Number
PROCESSID	VARCHAR2	50	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	12	Mandatory	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	Mandatory	-	Import File Name
UPLOADMODE	VARCHAR2	1	Mandatory	-	Mode of operation which has to be performed on the record
AMCID	VARCHAR2	12	Optional	-	AMC ID
USERID	VARCHAR2	15	Mandatory	-	Represents the user ID who has entered the latest record
MODULEID	VARCHAR2	30	Mandatory	-	Module ID of the Authorized representative
AUTHREPREFNO	VARCHAR2	12	Optional	-	Authorized Representative Reference Number
AUTHREPID	VARCHAR2	12	Optional	-	Authorized Representative ID
AUTHREPADDRESS	VARCHAR2	255	Optional	-	Authorized Representative Address
AUTHREPZIPCODE	VARCHAR2	10	Optional	-	Authorized Representative ZIP Code
AUTH_STAT	VARCHAR2	1	Optional	-	Authorization Status: A - Authorised U - Unauthorised
AGENTCODE	VARCHAR2	12	Optional	-	Agent Code
BRANCHCODE	VARCHAR2	12	Optional	-	Branch Code
AUTHREPSIGNATURE	VARCHAR2	255	Optional	-	Authorized Representative Signature
IMAGEAVAILABLE	NUMBER	1	Optional	-	Image available or Not
AUTHREPTITLE	VARCHAR2	15	Optional	-	Authorized Representative Title
AUTHREPSTATE	VARCHAR2	20	Optional	-	Authorized Representative State
AUTHREPUSSTATE	NUMBER	1	Optional	-	Authorized Representative US State
AUTHREPCITY	VARCHAR2	10	Optional	-	Authorized Representative City
FIRSTNAME	VARCHAR2	105	Optional	-	First Name
MIDDLENAME	VARCHAR2	105	Optional	-	Middle Name
LASTNAME	VARCHAR2	105	Optional	-	Last Name
AUTHREPCOUNTRY	VARCHAR2	3	Mandatory	-	Country of the authorized representative
NATIONALITY	VARCHAR2	3	Mandatory	-	Nationality of the authorized representative
COUNTRYOFBIRTH	VARCHAR2	3	Mandatory	-	Country of birth of the authorized representative
COUNTRYOFDOMICILE	VARCHAR2	3	Mandatory	-	Country of domicile of the authorized representative
TELEPHONE1	VARCHAR2	60	Mandatory	-	Telephone 1 of the authorized representative
TELEPHONE2	VARCHAR2	60	Mandatory	-	Telephone 2 of the authorized representative
CELLPHONENUMBER	VARCHAR2	60	Mandatory	-	Cellphone number of the authorized representative
INTDIALLINGCODEPH1	VARCHAR2	10	Mandatory	-	International Dialling code of phone number 1
INTDIALLINGCODEPH2	VARCHAR2	10	Mandatory	-	International Dialling code of phone number 2
INTDIALLINGCODECELL	VARCHAR2	10	Mandatory	-	International Dialling code of cell phone number
AUTHREPADDRESS2	VARCHAR2	255	Mandatory	-	Address of the authorized representative
AUTHREPCATEGORY	VARCHAR2	1	Mandatory	-	Category of the authorized representative
REMARKS	VARCHAR2	255	Optional	-	Remarks