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

No comments:

Post a Comment