| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table:
PER_ORG_ASGN_VW
|
| 3 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
ADDL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Additional Pay Sequence Number
|
| 6 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 7 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 8 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 9 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
%EDITTABLE
|
| 10 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 11 |
ADDL_PAY_SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Pay Shift
1=1
2=2
3=3
J=Use Job Shift
N=Not Applicable
Default Value: J
|
| 12 |
OTH_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Other Hours
|
| 13 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 14 |
OTH_PAY |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Other Pay
|
| 15 |
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
|
| 16 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 17 |
EARNINGS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 18 |
GOAL_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Goal Amount
|
| 19 |
GOAL_BAL |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Goal Balance
|
| 20 |
OK_TO_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pay
Y/N Table Edit
Default Value: N
|
| 21 |
DISABLE_DIR_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Direct Deposit
Y/N Table Edit
Default Value: N
|
| 22 |
PRORATE_ADDL_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Additional Pay
Y/N Table Edit
Default Value: N
|
| 23 |
PRORATE_CUI_WEEKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate EI Weeks
Y/N Table Edit
Default Value: N
|
| 24 |
PAY_PERIOD1 |
Character(1) |
VARCHAR2(1) NOT NULL |
First Pay Period
Y/N Table Edit
Default Value: Y
|
| 25 |
PAY_PERIOD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Second Pay Period
Y/N Table Edit
|
| 26 |
PAY_PERIOD3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Pay Period
Y/N Table Edit
|
| 27 |
PAY_PERIOD4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Fourth Pay Period
Y/N Table Edit
|
| 28 |
PAY_PERIOD5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Fifth Pay Period
Y/N Table Edit
|
| 29 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 30 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 31 |
TAX_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Tax Periods
Default Value: 1
|
| 32 |
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
|
| 33 |
ADDL_PAY_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Frequency
A=Annually
B=Biweekly
D=Daily
M=Monthly
P=Use Pay Group Frequency
Q=Quarterly
S=Semimonthly
W=Weekly
Default Value: P
|
| 34 |
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: R
|
| 35 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
Prompt Table:
DED_SUBSET_TBL
|
| 36 |
DED_TAKEN_GENL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
Default Value: R
|
| 37 |
DED_SUBSET_GENL |
Character(3) |
VARCHAR2(3) NOT NULL |
General Ded Subset ID
Prompt Table:
DED_SUBSET_TBL
|
| 38 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 39 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 40 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 41 |
RECORD_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Source
B=Batch
O=On-line
Default Value: O
|