Data import for Gaming

If you have gaming data and settings stored in files (.csv format), you can import the data within the Gaming application.

In the Gaming Application, go to Administration > Data Import.
Select the Import Type:
- Skills
- Certifications
- Persons — Select Gaming Settings, Person Skills, or Person Certifications.
- Jobs — Select Job Settings, Job Skills, or Job Certifications.
- Tip Compliance Rates
Click Browse to select the import file.
Select the Delimiter.
Click Import File.

Import Type details

The following sections contain details about the field and field values to include in the csv file for each Import Type. The default value (if any) for the field and if the field is required are also included.

Skills

This table contains details about the fields and field values to include in the csv file for the Skills import type.

Field	Field Value Description	Default Value	Required
SkillName	Name of skill	No default value	Yes
Description	Description of skill	No default value	Yes

Certifications

This table contains details about the fields and field values to include in the csv file for the Certifications import type.

Field	Field Value Description	Default Value	Required
CertificationName	Name of certification	No default value	Yes
Description	Description of certification	No default value	Yes
WarningDaysToExpire	Number of days before certificate expiration to begin warning the user at the clock	No default value	Yes
PreliminaryWarningDaysToExpire	Number of days before certificate expiration to begin giving preliminary warning to the user at the clock If defined, must be greater than the value for WarningDaysToExpire	None	No

Person Gaming Settings

This table contains details about the fields and field values to include in the csv file for the Person Gaming Settings import type.

Field	Field Value Description	Default Value	Required
PersonNumber	The employee's person number	No default value	Yes
TipMethod	The employee's tip method. Values are: Tip Compliance, Tip Declaration, Refer To Job, Neither Tip Declaration Nor Tip Compliance, None	None	No
TipComplianceStartDate	Start date for tip compliance in YYYY-MM-DD format	No date	Required only if TipMethod is set to “Tip Compliance”
TipComplianceEndDate	End date for tip compliance in YYYY-MM-DD format	No date	Required only if TipMethod is set to “Tip Compliance”
TokeProcessingMethod	The employee's toke processing method. Values are: Home, Worked, Greater of Home or Worked, Exclude, None	None	No
PayCodeForTipDeclaration	Name of the pay code used for tip declaration	No pay code	No
TokePoolProfile	Name of the employee's toke pool profile	No toke pool profile	No
GamingFAP	Name of the employee's Gaming Function Access Profile (FAP)	No Gaming FAP	No
TransactionProfile	Name of the employee's Transaction Profile	No transaction profile	No
EarlyOutShiftLength	Length of time after the beginning of the shift to define an early out, in seconds	No early out shift length	No

Person Skills

This table contains details about the fields and field values to include in the csv file for the Person Skills import type.

Field	Field Value Description	Default Value	Required
PersonNumber	The employee's person number	No default value	Yes
Skill	Name of skill	No default value	Yes
EffectiveDate	Effective date in YYYY-MM-DD format	No default value	Yes
Proficiency	Proficiency Level – Integer value. If defined, must be greater than zero.	No proficiency level	No

Person Certifications

This table contains details about the fields and field values to include in the csv file for the Person Certifications import type.

Field	Field Value Description	Default Value	Required
PersonNumber	The employee's person number	No default value	Yes
Certification	Name of certification	No default value	Yes
GrantDate	Grant date in YYYY-MM-DD format	No default value	Yes
ExpirationDate	Expiration date in YYYY-MM-DD format	No default value	Yes
Number	Certification number	No default value	Yes
Proficiency	Proficiency Level – Integer value. If defined, must be greater than zero.	No proficiency level	No

Job Code Settings

This table contains details about the fields and field values to include in the csv file for the Job Code Settings import type.

Field	Field Value Description	Default Value	Required
Job	Job name	No default value	Yes
TipMethod	The job's tip method. Values are: Tip Compliance, Tip Declaration, Neither Tip Declaration Nor Tip Compliance, None	None	No
MinimumOptionalSkills	If specified, the minimum number of optional skills that can be used to satisfy the job requirements. This is an integer value greater than or equal to zero.	None	No
MinimumOptionalCertifications	If specified, the minimum number of optional certifications that can be used to satisfy the job requirements. This is an integer value greater than or equal to zero.	None	No

Job Code Skills

This table contains details about the fields and field values to include in the csv file for the Job Code Skills import type.

Field	Field Value Description	Default Value	Required
Job	Job name	No default value	Yes
Skill	Skill name	No default value	Yes
Proficiency	Proficiency Level – Integer value. If defined, must be greater than zero.	No proficiency level	No
EnforcementLevel	Values are: Required or Optional	Required	No

Job Code Certifications

This table contains details about the fields and field values to include in the csv file for the Job Code Certifications import type.

Field	Field Value Description	Default Value	Required
Job	Job name	No default value	Yes
Certification	Name of certification	No default value	Yes
Proficiency	Proficiency Level – Integer value. If defined, must be greater than zero.	No proficiency level	No
EnforcementLevel	Values are: Required, Optional, or Conditional	Required	No

Tip Compliance Rates

This table contains details about the fields and field values to include in the csv file for the Tip Compliance Rates import type.

Field	Field Value Description	Default Value	Required
LocationSequence	List of location types, jobs, or “shift” separated by slashes (/). For example, “Department/Job” or “Area/Facility/Shift”.	No default value	Yes
Location1 Location2 Location3 Location4 Location5 Location6 Location7	Location corresponding to the value in LocationSequence. There must be one defined for each location type or job specified in LocationSequence (except for shift). The number of locations defined must match the number of types or jobs specified in LocationSequence.	No default value	Yes
Shift	Indicates the work shift	No default value	Required if “Shift” is specified in LocationSequence
EffectiveDate	Effective date in YYYY-MM-DD format	No default value	Yes
Rate	Pay rate	No default value	Yes
PayCode	Name of pay code	No paycode	No