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

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
12 26-Nov-2021 10:22 7 KB jmyers to previous
11 26-Nov-2021 10:22 7 KB jmyers to previous | to last
10 26-Nov-2021 10:22 7 KB RForbes to previous | to last
9 26-Nov-2021 10:22 7 KB RForbes to previous | to last
8 26-Nov-2021 10:22 7 KB JEscott to previous | to last
7 26-Nov-2021 10:22 7 KB JEscott to previous | to last
6 26-Nov-2021 10:22 7 KB JAiken to previous | to last
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 3 KB JEscott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 9 changed 48 lines
|ENTITY_CODE| NOT NULL| VARCHAR2(16)| Used to derive link to EMPLOYMENT record
|PERSON_CODE| NOT NULL| VARCHAR2(16)| Used to derive link to EMPLOYMENT record
|EMPLOYMENT_TYPE| |VARCHAR2(30)| Used to derive link to EMPLOYMENT record
|HIRE_DATE|DATE| | Used to derive link to EMPLOYMENT record
|FREQUENCY_CODE | NOT NULL| VARCHAR2(16)| Must be a valid Pay Frequency on [IPPF]
|SUNDRY_LINE_TYPE| NOT NULL| VARCHAR2(30)| Must be valid lexicon entry. Typically 01 or Sundry
|START_DATE| NOT NULL| DATE| First day that Sundry records need to be processed by payroll
|END_DATE| NOT NULL| DATE| Last day Sundry record will be processed
|PC_CODE_HEADER| NOT NULL| NUMBER(4)| Must be a valid [PC Code|PC_CODE] from the [IPPC] screen
|UNIT_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|GROUP_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|POSITION_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|JOB_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|LEAVE_TYPE_CODE| | VARCHAR2(16)| not used at this time
|PLAN_CODE| | VARCHAR2(16)| Not used at this time
|USER_CALC_CODE| | VARCHAR2(16)| Identifies the user calc to execute when sundry line is processed.
|COUNTRY_CODE | | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|STATE_PROVINCE_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|GEO_CODE| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|ASSIGNMENT_START_DATE| | DATE| Used to derive link to ASSIGNMENT record
|ASSIGNMENT_CODE| NOT NULL| VARCHAR2(16)| Used to derive link to ASSIGNMENT record
|TIMES_REMAINING| | NUMBER(5)| The number of time the sundry line needs to be processed.
|PAY_POINT_TYPE| | VARCHAR2(30)|
|PAY_POINT_TASK| | VARCHAR2(30)|
|PAY_POINT_SEQUENCE| | NUMBER(5)|
|TIME_ENTERED| | NUMBER(18,6)| Value associated to the [PC Code|PC_CODE] of this Sundry Line
|TIME_BASIS| | VARCHAR2(30)| Must be a valid lexicon entry. Typically 15 or $
|WCB_CLASS| | VARCHAR2(30)|
|DISTRIBUTION_MASK | | VARCHAR2(50) |
|REFERENCE_INFO| | VARCHAR2(50) |
|PC_CODE_DETAILS| | NUMBER(4)| Must be a valid [PC Code|PC_CODE] from the [IPPC] screen
|PC_ACTION| NOT NULL| VARCHAR2(30)| Must be a valid lexicon entry. Typically A or Accumulate
|PC_DETAIL_TYPE| NOT NULL| VARCHAR2(30)| Must be a valid lexicon entry. Typically 20 or 'Entered Value'
|ELEMENT_CODE| |VARCHAR2(16)|
|USER_VARIABLE_CODE | |VARCHAR2(16)|
|PC_CALC_METHOD| | VARCHAR2(30)| Must be a valid lexicon entry. Typically 00 or 'EV: Entered Value'
|DESCRIPTION| | VARCHAR2(50) |
|WAGE_RATE| |NUMBER(18,6)| A valid is only needed if this is not the employees prime assignment value
|WAGE_RATE_OVERRIDE | | NUMBER(18,6)|
|RATE_BASIS | | VARCHAR2(30)| A valid is only needed if this is not the employees prime assignment value
|RATE_BASIS_OVERRIDE | |VARCHAR2(30)|
|AMOUNT | |NUMBER(18,6)| Value associated to the [PC Code|PC_CODE] of this Sundry Line Detail
|AMOUNT_OVERRIDE | |NUMBER(18,6)|
|USER_VARIABLE_OVERRIDE| |NUMBER(18,6) |
|DISTRIBUTION_DR_MASK | |VARCHAR2(50) |
|DISTRIBUTION_CR_MASK | |VARCHAR2(50)|
|PC_RATE_SOURCE | |VARCHAR2(30)|
|HIGHER_OF_RATE | |VARCHAR2(4)|
|[ENTITY_CODE]| NOT NULL| VARCHAR2(16)| Used to derive link to EMPLOYMENT record
|[PERSON_CODE]| NOT NULL| VARCHAR2(16)| Used to derive link to EMPLOYMENT record
|[EMPLOYMENT_TYPE]| |VARCHAR2(30)| Used to derive link to EMPLOYMENT record
|[HIRE_DATE|DATE]| | Used to derive link to EMPLOYMENT record
|[FREQUENCY_CODE] | NOT NULL| VARCHAR2(16)| Must be a valid Pay Frequency on [IPPF]
|[SUNDRY_LINE_TYPE]| NOT NULL| VARCHAR2(30)| Must be valid lexicon entry. Typically 01 or Sundry
|[START_DATE]| NOT NULL| DATE| First day that Sundry records need to be processed by payroll
|[END_DATE]| NOT NULL| DATE| Last day Sundry record will be processed
|[PC_CODE_HEADER]| NOT NULL| NUMBER(4)| Must be a valid [PC Code|PC_CODE] from the [IPPC] screen
|[UNIT_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[GROUP_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[POSITION_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[JOB_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[LEAVE_TYPE_CODE]| | VARCHAR2(16)| not used at this time
|[PLAN_CODE]| | VARCHAR2(16)| Not used at this time
|[USER_CALC_CODE]| | VARCHAR2(16)| Identifies the user calc to execute when sundry line is processed.
|[COUNTRY_CODE] | | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[STATE_PROVINCE_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[GEO_CODE]| | VARCHAR2(16)| A valid is only needed if this is not the employees prime assignment value
|[ASSIGNMENT_START_DATE]| | DATE| Used to derive link to ASSIGNMENT record
|[ASSIGNMENT_CODE]| NOT NULL| VARCHAR2(16)| Used to derive link to ASSIGNMENT record
|[TIMES_REMAINING]| | NUMBER(5)| The number of time the sundry line needs to be processed.
|[PAY_POINT_TYPE]| | VARCHAR2(30)|
|[PAY_POINT_TASK]| | VARCHAR2(30)|
|[PAY_POINT_SEQUENCE]| | NUMBER(5)|
|[TIME_ENTERED]| | NUMBER(18,6)| Value associated to the [PC Code|PC_CODE] of this Sundry Line
|[TIME_BASIS]| | VARCHAR2(30)| Must be a valid lexicon entry. Typically 15 or $
|[WCB_CLASS]| | VARCHAR2(30)|
|[DISTRIBUTION_MASK] | | VARCHAR2(50) |
|[REFERENCE_INFO]| | VARCHAR2(50) |
|[PC_CODE_DETAILS]| | NUMBER(4)| Must be a valid [PC Code|PC_CODE] from the [IPPC] screen
|[PC_ACTION]| NOT NULL| VARCHAR2(30)| Must be a valid lexicon entry. Typically A or Accumulate
|[PC_DETAIL_TYPE]| NOT NULL| VARCHAR2(30)| Must be a valid lexicon entry. Typically 20 or 'Entered Value'
|[ELEMENT_CODE]| |VARCHAR2(16)|
|[USER_VARIABLE_CODE] | |VARCHAR2(16)|
|[PC_CALC_METHOD]| | VARCHAR2(30)| Must be a valid lexicon entry. Typically 00 or 'EV: Entered Value'
|[DESCRIPTION]| | VARCHAR2(50) |
|[WAGE_RATE]| |NUMBER(18,6)| A valid is only needed if this is not the employees prime assignment value
|[WAGE_RATE_OVERRIDE] | | NUMBER(18,6)|
|[RATE_BASIS] | | VARCHAR2(30)| A valid is only needed if this is not the employees prime assignment value
|[RATE_BASIS_OVERRIDE] | |VARCHAR2(30)|
|[AMOUNT] | |NUMBER(18,6)| Value associated to the [PC Code|PC_CODE] of this Sundry Line Detail
|[AMOUNT_OVERRIDE] | |NUMBER(18,6)|
|[USER_VARIABLE_OVERRIDE]| |NUMBER(18,6) |
|[DISTRIBUTION_DR_MASK] | |VARCHAR2(50) |
|[DISTRIBUTION_CR_MASK] | |VARCHAR2(50)|
|[PC_RATE_SOURCE] | |VARCHAR2(30)|
|[HIGHER_OF_RATE] | |VARCHAR2(4)|