Thursday, August 28, 2014

Payroll Interview Questions 1



What are the mandatory fields while creating Payroll?
Payroll Name, Period Type and Start Date


Define Elements 
Elements are the building blocks for earnings, deductions etc. of a Payroll.
It is a Data Structure which is used to hold information for both Human Resources and Payroll.
In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses.
In Payroll, elements constitute all the items in the Payroll run process.


What the Element can represent?
Earnings --> such as Salary, Wages & Bonuses
Benefits --> such as employee stock & pension plans
Non-Payroll items --> such as Expenses
Absences from work
Voluntary and In-Voluntary deductions
Employer Taxes and other Liabilities.


What are the pre-defined Elements?
UK Payroll legislation provides many predefined elements
--Tax
--National Insurance (Employee/Employer)
--Court Orders
These Elements cannot be modified.


What are the Element Entry Concepts?
Recurring - Recurring Entries can exists over many Payroll periods
Non-Recurring - Non-Recurring Entries are valid for single Payroll period only.


What are the types of Element Entry?

There are four types
Normal Entry
Override Entry
Additional Entry
Adjustment Entry
--Additive Adjustment
--Replacement Adjustment
--Balance Adjustment


How can we add a new input value to an existing Element?

We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element.

What is Salary Basis ?
Salary basis is the duration on which the salary is reckoned. It is a rule to administer pay.


Define – Quick Pay & Batch Processing 
When calculating pay, we can use either

- Quick Pay Process, which is for one employee or
- Batch Process for all employees together


What is Quick Pay/ Advance Pay/ Retro Pay?

QuickPay

QuickPay enables you to carry out payroll processing for individual employees. You can use QuickPay to pay employees who are leaving and who require payment immediately. If an employee asks what their net pay will be this month, you can run QuickPay to find the answer, then roll it back to remove all results from the database.

Advance Pay

The Advance Pay process enables you to pay employees in advance for holidays or other events. The process performs payroll runs for the periods to be advanced, using all date effective information in place, and stores the final net figure as the amount to be advanced.

Retro Pay

Payment for any previous cycle in the current payroll run


What is Retro Pay, Advance Pay & Absence Pay

- Retro Pay – Payment for any previous cycle in the current payroll run

- Advance Pay – Payment for any future cycle/advance in the current payroll run

- Absence Pay – Payment for leaves like sick leave, maternity leave, annual leave and other statutory leaves


Define Batch Element Entry?

This is an open interface specially designed for elements. With BEE we can quickly incorporate mass updates in any specific elements.

Wednesday, August 27, 2014

Lookup Types


User and Extensible Lookups

The following table shows the field and legislation for user and extensible lookups.

Field
Lookup
Legislation
Category (absence)
ABSENCE_CATEGORY
All
Reason (for absence)
ABSENCE_REASON
All
Account Type (for bank details)
ACC_TYPE
All
Categories (for activities, programs, packages)
ACTIVITY_CATEGORY
All
Successful attendance (for activity based events)
ACTIVITY_SUCCESS_CRITERIA
All
User Status (for an activity)
ACTIVITY_USER_STATUS
All
Address Type
ADDRESS_TYPE
All
AK Web Region Codes
AK_WEB_REGION_CODES
All
Reason (for application assignment status)
APL_ASSIGN_REASON
All
Type (event type for applicant)
APL_EVENT_TYPE
All
Type (interview type for applicant)
APL_INTERVIEW_TYPE
All
Reason (for secondary assignment status)
APL_SEC_ASSIGN_REASON
All
Appraisal and Assessment Status (appraisal and assessment on SSHR)
APPRAISAL_ASSESSMENT_STATUS
All
Types of appraisal processed by appraisal functionality
APPRAISAL_SYSTEM_TYPE
All
Appraisal and Assessment Type (appraisal and assessment on SSHR)
APPRAISAL_TYPE
All

AT_PROVINCE
All
Activity (for work incident)
AT_WORK_FLAG
All
Australian Tax Office Codes
AU_ATO_OFF
Australia
Australian Direct Entry Indicator
AU_DE_IND
Australia
Australian Direct Entry Transaction Code
AU_DE_TRN_CDE
Australia
State (Australian addresses)
AU_STATE
All
Years until eligible for long service leave on termination
AU_TERM_LSL_ELIGIBILITY_YEARS
Australia
Balance Type Category
BACKFEED_BT_CATEGORY
All
Check Type Category
BACKFEED_PD_CHECK_TYPE
All
Bank account name
BANK_ACCOUNT_NAME
All
Bank account number
BANK_ACCOUNT_NUMBER
All
Bank account type
BANK_ACCOUNT_TYPE
All
Bank branch
BANK_BRANCH
All
Bank name
BANK_NAME
All
Bargaining Unit (for assignment)
BARGAINING_UNIT_CODE
All
Bank name
BE_BANK
Belgium
City (Belgian addresses)
BE_CITY
Belgium
Contract Category
BE_CONTRACT_CATEGORY
Belgium
Disciplinary Action
BE_DISCIPLINARY_ACTION
Belgium
Disciplinary Body
BE_DISCIPLINARY_BODY
Belgium
Employee Coding
BE_EMPLOYEE_CODING
Belgium
Employee Type
BE_EMPLOYEE_TYPE
Belgium
Ending Reason
BE_ENDING_REASON
Belgium
Misdemeanour Type
BE_MISDEMEANOUR_TYPE
Belgium
Organization Language
BE_ORGANIZATION_LANGUAGE
Belgium
Reduced Charges Category
BE_REDUCED_CHARGES_CATEGORY
Belgium
RSZ Category
BE_RSZ_CATEGORY
Belgium
Starting Reason
BE_STARTING_REASON
Belgium
Yes/No
BE_YES_NO
Belgium
Bank Identifier Code
HR_BE_BIC_CODES
Belgium
Action Type
BEN_ACTN_TYP
All
Activity Type
BEN_ACTY_TYP
All
Benefits Balance Usage
BEN_BNFTS_BAL_USG
All
Certification Type
BEN_BNF_CTFN_TYP
All

