Objective

This article is intended to delineate the potential import objects within the worker information.

ATTENTION

It is not mandatory to send all files described in this document, only those necessary for business needs. If in doubt, contact the relationship manager who works for your company.

The spreadsheet will be considered invalid if one of these conditions is identified:

You can not change the column names;
You can not change the sheet names;
You can not change the order of the columns;
You can not change the order of the sheet;
You can not delete the columns;
You can not delete the sheet.

Spreadsheet

Files Samples:

Notes:

The date fields must use the mask: YYYY-MM-DD
The datetime fields must use the mask: YYYY-MM-DD HH:MI:SS
The decimal separator must be "."
Thousands separator should not be used.

Definition

Worker

Filename: worker.csv

Field	Mandatory?	Data Type	Description	Size	Accepted Values
admission	No	Date	Hiring date
nickname	No	String	Nickname	20
status	Yes	Integer	Status Indicator	1	0 = Active 1 = Inactive 2 = Away 3 = Hiring**
date_birth	No	Date	Birthday
is_manager	Yes	Integer	Worker with management role Indicator	1	0 = No 1 = Yes**
register	No	String	Workers id in company	20
name	Yes	String	Full name	80
pis	No	String	Social security id	13
id_number	No	String	Id card number	15
id_issuer	No	String	Id card issuer	20
id_issuer_state	No	String	Id card state issuer	50
id_issuer_date	No	Date	Id card issuance date
worker_book_serial_number	No	String	Applicable Only in Brazil	20
worker_book_number	No	String	Applicable Only in Brazil	20
worker_book_issue_date	No	Date	Applicable Only in Brazil
worker_book_validity	No	Date	Applicable Only in Brazil
type	Yes	Integer	Worker type	1	0 = Employee - Own employee 1 = Third Party - Local third party employee 2 = Hired Employee - Outsource employee 3 = Sporadic 4 = Customer Employee 5 = POB - Sporadic from POB 6 = Expatriate - Expatriate worker 7 = Expatriate Outsourced - Expatriate Outsource employee**
dismissal_date	No	Date	Termination date
cost_center_code	No	String	Cost center code	20	Reference to a Cost Center’s Code When sending the cost_center_code in this column, it is mandatory to send the this information in the sheet with costcenter.
nationality_description	No	String	Nationality	30	Reference for a Nationality’s Description When sending the nationality_description in this column, it is mandatory to send the this information in the sheet with nationality.
operational_job_name	No	String	Worker operational job name	200	Reference to a Role’s Name When sending the operational_job_name in this column, it is mandatory to send the this information in the sheet with role.
payroll_job_name	No	String	Worker role name	200	Reference to a Role’s Name When sending the payroll_job_name in this column, it is mandatory to send the this information in the sheet with role.
payroll_job_level_name	No	String	Worker role level name	40	Reference to a Role Level’s Name When sending the payroll_job_level_name in this column, it is mandatory to send the this information in the sheet with rolelevel.
operation_unit_acronym	No	String	Operation unit / Rig / Vessel	10	Reference to an Operating Unit’s Acronym When sending the operation_unit_acronym in this column, it is mandatory to send the this information in the sheet with operationunit.
company_name	No	String	Company name	80	Reference to a Company’s Name When sending the company_name in this column, it is mandatory to send the this information in the sheet with company.
gender	No	Integer	Gender	1	0 = M 1 = F
department_name	No	String	Department Name	200	Reference to a Department’s Name When sending the department_name in this column, it is mandatory to send the this information in the sheet with department.
category_type	Mutually Exclusive If informed, the category_id field should not be informed	Integer	Category Type Indicator	1	Categories type provided in Drake: 0 = OnShore 1 = OffShore 2 = Maritime**
category_id	Mutually Exclusive If informed, the category_type field should not be informed	String	Category’s id	200	If there are categories other than those provided in category_type field, it will be necessary to send the category sheet and in this field the name of the category in the sheet sent must be informed.
cpf	No	String	Worker tax pay number	20	Enter worker CPF without periods or special characters. Provide only numbers.
salary	No	Decimal	Worker Salary	19,4	from 0,00 to 922.337.203.685.477,5807

*Not repetead **Default Value

Department

Filename: department.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
name	Yes*	String	Department Name	200
description	No*	String	Department Description	200
acronym	No*	String	Department Acronym	10

*Not repetead **Default Value

Nationality

Filename: nationality.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
description	Yes*	String	Nationality Description	30
country_code	No	String	Country Code	10	Reference to a Country’s Code When sending the country_code in this column, it is mandatory to send the this information in the sheet with country.
country_name	No	String	Country Name	500	Although this property is not mandatory, if it is not informed, the import routine will associate the nationality with a country called “Others/Others” when informing new nationalities.

