Labor Details and Employee Information Subject Areas
The labor details and employee information subject areas include data related to Labor Management configuration, such as job rates and employees, as well as time card and other pay information. If you have Labor Management, you should use the subject areas that include Enterprise in the title. The subject areas include:
Employees
Data Permissions: POS Definitions, Employee Identifiable Information, Sensitive Identifiable Information, and General Labor.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Address Line 1 | addr1 | N/A | N/A | String | Text |
Address Line 2 | addr2 | N/A | N/A | String | Text |
Age Certification Date | ageCertDt | N/A | N/A | Date | Date |
Age Certification Number | ageCert | N/A | N/A | String | Text |
Alien Admin Number | alienNum | N/A | N/A | String | Text |
Bank 1 Account Number | bnkAccNum1 | N/A | N/A | String | Text |
Bank 1 Account Type | bnkAccType1 | N/A | N/A | String | Text |
Bank 1 Amount | bnkAmt1 | N/A | N/A | String | Text |
Bank 1 Amount Type | bnkAmtType1 | N/A | N/A | String | Text |
Bank 1 ID | bnkId1 | N/A | N/A | String | Text |
Bank 1 Route Code | bnkRt1 | N/A | N/A | String | Text |
Bank 2 Account Number | bnkAccNum2 | N/A | N/A | String | Text |
Bank 2 Account Type | bnkAccType2 | N/A | N/A | String | Text |
Bank 2 Amount | bnkAmt2 | N/A | N/A | String | Text |
Bank 2 Amount Type | bnkAmtType2 | N/A | N/A | String | Text |
Bank 2 ID | bnkId2 | N/A | N/A | String | Text |
Bank 2 Route Code | bnkRt2 | N/A | N/A | String | Text |
City | addrCity | N/A | N/A | String | Text |
City Additional Withholdings | cityAddtlWiHo | N/A | N/A | String | Text |
City Tax Exempt Flag | cityExmptFlg | N/A | N/A | String | Text |
Country | addrCountry | N/A | N/A | String | Text |
County | addrCounty | N/A | N/A | String | Text |
Date Of Birth | dob | N/A | N/A | Date | Date |
Earned Income Credit | earnedIncCred | N/A | N/A | String | Text |
Effective From | effectFrom | N/A | N/A | Date | Date |
Effective To | effectTo | N/A | N/A | Date | Date |
empEmail | N/A | N/A | String | Text | |
Emergency Contact Address | emergAddr | N/A | N/A | String | Text |
Emergency Contact Name | emergContName | N/A | N/A | String | Text |
Emergency Contact Phone Number | emergContPhNum | N/A | N/A | String | Text |
Emergency Contact Relation | emergContRel | N/A | N/A | String | Text |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | EmpNum | N/A | N/A | String | Text |
Ethnicity | empEthnicity | N/A | N/A | String | Text |
Exclude EU Directives | exclEuDir | N/A | N/A | String | Text |
Expiration Date | expDate | N/A | N/A | Date | Date |
Fax Number | faxNum | N/A | N/A | String | Text |
Fed Additional Withholding | fedAddtlWiHo | N/A | N/A | String | Text |
Federal Exemptions | fedExmpt | N/A | N/A | String | Text |
Federal Marital Status | fedMaritalStatus | N/A | N/A | String | Text |
Federal Tax Exempt Flag | fedExmptFlg | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Gender | custGender | N/A | N/A | String | Text |
Hire Date | empHireDate | N/A | N/A | Date | Date |
Hire Status | empHireStat | N/A | N/A | String | Text |
I9 ID 1 Expiration Date | i9Exp1 | N/A | N/A | Date | Date |
I9 ID 1 Number | i9Num1 | N/A | N/A | String | Text |
I9 ID 1 Type | i9Type1 | N/A | N/A | String | Text |
I9 ID 2 Expiration Date | i9Exp2 | N/A | N/A | Date | Date |
I9 ID 2 Number | i9Num2 | N/A | N/A | String | Text |
I9 ID2 Type | i9Type2 | N/A | N/A | String | Text |
I9 ID Category | I9Cat | N/A | N/A | String | Text |
I9 Resident Status | i9ResStatus | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Last Updated Date | updatedDate | N/A | N/A | Date | Date |
Live On Property | liveOnProp | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Middle Name | midName | N/A | N/A | String | Text |
Name Prefix | namePrefix | N/A | N/A | String | Text |
Name Suffix | nameSuffix | N/A | N/A | String | Text |
Other Phone Number | otherPhNum | N/A | N/A | String | Text |
Part Time Flag | partTimeEmp | N/A | N/A | String | Text |
Payroll ID | payId | N/A | N/A | String | Text |
Phone Number | phoneNum | N/A | N/A | String | Text |
Registered Disable Number | regDisNum | N/A | N/A | String | Text |
Rehire | rehireEmp | N/A | N/A | String | Text |
Rehire Date | empRehireDate | N/A | N/A | Date | Date |
Salary | empSal | N/A | N/A | String | Text |
Salary Type | empSalType | N/A | N/A | String | Text |
SSN | empSsn | N/A | N/A | String | Text |
State | addrState | N/A | N/A | String | Text |
State Additional Withholdings | stateAddtlWiho | N/A | N/A | String | Text |
State Exemptions | stateExmpt | N/A | N/A | String | Text |
State Marital Status | stateMaritalStat | N/A | N/A | String | Text |
State Tax Exempt Flag | stateExmptFlg | N/A | N/A | String | Text |
Temporary Employee Flag | tempEmp | N/A | N/A | String | Text |
Termination Date | termDate | N/A | N/A | Date | Date |
Termination Note | termNote | N/A | N/A | String | Text |
Termination Reason Code 1 | termReason1 | N/A | N/A | String | Text |
Termination Reason Code 2 | termReason2 | N/A | N/A | String | Text |
Termination Reason Code 3 | termReason3 | N/A | N/A | String | Text |
Termination Reason Code 4 | termReason4 | N/A | N/A | String | Text |
User Defined Alpha 1 | userA1 | N/A | N/A | String | Text |
User Defined Alpha 2 | userA2 | N/A | N/A | String | Text |
User Defined Alpha 3 | userA3 | N/A | N/A | String | Text |
User Defined Alpha 4 | usera4 | N/A | N/A | String | Text |
User Defined Alpha 5 | userA5 | N/A | N/A | String | Text |
User Defined Alpha 6 | userA6 | N/A | N/A | String | Text |
User Defined Alpha 7 | userA7 | N/A | N/A | String | Text |
User Defined Alpha 8 | userA8 | N/A | N/A | String | Text |
User Defined Numeric 1 | userNum1 | N/A | N/A | String | Text |
User Defined Numeric 2 | userNum2 | N/A | N/A | String | Text |
User Defined Numeric 3 | userNum3 | N/A | N/A | String | Text |
User Defined Numeric 4 | userNum4 | N/A | N/A | String | Text |
Work Permit Expiration Date | workPermExp | N/A | N/A | Date | Date |
Work Permit Number | workPermNum | N/A | N/A | String | Text |
Zip Code | postCode | N/A | N/A | String | Text |
Employee Job Rates
Data Permissions: General Labor, Employee Identifiable Information, Hourly Pay Rates, and Salaried Pay Rates.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Effective From | effectFrom | N/A | N/A | Date | Date |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Primary Job Flag | jobPrimary | N/A | N/A | String | Text |
Regular Pay Rate | jobRegRate | N/A | N/A | String | Text |
Skill Level | skilllvl | N/A | N/A | String | Text |
Enterprise Employees
Data Permissions: POS Definitions, Employee Identifiable Information, General Labor, and Sensitive Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Address Line 1 | addr1 | N/A | N/A | String | Text |
Address Line 2 | addr2 | N/A | N/A | String | Text |
Age Certification Date | ageCertDt | N/A | N/A | Date | Date |
Age Certification Number | ageCert | N/A | N/A | String | Text |
Alien Admin Number | alienNum | N/A | N/A | String | Text |
Bank 1 Account Number | bnkAccNum1 | N/A | N/A | String | Text |
Bank 1 Account Type | bnkAccType1 | N/A | N/A | String | Text |
Bank 1 Amount | bnkAmt1 | N/A | N/A | String | Text |
Bank 1 Amount Type | bnkAmtType1 | N/A | N/A | String | Text |
Bank 1 ID | bnkId1 | N/A | N/A | String | Text |
Bank 1 Route Code | bnkRt1 | N/A | N/A | String | Text |
Bank 2 Account Number | bnkAccNum2 | N/A | N/A | String | Text |
Bank 2 Account Type | bnkAccType2 | N/A | N/A | String | Text |
Bank 2 Amount | bnkAmt2 | N/A | N/A | String | Text |
Bank 2 Amount Type | bnkAmtType2 | N/A | N/A | String | Text |
Bank 2 ID | entBnkId2 | N/A | N/A | String | Text |
Bank 2 Route Code | bnkRt2 | N/A | N/A | String | Text |
City | addrCity | N/A | N/A | String | Text |
City Additional Withholdings | cityAddtlWiHo | N/A | N/A | String | Text |
City Tax Exempt Flag | cityExmptFlg | N/A | N/A | String | Text |
Country | addrCountry | N/A | N/A | String | Text |
County | addrCounty | N/A | N/A | String | Text |
Date of Birth | dob | N/A | N/A | Date | Date |
Earned Income Credit | earnedIncCred | N/A | N/A | String | Text |
Effective From | effectFrom | N/A | N/A | Date | Date |
Effective To | effectTo | N/A | N/A | Date | Date |
empEmail | N/A | N/A | String | Text | |
Emergency Contact Address | emergAddr | N/A | N/A | String | Text |
Emergency Contact Name | emergContName | N/A | N/A | String | Text |
Emergency Contact Phone Number | emergContPhNum | N/A | N/A | String | Text |
Emergency Contact Relation | emergContRel | N/A | N/A | String | Text |
Employee Name | employeeName | N/A | N/A | String | Text |
Ethnicity | empEthnicity | N/A | N/A | String | Text |
Exclude EU Directives | exclEuDir | N/A | N/A | String | Text |
Expiration Date | expDate | N/A | N/A | Date | Date |
Fax Number | faxNum | N/A | N/A | String | Text |
Federal Additional Withholdings | fedAddtlWiHo | N/A | N/A | String | Text |
Federal Exemptions | fedExmpt | N/A | N/A | String | Text |
Federal Marital Status | fedMaritalStatus | N/A | N/A | String | Text |
Federal Tax Exempt Flag | fedExmptFlg | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Full Time Foreign Student | fTimeStudent | N/A | N/A | String | Text |
Gender | custGender | N/A | N/A | String | Text |
Hire Date | empHireDate | N/A | N/A | Date | Date |
Hire Status | empHireStat | N/A | N/A | String | Text |
I9 ID 1 Expiration Date | i9Exp1 | N/A | N/A | Date | Date |
I9 ID 1 Number | i9Num1 | N/A | N/A | String | Text |
I9 ID 1 Type | i9Type1 | N/A | N/A | String | Text |
I9 ID 2 Expiration Date | i9Exp2 | N/A | N/A | Date | Date |
I9 ID 2 Number | i9Num2 | N/A | N/A | String | Text |
I9 ID 2 Type | i9Type2 | N/A | N/A | String | Text |
I9 ID Category | I9Cat | N/A | N/A | String | Text |
I9 Resident Status | i9ResStatus | N/A | N/A | String | Text |
Inactive From | fromInactDt | N/A | N/A | Date | Date |
Inactive Reason Code | inactReason | N/A | N/A | String | Text |
Inactive To | toInactTo | N/A | N/A | Date | Date |
Last Name | surname | N/A | N/A | String | Text |
Last Updated Date and Time | updateByTime | N/A | N/A | Date-time | Date-time |
Live On Property | liveOnProp | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Middle Name | midName | N/A | N/A | String | Text |
Minor | minorEmp | N/A | N/A | String | Text |
Name Prefix | namePrefix | N/A | N/A | String | Text |
Name Suffix | nameSuffix | N/A | N/A | String | Text |
Other Phone Number | otherPhNum | N/A | N/A | String | Text |
Part Time Flag | partTimeEmp | N/A | N/A | String | Text |
Part Time Foreign Student | pTimeStudent | N/A | N/A | String | Text |
Payroll ID | payId | N/A | N/A | String | Text |
Phone Number | phoneNum | N/A | N/A | String | Text |
Registered Disable Number | regDisNum | N/A | N/A | String | Text |
Rehire | rehireEmp | N/A | N/A | String | Text |
Rehire Date | empRehireDate | N/A | N/A | Date | Date |
Salary | empSal | N/A | N/A | String | Text |
Salary Type | empSalType | N/A | N/A | String | Text |
SSN | empSsn | N/A | N/A | String | Text |
State | addrState | N/A | N/A | String | Text |
State Additional Withholdings | stateAddtlWiho | N/A | N/A | String | Text |
State Exemptions | stateExmpt | N/A | N/A | String | Text |
State Marital Status | stateMaritalStat | N/A | N/A | String | Text |
State Tax Exempt Flag | stateExmptFlg | N/A | N/A | String | Text |
Temporary Employee Flag | tempEmp | N/A | N/A | String | Text |
Termination Date | termDate | N/A | N/A | Date | Date |
Termination Note | termNote | N/A | N/A | String | Text |
Termination Reason Code 1 | termReason1 | N/A | N/A | String | Text |
Termination Reason Code 2 | termReason2 | N/A | N/A | String | Text |
Termination Reason Code 3 | termReason3 | N/A | N/A | String | Text |
Termination Reason Code 4 | termReason4 | N/A | N/A | String | Text |
Termination Status | termStat | N/A | N/A | String | Text |
User Defined Alpha 1 | userA1 | N/A | N/A | String | Text |
User Defined Alpha 2 | userA2 | N/A | N/A | String | Text |
User Defined Alpha 3 | userA3 | N/A | N/A | String | Text |
User Defined Alpha 4 | userA4 | N/A | N/A | String | Text |
User Defined Alpha 5 | userA5 | N/A | N/A | String | Text |
User Defined Alpha 6 | userA6 | N/A | N/A | String | Text |
User Defined Alpha 7 | userA7 | N/A | N/A | String | Text |
User Defined Alpha 8 | userA8 | N/A | N/A | String | Text |
User Defined Numeric 1 | userNum1 | N/A | N/A | String | Text |
User Defined Numeric 2 | userNum2 | N/A | N/A | String | Text |
User Defined Numeric 3 | userNum3 | N/A | N/A | String | Text |
User Defined Numeric 4 | userNum4 | N/A | N/A | String | Text |
Work Permit Expiration Date | workPermExp | N/A | N/A | Date | Date |
Work Permit Number | workPermNum | N/A | N/A | String | Text |
Zip Code | postCode | N/A | N/A | String | Text |
Enterprise Employee Job Rates
Data Permissions: POS Definitions, Employee Identifiable Information, General Labor, Hourly Pay Rates, and Salaried Pay Rates.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Effective From | effectFrom | N/A | N/A | Date | Date |
Effective To | effectTo | N/A | N/A | Date | Date |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Home Store Name | empHomeStore | N/A | N/A | String | Text |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Primary Job | jobPrimary | N/A | N/A | String | Text |
Regular Pay Rate | jobRegRate | N/A | N/A | String | Text |
Skill Level | skillLvl | N/A | N/A | String | Text |
Enterprise Time Cards
Data Permissions: General Labor, Employee Time Card Details, Hourly Pay Rates, Salaried Pay Rates, Sales and Operations, Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Cash Tip Amount | cashTipAmt | N/A | Measure | Decimal2 | Currency |
Charged Sales Amount | chrgdSls | N/A | Measure | Decimal2 | Currency |
Charge Tip Amount | chrgTipAmt | N/A | Measure | Decimal2 | Currency |
Clock In Date and Time | clckInTime | N/A | N/A | Date-time | Date-time |
Clock In Status | clckInStat | N/A | N/A | Integer | Integer |
Clock Out Date and Time | clckOutTime | N/A | N/A | Date-time | Date-time |
Clock Out Status | clckOutStat | N/A | N/A | Integer | Integer |
Commission | commTtl | N/A | Measure | Decimal2 | Currency |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Gross Food and Beverage Sales | grossFBSls | N/A | Measure | Decimal2 | Currency |
Indirect Tips Paid Amount | indirectTipAmt | N/A | Measure | Decimal2 | Currency |
Job Code Name | jobName | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Overtime 1 Hours | otHrs1 | N/A | Measure | Decimal2 | Currency |
Overtime 1 Pay | otPay1 | N/A | Measure | Decimal4 | Numeric |
Overtime 2 Hours | otHrs2 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Pay | otPay2 | N/A | Measure | Decimal4 | Numeric |
Overtime 3 Hours | otHrs3 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Pay | otPay3 | N/A | Measure | Decimal4 | Numeric |
Overtime 4 Hours | otHrs4 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Pay | otPay4 | N/A | Measure | Decimal4 | Numeric |
Point of Sale Reset Date and Time | posResetTime | N/A | N/A | Date-time | Date-time |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal4 | Numeric |
Regular Pay Rate | jobRegRate | N/A | Measure | Decimal2 | Currency |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
SSN | empSsn | N/A | N/A | String | Text |
Total Hours | ttlHrs | N/A | Measure | Decimal2 | Currency |
Total Pay | ttlPay | N/A | Measure | Decimal2 | Currency |
Total Tip | ttlTip | N/A | Measure | Decimal2 | Currency |
User Defined Alpha 1 | userA1 | N/A | N/A | String | Text |
User Defined Alpha 2 | userA2 | N/A | N/A | String | Text |
User Defined Alpha 3 | userA3 | N/A | N/A | String | Text |
User Defined Alpha 4 | userA4 | N/A | N/A | String | Text |
User Defined Alpha 5 | userA5 | N/A | N/A | String | Text |
User Defined Numeric 1 | userNum1 | N/A | N/A | String | Text |
User Defined Numeric 2 | userNum2 | N/A | N/A | String | Text |
User Defined Numeric 3 | userNum3 | N/A | N/A | String | Text |
User Defined Numeric 4 | userNum4 | N/A | N/A | String | Text |
User Defined Numeric 5 | userNum5 | N/A | N/A | String | Text |
Enterprise Time Card Adjustments
Data Permissions: General Labor, Employee Time Card Details, Hourly Pay Rates, Salaried Pay Rates, Sales and Operations, and Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Adjustment Date and Time | adjTime | N/A | N/A | Date-time | Date-time |
Business Date | busDate | Business Date | N/A | Date | Date |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Previous Charged Sales Amount | prevChrgSls | N/A | Measure | Decimal2 | Currency |
Previous Charged Tips Amount | prevChrgTip | N/A | Measure | Decimal2 | Currency |
Previous Clock In Date and Time | prevClckInTime | N/A | N/A | Date-time | Date-time |
Previous Clock Out Date and Time | prevClckOutTime | N/A | N/A | Date-time | Date-time |
Previous Commission | prevCommTtl | N/A | Measure | Decimal2 | Currency |
Previous Gross Food and Beverage Sales | prevGrossFBSls | N/A | Measure | Decimal2 | Currency |
Previous Indirect Tips Paid Amount | prevIndirectTip | N/A | Measure | Decimal2 | Currency |
Previous Job Code Name | prevJobName | N/A | N/A | String | Text |
Previous Revenue Center | prevRvc | N/A | N/A | String | Text |
Previous Service Charge Tip Amount | prevSrvcChrgTip | N/A | Measure | Decimal2 | Currency |
Reason | adjReason | N/A | N/A | String | Text |
SSN | empSsn | N/A | N/A | String | Text |
User Defined Alpha 1 | userA1 | N/A | N/A | String | Text |
User Defined Alpha 2 | userA2 | N/A | N/A | String | Text |
User Defined Alpha 3 | userA3 | N/A | N/A | String | Text |
User Defined Alpha 4 | userA4 | N/A | N/A | String | Text |
User Defined Alpha 5 | userA5 | N/A | N/A | String | Text |
User Defined Numeric 1 | userNum1 | N/A | N/A | String | Text |
User Defined Numeric 2 | userNum2 | N/A | N/A | String | Text |
User Defined Numeric 3 | userNum3 | N/A | N/A | String | Text |
User Defined Numeric 4 | userNum4 | N/A | N/A | String | Text |
User Defined Numeric 5 | userNum5 | N/A | N/A | String | Text |
Other Pay
Data Permissions: General Labor, Hourly Pay Rates, Salaried Pay Rates, and Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Closed | clsd | N/A | N/A | String | Text |
Description | descript | N/A | N/A | String | Text |
Employee Name | employeeName | N/A | N/A | Text | Text |
Employee Number | empPosRef | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Last Name | surname | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Pay Amount | empPayAmnt | N/A | N/A | Decimal4 | Numeric |
Pay Hours | empPayHrs | N/A | N/A | Decimal2 | Currency |
Pay Rate | empPayRate | N/A | N/A | Decimal4 | Numeric |
Pay Type | empPayType | N/A | N/A | String | Text |
Transaction ID | transId | N/A | N/A | String | Text |
Other Pay Adjustments
Data Permissions: General Labor, Hourly Pay Rates, Salaried Pay Rates, and Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Adjustment Date and Time | adjDate | N/A | N/A | Date-time | Date-time |
Business Date | busDate | Business Date | N/A | Date | Date |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empPosRef | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Manager Name | mgr | N/A | N/A | String | Text |
Previous Description | prevDescript | N/A | N/A | String | Text |
Previous Job Code Name | prevJobName | N/A | N/A | String | Text |
Previous Job Code Number | prevJobNum | N/A | N/A | Integer | Integer |
Previous Pay Amount | prevEmpPayAmt | N/A | N/A | Decimal4 | Numeric |
Previous Pay Hours | prevEmpPayHrs | N/A | N/A | Decimal2 | Currency |
Previous Pay Rate | prevEmpPayRate | N/A | N/A | Decimal4 | Numeric |
Previous Pay Type | prevEmpPayType | N/A | N/A | String | Text |
Time Cards
Data Permissions: General Labor, Employee Time Card Details, Hourly Pay Rates, Salaried Pay Rates, Sales and Operations, and Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Cash Tip Amount | cashTipAmt | N/A | Measure | Decimal2 | Currency |
Charge Sales Amount | chrgdSls | N/A | Measure | Decimal2 | Currency |
Charge Tip Amount | chrgTipAmt | N/A | Measure | Decimal2 | Currency |
Clock In Date and Time | clckInTime | N/A | N/A | Date-time | Date-time |
Clock In Status | clckInStat | N/A | N/A | Integer | Integer |
Clock Out Date and Time | clckOutTime | N/A | N/A | Date-time | Date-time |
Clock Out Status | clckOutStat | N/A | N/A | Integer | Integer |
Commission | commTtl | N/A | Measure | Decimal2 | Currency |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empPosRef | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Gross Food and Beverage Sales | grossFbSls | N/A | Measure | Decimal2 | Currency |
Indirect Tips Paid Amount | indirectTipAmt | N/A | Measure | Decimal2 | Currency |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locPosRef | N/A | N/A | String | Text |
Overtime 1 Hours | otHrs1 | N/A | Measure | Decimal2 | Currency |
Overtime 1 Pay | otPay1 | N/A | Measure | Decimal4 | Numeric |
Overtime 2 Hours | otHrs2 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Pay | otPay2 | N/A | Measure | Decimal4 | Numeric |
Overtime 3 Hours | otHrs3 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Pay | otPay3 | N/A | Measure | Decimal4 | Numeric |
Overtime 4 Hours | otHrs4 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Pay | otPay4 | N/A | Measure | Decimal4 | Numeric |
Point of Sale Reset Date and Time | posResetTime | N/A | N/A | Date-time | Date-time |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal4 | Numeric |
Regular Pay Rate | jobRegRate | N/A | Measure | Decimal2 | Currency |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Total Hours | ttlHrs | N/A | Measure | Decimal2 | Currency |
Total Pay | ttlPay | N/A | Measure | Decimal2 | Currency |
Total Tip | ttlTip | N/A | Measure | Decimal2 | Currency |
Time Card Adjustments
Data Permissions: General Labor, Employee Time Card Details, Hourly Pay Rates, Salaried Pay Rates, Sales and Operations, and Employee Identifiable Information.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Adjustment Date and Time | adjTime | N/A | N/A | Date-Time | Date-Time |
Business Date | busDate | Business Date | N/A | Date | Date |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | employeePosRef | N/A | N/A | String | Text |
Employee Payroll ID | empPayroId | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Previous Charged Sales Amount | prevChrgSls | N/A | Measure | Decimal2 | Currency |
Previous Charged Tips Amount | prevChrgTip | N/A | Measure | Decimal2 | Currency |
Previous Clock In Date and Time | prevClckInTime | N/A | N/A | Date-Time | Date-Time |
Previous Clock Out Date and Time | prevClckOutTime | N/A | N/A | Date-Time | Date-Time |
Previous Commission | prevCommTtl | N/A | Measure | Decimal2 | Currency |
Previous Gross Food and Beverage Sales | prevGrossFbSls | N/A | Measure | Decimal2 | Currency |
Previous Indirect Tips Paid | prevIndirectTip | N/A | Measure | Decimal2 | Currency |
Previous Job Code Name | prevJobName | N/A | N/A | String | Text |
Previous Job code Number | prevJobNum | N/A | N/A | Integer | Integer |
Previous Revenue Center | prevRvc | N/A | N/A | String | Text |
Previous Service Charge Tip Amount | prevSrvcChrgTip | N/A | Measure | Decimal2 | Currency |
Reason | adjReason | N/A | N/A | String | Text |
Parent topic: Subject Areas