BEN_CMP_ENRT_ACTN_TYP
All
Compensation Category
BEN_COMP_TYP
All
Type
BEN_CRT_ORDR_TYP
All
Delivery Medium
BEN_DLVRY_MED
All
Delivery Method
BEN_DLVRY_MTHD
All

BEN_DLVRY_SCHED_INFO
All
Dependent Coverage Certification Type
BEN_DPNT_CVG_CTFN_TYP
All
Enrollment Certification Type
BEN_ENRT_CTFN_TYP
All
Life Event Occurred Date Code
BEN_EVAL_DET
All
Change Event
BEN_EXT_CHG_EVT
All
Format Mask
BEN_EXT_FRMT_MASK
All
Operator
BEN_EXT_OPER
All
Run Status
BEN_EXT_STAT
All
Condition (Optional) Where
BEN_EXT_TTL_COND_OPER
All
Field
BEN_FIELD
All

BEN_FILE_CTL_TTL_TYP
All

BEN_FILE_DTA_TYP
All
Type
BEN_FILE_RCRD_TYP
All

BEN_FILE_TYP
All

BEN_FILE_UPDT_TYP
All

BEN_FL_TM_PT_TM
All
Type
BEN_GD_R_SVC_TYP
All

BEN_GNDR
All
Health Service
BEN_HLTH_CARE_SVC_TYP
All

BEN_INFO_SRC
All

BEN_INTRFC_TYP
All

BEN_MED_CNTNT_TYP
All

BEN_MED_FMT_TYP
All
Non-Monetary UOM
BEN_NNMNTRY_UOM
All
Option Type
BEN_OPT_TYP
All
Organization Roles
BEN_ORG_ROLE_TYP
All
Reason
BEN_OVRID_RSN
All
Designation code
BEN_PCP_DSGN
All
Program Group
BEN_PGM_GRP
All
Program Type
BEN_PGM_TYP
All

BEN_PIN_PRPS
All
Product
BEN_PRDCT
All
Type
BEN_PRMRY_CARE_PRVDR_TYP
All
Primary Funding Method
BEN_PRMRY_FNDG_MTHD
All

BEN_PRTN_CTFN_TYP
All
Payment Schedule
BEN_PYMT_SCHED
All
QDRO Payment Distribution
BEN_QDRO_DSTR_MTHD
All
Administrative Code
BEN_REGN_ADMIN
All
Regulatory Plan Type
BEN_REGY_PL_TYP
All
Regulatory Purpose
BEN_REGY_PRPS
All
Type
BEN_REIMBMT_CTFN_TYP
All

BEN_RESND_RSN
All

BEN_RMBT_CTFN_TYP
All
Purpose
BEN_RPTG_PRPS
All
Waive Coverage Reason
BEN_WV_CVG_RSN
All
Waive Participation Certification Type
BEN_WV_PRTN_CTFN_TYP
All
Waiving Participation Reason
BEN_WV_PRTN_RSN
All
Blood Type
BLOOD_TYPE
All
Source of student
BOOKING_SOURCE
All
Measurement Type (for budget)
BUDGET_MEASUREMENT_TYPE
All
Cash Analysis (for a cash payment)
CASH_ANALYSIS
All
Census Metropolitan Area (Canada)
CA_CMA
Canada
Canadian Payment Association Codes
CA_DD_CPA_CODES
Canada
Element categories
CA_EMPLOYER_LIABILITIES
Canada
Select Form to be printed (Canada)
CA_FORM_NAME
Canada
Element categories
CA_INVOLUNTARY_DEDUCTIONS
Canada
Element categories
CA_PAYMENT
Canada
Province (Canadian addresses)
CA_PROVINCE
All
Element categories
CA_REGULAR_EARNINGS
Canada
Element categories
CA_SUPPLEMENTAL_EARNINGS
Canada
Element categories
CA_TAXABLE_BENEFITS
Canada
Element categories
CA_VOLUNTARY_DEDUCTIONS
Canada
Method
CERTIFICATION_METHOD
All
List of Swiss Cantons
CH_CANTON
All

CHECKBOX
All
Checklist categories
Note: Applicable to Release 12 only
CHECKLIST_CATEGORIES
All
Check item (on a checklist)
CHECKLIST_ITEM
All
Status (of an item on a checklist)
CHECKLIST_STATUS
All
User friendly names for cheque/check-ordering SQL statement
CHEQUE_PROCEDURE
All
User friendly names for cheque/check-writing SRW2 reports.
CHEQUE_REPORT
All
Company Age (for salary surveys mappings)
COMPANY_AGE
All
Company Size (for salary surveys)
COMPANY_SIZE
All
Primary Evaluation Method
COMPETENCE_EVAL_TYPE
All
Consultation Type
CONSULTATION_TYPE
All
Consultation Result
CONSULTATION_RESULT
All
Competence Type
COMPETENCE_TYPE
All
Type (relationship of one person to another)
CONTACT
All
Contract End Reason
CONTRACT_END_REASON
All
Contract Start Reason
CONTRACT_START_REASON
All
Contract Status
CONTRACT_STATUS
All
Contract Status Reason
CONTRACT_STATUS_REASON
All
Contract Types
CONTRACT_TYPE
All
Contract Types (Belgium)
CONTRACT_TYPE_BE
Belgium
Type (of MIX batch control total)
CONTROL_TYPE
All
Assignment Category
CWK_ASG_CATEGORY
All
Reason (for contingent worker assignment)
CWK_ASSIGN_REASON
All
Reason (for contingent worker secondary assignment status)
CWK_SEC_ASSIGN_REASON
All
Reason a student failed to successfully complete an event.
DELEGATE_FAILURE_REASON
All
User defined Type to categorize development events.
DEV_EVENT_TYPE
All
Bank Code
DE_BANK_CODE
Germany
Course Type (for qualifications)
DE_COURSE_TYPE
Germany
Establishment Type (for qualifications)
DE_ESTABLISHMENT_TYPE
Germany
Hereditary Title
DE_HEREDITARY_TITLE
Germany
Work Incident Status
DE_INCIDENT_STATUS
Germany
License Type (degree type)
DE_LICENSE_TYPE
Germany
Organization Link Type
DE_LINK_TYPE
Germany
Name Prefix
DE_PREFIX
Germany
Professional Title
DE_PROF_TITLE
Germany
Bank Identifier Code
HR_DE_BIC_CODES
Germany