*Not repetead **Default Value

Country

Filename: country.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
acronym	Yes*	String	Country Acronym	10
name	No	String	Country Name	500
iso_code	Yes*	String	Code of country as listed on ISO 3166-2	2	https://en.wikipedia.org/wiki/ISO_3166-2

*Not repetead **Default Value

Company

Filename: company.csv

Propriedade	Mandatory?	Data Type	Description	Size	Accepted Values
name	Yes*	String	Company Name	80
trading_name	No	String	Commercial Name	25
type	Yes	Integer	Company Type	1	1 = Road Transporter, 2 = Air Conveyor 3 = Hospitality 4 = Agents 5 = Others 6 = Training 7 = Sea Carrier 8 = Workforce Labour**
client_code	No	String	Client Company Code	20

*Not repetead **Default Value

Address

Filename: address.csv

Attention:
The system only allows one hiring address per worker.

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.orker’s Name
public_area	No	String	St/Av name	255
number	No	String	St/Av number	25
complement	No	String	Additional information/Reference	50
neighborhood	No	String	Neighborhood	100
city	No	String	City	100
state	No	String	State code	2
zip_code	No	String	Zip code	12
country_iso_code	No	String	Code of country as listed on ISO 3166-2	2	https://en.wikipedia.org/wiki/ISO_3166-2 Reference to a Country’s Iso Code When sending the country_iso_code in this column, it is mandatory to send the this information in the sheet with country.
type	Yes	Integer		1	0 = Residential 1 = Commercial - Company address 2 = Others 3 = Hiring - Main logistic address 4 = Public - Reference address 5 = Hiring Airport - Main logistic address when worker is expatriate**
situation	Yes	Integer	Situation Indicator	1	0 = Disabled 1 = Enabled **

*Not repetead **Default Value

Email

Filename: email.csv

Attention:
The system allows you to register several emails, but only one main email.

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
email	Yes*	String	Email	255	An email is initially considered accepted when it has: A sequence of characters followed by an "@" followed by more characters followed by a "." followed by at least two characters.
main_email	No	Integer	Indicates the main email. There can only be one main email per person.	1	0 = Secondary email 1 = Primary email**
do_not_use	No	Integer	When enabled DRAKE won't use this email to communicate with worker and myDRAKE registration	1	0 = Can be used 1 = Not used**

*Not repetead **Default Value

Telephone

Filename: phone.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
number	Yes	String	Telephone Number	14
country_calling_codes	No	String	Country calling codes, country dial-in codes, international subscriber dialing (ISD) codes, or most commonly, telephone country codes	3
ddd	No	String	Area code	3
type	No	Integer	Telephone Number Type	1	0 = Residential 1 = Commercial 2 = Mobile 3 = Husband/Wife 4 = Parents 5 = Neighbor 6 = Message 7 = Emergency**
observation	No	String	Telephone Observation	50

*Not repetead **Default Value

Vacation Acquisitive Period

Filename: vacationacquisitiveperiod.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
acquisitive_period_start	Yes	Date	Acquisitive Period Start
acquisitive_period_end	Yes	Date	Acquisitive Period End
consessive_period_start	Yes	Date	Consessive Period Start
consessive_period_end	Yes	Date	Consessive Period End
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
vacation_days	Yes	Integer	Number of Vacation Days	2	from 1 to 30

*Not repetead **Default Value

Vacation

Filename: vacation.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
start	Yes	Date	Vacation Start
end	Yes	Date	Vacation End
acquisitive_period_start	No	Date	Acquisitive Period Start		Reference to the beginning of the worker's Acquisition Period.
status	Yes	String		50	Planned Confirmed Canceled**

*Not repetead **Default Value

Operational Unit / Rig / Vessel

Filename: operationunit.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
description	Yes*	String	Operational Unit Description	60
acronym	Yes*	String	Operational Unit Acronym	10
costcenter_code	No	String	Cost Center Code	20	Reference to a Cost center’s Code When sending the costcenter_code in this column, it is mandatory to send the this information in the sheet with costcenter.
type	No	Integer	Operational Unit Type	1	0 = Onshore 1 = Offshore 2 = Extra**

*Not repetead **Default Value

When a role is sent and there is more than one salary level for it, it will be mandatory to send the role Role Level - Job Level.

Role - Job

Filename: role.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
code	Yes	String	Role Code	20
name	Yes*	String	Role Name	200
category	No	String	category type of the function	10	OnShore OffShore Maritime**
origin	No	String	Role Classification	50	Operation General Payroll**
salary	Yes	Decimal	Role Level Salary	19,4	from 0,00 to 922.337.203.685.477,5807**

*Not repetead **Default Value

Role Level - Job Level

