Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Email

String

Email Address

Yes

Email format:

test@dcisoftware.com

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

Email

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

...