DE_REGION
All
Category (of disability)
DISABILITY_CATEGORY
Note: For Polish users only: This lookup contains relevant Polish codes. Therefore, you must not add further codes for disability categories to this lookup.
All
Reason (for disability)
DISABILITY_REASON
All
Status (of disability)
DISABILITY_STATUS
All
Disease Type
DISEASE_TYPE
All
Document Category
DOCUMENT_CATEGORY
All
Document Status (contract)
DOCUMENT_STATUS
All
Reason (for element entry)
ELE_ENTRY_REASON
All
Reason (for employee assignment)
EMP_ASSIGN_REASON
All
Employment Category
EMP_CAT
All
Type (of employee event)
EMP_EVENT_TYPE
All
Type (of interview for employee)
EMP_INTERVIEW_TYPE
All
Reason (for secondary assignment status)
EMP_SEC_ASSIGN_REASON
All
Employee Category
EMPLOYEE_CATG
Ireland
Bank Identifier Code
HR_IE_BIC_CODES
Ireland
Employee Category
EMPLOYEE_CATG
Mexico
Reason (for change in enrollment status)
ENROLLMENT_STATUS_REASON
All
Province
ES_PROVINCE
Spain
Bank Identifier Code
HR_ES_BIC_CODES
Spain
Ethnic Origin
ETH_TYPE
All
System (job or position evaluation system)
EVAL_SYSTEM
All
Measurement In (type for EVAL SYSTEM)
EVAL_SYSTEM_MEAS
All
User defined status for an event
EVENT_USER_STATUS
All
Type (of work pattern exception)
EXCEPTION_CATEGORY
All
Type (of finance line)
FINANCE_LINE_TYPE
All
Type (of formula)
FORMULA_TYPE
All
Bank Details
HR_DK_BANK_REGISTRATION
Denmark
Condition of Employment
DK_EMP_CATEGORY
Denmark
Employee Group
DK_EMP_GROUP
Denmark
Employee Type
DK_EMP_TYPE
Denmark
School Type
DK_ESTB_TYPE
Denmark
Labels (for Denmark)
DK_FORM_LABELS
Denmark
Employee Category
DK_EMP_CATEGORY
Denmark
Postal Code/Town
DK_POSTCODE_TOWN
Denmark
Union Membership
DK_UNION_MEMBERSHIP
Denmark
Court Order Name
DK_COURT_ORDER_NAME
Denmark
Benefits Given
DK_BENEFIT
Denmark
Postal Code
DK_POSTAL_CODE
Denmark
Bank Identifier Code
HR_DK_BIC_CODES
Denmark
Community Price Category
FI_COM_PRICE_CAT
Finland
Insurance Occupational Group
FI_INS_OCC_GRP
Finland
Electronic Report Method
FI_REPORTING_METHOD
Finland
Union Occupational Group
FI_EMPR_OCC_GRP
Finland
Pension Type
FI_PENSION_TYPES
Finland
Postal Code
FI_POSTAL_CODE
Finland
Bank Identifier Code
HR_FI_BIC_CODES
Finland
Activity Type
FR_ACTIVITY_TYPE
France
Address Suffix
FR_ADDRESS_SUFFIX
France
AGIRC/ARRCO
FR_AGIRC_ARRCO
France
Bank
FR_BANK
France
Contract Category
FR_CONTRACT_CATEGORY
France
Disability/COTOREP Code
FR_COTOREP_CODE
France
DADS Type
FR_DADS_TYPE
France
Department
FR_DEPARTMENT
France
Disciplinary Actions
FR_DISCIPLINARY_ACTION
France
Education Status
FR_EDUCATION_STATUS
France
Employee Category
FR_EMPLOYEE_CATEGORY
France
Employee Status
FR_EMPLOYEE_STATUS
France
Employer Type
FR_EMPLOYER_TYPE
France
Employment Type
FR_EMPLOYMENT_TYPE
France
Ending Reason
FR_ENDING_REASON
France
Guaranteed ID
FR_GI_TYPES
France
Hiring Reason
FR_PQH_NONTIT_HIRE_REASON
France
Class of Illness
FR_ILLNESS_CLASS
France
Type of Illness
FR_ILLNESS_TYPE
France
Invalidity Category
FR_INVALIDITY_CLASS
France
Qualification Level
FR_LEVEL_OF_WORKER
France
Mandate Type
FR_MANDATE_TYPE
France
Type of Medical Examination
FR_MEDICAL_EXAMINATION_TYPE
France
Result of Medical Examination
FR_MEDICAL_RESULT
France
Military Service Status
FR_MILITARY_SERVICE_STATUS
France
Military Service Types
FR_MILITARY_SERVICE_TYPE
France
Misdemeanor Type
FR_MISDEMEANOUR_TYPE
France
NAF/APE Code
FR_NAF_CODE
France
PCS Code
FR_PCS_CODE
France
Pension Code
FR_PENSION_CODE
France
Reason (in Person EIT-French Public Sector additional Seniority Details)
FR_PQH_ADDL_REASON
France
Activity (in Person EIT-French Public Sector Soldier Details)
FR_PQH_ARMY_ACTIVITY
France
Army Body (in Person EIT-French Public Sector Soldier Details)
FR_PQH_ARMY_BODY
France
Hierarchy (in Person EIT-French Public Sector Soldier Details)
FR_PQH_ARMY_HIERARCHY
France
Rank (in Person EIT-French Public Sector Soldier Details)
FR_PQH_ARMY_RANK
France
Bonification Type (in Person EIT-French Public Sector Bonification Details)
FR_PQH_BONIFICATION_TYPE
France
Level
FR_PQH_COMMITTEE_LEVEL
France
Type (Members)
FR_PQH_COMMITTEE_MEMBER_TYPE
France
Mention (in Qualification Type DDF)
FR_PQH_DIPLOMA_MENTION
France
Optional (in Qualification Type DDF)
FR_PQH_DIPLOMA_OPTION
France
Specialty (in Qualification Type DDF)
FR_PQH_DIPLOMA_SPECIALITY
France
Sub-Specialty (in Qualification Type DDF)
FR_PQH_DIPLOMA_SUB_SPECIALITY
France
Relationship Type
FR_PQH_EXT_ORG_TYPE
France
Category (in Corps)
FR_PQH_GRADE_CATEGORY
France
Badge Name (in Ministry Awards SIT)
FR_PQH_MINISTRY_BADGE_NAME
France
Level (in Ministry Awards SIT)
FR_PQH_MINISTRY_LEVEL
France
Medal Name (in Ministry Awards SIT)
FR_PQH_MINISTRY_MEDAL_NAME
France
Order Name (in Ministry Awards SIT)
FR_PQH_MINISTRY_ORDER_NAME
France
Activity (in Organization EIT)
FR_PQH_ORG_ACTIVITY
France
Physical Share (in Assignment: Statutory Information)
FR_PQH_PHYSICAL_SHARE
France
Type of Service (in Person EIT-French Public Sector Soldier Details)
FR_PQH_TYPE_OF_ARMY_SERVICE
France
Event
FR_PQH_VALIDATION_EVENT
France
Previous Employer COTOREP Type
FR_PREVIOUS_COTOREP
France
Department
FR_REGION
France
Representative Type
FR_REPRESENTATIVE_TYPE
France
Starting Reason
FR_STARTING_REASON
France
Types of French Training
FR_TRAINING_TYPE
France
Type of Worker
FR_TYPE_OF_WORKER
France
URSSAF Code
FR_URSSAF_CODE
France
Visa Status
FR_VISA_STATUS
France
Visa Type
FR_VISA_TYPE
France
Work Accident Code
FR_WORK_ACCIDENT_CODE
France
Work Accident Result
FR_WORK_ACCIDENT_RESULT
France
Type of Work Accident
FR_WORK_ACCIDENT_TYPE
France
Work Pattern
FR_WORK_PATTERN
France
Medical Service
FR_WORK_MEDICAL_SERVICE
France
Situation Sub Type
FR_PQH_STAT_SIT_SUB_TYPE
France
Situation Reason
FR_PQH_STAT_SIT_REASON
France
Type of Request
FR_PQH_STAT_SIT_RQST_TYPE
France
Label names for the BIAF report template
BIAF_LOOKUP_CODE
France
Label names for the DIF Statement report template
DIF_STMT_LOOKUP_CODE
France
Bank Identifier Code
HR_FR_BIC_CODES
France
Representative Body's method of funding
FUNDING_METHOD
All
Authority (for PAYE details)
GB_AUTHORITY
GB
Bank Name
GB_BANKS
GB
Certificate (for element NI)
GB_CERTIFICATE
GB
Cheque/Check Style
GB_CHEQUE_REPORT
GB
County (UK addresses)
GB_COUNTY
GB
Pay day type
GB_PAY_DAY_TYPE
GB
Pension
GB_PENSION
GB
Allows users to to define valid SCON number for NI SCON input
GB_SCON
GB
Sequence (for the BACS process)
GB_SORT_SEQUENCE
GB

