Personnel Activity Tracker - File Layout and Data Mapping
The Personnel Activity Tracker import file format is .xml, .exml, .csv,.txt, or .unl.
The following table shows the data columns, names, descriptions, and destination database fields in the Personnel Activity Tracker .csv import file.
Column | Name | Description | Destination Database Field (table.field) |
|---|---|---|---|
A | Employee Number | The employee number. | pat_act.empl_no |
B | Free Text | Additional information about the employee's activity record. | pat_act.free_text |
C | Situation User 1 | User-defined Field Number 1 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data1 |
D | Situation User 10 | User-defined Field Number 10 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data10 |
E | Situation User 11 | User-defined Field Number 11 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data11 |
F | Situation User 12 | User-defined Field Number 12 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data12 |
G | Situation User 13 | User-defined Field Number 13 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data13 |
H | Situation User 14 | User-defined Field Number 14 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data14 |
I | Situation User 15 | User-defined Field Number 15 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data15 |
J | Situation User 16 | User-defined Field Number 16 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data16 |
K | Situation User 17 | User-defined Field Number 17 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data17 |
L | Situation User 18 | User-defined Field Number 18 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data18 |
M | Situation User 19 | User-defined Field Number 19 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data19 |
N | Situation User 2 | User-defined Field Number 2 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data2 |
O | Situation User 20 | User-defined Field Number 20 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data20 |
P | Situation User 3 | User-defined Field Number 3 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data3 |
Q | Situation User 4 | User-defined Field Number 4 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data4 |
R | Situation User 5 | User-defined Field Number 5 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data5 |
S | Situation User 6 | User-defined Field Number 6 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data6 |
T | Situation User 7 | User-defined Field Number 7 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data7 |
U | Situation User 8 | User-defined Field Number 8 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data8 |
V | Situation User 9 | User-defined Field Number 9 for the Situation Name CRDC on the Situation Type Table page. | pat_act.sit_data9 |
W | Description | The description of the employee's activity record. | pat_act.sit_desc |
X | End Date | The ending date for the situation or activity. | pat_act.sit_end_dat |
Y | Start Date | The beginning date for the situation or activity. | pat_act.sit_st_dat |
Z | Situation Type | The type of situation for the employee's activity. The valid value is CRDC. | pat_act.sit_type |