PIN (integer)
CREATEDBY (6 symbols)
CREATETIME (DateTime)
NAME (180 symbols)
ADDRESS1 (40 symbols)
ADDRESS2 (40 symbols)
ADDRESS3 (40 symbols)
PERSONALIDNO (20 symbols)
SEX (1 symbol) - please use F/M
POSTCODE (100 symbols)
POSTPLACE (100 symbols)
INITIALS (15 symbols)
NATIONALITY (3 symbols)
DEPARTMENTCODE (10 symbols)
MANAGENTCODE (10 symbols)
UNIONCODE (10 symbols)
PERSONGROUPCODE (10 symbols)
CATHEGORYA (integer)
CATHEGORYB (integer)
CATHEGORYC (integer)
BIRTHDATE (DateTime)
DEATHDATE (DateTime)
EMPLOYMENTSTARTDATE (DateTime)
EMPLOYMENTENDDATE (DateTime)
RANK (10 symbols) - please note that the imported value must exist in General Codes -> Rank
DIVISION (integer)
CONTRACTSTARTDATE (DateTime)
CONTRACTENDDATE (DateTime)
CONTRACTEXPIRYDATE (DateTime)
PINDEFAULTRELIEF (integer)
CURRENCY (3 symbols) -
LEAVEPAYFACTOR (10 symbols)
BANKACCOUNTNO (35 symbols)
TRANSFERBALANCE (2 symbols)
HAIRCOLOR (10 symbols)
EYECOLOR (10 symbols)
HEIGHT (interger)
WEIGHT (interger)
TERMOFNOTICE (interger)
PLACEOFBIRTH (35 symbols)
MARITALSTATUS (10 symbols)
HOMEAIRPORT (60 symbols)
TRAVELTIME (12 symbols)
MARITIMEOFFICE (20 symbols)
BLOODGROUP (5 symbols)
EYESIGHT (10 symbols)
ALLERGY (25 symbols)
EXTERNALCOMPANY (15 symbols)
QUICKSELECTIONSWITCHES (20 symbols)
SEQUENCENO (integer) - used as a counter. Must be unique
UPDATEFLAGS (125 symbols)
SITEID (integer) - the internal number of the installation site to which a person belongs, e.g. 1 for office, 11-15 for vessels.
CLIENT (integer) - the code corresponding to field NUMORGID of an organization unit (concern/company/vessel etc)
UPDATEDTIME (DateTime)
UPDATEDBY (6 symbols)
PICTURENO (integer)
ALTERNATIVEPIN (15 symbols)
ADDRESS_COUNTRY (2 symbols)
DEATHPLACE (20 symbols)
DEATHREASON (20 symbols)
CONTRACTTYPE (10 symbols)
STOPREASON (60 symbols)
SHIFTCODE (10 symbols)
SHIFTSTART (DateTime)
SHIFTVESSEL (integer)
CREWPOOL (10 symbols)
PAYROLLSTATUS (10 symbols)
PAYROLLTYPE (10 symbols)
TELEPHONE (100 symbols) - normally it is better to use one of fields from Telecommunication section (see below)
LEAVEDAYSFROMDATE (DateTime)
WORKINGSPOUCE (1 symbol) - please use Y/N
NOOFDEPENDANTS (2 symbols)
CURRENCYFORPAYMENT (3 symbols)
COSTPLACE (10 symbols)
TURNUSCODE (10 symbols)
SRCNO (25 symbols)
FIRSTNAME (50 symbols)
MIDDLENAME (50 symbols)
LASTNAME (50 symbols)
MAIDENNAME (30 symbols)
CALLINGNAME (30 symbols)
TITLENAME (15 symbols)
SUFFIXNAME (15 symbols)
PAYROLLVSL (integer)
COUNTRYOFBIRTH (2 symbols)
OTHERCITIZENSHIP (2 symbols)
AADDRESS1 (40 symbols) - additional address field under the Other folder
AADDRESS2 (40 symbols) - additional address field under the Other folder
AADDRESS3 (40 symbols) - additional address field under the Other folder
APOSTCODE (100 symbols) - additional post code field under the Other folder
APOSTPLACE (20 symbols) - additional post place field under the Other folder
AADDRESS_COUNTRY (2 symbols)
PORTSIGNON (20 symbols)
PORTSIGNOFF (20 symbols)
COSTGROUPCHANGEDATE (DateTime)
HOMEAIRPORT2 (60 symbols)
HOMEAIRPORT3 (60 symbols)
TRAVELTIME2 (12 symbols)
TRAVELTIME3 (12 symbols)
repl_ModifiedBySite (integer) - field for following up replication data
repl_ModifiedDate (DateTime) - field for following up replication data
REPL_GMTMODIFIEDDATE (DateTime) - field for following up replication data
EMAILPAYSLIP (1 symbol)
NOPAPERCOPY (1 symbol)
SHIFTEND (DateTime)
SESSIONID (integer) - field used for audit purpose
DBACTION (10 symbols) - field for storing database actions like INSERT/UPDATE
AUDIT_LINENR (integer) - field used for audit purpose
ADDRESS_STRNR (5 symbols)
AADDRESS_STRNR (5 symbols)
SMOKER (1 symbol) - please use Y/N
RELIGION (10 symbols)
PANTSKIRTSIZE (10 symbols)
SHIRTBLOUSESIZE (10 symbols)
SHOESIZE (10 symbols)
PPE_BOILERSUITE (10 symbols)
PPE_SAFETYSHOES (10 symbols)
PPE_HELMET (10 symbols)
PPE_SSUITE (10 symbols)