PQP_GB_ADDITIONAL_PAY_TYPE
GB

PQP_GB_SWF_CNTRCT_AGRMNT_TYPES
GB

PQP_GB_SWF_ABSENCE_CATEGORY
GB

PQP_GB_SWF_DESTINATION_CODES
GB

PQP_GB_SWF_ORIGIN_CODES
GB

PQP_GB_DCSF_PAY_SCALE
GB

PQP_GB_SWF_POSTS
GB

PQP_GB_REGIONAL_SPINE_CODE
GB

PQP_GB_SWF_ROLES
GB

PQP_GB_DCSF_SPINE_POINTS
GB

PQP_GB_SWF_SUBJECT_CODES
GB

PQP_GB_SWF_QTS_ROUTES
GB

PQP_GB_SWF_QUALIFICATION_CODES
GB

PQP_GB_STAFF_CATEGORY
GB

UK_ETHNIC_CODES
GB
Names of Item Types for HR Summary Process
GSP_ITEM_TYPE
All
Names of Key Types for HR Summary Process
GSP_KEY_TYPE
All
Names of Restriction Types for HR Summary Process
GSP_RESTRICTION_TYPE
All
Hazard
HAZARD_TYPE
All
Area (Hong Kong addresses)
HK_AREA_CODES
Hong Kong
Rental/Passage Deduction Level
HK_DEDUCTION_LEVEL
Hong Kong
Leaving Reasons
HK_DEPARTURE_REASONS
Hong Kong
IR56B Origin
HK_IR56B_ORIGIN
Hong Kong
IR56 Box Descriptions
HK_IR56_BOX_DESC
Hong Kong
MPF Voluntary Processing Rules
HK_MPF_PROC_RULE
Hong Kong
MPF Wage Base
HK_MPF_WAGE_BASE
Hong Kong
Nature of Quarters
HK_NATURE_OF_QUARTERS
Hong Kong
Overseas Payment Amount Known
HK_OVERSEAS_PAYMENT
Hong Kong
Returning to Hong Kong
HK_RETURN_TO_HK
Hong Kong
Tax Reporting Year
HK_TAX_YEAR
Hong Kong
Document Category
HR_ADI_DOCUMENT_TYPE
All
Date Posted
HR_APPLICATION_DATE
All
Reason for Deployment
HR_DEPLOYMENT_REASONS
All
Hire Date
HR_HIRE_DATE
All
Banks in Ireland
HR_IE_BANK
Ireland
Date Posted
HR_JOB_POSTED_DATE
All
HR Metalink Application
HR_METALINK_APPLICATION
All
Academic Title
HR_NL_ACADEMIC_TITLE
NL
Dutch Bank Details
HR_NL_BANK
NL
Dutch Cities
HR_NL_CITY
NL
Correspondence Language
HR_CORR_LANGUAGE
NL
Dutch HR WAO Disability
HR_NL_DI_WAO
NL
Full Name Format
HR_NL_FULL_NAME_FORMAT
NL
Identification Certificate
HR_NL_ID_CERTIFICATE
NL
Job Level
HR_NL_JOB_LEVEL
NL
Nationality
HR_NL_NATIONALITY
NL
Province
HR_NL_PROVINCE
NL
Dutch Regions
HR_NL_REGIONS
NL
Royal Title
HR_NL_ROTAL_TITLE
NL
End Reasons for Social Health Insurance Report
HR_NL_SHI_END
NL
Special Title
HR_NL_SPECIAL_TITLE
NL
Field Labels
HR_FORM_LABELS
NL
Bank Identifier Code
HR_NL_BIC_CODES
NL
Group
HR_WPM_GROUP
All
Unit of Measure
HR_WPM_MEASURE_UOM
All
Priority
HR_WPM_PRIORITY
All
Weighting
HR_WPM_WEIGHTING
All
Sector
NL_SECTOR
NL
Batch process used by OTM
HXT_BATCH_STATUS
All
Days of the week
HXT_DAY_OF_WEEK
All
Process modes used by OTM
HXT_PROCESS_MODE
All
Benefit Type
IE_BENEFIT_TYPE
Ireland
Benefit Type
IE_BIK_ASSET_TYPE
Ireland
Benefit Type
IE_BIK_REPORTABLE_ITEM
Ireland
Calculation Option
IE_CALC_OPTION
Ireland
Cheque List Report Sort Option
IE_CHEQLIST_SORT
Ireland
Cheque Report
IE_CHEQUE_REPORT
Ireland
Colleges (Irish colleges)
IE_COLLEGES
Ireland
County (Irish addresses)
IE_COUNTY
Ireland
Text to be displayed on Irish specific field prompts
IE_FORM_LABELS
Ireland
Basis of Tax Assessment
IE_PAYE_ASSESS_BASIS
Ireland
Information Source
IE_PAYE_INFO_SOURCE
Ireland
Tax Basis
IE_PAYE_TAX_BASIS
Ireland
Postal Code
IE_POSTAL_CODE
Ireland
Contribution Class
IE_PRSI_CONT_CLASS
Ireland
Overridden Subclass
IE_PRSI_CONT_SUBCLASS
Ireland
Mode
IE_P35_SRS_MODE
Ireland
Qualification Type
IE_QUAL_TYPES
Ireland
Incident Type
INCIDENT_TYPE
All
Industry (for salary survey)
INDUSTRY
All
Injury
INJURY_TYPE
All
Bank Name
IT_BANK
Italy
City (Italian addresses)
IT_CITY
Italy
Collective Agreement
IT_COLLECTIVE AGREEMENTS
Italy
Contract Type
IT_CONTRACT_TYPE
Italy
Text to be displayed on Italian specific field prompts
IT_FORM_LABELS
Italy
Employment Category
IT_EMP_CAT
Italy
Province (Italian addresses)
IT_PROVINCE
All
Trade Unions
IT_TRADE_UNIONS
Italy
Unemployment Insurance Codes
IT_UNEMPLOYMENT_INSURANCE_CODE
Italy
Unemployment Insurance Sub Codes
IT_UNEMPLOYMENT_INS_SUB_CODE
Italy
Extra Job Information
JOB_CATEGORY
All
Categories of Jobs
JOB_CATEGORIES
All
Representative Body's Jurisdiction
JURISDICTION
All
Reason (for leaving)
LEAV_REAS
All

