This table includes additional pay data, such as stipends. It is mostly for short time periods.
Detailed Information
The earnings code and sequence number allow for an employee to have multiple stipends. The sequence number does not work like the effective sequence on the job record.
| Record.Fieldname |
Format |
XLAT |
Heading Text |
Notes |
| ACCT_CD - Combination Code |
Char25 |
|
Combo Code |
|
| ADDL_PAY_FREQUENCY - Tax Frequency |
Char1 |
N |
Tx Freq |
|
| ADDL_PAY_SHIFT - Additional Pay Shift |
Char1 |
N |
Addl Shift |
|
| ADDL_SEQ - Additional Pay Sequence Number |
Num2.0 |
|
Addl Seq # |
|
| ADDLPAY_REASON - Reason for Additional Pay |
Char3 |
N |
Reason |
|
| BUSINESS_UNIT - Business Unit |
Char5 |
|
Unit |
|
| COMP_RATECD - Comp Rate Code |
Char6 |
|
Rate Code |
|
| DED_SUBSET_GENL - General Ded Subset ID |
Char3 |
|
Genl Ded Subset |
|
| DED_SUBSET_ID - Deduction Subset ID |
Char3 |
|
Subset ID |
|
| DED_TAKEN - Deductions Taken |
Char1 |
N |
Ded Taken |
|
| DED_TAKEN_GENL - General Deductions Taken |
Char1 |
N |
Genl Ded Taken |
|
| DEPTID - Department |
Char10 |
|
Dept ID |
|
| DISABLE_DIR_DEP - Disable Direct Deposit |
Char1 |
|
No Dir Dep |
|
| EARNINGS_END_DT - Earnings End Date |
Date |
|
Earn End Dt |
|
| EFFDT - Effective Date |
Date |
|
Eff Date |
|
| EMPL_RCD - Empl Record |
Num3.0 |
|
Empl Record |
|
| EMPLID - Empl ID |
Char11 |
|
ID |
|
| ERNCD - Earnings Code |
Char3 |
|
Earn Code |
|
| GL_PAY_TYPE - General Ledger Pay Type |
Char6 |
|
GL Pay Type |
|
| GOAL_AMT - Goal Amount |
SNm10.2 |
|
Goal Amt |
|
| GOAL_BAL - Current Goal Balance |
SNm10.2 |
|
Goal Bal |
|
| HOURLY_RT - Hourly Rate |
Num13.6 |
|
Hrly Rate |
|
| JOBCODE - Job Code |
Char6 |
|
Job Code |
|
| LOCALITY - Locality |
Char10 |
|
Locality |
|
| OK_TO_PAY - OK to Pay |
Char1 |
|
Pay |
|
| OTH_HRS - Other Hours |
SNm6.2 |
|
Oth Hrs |
|
| OTH_PAY - Other Pay |
SNm10.2 |
|
Oth Py |
When GOAL_AMT is 0, OTH_PAY is the amount paid to the employee monthly between EFFDT and EARNINGS_END_DT. |
| PAY_PERIOD1 - First Pay Period |
Char1 |
|
First |
|
| PAY_PERIOD2 - Second Pay Period |
Char1 |
|
Second |
|
| PAY_PERIOD3 - Third Pay Period |
Char1 |
|
Third |
|
| PAY_PERIOD4 - Fourth Pay Period |
Char1 |
|
Fourth |
|
| PAY_PERIOD5 - Fifth Pay Period |
Char1 |
|
Fifth |
|
| PLAN_TYPE - Plan Type |
Char2 |
N |
Plan Typ |
|
| POSITION_NBR - Position Number |
Char8 |
|
Position |
|
| PRORATE_ADDL_PAY - Prorate Additional Pay |
Char1 |
|
Addl Prort |
|
| PRORATE_CUI_WEEKS - Prorate EI Weeks |
Char1 |
|
EI Prorate |
|
| RECORD_SOURCE - Record Source |
Char1 |
|
Record Src |
|
| SEPCHK - Separate Check Nbr |
Num2.0 |
|
Sep Check Nbr |
|
| STATE - State |
Char6 |
|
State |
|
| TAX_METHOD - Tax Method |
Char1 |
N |
Tax Method |
|
| TAX_PERIODS - Tax Periods |
Num2.0 |
|
Tx Periods |
|
Data Columns to be used as Keys
- ADDL_SEQ - Additional Pay Sequence Number
- EFFDT - Effective Date
- EMPL_RCD - Empl Record
- EMPLID - Empl ID
- ERNCD - Earnings Code
Environment