Administrator and manager
Table name:
Description: System administrator data
Data description
|
Type
|
Data exported
|
operator_key
|
Integer
|
Operator key
|
employee_key
|
Integer
|
Employee key
|
employee_surname
|
24-character string
|
Employee’s surname
|
employee_first_name
|
24-character string
|
Employee’s first name
|
employee_identification_number
|
16-character string
|
Employee’s ID
|
EMPLOYEE_IDENTIFICATION_CODE
|
80-character string
|
Employee ID number code
|
employee_badge_code
|
16-character string
|
Employee’s badge 1 number
|
operator_surname
|
24-character string
|
Operator surname
|
operator_first_name
|
24-character string
|
Operator first name
|
login
|
80-character string
|
Operator login
|
password_operator
|
32-character string
|
Operator password encrypted in MD5
|
language
|
Integer
|
Software language for the employee
1 English (United States)
2 English (Canada)
3 French Canada)
7 Russian (terminal)
27 English (South Africa)
30 Greek
31 Dutch (Netherlands)
32 Dutch (Belgium)
33 French
34 Spanish
39 Italian
40 Romanian (terminal)
41 French (Switzerland)
44 English (United Kingdom)
45 Danish
47 Norwegian
48 Polish (terminal and employee self-service)
49 German
90 Turkish (terminal)
96 Basque (terminal)
97 Catalan (terminal)
99 Test language
101 Welsh
263 English (Cyprus)
351 Portuguese
353 English (Ireland)
371 Latvian (terminal)
420 Czech (terminal)
966 Arabic (Experimental)
971 English (United Arab Emirates)
|
senders_email
|
255-character string
|
Sender email address
|
recipients_email
|
255-character string
|
Recipient email address
|
duration_visualization
|
Integer
|
Duration visualisation format
0 Hours minutes
1 Hours hundredths
|
site_key
|
Integer
|
Work site key
|
work_site_description
|
40-character string
|
Work site description
|
Back to top
|
Populations
Table name:
Description: Information on populations
Data description
|
Type
|
Data exported
|
population_key
|
Integer
|
Population key
|
employee_key
|
Integer
|
Employee key
|
operator_key
|
Integer
|
Operator key
|
start_date
|
Date
|
Date when the employee starts to be taken into account in the population
Format: yyyy-mm-dd
|
employee_surname
|
24-character string
|
Employee’s surname
|
employee_first_name
|
24-character string
|
Employee’s first name
|
employee_identification_number
|
16-character string
|
Employee’s identification number
|
EMPLOYEE_IDENTIFICATION_CODE
|
80-character string
|
Employee ID number code
|
employee_badge_code
|
16-character string
|
Employee’s badge 1 number
|
population_description
|
255-character string
|
Population description
|
end_date
|
Date
|
Date when the employee is no longer taken into account in the population
|
operator_surname
|
24-character string
|
Operator surname
|
operator_first_name
|
24-character string
|
Operator first name
|
login
|
80-character string
|
Operator login
|
password_population
|
32-character string
|
Operator password encrypted in MD5
|
Back to top
The system exports the employees from each population managed by each administrator for each registered date of the employee in the populations. To do so, the system must extract the employee assignments for each population.
|
Employee groups
Table name:
Description: Information on groups of employees
Data description
|
Type
|
Data exported
|
employee_group_key
|
Integer
|
Employee group key
|
employee_key
|
Integer
|
Employee key
|
employee_surname
|
24-character string
|
Employee’s surname
|
employee_first_name
|
24-character string
|
Employee’s first name
|
employee_identification_number
|
16-character string
|
Employee’s identification number
|
EMPLOYEE_IDENTIFICATION_CODE
|
80-character string
|
Employee ID number code
|
employee_badge_code
|
16-character string
|
Employee’s badge 1 number
|
employee_group_description
|
40-character string
|
Employee group description
|
Back to top
|
Organisation chart
Table name:
Description: Information on the organisation chart
Data description
|
Type
|
Data exported
|
organization_chart_key
|
Integer
|
Organisation chart key
|
company_key
|
Integer
|
Company key
|
company_description
|
50-character string
|
Company name
|
company_adress
|
250-character string
|
Company address
|
company_phone_number
|
15-character string
|
Company telephone number
|
company_fax_number
|
15-character string
|
Company fax number
|
company_file_number
|
40-character string
|
Company file number
|
level_8_description
|
50-character string
|
Level 8 description
|
level_8_key
|
Integer
|
Level 8 key
|
level_8_manager
|
50-character string
|
Level 8 manager
|
level_7_description
|
50-character string
|
Level 7 description
|
level_7_key
|
Integer
|
Level 7 key
|
level_7_manager
|
50-character string
|
Level 7 manager
|
level_6_description
|
50-character string
|
Level 6 description
|
level_6_key
|
Integer
|
Level 6 key
|
level_6_manager
|
50-character string
|
Level 6 manager
|
level_5_description
|
50-character string
|
Level 5 description
|
level_5_key
|
Integer
|
Level 5 key
|
level_5_manager
|
50-character string
|
Level 5 manager
|
level_4_description
|
50-character string
|
Level 4 description
|
level_4_key
|
Integer
|
Level 4 key
|
level_4_manager
|
50-character string
|
Level 4 manager
|
firm_key
|
Integer
|
Company key
|
firm_description
|
50-character string
|
Company description
|
firm_manager
|
50-character string
|
Company manager
|
departement_key
|
Integer
|
Department key
|
departement_description
|
50-character string
|
Department description
|
departement_manager
|
50-character string
|
Department manager
|
sub_departement_key
|
Integer
|
Sub-department key
|
sub_departement_description
|
50-character string
|
Sub-department description
|
sub_departement_manager
|
50-character string
|
Sub-department manager
|
section_key
|
Integer
|
Section key
|
SECTION_ABBREVIATION
|
13-character string
|
Section abbreviation
|
section_description
|
50-character string
|
Section description
|
section_manager
|
50-character string
|
Section manager
|
level_type
|
Boolean variable
|
Level type
|
Back to top
|
Default section(s) activities
Table name:
Description: Default activity history by department set up in the organisation chart.
Data description
|
Type
|
Data exported
|
SECTION_KEY
|
Integer
|
Technical section key
|
DEFAULT_JOB_APP_START_DATE
|
Date
|
Start date of the service's default activity assignment
|
SECTION_PARENT_KEY
|
Integer
|
Technical key of the related level of the service in the organisation chart
|
SECTION_PARENT_INFO
|
50-character string
|
Information about the related level of the service in the organisation chart
|
SECTION_PARENT_DESCRIPTION
|
50-character string
|
Description of the related level of the service in the organisation chart
|
SECTION_INFO
|
50-character string
|
Information about the section
|
SECTION_ABBREVIATION
|
40-character string
|
Section abbreviation
|
SECTION_DESCRIPTION
|
50-character string
|
Section description
|
DEFAULT_JOB_APP_END_DATE
|
Date
|
End date of the service's default activity assignment
|
DEFAULT_JOB_ABBREVIATION
|
5-character string
|
Default task abbreviation
|
DEFAULT_JOB_CODE
|
40-character string
|
Default task code
|
DEFAULT_JOB_DESCRIPTION
|
40-character string
|
Default task description
|
DEFAULT_COST_CENTRE_ABBRE
|
5-character string
|
Default cost centre abbreviation
|
DEFAULT_COST_CENTRE_CODE
|
40-character string
|
Default cost centre code
|
DEFAULT_COST_CENTRE_DESC
|
40-character string
|
Default cost centre description
|
DEFAULT_CUSTOMER_ABBREV
|
5-character string
|
Default customer abbreviation
|
DEFAULT_CUSTOMER_CODE
|
40-character string
|
Default customer code
|
DEFAULT_CUSTOMER_DESC
|
40-character string
|
Default customer description
|
Back to top
|
Payroll periods
Table name:
Description: For each payroll period their associated payroll calendar
Data description
|
Type
|
Data exported
|
payroll_period_key
|
Integer
|
Payroll period key
|
payroll_calendar_key
|
Integer
|
Payroll calendar key
|
payroll_calendar_description
|
40-character string
|
Payroll calendar description
|
start_date
|
Date
|
Start of the period date
|
end_date
|
Date
|
End of the period date
|
locked_results
|
Boolean variable
|
Locked results at the end of the period
0no
1yes |
Back to top
|
