| # |
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 |
CONS_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidation Based On
B=Both Payroll Earns and Rate
E=Payroll Earnings Only
R=Compensation Rate Only
S=Payroll Special Accumulator
T=Earnings Balance Table
W=Payroll W2 Accumulator
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 |
ERNCD_SPCL |
Character(3) |
VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table:
SPCL_EARNS_TBL
|
| 6 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table:
PA_BAL_ID_VW
|
| 7 |
MINIMUM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Minimum Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 8 |
MINIMUM |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Minimum Amount
|
| 9 |
MINIMUM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Amount
Prompt Table:
PA_ALIAS_USE
|
| 10 |
MINIMUM_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 11 |
ADDITIONAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Additional Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 12 |
ADDITIONAL |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Additional amount
|
| 13 |
ADDITIONAL_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Plus Additional Amount
Prompt Table:
PA_ALIAS_USE
|
| 14 |
ADDITIONAL_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 15 |
MAXIMUM_LIMIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Maximum Limit Field
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 16 |
MAXIMUM_LIMIT |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Maximum Limit
|
| 17 |
MAX_LIMIT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Maximum Limit Alias
Prompt Table:
PA_ALIAS_USE
|
| 18 |
MAX_LIMIT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 19 |
TOTAL_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Pay or Including Erncds
I=Including
T=Total Bal/Pay Minus
|
| 20 |
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
|
| 21 |
START_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Start Date (Month)
|
| 22 |
START_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Start Date (Day)
|
| 23 |
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
|
| 24 |
ROUND_METHOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Round Method
Prompt Table:
PA_DATE_RND_OPT
|
| 25 |
USE_ACTUAL_COMPRTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Compensation Rate
Y/N Table Edit
|
| 26 |
PARTIAL_INCL_CDS |
Character(10) |
VARCHAR2(10) NOT NULL |
Partial period include codes
Prompt Table:
PA_HR_ACT
|
| 27 |
PARTIAL_EXCL_CDS |
Character(10) |
VARCHAR2(10) NOT NULL |
Partial period exclude codes
Prompt Table:
PA_HR_ACT
|
| 28 |
PARTIAL_CONT_CDS |
Character(10) |
VARCHAR2(10) NOT NULL |
Partial period continuous cds
Prompt Table:
PA_HR_ACT
|