LOCAL_BAL_FORM_NAME
All
Marital Status
MAR_STATUS
All
Marital Status (Belgium)
MAR_STATUS_BE
Belgium
Government Employment Sector
MX_HR_EMP_CAT
Mexico
MX_SOCIAL_SECURITY_SALARY_TYPE
Social Security Salary Type
Mexico

MX_STATE
All

MY_STATE
All
North American Industry Code for Canada
NAIC
All
Nationality
NATIONALITY
All
NI Unique Error or Warning
NI_UNIQUE_ERROR_WARNING
All

NL_REGION
All
Reason
NPW_TERMINATION_REASONS
All
Region (New Zealand addresses)
NZ_COUNTIES
All
District of Origin
NZ_DISTRICT_OF_ORIGIN
New Zealand
Ethnic Origin
NZ_ETHNIC_ORIGIN
New Zealand
Tribal Group
NZ_TRIBAL_GROUP
New Zealand
Organization Type
ORG_TYPE
All
Class Begins
OTA_ENROLL_CLASS_DATE
All
Use to which a work pattern is or may be put
PATTERN_PURPOSE
All
Type of checksum used for deductions batches
PAY_PDT_DED_CKSUM
All
Type of checksum used for earnings deductions batches
PAY_PDT_EARN_CKSUM
All
Type of checksum used for time entry batches
PAY_PDT_TIME_CKSUM
All
Category
PER_CATEGORIES
All
Communication delivery method, Report Method
PER_CM_MTHD
All
Cluster
PER_COMPETENCE_CLUSTER
All
FTE Capacity
PER_FTE_CAPACITY
All
Minimum Service
PER_LENGTHS_OF_SERVICE
All
Format Type
PER_NAME_FORMATS
All
Credit Type
PER_QUAL_FWK_CREDIT_TYPE
All
Field
PER_QUAL_FWK_FIELD
All
Level
PER_QUAL_FWK_LEVEL
All
Level Type
PER_QUAL_FWK_LEVEL_TYPE
All
Provider
PER_QUAL_FWK_PROVIDER
All
QA Organization
PER_QUAL_FWK_QA_ORG
All
Qualification Type
PER_QUAL_FWK_QUAL_TYPE
All
Sub-Field
PER_QUAL_FWK_SUB_FIELD
All
Unit Standard Type
PER_QUAL_FWK_UNIT_STD_TYPE
All
Relocation
PER_RELOCATION_PREFERENCES
All
Status
PER_SUBJECT_STATUSES
All
Subject
PER_SUBJECTS
All
Work Duration
PER_TIME_SCALES
All
Tuition Method
PER_TUITION_METHODS
All
Address Type
ADDRESS_TYPE
Norway
Confederation Code
NO_CONFEDERATION_CODES
Norway
Labels (for Norway)
NO_FORMS_LABEL
Norway
Marital Status
MAR_STATUS
Norway
Nationality
NATIONALITY
Norway
Legal Employer
NO_LEGAL_EMP_SI_STATUS
Norway
Organization Class
ORG_CLASS
All
Contact Type
ORG_CONTACT_TYPES
Norway
SSB Position Code
HR_NO_POSITION_CODES
Norway
School Type
NO_ESTB_TYPES
Norway
Tax Municipality
NO_TAX_MUNICIPALITY
Norway
Tax Table Numbers
NO_TAX_TABLE_NO
Norway
Title
TITLE
Norway
Bank Identifier Code
HR_NO_BIC_CODES
Norway
US Country Code
PER_US_COUNTRY_CODE
USA
I9 Status
PER_US_I9_STATE
USA
US Income Types
PER_US_INCOME_TYPES
USA
US Process Type
PER_US_PROCESS_TYPE
USA
US Residency Status
PER_US_RES_STATUS
USA
US Visa Categories
PER_US_VISA_CATEGORIES
USA
US Visa Types
PER_US_VISA_TYPES
USA
US Visit Code
PER_US_VISIT_CODE
USA
Work Hours
PER_WORK_HOURS
All
Work Schedule
PER_WORK_SCHEDULE
All
Rating
PERFORMANCE_RATING
All
Type
PHONE_TYPE
All
Reason (for grade step placement)
PLACEMENT_REASON
All
Position Family
POSITION_FAMILY
All
Status (of reserved position)
POSITION_RESERVED_STATUS
All
Status (of position)
POSITION_STATUS
All
Academic Rank
PQH_ACADEMIC_RANK
USA
Document Type (in Corps: Document Details)
PQH_CORPS_DOC_TYPE
FR
Type of Exam (in Corps: Entrance Exams)
PQH_CORPS_EXAM_TYPE
FR
Filere (in Position and Corps HGRID)
PQH_CORPS_FILERES
FR
Way of Joining Corps (in Corps: Other Details)
PQH_CORPS_WAYS
FR
Requirements (in Corps: Other Details)
PQH_CORPS_WAYS_CRITERIA
FR
Value of SSHR Transaction Attribute (in Document Management)
PQH_CURRENT_PROPOSED
All

