Compliance Template for import

Owned by Andre Novais
Last updated: set. 24, 2024 by Rodrigo Rodrigues
2 min read

Objective

This article is intended to delineate the potential import objects within the compliance module.

 

 

ATTENTION

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

 

 

Notes:

  1. The date fields must use the mask: YYYY-MM-DD

  2. The decimal separator must be "."

  3. Decimal thousands separator should not be used.

 

Definition

matrix

Property

Mandatory?

Data Type

Description

Size

Accepted Values

name

Yes*

String

Matrix Name

255

 

acronym

No*

String

Matrix Acronym

10

 

description

Yes*

String

Matrix Description

4.000

 

show_for_mydrake_users

Yes

Integer

Show for myDrake Users

 1

0 = No**
1 = Yes

days_in_advance_to_automatically_schedule_internal_online_training

Yes

Integer

Days in advance to automatically schedule internal online training

 4

from 0** to 9999

*Not repetead **Default Value

 

qualification

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

 

qualification_requirement_type

Property

Mandatory?

Data Type

Description

Size

Accepted Values

name

Yes*

String

Qualification Requirement Type Name

255

 

acronym

No*

String

Qualification Requirement Type Acronym

10

 

must_be_accomplished_by_supplier

Yes

Integer

Must be accomplished by supplier

 1

0 = No**
1 = Yes

*Not repetead **Default Value

qualification_requirement

Property

Mandatory?

Data Type

Description

Size

Accepted Values

matrix_name

Yes

String

Matrix Name

255

 

description

No

String

Description

255

 

qualification_name

Yes

Integer

Qualification Name

255

 

qualification_requirements_name

Yes

String

Qualification Requirements Name

255

 

operationaunit_acronym

No

String

Operational Unit Acronym

10

When sending the operationunit_acronym in this column, it is mandatory to send the this information in the sheet with name operationunit.

department_name

No

String

Department Name

200

When sending the department_name in this column, it is mandatory to send the this information in the sheet with name department.

role_code

No

String

Role Code

20

When sending the role_code in this column, it is mandatory to send the this information in the sheet with name role.

contract_number

No

String

Contract Number

60

When sending the contract_number in this column, it is mandatory to send the this information in the sheet with name contract.

country_acronym

No

String

Country

10

When sending the country_acronym in this column, it is mandatory to send the this information in the sheet with name country.

worker_type

No

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

activit_name

No

String

Activit Name

1.000

When sending the activit_name in this column, it is mandatory to send the this information in the sheet with name activit

costcenter

Property

Mandatory?

Data Type

Description

Size

Accepted Values

name

No*

String

Cost Center Name

50

 

code

Yes*

String

The value of this column can be the same as ID column

20 

 

active

Yes

Integer

Cost Center Activity indicator

 

0 = No
1 = Yes**

client_code

No

String

Client Cost Center Code

50

 

*Not repetead **Default Value

operationunit

Property

Mandatory?

Data Type

Description

Size

Accepted Values

description

No

String

Operational Unit Description

 60

 

acronym

Yes

String

Operational Unit Acronym

10

 

costcenter_code

No

String

Cost Center Code

200

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

 

0 = Onshore
1 = Offshore
2 = Extra

 

department

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

role

Property

Mandatory?

Data Type

Description

Size

Accepted Values

name

Yes*

String

Role Name

200

 

code

Yes*

String

Role Code

20

 

active

Yes

Integer

Role activity indicator

 

0 = No
1 = Yes**

category

No

String

category type of the function

10

OnShore
OffShore**
Maritime

origin

No

String

Role Classification

50

Operation
General**
Payroll

salary

No

Decimal

Role Level Salary

 

from 0.00** to 999999999.99

*Not repetead **Default Value

contract

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

country

Property

Mandatory?

Data Type

Description

Size

Accepted Values

acronym

Yes*

String

Country Acronym

10

 

name

No*

String

Country Name

500

 

iso_code

No

String

Code of country as listed on ISO 3166-2

2

https://en.wikipedia.org/wiki/ISO_3166-2

*Not repetead

 

activit

Propriedade

Mandatory?

Data Type

Description

Size

Accepted Values

name

Yes*

String

Activit Name

1.000

 

description

No*

String

Activit Description

4.000

 

acronym

No*

String

Activit Acronym

100

 

 

Caso surja alguma dúvida, entre em contato com nosso suporte através do E-mail: suporte@sapiensia.com / ou Telefone em: +55 (21) 2391-4726