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 8 changed 40 lines
|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
|[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|DSP_ID_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|DSP_ID_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|DTX_ID_HOME]| |VARCHAR2(16)| GEO Code from resident tax jurisdiction on IEPI
|[GEO_CODE_WORK|DTX_ID_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