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. There are function access profile permissions required to import data. Refer to Create a Gaming Function Access Profile for more information.

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
- Toke Pool Amounts — You can import toke pool amounts for one toke pool at a time.
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

Toke Pool Amounts

This table contains details about the fields and field values to include in the csv file for the Toke Pool Amounts import type.For the column header, only include the name as listed in the Field column. Do not include extra characters or spaces.

Field	Field Value Description	Default Value	Required
TokePoolName	Name of the configured Toke Pool for which data needs to be imported	No default value	Yes
TokePoolDate	Date for which the committee and adjustment entries will be imported for given toke pool	No default value	Yes
GrossAmount	Gross amount value to be added in Enter Amount screen for a particular toke pool and date. The value can be positive or negative.	0	No
OtherDeduction	Other deduction value to be added in Enter Amount screen for a particular toke pool and date. The value can be positive or negative.	0	No
PersonNumber	Person Number value for the person that has either a committee entry, adjustment entry, or both	No default value	Yes
CommitteeAmount	Committee Amount for the person The value cannot be 0. If there is a value for CommitteeAmount, then it is implied that there is a committee entry. If there is no value for CommitteeAmount or for CommitteePayCodeName this is still valid as it suggests that there aren't any committee entries but there could be adjustments.	No default value	No
CommitteePayCodeName	Pay code value for the committee entry of the given person	No default value	Required if a value exists for CommitteeAmount
AdjustmentsReason	The type for the adjustment entry. The value can be either Amount or Hours. If a value is entered this implies that an adjustment entry is imported.	No default value	No
AdjustmentsAmount	Amount value for Adjustment entry for the given person. The value cannot be 0. If a value is entered, this implies that an adjustment entry is imported. If there aren't any values for AdjustmentsAmount or AdjustmentsPayCodeName this is still valid because it implies there isn't an adjustment entry but there could be a committee entry.	No default value If the AdjustmentsReason value is Hours, this field should be empty.	No
AdjustmentsHours	Hours value for Adjustment entry for the given person The value cannot be 0. If a value is entered, this implies that an adjustment entry is imported. If there aren't any values for AdjustmentsHours or AdjustmentsPayCodeName this is still valid because it implies there isn't an adjustment entry but there could be a committee entry.	No default value If the AdjustmentsReason value is Amount, this field should be empty.	No
AdjustmentsPayCodeName	Paycode name for the Adjustments entry for the given person	No default value	Required if a value exists for AdjustmentsReason and AdjustmentsAmount/AdjustmentsHours