WRK_EARNINGS(SQL Table) |
Index Back |
|---|---|
Work Record - Pay EarningsThis work record contains payroll affecting information such as earnings, hours, location, tax information, etc. It is the core record for the payroll process. An employee might have more than one pay earning record depending on other payroll affecting activity during the pay period, such as change in pay rate, job, etc. Each pay earning record may have one or more subordinate Pay Other Earnings record(s).This work record is used during Payroll Calculation process and contains information for future use by PAY_EARNINGS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | PAY_END_DT | Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
| 5 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 6 | LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 7 | ADDL_NBR | Number(3,0) | SMALLINT NOT NULL | Additional Pay Line Nbr |
| 8 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
| 12 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 13 | ADDLPAY_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason for Additional Pay
A=Anniversary Award AWD=Award Data BAS=Benefits Administration Credit C=Contract Pay JOB=Job Other Pay N=Not Specified O=Outstanding Contribution P=Performance Award Q=President's Award S=Productivity Award |
| 14 | DISABLE_DIR_DEP | Character(1) | VARCHAR2(1) NOT NULL |
Disable Direct Deposit
Y/N Table Edit Default Value: N |
| 15 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit Default Value: N |
| 16 | PAY_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payline Calculation Status
C=Calculated E=Calculation Error F=Confirmed I=Initial Load P=Pay in Progress U=Updated by User V=Reversing Check Default Value: I |
| 17 | OK_TO_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Okay to pay indicator.
Y/N Table Edit Default Value: N |
| 18 | JOB_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit Default Value: N |
| 19 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: ACCT_CD_TBL |
| 20 | GL_PAY_TYPE | Character(6) | VARCHAR2(6) NOT NULL | General Ledger Pay Type |
| 21 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 22 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 23 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 24 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N |
| 25 | SHIFT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Shift Differential Rate |
| 26 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 27 | FLSA_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | FLSA Rate |
| 28 | RATE_USED | Character(1) | VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate F=FLSA Rate H=Hourly Rate |
| 29 | FLSA_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
FLSA required
N=NO FLSA REQUIRED Y=FLSA REQUIRED |
| 30 | ERNCD_REG_HRS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_HRS |
| 31 | ERNCD_OT_HRS | Character(3) | VARCHAR2(3) NOT NULL |
OT Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_OT_HRS |
| 32 | REG_PAY_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Hours Input |
| 33 | REG_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Hours |
| 34 | OT_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Overtime Hours |
| 35 | REG_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Hourly Earnings |
| 36 | OT_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Overtime Hourly Earnings |
| 37 | ERNCD_REG_EARNS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Earns Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS |
| 38 | REG_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Salaried Earnings |
| 39 | REG_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Earnings |
| 40 | REG_EARN_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Earnings Hours |
| 41 | DED_TAKEN | Character(1) | VARCHAR2(1) NOT NULL |
Deductions Taken
D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D |
| 42 | DED_SUBSET_ID | Character(3) | VARCHAR2(3) NOT NULL | Deduction Subset ID |
| 43 | DED_TAKEN_GENL | Character(1) | VARCHAR2(1) NOT NULL |
Specify how general deduction is to be taken.
D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D |
| 44 | DED_SUBSET_GENL | Character(3) | VARCHAR2(3) NOT NULL | Subset ID for general deductions. |
| 45 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TAX_DATA |
| 46 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL |
Locality
Prompt Table: LOCAL_TAX_DATA |
| 47 | PAY_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly Default Value: PAYGROUP_TBL.PAY_FREQUENCY Prompt Table: FREQUENCY_TBL |
| 48 | TAX_PERIODS | Number(2,0) | SMALLINT NOT NULL |
Tax Periods
Default Value: 1 |
| 49 | TAX_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized B=Bonus C=Cumulative G=Aggregate L=Lump Sum M=Commission P=Specified on Paysheet S=Supplemental X=Special Supplemental Default Value: A |
| 50 | ADDL_TAXES | Character(1) | VARCHAR2(1) NOT NULL |
Additional Taxes
Y/N Table Edit Default Value: Y |
| 51 | OVERRIDE_HOURLY_RT | Character(1) | VARCHAR2(1) NOT NULL |
OverRide Hourly Rate Indicator
Y/N Table Edit Default Value: N |
| 52 | BENEFIT_RCD_NBR | Number(3,0) | SMALLINT NOT NULL | Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number. |
| 53 | SINGLE_CHECK_USE | Character(1) | VARCHAR2(1) NOT NULL |
How is Single Check Used
C=Check Only N=Not Applicable P=Paysheet Only Default Value: N |
| 54 | TL_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Time && Labor Source Flag
T=Time and Labor Record U=User Updated/Created Record |
| 55 | PAY_SHEET_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source of Paysheet
B=Flat Sum Bonus Calculation F=FLSA Paysheet K=Batch Final Check L=Online Final Check O=On-line Paysheet P=Paysheet Load S=Regular Paysheet Default Value: S |
| 56 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: JOB.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |
| 57 | EI_PRIOR_PD_CORR | Character(1) | VARCHAR2(1) NOT NULL |
EI Prior Period Correction
Y/N Table Edit Default Value: N |
| 58 | COMP_RATECD_REG | Character(6) | VARCHAR2(6) NOT NULL |
Regular Comp Rate Code
Prompt Table: COMP_RT_REG_VW |
| 59 | COMP_RATECD_OT | Character(6) | VARCHAR2(6) NOT NULL |
Overtime Comp Rate Code
Prompt Table: COMP_RT_OT_VW |
| 60 | COMPRATE_USED_REG | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used for Regular |
| 61 | COMPRATE_USED_OT | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used for Overtime |
| 62 | FICA_STATUS_EE | Character(1) | VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt H=ER FICA Exmpt J=EE FICA Exmpt K=EE/ER FICA Exmpt M=Medicare only N=Subject |
| 63 | PAID_PRDS_PER_YEAR | Number(6,2) | DECIMAL(5,2) NOT NULL | Annualize factor for contract pay calculation |
| 64 | ORIG_PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Original Paygroup |
| 65 | FLSA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required |
| 66 | XREF_NUM | Number(15,0) | DECIMAL(15) NOT NULL |
T&L Xref Num
Default Value: 0 |
| 67 | FLSA_END_DT | Date(10) | DATE | FLSA End Date |
| 68 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 69 | BEN_DED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Benefit Deductions Status
A=Additional Pay Update C=Calculated D=Employee Data Update I=Initial L=Pay Calendar Update U=User Update Default Value: I |
| 70 | GENL_DED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
General Deductions Status
A=Additional Pay Update C=Calculated D=Employee Data Update I=Initial L=Pay Calendar Update U=User Update Default Value: I |
| 71 | HP_CONTRACT_NUM | Number(7,0) | INTEGER NOT NULL | Contract Number |
| 72 | HP_CONTRACT_SEQ | Number(3,0) | SMALLINT NOT NULL | Contract Sequence |
| 73 | PY_JUR_CODE | Character(10) | VARCHAR2(10) NOT NULL | This field is used for storing Jurisdiction Code for the state |