This page (revision-6) was last changed on 26-Nov-2021 10:22 by JEscott

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

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
6 26-Nov-2021 10:22 8 KB JEscott to previous
5 26-Nov-2021 10:22 7 KB JEscott to previous | to last
4 26-Nov-2021 10:22 7 KB JEscott to previous | to last
3 26-Nov-2021 10:22 7 KB JEscott to previous | to last
2 26-Nov-2021 10:22 7 KB JEscott to previous | to last
1 26-Nov-2021 10:22 7 KB JEscott to last

Page References

Incoming links Outgoing links
CONVERTING PAY HISTORY
CONVERTING PAY HISTORY

Version management

Difference between version and

At line 2 removed one line
The conversion of Payroll History data is actually done in two steps. The conversion process starts with the loading and converting of PAY HEADERS, followed by the PAY PC AMOUNTS. The PAY LINES can optionally be converted for historical reasons, but they will not have any impact on future pays. The PAY HEADERS and PAY PC AMOUNTS will only be used for pay reversals or for the generation of the To Date amounts [IE year to date, quarter to date, etc.].
At line 3 added 2 lines
The conversion of Payroll History data is actually done in two steps. The conversion process starts with the loading and converting of PAY HEADERS, followed by the PAY PC AMOUNTS. The PAY LINES can optionally be converted for historical reasons, but they will not have any impact on future pays. The PAY HEADERS and PAY PC AMOUNTS will only be used for pay reversals or for the generation of the To Date amounts (IE year to date, quarter to date, etc.).
At line 6 changed 42 lines
Name Null? Type Notes
------------------------ -------- ------------ ------------------------
ENTITY_CODE NOT NULL VARCHAR2(16) Used to link to the EMPLOYEE records on IEEM
PERSON_CODE NOT NULL VARCHAR2(16) Used to link to the EMPLOYEE records on IEEM
EMPLOYMENT_TYPE VARCHAR2(30) Used to link to the EMPLOYEE records on IEEM
HIRE_DATE DATE Used to link to the EMPLOYEE records on IEEM
PAY_NUMBER NOT NULL NUMBER(5) A unique number to identify the pay for each employee. IE each employee would have Pay Number 1 and count up for each additional pay.
USER_NAME VARCHAR2(30) The Personality USERID who created the record. Typically set to P2K.
UNIT_CODE NOT NULL VARCHAR2(16) Unit code from the employees prime assignment record, as of the Pay Issue date.
GROUP_CODE NOT NULL VARCHAR2(16) Group code from the employees prime assignment record, as of the Pay Issue date.
COUNTRY_CODE NOT NULL VARCHAR2(16)
STATE_PROVINCE_CODE_HOME NOT NULL VARCHAR2(16) Must be a valid entry from the IDSP screen. Typically set to the resident State code as of the Pay Issue date.
STATE_PROVINCE_CODE_WORK NOT NULL VARCHAR2(16) Must be a valid entry from the IDSP screen. Typically set to the work State code as of the Pay Issue date.
PAY_CATEGORY_CODE NOT NULL VARCHAR2(16) Must be a valid entry from the IPPGC or IPPGU, for Canadian or USA pays
PAY_CALENDAR_CODE NOT NULL VARCHAR2(16) Must be a valid entry from the IPCL screen.
PAY_PERIOD NOT NULL NUMBER(10) Must be a valid period for the Pay Calendar from the IPCL screen.
PAYROLL_CODE NOT NULL VARCHAR2(16) Must be a valid entry from the IPPR screen.
BATCH_NUMBER NUMBER(10) Must be a valid entry for the PAYROLL from the IPBE screen.
PAY_RUN_NUMBER NUMBER(10) Must be within a valid range defined on IMCS.
SCHOOL_DISTRICT_CODE VARCHAR2(16) Used for school district tax calculation, if applicable.
GEO_CODE_HOME VARCHAR2(16) GEO Code from resident tax jurisdiction on IEPI
GEO_CODE_WORK VARCHAR2(16) GEO Code from work tax jurisdiction on IEAS
AUDITED VARCHAR2(4) Check mark field set during UPAUDT> Typically set to '1'
CHECK_NUMBER NUMBER(10)
FINAL_PAY_METHOD VARCHAR2(30) Set to '01' if this records represents the last pay the employee received
FIRST_PAY_IN_MONTH VARCHAR2(4) optional check mark field, set to '1' if fist pay of the calendar month
FIRST_PAY_IN_PERIOD VARCHAR2(4) optional check mark field, set to '1' if fist pay of the pay period
HAND_CHECK VARCHAR2(4) optional check mark field
PAY_BY_CHECK VARCHAR2(4) optional check mark field
PAY_HEADER_SOURCE VARCHAR2(30) Must be a valid lexicon entry. Typically set to '05' or 'External Source'
PAY_HEADER_STAGE VARCHAR2(30) Must be a valid lexicon entry. Typically set to '70' or 'Closed'
PAY_RUN_SEQUENCE NUMBER(5)
POSTED_BENEFITS VARCHAR2(4) optional check mark field
POSTED_ATTENDANCE VARCHAR2(4) optional check mark field
QUICK_PAY VARCHAR2(4)
TAX_WEEKS NUMBER(18,6)
TIMESHEET_RETURNED VARCHAR2(4)
CHECK_AMOUNT NUMBER(14,2)
PAY_ISSUE_DATE DATE Date of the check or deposit. Determines the Year to add to.
SUNDRY_ATTACHED VARCHAR2(4) optional check mark field
JOURNALIZED VARCHAR2(4)
REVERSAL_PAY_NUMBER NUMBER(5) Must point to a previously loaded pay header, or blank
||Name || Null? || Type || Notes
|ENTITY_CODE | NOT NULL | VARCHAR2(16)| Used to link to the EMPLOYEE records on IEEM
|PERSON_CODE | NOT NULL | VARCHAR2(16)| Used to link to the EMPLOYEE records on IEEM
|EMPLOYMENT_TYPE | | VARCHAR2(30)| Used to link to the EMPLOYEE records on IEEM
|HIRE_DATE | | DATE | Used to link to the EMPLOYEE records on IEEM
|PAY_NUMBER | NOT NULL | NUMBER(5) | A unique number to identify the pay for each employee. IE each employee would have Pay Number 1 and count up for each additional pay.
|USER_NAME | | VARCHAR2(30)| The Personality USERID who created the record. Typically set to P2K.
|UNIT_CODE | NOT NULL| VARCHAR2(16)| Unit code from the employees prime assignment record, as of the Pay Issue date.
|GROUP_CODE | NOT NULL| VARCHAR2(16)| Group code from the employees prime assignment record, as of the Pay Issue date.
|COUNTRY_CODE | NOT NULL| VARCHAR2(16)|
|STATE_PROVINCE_CODE_HOME| NOT NULL| VARCHAR2(16)| Must be a valid entry from the IDSP screen. Typically set to the resident State code as of the Pay Issue date.
|STATE_PROVINCE_CODE_WORK| NOT NULL| VARCHAR2(16)| Must be a valid entry from the IDSP screen. Typically set to the work State code as of the Pay Issue date.
|PAY_CATEGORY_CODE| NOT NULL| VARCHAR2(16)| Must be a valid entry from the IPPGC or IPPGU, for Canadian or USA pays
|PAY_CALENDAR_CODE| NOT NULL| VARCHAR2(16)| Must be a valid entry from the IPCL screen.
|PAY_PERIOD| NOT NULL | NUMBER(10)| Must be a valid period for the Pay Calendar from the IPCL screen.
|PAYROLL_CODE| NOT NULL| VARCHAR2(16)| Must be a valid entry from the IPPR screen.
|BATCH_NUMBER | | NUMBER(10)| Must be a valid entry for the PAYROLL from the IPBE screen.
|PAY_RUN_NUMBER| |NUMBER(10)| Must be within a valid range defined on IMCS.
|SCHOOL_DISTRICT_CODE| |VARCHAR2(16)| Used for school district tax calculation, if applicable.
|GEO_CODE_HOME| |VARCHAR2(16)| GEO Code from resident tax jurisdiction on IEPI
|GEO_CODE_WORK | |VARCHAR2(16)| GEO Code from work tax jurisdiction on IEAS
|AUDITED | |VARCHAR2(4)| Check mark field set during UPAUDT> Typically set to '1'
|CHECK_NUMBER | |NUMBER(10) |
|FINAL_PAY_METHOD | |VARCHAR2(30)| Set to '01' if this records represents the last pay the employee received
|FIRST_PAY_IN_MONTH | |VARCHAR2(4)| optional check mark field, set to '1' if fist pay of the calendar month
|FIRST_PAY_IN_PERIOD | |VARCHAR2(4)| optional check mark field, set to '1' if fist pay of the pay period
|HAND_CHECK | |VARCHAR2(4)| optional check mark field
|PAY_BY_CHECK| |VARCHAR2(4)| optional check mark field
|PAY_HEADER_SOURCE| |VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '05' or 'External Source'
|PAY_HEADER_STAGE | |VARCHAR2(30)| Must be a valid lexicon entry. Typically set to '70' or 'Closed'
|PAY_RUN_SEQUENCE | |NUMBER(5)|
|POSTED_BENEFITS | |VARCHAR2(4)| optional check mark field
|POSTED_ATTENDANCE | |VARCHAR2(4)| optional check mark field
|QUICK_PAY | |VARCHAR2(4)|
|TAX_WEEKS | |NUMBER(18,6)|
|TIMESHEET_RETURNED| |VARCHAR2(4)|
|CHECK_AMOUNT | |NUMBER(14,2)|
|PAY_ISSUE_DATE | |DATE |Date of the check or deposit. Determines the Year to add to.
|SUNDRY_ATTACHED | |VARCHAR2(4)| optional check mark field
|JOURNALIZED | |VARCHAR2(4)|
|REVERSAL_PAY_NUMBER| |NUMBER(5)| Must point to a previously loaded pay header, or blank
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JEscottTop