Employees
Internal Name | Common Name |
QHRSTAFF.CODE | Staff Code |
QHRSTAFF.ALPHA_SORT | Staff Alpha Code |
QHRSTAFF.LAST_NAME | Staff Last Name |
QHRSTAFF.FIRST_NAME | Staff First Names |
QHRSTAFF.PADDRESS | Postal Address |
QHRSTAFF.PSUBURB | Postal Suburb |
QHRSTAFF.PCITY | Postal City |
QHRSTAFF.PPHONE | Staff Home Phone |
QHRSTAFF.BIRTH_DATE | Birth Date |
QHRSTAFF.MALE_FEMAL | Male/Female |
QHRSTAFF.PER_CASUAL | Permanent/Casual |
QHRSTAFF.FULL_PART | Full-Time/Part-Time |
QHRSTAFF.CURRENT | Current Employee |
QHRSTAFF.START_DATE | Start date |
QHRSTAFF.FINISH | Termination Date |
QHRSTAFF.DUE_BACK | Date Due Back from Leave |
QHRSTAFF.IRD_NUMBER | IRD Number |
QHRSTAFF.FREQUENCY | Pay Frequency |
QHRSTAFF.TAX_CODE | Tax code |
QHRSTAFF.REVIEW | Review Date |
QHRSTAFF.APPRENTICE | Apprentice (Yes/No) |
QHRSTAFF.APP_HOURS | Apprentice Hours |
QHRSTAFF.ACC_CODE | ACC Code |
QHRSTAFF.SALARY_WAG | Salary/Wages |
QHRSTAFF.STETHNIC | Ethnicity |
QHRSTAFF.STMANAGER | Supervisor |
QHRSTAFF.STMANMAIL | Supervisor E-mail |
QHRSTAFF.STMANPHONE | Supervisor Phone Number |
QHRSTAFF.PSNAME | Staff Position |
QHRSTAFF.STITLE | Staff Title |
QHRSTAFF.RADDRESS | Staff Home Address |
QHRSTAFF.RSUBURB | Staff Home Suburb |
QHRSTAFF.RCITY | Staff Home City |
QHRSTAFF.ENAME | Next of Kin's Name |
QHRSTAFF.EADDRESS | Next of Kin's Address |
QHRSTAFF.ESUBURB | Next of Kin's Suburb |
QHRSTAFF.ECITY | Next of Kin's City |
QHRSTAFF.EPHONE | Next of Kin's Phone Number |
QHRSTAFF.STPICTURE | Staff Photo |
QHRSTAFF.STEMAIL | Staff Email |
QHRSTAFF.STEXT | Staff Internal Extension |
QHRSTAFF.STEMPGRP | Staff Employee Group Code |
QHRSTAFF.EGNAME | Employee Group Name |
QHRSTAFF.STUDFD1 | User Defined Date 1 |
QHRSTAFF.STUDFD2 | User Defined Date 2 |
QHRSTAFF.STUDFL1 | User Defined True/False 1 |
QHRSTAFF.STUDFL2 | User Defined True/False 2 |
QHRSTAFF.STUDFN1 | User Defined Number 1 |
QHRSTAFF.STUDFC1 | User Defined Character 1 |
QHRSTAFF.STUDFC2 | User Defined Character 2 |
QHRSTAFF.STUDFC3 | User Defined Character 3 |
QHRSTAFF.STUDFM1 | User Defined Memo 1 |
QHRSTAFF.STUDFM2 | User Defined Memo 2 |
QHRSTAFF.PERIODPAY | Pay Per Period |
QHRSTAFF.DEPTCODE | Department Code |
QHRSTAFF.DEPTNAME | Department Name |
QHRSTAFF.LASTFIRST | Staff LastName FirstName |
QHRSTAFF.FIRSTLAST | Staff Firstname LastName |
QHRSTAFF.OCCUPATION | Staff Occupation |
QHRSTAFF.PPOSTCODE | Staff Postal Code |