| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
HRS_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Based On
E=Pension Consolidated Earnings
H=Payroll Hours
S=Payroll Special Accumulator
T=Earnings Balance Table
W=Payroll W2
Default Value: E
|
| 4 |
PA_W2_BOX |
Character(4) |
VARCHAR2(4) NOT NULL |
W2 Box
01=Wages,tips, other compensation
03=Social Security Wages
05=Medicare wages and tips
17=State Wages, tips, etc.
20=Local wages, tips, etc.
|
| 5 |
CONS_EARNINGS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Consolidated Earnings Name
Prompt Table:
PA_CONS_EARN_VW
|
| 6 |
ERNCD_SPCL |
Character(3) |
VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table:
SPCL_EARNS_TBL
|
| 7 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table:
PA_BAL_ID_VW
|
| 8 |
CUSTOM_STMT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table:
PA_CUSTOM
|
| 9 |
EARNS_HRS_DIVISOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings to Hours Divisor
C=Constant
R=Compensation Rate
S=Custom Statement
T=Table LookUp
U=User Code
|
| 10 |
HRS_CONSTANT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Constant Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 11 |
HRS_CONSTANT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Hours Constant
|
| 12 |
HRS_CONSTANT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Hours Constant Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 13 |
HRS_CONST_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
|
| 14 |
TABLE_USE_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Table Use Name
Prompt Table:
PA_TBL_LOOKUP
|
| 15 |
ACCUM_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Accumulation Period
A=Employee's Anniversary Year
C=Calendar Year
M=Calendar Month
O=Other Year
P=Plan Year
Default Value: C
|
| 16 |
ACCUM_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accumulate Based On
E=Earned Date
P=Pay Check Date
R=Payroll End Date
Default Value: E
|
| 17 |
USE_ANNV_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
First Period is Anniv Year
Y/N Table Edit
|
| 18 |
MINIMUM |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Minimum Amount
|
| 19 |
MINIMUM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Minimum Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 20 |
MINIMUM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Amount
Prompt Table:
PA_ALIAS_USE
|
| 21 |
MINIMUM_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 22 |
MAXIMUM_LIMIT |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Maximum Limit
|
| 23 |
MAXIMUM_LIMIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Maximum Limit Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 24 |
MAX_LIMIT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Maximum Limit Alias
Prompt Table:
PA_ALIAS_USE
|
| 25 |
MAX_LIMIT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 26 |
ADDITIONAL |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Additional amount
|
| 27 |
ADDITIONAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Additional Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 28 |
ADDITIONAL_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Plus Additional Amount
Prompt Table:
PA_ALIAS_USE
|
| 29 |
ADDITIONAL_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 30 |
HR_ACTION_CATEGORY |
Character(10) |
VARCHAR2(10) NOT NULL |
HR Action / Reason Category
Prompt Table:
PA_HR_ACT
|
| 31 |
START_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Start Date (Month)
|
| 32 |
START_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Start Date (Day)
|
| 33 |
TABLE_USE_NAMET |
Character(2) |
VARCHAR2(2) NOT NULL |
Table Use Type
|
| 34 |
TOTAL_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Pay or Including Erncds
I=Including
T=Total Bal/Pay Minus
|