PQH_PA_HGRID_NODE_IMAGE
All

PQH_PA_HGRID_ROLLOVER_TEXT
All
Tenure Status
PQH_TENURE_STATUS
USA
Element Extra Information (rate type name)
PQP_RATE_TYPE
UK
Subtype (for previous employer)
PREV_EMP_SUBTYPE
All
Type (for previous employer)
PREV_EMP_TYPE
All
Student Enrollments Priority
PRIORITY_LEVEL
All
Type (of Professional Credits)
PROFESSIONAL_CREDIT_TYPE
All
Source of Proficiency Rating
PROFICIENCY_SOURCE
All
A label given to group events within a program
PROGRAM_MEMBERSHIP_GROUP
All
Reason (for salary proposal)
PROPOSAL_REASON
All
Units (qualifying units for probation period)
QUALIFYING_UNITS
All
Basis
RATE_BASIS
All
Type (of recruitment activity, also used in application source)
REC_TYPE
All
Report Method
REPORT_METHOD
All

RECON_STATUS
All
Type (of resource)
RESOURCE_TYPE
All
Reason (a resource is used by an activity)
RESOURCE_USAGE_REASON
All
Account Type
SG_ACCOUNT_TYPE
Singapore
Bank Code
SG_BANK_CODE
Singapore
Employer IRAS Category
SG_EMPLOYER_IRAS_CATEGORY
Singapore
Permit Category
SG_PERMIT_CATEGORY
Singapore
Race
SG_RACE
Singapore
Religion
SG_RELIGION
Singapore
Survey Age (for salary surveys)
SURVEY_AGE
All
Survey Company (for salary surveys)
SURVEY_COMPANY
All
Job Name (for salary surveys)
SURVEY_JOB_NAME
All
Region (for salary surveys)
SURVEY_REGION
All
Seniority (for salary surveys)
SURVEY_SENIORITY
All
Reason (for terminating application)
TERM_APL_REASON
All
Prefix
TITLE
All
Uses Tobacco (for benefits)
TOBACCO_USER
All
Role (of trainer in event)
TRAINER_PARTICIPATION
All
Center (where event takes place)
TRAINING_CENTRE
All
Type (of unit for event pricing)
TRAINING_UNIT
All
Accrual Start
US_ACCRUAL_START_TYPE
All
Status of request for accommodation
US_ADA_STATUSES
All
Coverage Level (for medical, dental and vision benefit plans)
US_BENEFIT_COVERAGE
All
Status (of continued coverage)
US_COBRA_STATUS
All
Reason (for COBRA Termination)
US_COBRA_TERM_REASON
All
Category (within Earnings classification)
US_EARNINGS
All
Category (within Imputed Earnings classification)
US_IMPUTED_EARNINGS
All
Category (within Information classification)
US_INFORMATION
All
Category (within Involuntary Deductions classification)
US_INVOLUNTARY_DEDUCTIONS
All
Job Groups
US_JOB_GROUPS
All
Filing Status for local income tax
US_LIT_FILING_STATUS
All
Exemption Reason (for excluding employee from New Hire report)
US_NEW_HIRE_EXCEPTIONS
All
Category (within Nonpayroll Payments classification)
US_PAYMENT
All
Category (of accrual plan)
US_PTO_ACCRUAL
All
Filing Status for state income tax
US_SIT_FILING_STATUS
All
State (US addresses)
US_STATE
All
Category (within Supplemental Earnings classification)
US_SUPPLEMENTAL_EARNINGS
All
Row Type (for Payroll Tables)
US_TABLE_ROW_TYPES
All
List of different instances of US Payroll Tax Balance reports
US_TAX_REPORT
All
Category (within Voluntary Deductions classification)
US_VOLUNTARY_DEDUCTIONS
All
Position of WC surcharge (after experience modifications and after premium discount)
US_WC_SURCHARGE_POSITION
All
Category (of a vacancy, for use in HR Direct Access)
VACANCY_CATEGORY
All
Status (of a vacancy)
VACANCY_STATUS
All
Type of Reporting Organization
VETS_ORG_TYPE
All
User friendly names for cheque writing SRW2 reports
W2_BOX-14_USER_DEFINED
All
Name (of global used in workflow)
WF_GLOBAL
All
Availability Schedule
WORK_SCHEDULE
All
Aggregate Third Party Cheque Types
ZA_AGG_3RD_CHEQUE_REPORT
S Africa
Cheque Reports
ZA_CHEQUE_REPORT
S Africa
Credit Transfer Cheque Reports
ZA_CT_CHEQUE_REPORT
S Africa
Employment Equity Occupational Categories
ZA_EMP_EQ_OCCUPATIONAL_CAT
S Africa
Employment Equity Occupational Levels
ZA_EMP_EQ_OCCUPATIONAL_LEV
S Africa
Employment Equity Status
ZA_EMP_EQUITY_STATUS
S Africa
Language Preference
ZA_LANG_PREF
S Africa
NQF Activity Names
ZA_NQF_ACTIVITY_NAMES
S Africa
NQF Chamber Names
ZA_NQF_CHAMBER_NAMES
S Africa
Race
ZA_RACE
S Africa
Religion
ZA_RELIGION
S Africa
RSC Regions
ZA_RSC_REGIONS
S Africa
Sort Order for Tax Certificates
ZA_TAXCERT_SORT
S Africa
Country of Passport Issue
ZA_COUNTRY_OF_PASSPORT_ISSUE
S Africa
Employer Trade Classification
ZA_EMPLOYER_TRADE_CLASS
S Africa
Tax Area
CN_TAX_AREA
China
Social Insurance/PHF Contribution Area
CN_SIC_AREA
China
Notice Duration Unit
CN_DURATION_UNIT
China
Province/City/SAR (Personal Address Information and Location Address windows)
CN_PROVINCE
China
Hukou Location
CN_HUKOU_LOCN
China
Hukou Type
CN_HUKOU_TYPE
China
Health Status
CN_HEALTH_STATUS
China
Race/Ethnic Origin
CN_RACE
China
Highest Education Level
CN_HIGH_EDU_LEVEL
China
Enterprise Category
CN_ENTRP_CATEGORY
China
Archive Format
CN_FILE_ARCHIVE
China
Last Level
CN_MILITARY_LEVEL
China
Last Rank
CN_MILITARY_RANK
China
Type of Exception
CN_PARTY_EXCEPTION
China
Party Status
CN_PARTY_STATUS
China
Party Type
CN_PARTY_TYPE
China
Type
CN_RDP_TYPE
China
Technical Title
CN_TECH_TITLE
China
Way to obtain Title
CN_TECH_WAY
China
Religion
GCC_RELIGION
For all GCC countries. Saudi Arabia, Kuwait
Employment Status
SA_EMPLOYMENT_STATUS
Saudi Arabia
City
SA_CITY
Saudi Arabia
Bank
SA_BANKS
Saudi Arabia
Bank
HU_BANKS
Hungary
County
HU_COUNTY
Hungary
Location Types
HU_LOCATION_TYPES
Hungary
Nationality
HU_NATIONALITY
Hungary
Form Labels
HU_FORM_LABELS
Hungary
Company Formation
HU_COMPANY_FORMATION
Hungary
Pension Provider
HU_PENSION_PROVIDERS
Hungary
Job Classification
HU_JOB_CLASSIFICATION
Hungary
Joining Reason
HU_JOINING_REASON
Hungary
Military Rank
HU_MILITARY_RANK
Hungary
Civil Defense Organization
HU_CIVIL_DEFENCE_ORG
Hungary
Civil Local Department
HU_CIVIL_LOCAL_DEPT
Hungary
Civil Local Sub Department
HU_CIVIL_LOCAL_SUB_DEPT
Hungary
Civil Group
HU_CIVIL_GROUP
Hungary
Civil Sub Group
HU_CIVIL_SUB_GROUP
Hungary
Bank Identifier Code
HR_HU_BIC_CODES
Hungary
Banks
ES_BANKS
Spain
Company Types
ES_COMPANY_TYPES
Spain
Province
ES_PROVINCE
Spain
Province codes
ES_PROVINCE_CODES
Spain
Form Labels
ES_FORM_LABELS
Spain
Identifier Type
ES_IDENTIFIER_TYPE
Spain
Epigraphs
ES_EPIGRAPHS
Spain
Contract Subtype
ES_CONTRACT_SUBTYPE
Spain
Contract Replacement Reason
ES_CONTRACT_REPLACEMENT_REASON
Spain
Worker Status
ES_WORKER_STATUS
Spain
Unemployment Status
ES_UNEMPLOYMENT_STATUS
Spain
Special Relationship Type
ES_SPECIAL_RELATIONSHIP_TYPE
Spain
Contract Start Reason
ES_CONTRACT_START_REASON_UDT
Spain
Payment Key
ES_PAYMENT_KEY
Spain
Sub Payment Key (for Payment Key B)
ES_SUB_PAYMENT_KEY_B
Spain
Sub Payment Key (for Payment Key F)
ES_SUB_PAYMENT_KEY_F
Spain
Sub Payment Key (for Payment Key G)
ES_SUB_PAYMENT_KEY_G
Spain
Sub Payment Key (for Payment Key H)
ES_SUB_PAYMENT_KEY_H
Spain
Sub Payment Key (for Payment Key L)
ES_SUB_PAYMENT_KEY_L
Spain
Contract Subtype
ES_CONTRACT_SUB_TYPE_UDT
Spain
State/UT
IN_STATES
India
Pin Code
IN_PIN_CODES
India
Bank Name
IN_BANK
India
Branch Name
IN_BANK_BRANCH
India
Account Type
IN_ACCOUNT_TYPE
India
Contribution Period
IN_ESI_CONTRIB_PERIOD
India
Currency Period
IN_FINANCIAL_YEAR
India
Remittance Month
IN_CALENDAR_MONTH
India
Nature of Injury
IN_INJURY
India
Disablement Level
IN_DISABLEMENT_LEVEL
India
Type (Extra Contact Information)
IN_NOMINATION_TYPES
India
Residential Status
IN_RESIDENTIAL_STATUS
India
Religion
IN_RELIGION
India
Community
IN_COMMUNITY
India
Employer Classification
IN_ER_CLASS
India
Trust Classification
IN_PF_CLASSIFICATION
India
Office Type
IN_OFFICE_TYPES
India
Industry Classification
IN_IND_CLASS
India
Joy Type
IN_JOB_TYPE
India
TDS Type on Bonus
IN_BONUS_TDS_TYPE
India
Reason for ESI Exemption
IN_ESI_EXEMPTION
India
Gratuity forfeiture reason
IN_GRATUITY_FORFEITURE_REASON
India
Leaving reason
LEAV_REAS
India
Allowance Categories for India
IN_ALLOWANCE_CATEGORY
India
Declaration Types
IN_TAX_DECLARATION_TYPES
India
City Types
IN_CITY_TYPE
India
Declaration Status
IN_DECLARATION_STATUS
India
Approval Status
IN_APPROVAL_STATUS
India
Declaration Types
IN_INPUT_NAMES
India
Professional Tax Frequencies
IN_PT_FREQUENCIES
India
Employee Type
IN_EMPLOYEE_TYPE
India
Check Styles
IN_CHEQUE_REPORT
India
Other Termination Types
IN_OTHER_TERMINATIONS
India
Period
IN_PT_FORM3_QUARTERS
India
Frequency
IN_PT_FORM3_FREQUENCY
India
Year
IN_PT_FORM3_YEAR
India
LWF Adjustment Reason
IN_LWF_ADJUST_REASONS
India
LWF Exemption Reason
IN_LWF_EXEMPTION
India
Cheque/DD Drawn Bank Name
IN_PF_BANK
India
Cheque/DD Deposited Base Branch
IN_PF_BASE_BANK
India
Governorate
KW_GOVERNORATE
Kuwait
Employment Status
KW_EMPLOYMENT_STATUS
Kuwait
Banks
KW_BANKS
Kuwait
Company Types
KW_COMPANY_TYPE
Kuwait
Street Type
PL_STREET_TYPE
Poland
Province
PL_PROVINCE
Poland
District
PL_DISTRICT
Poland
Community
PL_COMMUNITY
Poland
Bank Branch
PL_BANK_BRANCH_NAME
Poland
Bank Name
PL_BANK_NAME
Poland
Period of Submission
PL_PLATNIK_TERM
Poland
Application to NIRDP
HR_PL_NIRDP_APPLICATION
Poland
Legal Base of Activity
PL_LEGAL_BASE_ACTIVITY
Poland
Type of Property
PL_TYPE_OF_PROPERTY
Poland
Type of Service
PL_TYPE_OF_SERVICE
Poland
Employee Social Security Meaning
PL_EMP_SOCIAL_SECURITY_MEANING
Poland
Expense Type
PL_TYPE_OF_VEHICLE_EXPENSE
Poland
Paid By
PL_TYPE_OF_VEHICLE_PAYEE
Poland
Payment Mode
PL_TYPE_OF_VEHICLE_PAY_MODE
Poland
Bank Identifier Code
HR_PL_BIC_CODES
Poland
Bank Code
HR_KW_BANK_CODES
Kuwait
Loan Type
KW_LOAN_TYPE
Kuwait
Equipment Used
RU_EQUIPMENT
Russia
Alcoholic or Narcotic
RU_INTOXICATION
Russia

