| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 3 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 4 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 5 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 6 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
|
| 7 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 8 |
CHECK_DT |
Date(10) |
DATE |
Check date.
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 10 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 11 |
PY_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 12 |
PY_EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Employee Record
|
| 13 |
PY_EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 14 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 15 |
TOTAL_GROSS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Gross
|
| 16 |
TOTAL_TAXES |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Taxes
|
| 17 |
TOTAL_DEDUCTIONS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Deductions
|
| 18 |
PY_NET_PAY |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Net Pay
|
| 19 |
PY_ER_DED_CUR |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Payroll Current Employer Deduction
|
| 20 |
PY_ER_TAX_CUR |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Payroll Employer Tax Current
|
| 21 |
PY_COMPANY_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Company description
|
| 22 |
PY_PAYGROUP_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Paygroup Description
|
| 23 |
PY_BUS_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Business Unit description
|
| 24 |
PY_DEPT_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Department description
|
| 25 |
PY_STATE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
State Description
|
| 26 |
PY_PAY_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the type of pay frequency.
A=Annual
B=Biweekly
C=Contract
D=Daily
F=Every Four Weeks
H=Hourly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
|
| 27 |
PY_EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 28 |
PY_PAYCHECK_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Option
&=Check and Advice
A=Advice
C=Check
M=Manual Check
R=Check Reversal
|
| 29 |
PY_OFF_CYCLE_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Off-Cycle Calendar
|
| 30 |
PY_RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Run ID
|