This page (revision-12) was last changed on 26-Nov-2021 10:22 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 5 KB Lilia Urtan to previous
11 26-Nov-2021 10:22 5 KB rforbes to previous | to last
10 26-Nov-2021 10:22 5 KB jmyers to previous | to last
9 26-Nov-2021 10:22 5 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
8 26-Nov-2021 10:22 5 KB jmyers to previous | to last
7 26-Nov-2021 10:22 6 KB jmyers to previous | to last
6 26-Nov-2021 10:22 6 KB jmyers to previous | to last
5 26-Nov-2021 10:22 6 KB jmyers to previous | to last
4 26-Nov-2021 10:22 6 KB jmyers to previous | to last
3 26-Nov-2021 10:22 6 KB jmyers to previous | to last WORK_RULE_CODE ==> WORK_RULE (Field)
2 26-Nov-2021 10:22 6 KB jmyers to previous | to last
1 26-Nov-2021 10:22 6 KB RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 6 added 2 lines
The data for this screen is stored in the [P2K_HR_IDENTITIES], [P2K_HR_PERSONALS], [P2K_HR_EMPLOYMENTS], [P2K_HR_ASSIGNMENTS] and [P2K_HR_ASSIGNMENT_DETAILS] tables.
At line 11 changed one line
;[Person Code|PERSON_CODE]:This field shows the unique code or number assigned to this employee by the organization (i.e. employee number, personal ID number, badge number). This code may be defined as system generated through [IMCS] ([P2K_AM_CODE_SEQUENCES]). This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Person Code|PERSON_CODE]:This field shows the unique code or number assigned to this employee by the organization (i.e. employee number, personal ID number, badge number). This code may be defined as system generated through [IMCS].
At line 13 changed one line
;[First Name|FIRST_NAME]:This is the first name legally used by the employee. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[First Name|FIRST_NAME]:This is the first name legally used by the employee.
At line 15 changed one line
;[Last Name|LAST_NAME]:This is the last name legally used by the employee. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Last Name|LAST_NAME]:This is the last name legally used by the employee.
At line 17 changed one line
;[Gov't Code Origin|GOVT_CODE_ORIGIN]:This field identifies the country that generated the employee's government code. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Gov't Code Origin|GOVT_CODE_ORIGIN]:This field identifies the country that generated the employee's government code.
At line 19 changed one line
;[SSN|GOVERNMENT_CODE]:This is the government code (Social Security Number / Social Insurance Number) of the employee. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[SSN|GOVERNMENT_CODE]:This is the government code (Social Security Number / Social Insurance Number) of the employee.\\ IEQH provides warning message when S.S.N of a terminated employee is re-entered while hiring a new employee.
At line 21 removed one line
;[Date of Birth|BIRTH_DATE]:This is the date of birth of the employee. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
At line 23 changed one line
;[Gender|GENDER]:Select from the lexicon list for Male or Female. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Date of Birth|BIRTH_DATE]:This is the date of birth of the employee.
At line 25 changed one line
;[Ethnicity|ETHNIC]:Select from the lexicon list for the ethnic code of the employee, for Equal Opportunity/Employment Equity purposes. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Gender|GENDER]:Select from the lexicon list for Male or Female.
At line 27 changed one line
;[Address 1|ADDRESS_LINE_1] and [Address 2|ADDRESS_LINE_2]:These fields define the address for the employee's home address. This a required field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[Ethnicity|ETHNIC]:Select from the lexicon list for the ethnic code of the employee, for Equal Opportunity/Employment Equity purposes.
At line 29 changed one line
;[City|LOCALITY]:This field defines the city for the employee's home address. This a required field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[Address 1|ADDRESS_LINE_1] and [Address 2|ADDRESS_LINE_2]:These fields define the address for the employee's home address.
At line 31 changed one line
;[State|STATE_PROVINCE_CODE]:This field defines the state (and tax jurisdiction) for the employee's home address. This a required field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[City|LOCALITY]:This field defines the city for the employee's home address.
At line 33 changed one line
;[Postal Code|ZIP_POSTAL]:This field defines the city for the employee's home address. This a required field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[State|STATE_PROVINCE_CODE]:This field defines the state (and tax jurisdiction) for the employee's home address.
At line 35 changed one line
;[Phone #|PHONE_NUMBER]:This is the employee's home phone number. This an optional field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[Postal Code|ZIP_POSTAL]:This field defines the city for the employee's home address.
At line 37 changed one line
;[Cellular #|CELLULAR_NUMBER]:This is the employee's cellular number. This an optional field maintained on [IEPI] ([P2K_HR_PERSONALS]).
;[Phone #|PHONE_NUMBER]:This is the employee's home phone number.
At line 39 changed one line
;[Email|EMAIL_ADDRESS]:This field displays the employee's email address.
;[Cellular #|CELLULAR_NUMBER]:This is the employee's cellular number.
At line 42 added 2 lines
;[Email|EMAIL_ADDRESS(Field)]:This field displays the employee's email address.
At line 46 changed one line
;[Hire Date|HIRE_DATE]:The hire date is the date that the employment agreement or period of employment commences. This a required field maintained on [IEID] ([P2K_HR_IDENTITIES]).
;[Hire Date|HIRE_DATE]:The hire date is the date that the employment agreement or period of employment commences.
At line 48 changed one line
;[Start Date|ASSIGNMENT_START_DATE] / [End Date|ASSIGNMENT_END_DATE]:These field define the start and end date of the prime assignment. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Start Date|ASSIGNMENT_START_DATE] / [End Date|ASSIGNMENT_END_DATE]:These field define the start and end date of the prime assignment.
At line 50 changed one line
;[Assignment|ASSIGNMENT_CODE]:This field displays the employee's assignment. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Assignment|ASSIGNMENT_CODE]:This field displays the employee's assignment.
At line 52 changed one line
;[Position|POSITION_CODE]:This is the position to which the employee is assigned. Using positions will result in many fields having defaulted values inherited from the position definition. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Position|POSITION_CODE]:This is the position to which the employee is assigned. Using positions will result in many fields having defaulted values inherited from the position definition.
At line 54 changed one line
;[Job|JOB_CODE]:This field indicates the task that the employee is hired to perform. The job must be within the Unit that is indicated. May be defaulted by Position. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Job|JOB_CODE]:This field indicates the task that the employee is hired to perform. The job must be within the Unit that is indicated. May be defaulted by Position.
At line 58 changed one line
;[Department|DEPARTMENT_CODE]:This field shows the department to which the employee is assigned. May be defaulted by Position. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Department|DEPARTMENT_CODE]:This field shows the department to which the employee is assigned. May be defaulted by Position.
At line 60 changed one line
;[Unit|UNIT_CODE]:This is the unit that the employee is affiliated to. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Unit|UNIT_CODE]:This is the unit that the employee is affiliated to.
At line 62 changed one line
;[Group|GROUP_CODE]:This shows the group code that determines the policy rules under which the employee must be processed. This field may be defaulted by Position. This a required field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Group|GROUP_CODE]:This shows the group code that determines the policy rules under which the employee must be processed. This field may be defaulted by Position.
At line 68 changed one line
;[Range|RANGE_CODE]:This field displays the minimum and maximum salary payable for the job. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Range|RANGE_CODE]:This field displays the minimum and maximum salary payable for the job.
At line 70 changed one line
;[Scale|SCALE_CODE] / [Step|STEP_CODE]:This field displays the scale/step code used to default to an employee's assignment record. This record may be defaulted by Position or Job. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Scale|SCALE_CODE] / [Step|STEP_CODE]:This field displays the scale/step code used to default to an employee's assignment record. This record may be defaulted by Position or Job.
At line 72 changed one line
;[Basis|RATE_BASIS]:This field displays the rate basis the wage rate is being stored or displayed in. i.e. hourly, weekly, biweekly, semi-monthly, monthly or annually. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Basis|RATE_BASIS]:This field displays the rate basis the wage rate is being stored or displayed in. i.e. hourly, weekly, biweekly, semi-monthly, monthly or annually.
At line 76 changed one line
;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours the employee works. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Hours Per Day|HOURS_PER_DAY]:This field shows the average daily hours the employee works.
At line 78 changed one line
;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average weekly hours the employee works. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Hours Per Week|HOURS_PER_WEEK]:This field shows the average weekly hours the employee works.
At line 80 changed one line
;[Hours Per Pay|HOURS_PER_PAY]:This field shows the average hours the employee works within a pay period. This an optional field maintained on [IEAS] ([P2K_HR_ASSIGNMENTS]).
;[Hours Per Pay|HOURS_PER_PAY]:This field shows the average hours the employee works within a pay period.
At line 82 changed one line
;[Email|EMAIL_ADDRESS]:This field displays the email associated with the job.
;[Email|EMAIL_ADDRESS(Field)]:This field displays the email associated with the job.