...
Field # | Field | Type | Description | Required | Comments |
1 | Name | String | Name | Yes | Min Length: 6 Max Length: 200 |
2 | Address | String | Address Line 1 | Yes | Min Length: 2 Max Length: 150 |
3 | Address2 | String | Address Line 2 | Optional | Min Length: 2 Max Length: 150 |
4 | City | String | City | Yes | Min Length: 2 Max Length: 20 |
5 | State | String | State | Yes | State abbreviation of 2 characters i.e., Min Length and Max Length: 2 |
6 | PostalCode | String | Postal Code | Yes | Length = 5 numerals |
7 | CountryCode | String | 3 Letter Country Code | Yes | Should be USA |
8 | TimeZone | String | Time Zone | Yes | See “Admin Guide: Static Data Reference File for Imports” in the Help Center |
9 | Phone | String | Phone Number | Yes | 10-digit phone number; exclude dashes and parentheses |
10 | AltPhone | String | Alternate Phone Number | Optional | 10-digit phone number; exclude dashes and parentheses |
11 | String | Email Address | Yes | Email format: | |
12 | CostCenterId | Integer | Unique identifier for the Cost Center | Yes | Must use existing Id in DCI |
13 | ProfileReference | String | Third-party reference number for the Profile | Optional | Max Length: 200 |
14 | EVVRequired | Boolean | EVV Required | Yes | 0 - False 1 - True |
15 | EnableGeofencing | Boolean | Enable Geofencing | Conditional -Required if EVVRequired = 1 True | 0 - False 1 - True |
16 | RequiresMultipleClientPerPunch | Boolean | Requires Multiple Client Per Punch | Yes | 0 - False 1 - True |
17 | MinimumNumberOfAttendees | Integer | Value of the minimum number of Attendees should be defined | Required | The column is selectively mandatory when RequiresMultipleClientPerPunch=1 |
Update Employee Profile
Field # | Field | Type | Description | Required | Comments |
1 | ProfileId | Integer | Unique profile Id | Yes | Must be the existing employee profile Id |
2 | FirstName | String | First Name | Yes | Min Length: 2 Max Length: 50 |
3 | LastName | String | Last Name | Yes | Min Length: 2 Max Length: 50 |
4 | FullName | String | Full Name | Optional | Min Length: 2 Max Length: 200 |
5 | Address | String | Address Line 1 | Yes | Min Length: 2 Max Length: 150 |
6 | Address2 | String | Address Line 2 | Optional | Min Length: 2 Max Length: 150 |
7 | City | String | City | Yes | Min Length: 2 Max Length: 20 |
8 | State | String | State | Yes | The state’s two letter abbreviation (i.e., AZ) |
9 | PostalCode | String | Postal Code | Yes | Length = 5 numerals |
10 | Phone | String | Phone Number | Yes | 10-digit phone number; exclude dashes and parentheses |
11 | AltPhone | String | Alternate Phone Number | Optional | 10-digit phone number; exclude dashes and parentheses |
12 | MobilePhone | String | Cell Phone Number | Optional | 10-digit phone number; exclude dashes and parentheses |
13 | String | Email Address | Yes | Email format: test@dcisoftware.com | |
14 | TimeZone | String | Time Zone | Yes | See “Imports – Static Data Reference File – Admin Guide” in the Help Center |
15 | CostCenterId | Integer | Unique cost center Id | Yes | Must be the existing cost center Id |
16 | DOB | Date | Date of Birth | Yes | Format: MM/DD/YYYY |
17 | ProfileReference | String | Third-party reference number for the profile | Optional | Min Length: 1 Max Length: 200 |
18 | EmployeeType | Integer | Employee Type | Yes | See “Imports – Static Data Reference File – Admin Guide” in the Help Center: Hourly Non-Exempt: 2 Salary Exempt: 3 Salary Non-Exempt: 4 Contractor: 5 |
19 | EmployeeNumber | String | Third-party employee number | Yes | Min Length: 2 Max Length: 20 |
20 | SSN | String | Social Security Number | Yes | Min and Max Length: 9 (Numerals) Full non-encrypted social security number |
21 | ProfessionalId1 | String | Third-party professional identifier | Optional | Min Length: 2 Max Length: 20 |
22 | ProfessionalId2 | String | Third-party professional identifier | Optional | Min Length: 2 Max Length: 20 |
23 | PayrollId | String | Third-party payroll identifier | Optional | Min Length: 2 Max Length: 20 |
24 | WeeklyHours | Decimal | Weekly Hours available to work | Yes | Min Length: 2 Max Length: 20 |
25 | HolidayScheduleId | Integer | Holiday Schedule identifier | Yes | Must be the existing holiday schedule Id |
26 | TemplateId | Integer | Certification Template Id | Optional | Must be the existing certification template Id |
27 | DomesticWorker | Boolean | Domestic Worker | Yes | 0 – No 1 - Yes |
28 | OneDayRestIn7Exemption | Boolean | One Day of Rest in 7 Exemption | Yes | 0 – No 1 - Yes |
29 | PreferredDayOfRest | Integer | Preferred Day Of Rest | Conditional – Required if OneDayRestIn7Exemption = 1 (Yes) | 0 – Sunday 1 – Monday 2 – Tuesday 3 – Wednesday 4 – Thursday 5 – Friday 6 - Saturday |
30 | RetainSSN | Bit | Checks whether the SSN needs to be stored in Encrypted SSN or not | No | 0 – No 1 - Yes |
31 | HireDate | Date | Hire Date of Employee | No | Format: MM/DD/YYYY |
32 | Pin | Nvarchar | Login Pin of the Employee | Yes | Min/Max Length: 4 |
33 | ProfileStatus | Integer | Status of the Employee | Yes | 1 – Active 2 - Inactive |
Update Employee Profile Element
Field # | Field | Type | Description | Required | Comments |
1 | ProfileId | Integer | Unique Id of the Profile | Yes | Should be the existing Id of the Employee Profile |
2 | DataElementName | String | Name of the columns - SSN - EmployeeNumber - RetainSSN - ProfileReference - AuthenticationStatus | Yes | Columns: SSN Should be of 9 Numerals EmployeeNumber Min Length - 2 Max Length - 20 ProfileReference Min Length - 2 Max Length - 200 RetainSSN Must have value 0 or 1 Value: ● 0 - No ● 1 - Yes AuthenticationStatus Should be the existing Authentication status Id: ● 1 - Active ● 2 - Disabled ● 3 - Locked |
3 | NewDataValue | String | Data | No | Data corresponding to the column - SSN - EmployeeNumber - RetainSSN - ProfileReference - AuthenticationStatus |
...