| # |
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 |
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.
|
| 12 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
Default Value: PAY_EARNINGS.PAY_END_DT
|
| 13 |
EARNS_BEGIN_DT |
Date(10) |
DATE |
Earnings Begin Date
Default Value: PAY_CALENDAR.PAY_BEGIN_DT
|
| 14 |
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
Default Value: N
|
| 15 |
DISABLE_DIR_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Direct Deposit
Y/N Table Edit
Default Value: PAY_EARNINGS.OFF_CYCLE
|
| 16 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit
Default Value: N
|
| 17 |
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
|
| 18 |
OK_TO_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Okay to pay indicator.
Y/N Table Edit
Default Value: N
|
| 19 |
JOB_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit
Default Value: N
|
| 20 |
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
|
| 21 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
%EDITTABLE
|
| 22 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 23 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 24 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 25 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 26 |
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
|
| 27 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Shift Differential Rate
|
| 28 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 29 |
FLSA_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
FLSA Rate
|
| 30 |
RATE_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate
F=FLSA Rate
H=Hourly Rate
Default Value: H
|
| 31 |
FLSA_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA required
N=NO FLSA REQUIRED
Y=FLSA REQUIRED
Default Value: N
|
| 32 |
ERNCD_REG_HRS |
Character(3) |
VARCHAR2(3) NOT NULL |
Regular Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_HRS
|
| 33 |
ERNCD_OT_HRS |
Character(3) |
VARCHAR2(3) NOT NULL |
OT Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_OT_HRS
|
| 34 |
REG_PAY_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Regular Hours Input
|
| 35 |
REG_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Regular Hours
|
| 36 |
OT_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Overtime Hours
|
| 37 |
REG_HRLY_EARNS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Regular Hourly Earnings
|
| 38 |
OT_HRLY_EARNS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Overtime Hourly Earnings
|
| 39 |
ERNCD_REG_EARNS |
Character(3) |
VARCHAR2(3) NOT NULL |
Regular Earns Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS
|
| 40 |
REG_PAY |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Regular Salaried Earnings
|
| 41 |
REG_EARNS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Regular Earnings
|
| 42 |
REG_EARN_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Regular Earnings Hours
|
| 43 |
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
Prompt Table:
DED_TAKEN_BN_VW
|
| 44 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
Prompt Table:
DED_SUBSET_TBL
|
| 45 |
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
Prompt Table:
DED_TAKEN_GN_VW
|
| 46 |
DED_SUBSET_GENL |
Character(3) |
VARCHAR2(3) NOT NULL |
Subset ID for general deductions.
Prompt Table:
DED_SUBSET_TBL
|
| 47 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%RECNAME_EDIT
|
| 48 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_DATA
|
| 49 |
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:
PAY_FREQ_WRK_VW
|
| 50 |
TAX_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Tax Periods
Default Value: 1
|
| 51 |
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
|
| 52 |
ADDL_TAXES |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Taxes
Y/N Table Edit
Default Value: Y
|
| 53 |
OVERRIDE_HOURLY_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
OverRide Hourly Rate Indicator
Y/N Table Edit
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
Default Value: JOB.FICA_STATUS_EE
|
| 63 |
PAID_PRDS_PER_YEAR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Annualize factor for contract pay calculation
|
| 64 |
FLSA_END_DT |
Date(10) |
DATE |
FLSA End Date
|
| 65 |
ORIG_PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Original Paygroup
|
| 66 |
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
Default Value: X
|
| 67 |
XREF_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
T&L Xref Num
Default Value: 0
|
| 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
Default Value: 0
Prompt Table:
HP_CNTRACT_VW
|
| 72 |
HP_CONTRACT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Sequence
Default Value: 0
|
| 73 |
PY_JUR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for storing Jurisdiction Code for the state
Prompt Table:
PY_JUR_MW_DVW
|