Filename: rolelevel.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
role_name	Yes	String	Role Name	200	Reference to a Role’s Name When sending the role_name in this column, it is mandatory to send the this information in the sheet with role.
name	Yes	String	Role Level Name	40
salary	Yes	Decimal	Role Level Salary	19,4	from 0,00 to 922.337.203.685.477,5807**

*Not repetead **Default Value

Absence

Filename: absence.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
start	Yes	Date	Absence Start
end	No	Date	Absence End

*Not repetead **Default Value

Document

Filename: document.csv

Attention points:

1 - One of the fields: “worker_name”, “company_name” or “operation_unit_acronym” needs to be filled in, as it indicates the owner of the document

2- The mandatory of some indicated fields may vary according to the type of document. For cases where the field becomes mandatory, the corresponding document type is identified.

Property	Mandatory?	Data Type	Description	Size	Accepted Values
document_type_know_id	Yes	String	Known document types in Drake	200	OccupationalHealth Certificate Passport Detached Cpf NationalIdentityCard
worker_name	Mutually Exclusive (1)	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
company_name	Mutually Exclusive (1)	String	Company Name	80	Reference to a Company Name When sending the company_name in this column, it is mandatory to send the this information in the sheet with company.
operation_unit_acronym	Mutually Exclusive (1)	String	Operational Unit Acronym	10	Reference to an Operating’s Unit Acronym When sending the operation_unit_acronym in this column, it is mandatory to send the this information in the sheet with operationunit.
issuer_name	No	String	Document Issuer Name	80	Reference to a Company Name When sending the company_name in this column, it is mandatory to send the this information in the sheet with company.
qualification_name	Yes	String	Qualification name	255	Reference to a Qualification’s Name When sending the qualification_name in this column, it is mandatory to send the this information in the sheet with qualification.
title	No	String	Title of document	200
number	No	String	Number of document	100
comment	No	String	Comments of document	4000
place	No	String	Place where the document was issued	50
responsible_person	No	String	Responsible for the document	50
fit_for_work	Mandatory for OccupationalHealth document type (2)	Integer	Approved / Rejected Indicator.	1	0 = No 1 = Yes
issue_date	Yes	Date	Issue Date
valid_until_date	No	Date	Due date
receipt_date	No	Date	Receipt Date
period_start_date	No	Date	Training start period
period_end_date	No	Date	Training end period
online_training	Mandatory for Certificate document type (2)	Integer	Indicates whether the training was done online	1	0 = No 1 = Yes
first_entry_date	No	Date	Applicable for VISA document type
create_date	No	Date	Document creation date

*Not repetead **Default Value

Medical Licence

Filename: medicallicence.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
start	Yes	Date	Medical Licence Start
end	No	Date	Medical Licence End
end_of_leave	No	Date	Last day before return to work

*Not repetead **Default Value

Cost center

Filename: costcenter.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
name	No	String	Cost Center Name	50
code	Yes*	String	Cost Center Code	20
active	Yes	Integer	Cost Center Activity indicator	1	0 = No 1 = Yes**
client_code	No	String	Client Cost Center Code	50

*Not repetead **Default Value

Qualification

Filename: qualification.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
name	Yes*	String	Qualification Title Name	255
acronym	No	String	Qualification Title Acronym	10
is_expirable	Yes	Integer	Qualification Expirable Indicator	1	0 = No 1 = Yes
validity_in_months	Yes	Integer	Quantity months validity	4	0 to 9999

*Not repetead **Default Value

Contract

Filename: contract.csv

Propriedade	Mandatory?	Data Type	Description	Size	Accepted Values
number	Yes*	String	Contract Number	60
title	No	String	Contract Title	100
description	No	String	Contract Description	4000
start	No	Date	Contract Start
end	No	Date	Contract End

*Not repetead **Default Value

Contract Member

Filename: contractmember.csv

Property	Mandatory?	Data Type	Description	Size	Accepted Values
contract_number	Yes	String	Contract Number	60	Reference to a Contract’s Number When sending the contract_number in this column, it is mandatory to send the this information in the sheet with contract.
worker_name	Yes	String	Worker Name	80	Reference to a Worker’s Name When sending the worker_name in this column, it is mandatory to send the this information in the sheet with worker.
main_contract	Yes	Integer		1	0 = No 1 = Yes**

*Not repetead **Default Value

Worker Template

Objective

Spreadsheet

Files Samples:

Notes:

Definition

Worker

Department

Nationality

Country

Company

Address

Email

Telephone

Vacation Acquisitive Period

Vacation

Operational Unit / Rig / Vessel

Role - Job

Role Level - Job Level

Absence

Document

Medical Licence

Cost center

Qualification

Contract

Contract Member

Category