RETROPAY_EARNS(SQL Table) |
Index Back |
---|---|
Retroactive Pay EarningsRetroactive Pay Earnings |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Retro Pay Sequence Number | |
2 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
3 | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
|
4 | Date(10) | DATE | Pay Period End Date | |
5 | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
|
6 | Number(4,0) | SMALLINT NOT NULL | Page # | |
7 | Number(2,0) | SMALLINT NOT NULL | Line # | |
8 | Number(3,0) | SMALLINT NOT NULL |
Additional Pay Line #
Prompt Table: PAY_EARNINGS |
|
9 | Character(1) | VARCHAR2(1) NOT NULL |
Type of Earning
1=Regular Hourly 2=Regular Salary 3=Overtime 4=Other Earns 5=Other Hours |
|
10 | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
|
11 | Number(2,0) | SMALLINT NOT NULL | Sequence Number | |
12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
13 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
14 | RETROPAY_EFFDT | Date(10) | DATE NOT NULL | Retro Pay Effective Date |
15 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
16 | ADDL_SEQ | Number(2,0) | SMALLINT NOT NULL | Additional Pay Sequence Number |
17 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
18 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
19 | EARNS_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Earnings Hours |
20 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
21 | NEW_HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | New Hourly Rate |
22 | EARNS_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earnings Amount |
23 | EARNS_AMT_ENTERED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earns Amount Entered |
24 | NEW_EARNS_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | New Earnings Amount |
25 | EARNS_AMT_OVRD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Earnings Amount Override |
26 | AMOUNT_DIFF | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Amount Difference |
27 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating |
28 | SHIFT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Shift Differential Rate |
29 | RETROPAY_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Earnings Type
Prompt Table: EARNINGS_TBL |
30 | RETROPAY_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Process Flag
C=Calculated N=Not Processed P=Loaded to Paysheets R=Recalculate Request X=Extracted |
31 | EXCEPTION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Exception - Chg in Pay Period
Y/N Table Edit Default Value: N |
32 | OK_TO_PAY | Character(1) | VARCHAR2(1) NOT NULL |
OK to Pay
Y/N Table Edit Default Value: N |
33 | JOB_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit Default Value: N |
34 | RETRO_ADDL_NO | Number(3,0) | SMALLINT NOT NULL | Retro Pay Additional Number |
35 | RETRO_SEPCHK | Number(1,0) | SMALLINT NOT NULL | Retro Pay Separate Check No. |
36 | TERM_EMPL_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Terminated Employees Processed
Y/N Table Edit Default Value: N |
37 | FLSA_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
FLSA required
N=NO FLSA REQUIRED Y=FLSA REQUIRED Default Value: N |
38 | RATE_USED | Character(1) | VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate F=FLSA Rate H=Hourly Rate Default Value: H |
39 | FLSA_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | FLSA Rate |
40 | RECORD_CHANGED | Character(1) | VARCHAR2(1) NOT NULL |
Record Changed
Y/N Table Edit Default Value: N |
41 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
42 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
43 | DIST_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Distribution |
44 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
45 | COMPRATE_USED | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used |
46 | NEW_COMPRATE_USED | Number(19,6) | DECIMAL(18,6) NOT NULL | New Comp Rate Used |
47 | RETROPAY_LOAD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Load Switch
Y/N Table Edit Default Value: Y |
48 | FLSA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FLSA Status field
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 Default Value: X |