RU_MARITAL_STATUS
Russia
Reserve Category
RU_RESERVE_CATEGORY
Russia
Rank
RU_MILITARY_RANK
Russia
Profile
RU_MILITARY_PROFILE
Russia
Service Readiness Category
RU_MILITARY_SERVICE_READINESS
Russia
Conscription Dismissal Mark
RU_QUITTING_MARK
Russia
No field name. Used internally to map codes in the PER_CATEGORIES lookup.
RU_EDUCATION_LEVELS
Russia
No field name. Used internally to map codes in the PER_CATEGORIES lookup.
RU_ENTERPRISE_EDUCATION
Russia
Course Name
RU_COURSE_NAMES
Russia
Type of Qualification Improvement
RU_QUAL_IMPROVEMENT_TYPES
Russia
Document Name
RU_DOCUMENT_NAMES
Russia

COMPETENCE_TYPE
Russia
Type of Activity
RU_ACTIVITY_TYPE
Russia
Calculated Record of Service Reason (CSR)
RU_CALC_RECORD_SERVICE
Russia
Insurance Type
RU_INSURANCE_TYPE
Russia
Limited Term Reason
RU_LIMITED_CONTRACT_REASON
Russia
Long Service Reason (LSR)
RU_LONG_SERVICE
Russia
Special Working Conditions
RU_SPECIAL_WORK_CONDITIONS
Russia
Territory Conditions
RU_TERRITORY_CONDITIONS
Russia
Usage Schedule
RU_USAGE_SCHEDULE
Russia
Vehicle Category
RU_VEHICLE_CATEGORY
Russia
Place of Birth/OKATO Code
RU_OKATO
Russia
SUN Code
SE_SKILLS_LEVEL_CODE
Sweden
County Code
SE_COUNTY_CODES
Sweden
Municipality
SE_TAX_MUNICIPALITY
Sweden
Industry Code
SE_INDUSTRY_CODE
Sweden
Employment Category
SE_EMP_CATG
Sweden
Estimated Period of Absence
SE_EST_PER_ABS
Sweden
Central Reporting
SE_CENTRAL_REPORTING
Sweden
Bank Identifier Code
HR_SE_BIC_CODES
Sweden
Religion
AE_RELIGION
UAE
City
AE_CITY_CODES
UAE
Emirate
AE_EMIRATE
UAE
Area
AE_AREA_CODES
UAE
Language
AE_LANGUAGES
UAE

To Know More about it go through the below Link