| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 3 |
PAYCHECK_DIST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Mail Option
1=Company Distribution
2=Postal Service
I=Company Distribution
X=Postal Service
Default Value: I
|
| 4 |
PAYCHECK_ADDR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Address Option
1=Home Address
2=Mailing Address
3=Check Address
C=Check Address
E=Select on Payroll Options Page
H=Home Address
M=Mailing Address
Default Value: H
|
| 5 |
PAYCHECK_LOCN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Option
D=Home Department Location
E=Select on Payroll Options Page
J=Job Location
O=Other Location
Default Value: D
|
| 6 |
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
|
| 7 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
Prompt Table:
DED_SUBSET_TBL
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 9 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SET_LOC_PAY_VW
|
| 10 |
MAIL_DROP |
Character(50) |
VARCHAR2(50) NOT NULL |
Mail Drop ID
|
| 11 |
PAYCHECK_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Paycheck Name
|
| 12 |
PRIM_PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Primary PayGroup
Prompt Table:
PRIM_PAYGRP_VW
|
| 13 |
PI_DC_EMPLRCD |
Number(3,0) |
SMALLINT NOT NULL |
Deduction Calc Record
Default Value: 0
Prompt Table:
PI_MULT_DED_VW
|
| 14 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
PERSON_ADDRESS
|