| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: OPRDEFTBL_UPG.COMPANY
Prompt Table:
COMPANYTBL_UPG
|
| 2 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
PAY_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
|
| 8 |
RETIREE_PAYGROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Retiree Pay Group
Default Value: N
|
| 9 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: OPRDEFTBL_UPG.COUNTRY
|
| 10 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
|
| 11 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Default Value: H
|
| 12 |
NET_PAY_MINIMUM |
Number(4,0) |
SMALLINT NOT NULL |
Minimum Net Pay
|
| 13 |
NET_PAY_MAXIMUM |
Number(8,0) |
INTEGER NOT NULL |
Maximum Net Pay
Default Value: 10000
|
| 14 |
AUTO_OVERTIME |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Automatic Overtime
|
| 15 |
PAY_REF_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Payroll Reference #
|
| 16 |
ROE_ISSUER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ROE Issuer ID
|
| 17 |
ROE_CONTACT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ROE Contact ID
|
| 18 |
PAY_RPT_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Report Sequence
1=Dept, Employee Type, Employee
2=Dept, Employee
3=Employee Only
4=Employee Type, Dept, Employee
5=Employee Type, Employee
Default Value: 1
|
| 19 |
PAY_RPT_SUBTOTALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Report Subtotals
A=Break After Subtotals
B=Break Before and After Subttls
N=No Subtotals
Default Value: A
|
| 20 |
PAY_RPT_EMPL_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Rpt Employee Sequence
E=Employee ID Sequence
N=Employee Name Sequence
Default Value: N
|
| 21 |
PAYCHECK_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Sequence
E=Select on Payroll Data Panel
I=Company Distribution Order
P=Paysheet Order
X=Postal Code Order
Default Value: P
|
| 22 |
PAYCHECK_ADDR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Address Option
1=Home Address
2=Mailing Address
3=Check Address
C=Mail to Check Address
E=Select on Payroll Data Panel
H=Mail to Home Address
M=Mail to Mailing Address
Default Value: H
|
| 23 |
PAYCHECK_LOCN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Option
D=Home Department Location
E=Select on Payroll Data Panel
J=Job Location
O=Other Location
Default Value: D
|
| 24 |
PAYCHECK_EMPL_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Employee Sequence
E=Employee ID Sequence
N=Employee Name Sequence
Default Value: N
|
| 25 |
PAYCHECK_SEQ_FLD01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 01
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 26 |
PAYCHECK_SEQ_FLD02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 02
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 27 |
PAYCHECK_SEQ_FLD03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 03
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 28 |
PAYCHECK_SEQ_FLD04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 04
D=Department Id
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 29 |
PAYCHECK_SEQ_FLD05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 05
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 30 |
PAYCHECK_SEQ_FLD06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 06
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 31 |
PAYCHECK_SEQ_FLD07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 07
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 32 |
PAYCHECK_SEQ_FLD08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 08
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 33 |
PAYCHECK_SEQ_FLD09 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 09
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 34 |
PAYCHECK_SEQ_FLD10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Print Sequence 10
D=Department ID
E=Employee ID or Name
F=FLSA Status
L=Location
M=Mail Drop
S=Shift
T=Employee Type
U=Supervisor ID
|
| 35 |
OASDI_EARNS_BREAK |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Earnings Break Point
|
| 36 |
OASDI_LOW_FACTOR |
Number(5,4) |
DECIMAL(4,4) NOT NULL |
Factor for Low Earnings
|
| 37 |
OASDI_HIGH_EXEMPT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Exemption for High Earnings
|
| 38 |
PRORATE_SALARIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Salaried Proration Rule
A=Percent of Annual
P=Percent of Period
W=Rate per Work Day
Default Value: A
|
| 39 |
PRORATE_HRLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Hourly Proration Rule
P=Percent of Period
W=Work Days
Default Value: W
|
| 40 |
AUTO_PAYSHEET_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Paysheet Update
Default Value: Y
|
| 41 |
WORK_SCHEDULE |
Character(7) |
VARCHAR2(7) NOT NULL |
Work Schedule
|
| 42 |
DFLT_BEN_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Default Benefit Program
|
| 43 |
ERN_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Program ID
Default Value: COMPANYTBL_UPG.DFLT_ERN_PROGRAM
|
| 44 |
ERNCD_REG_HRS |
Character(3) |
VARCHAR2(3) NOT NULL |
Regular Hours Earnings Type
|
| 45 |
ERNCD_OT_HRS |
Character(3) |
VARCHAR2(3) NOT NULL |
OT Hours Earnings Type
|
| 46 |
ERNCD_REG_EARNS |
Character(3) |
VARCHAR2(3) NOT NULL |
Regular Earns Earnings Type
|
| 47 |
ERNCD_HOLIDAY |
Character(3) |
VARCHAR2(3) NOT NULL |
Holiday (Statutory) Earn Type
|
| 48 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
|
| 49 |
RETROPAY_PGM_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Retro Pay Program ID
|
| 50 |
FLSA_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA required
N=NO FLSA REQUIRED
Y=FLSA REQUIRED
Default Value: COMPANYTBL_UPG.FLSA_REQUIRED
|
| 51 |
ERNCD_HOL_NONSTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Non-Stat Holiday
Prompt Table:
ERN_PROGRAM_DEF
|
| 52 |
PI_CONFIG_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Configuration ID
|
| 53 |
DEFAULT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Default SetID
Default Value: PAYGROUPTBL_UPG.PAYGROUP
|
| 54 |
CONFIRM_ERRORS |
Character(1) |
VARCHAR2(1) NOT NULL |
Continue With Errors
Default Value: N
|
| 55 |
ERR_PED_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Pay End Dt Option
D=Next Day
N=None Chosen
S=Same Day
Default Value: N
|
| 56 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 57 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: INSTALLATIO_UPG.EXCHNG_TO_RT_TYPE
|
| 58 |
RT_CONV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Conversion Date
C=Check Date
P=Pay End Date
T=Today's Date
Default Value: C
|
| 59 |
TIPS_DELAY_WTHLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delay Withholding of Taxes
Default Value: COMPANYTBL_UPG.TIPS_DELAY_WTHLD
|
| 60 |
TIPS_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust to Minimum Wage
Default Value: COMPANYTBL_UPG.TIPS_ADJUST
|
| 61 |
ERNCD_TIPS_ADJUST |
Character(3) |
VARCHAR2(3) NOT NULL |
Min Wage Adjustment Earns Code
Default Value: COMPANYTBL_UPG.ERNCD_TIPS_ADJUST
|
| 62 |
ERNCD_TIPS_CRED |
Character(3) |
VARCHAR2(3) NOT NULL |
Tip Credit Earnings Code
Default Value: COMPANYTBL_UPG.ERNCD_TIPS_CRED
|
| 63 |
FLSA_SAL_HRS_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Salaried Hours Used
F=Fixed Salaried Hours
U=Unspecified Salaried Hours
Default Value: U
|
| 64 |
TERM_PGM_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Final Check Program ID
|
| 65 |
CAO_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
The CAO field is specified by Pay Group for HR Netherlands.
DET=CAO Retail Trade
HOU=CAO Wood Industry
MED=CAO Medical Staff
MET=CAO Metal Industry
VER=CAO Transportation Industry
|
| 66 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
|
| 67 |
ERNCD_1042_EARNS |
Character(3) |
VARCHAR2(3) NOT NULL |
1042 Earn Code
|
| 68 |
ERNCD_ERN_NOT_PD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earned and Not Paid Erncd
|
| 69 |
ERNCD_PD_NOT_ERN |
Character(3) |
VARCHAR2(3) NOT NULL |
Paid Not Earned Erncd
|
| 70 |
ERNCD_CNTRCT_REG |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Regular Earnings
|
| 71 |
STDNT_FIN_PAYGROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Fin Paygroup
Default Value: N
|
| 72 |
INDUSTRY_SECTOR |
Character(4) |
VARCHAR2(4) NOT NULL |
Industry Sector
CORE=Core
PBSC=Public Sector
USFG=US Federal Government
Default Value: CORE
|
| 73 |
INDUSTRY |
Character(4) |
VARCHAR2(4) NOT NULL |
Industry
CORE=Core
EDUC=Education
FNSV=Financial Services
GOVT=Government
HLTH=Health Care
RETL=Retail
TRAN=Transportation
UTIL=Utilities
Default Value: CORE
|
| 74 |
FLSA_PERIOD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
FLSA Period Definition
00=Fixed FLSA Period
01=Fire Protection
02=Law Enforcement
Default Value: 00
|
| 75 |
FLSA_CALENDAR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
FLSA Calendar ID
|