| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPONENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Sal package - Package Component
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
COMPONENT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Sal Package - Component Type
AMT=Flat Amount
FAIR=Airline
FBRD=Board
FENT=Tax-exempt Body Entertainment
FEXP=Expenses
FHSG=Housing
FLAA=Living Away From Home Allowanc
FLOA=Loan
FPRK=Car Parking
FPTY=Property
FRSD=Residual
FVEH=Motor Vehicle
FWVR=Debt Waiver
HOM=Home Office Lease
PCT=Pct of Contributing Components
PCTB=Percentage of Benefits Base
Default Value: AMT
|
| 7 |
CALC_STARTING_PT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal package
N=None
T=Total Package Value
Default Value: N
|
| 8 |
PACKAGE_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Sal Package - Package Level
NIL=No Effect
TEC=Total Empl Cost
TPV=Total Pkg Value
Default Value: TPV
|
| 9 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
PKG_COMP_RCD_VW
|
| 10 |
ADD_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 11 |
PROJECTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Projection Calculation Type
A=Ad Hoc
B=Budget
R=Regular
Default Value: R
|
| 12 |
ENROL_BENEF_BASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Enrol Benefits Base
Y/N Table Edit
|
| 13 |
BEN_BSE_COMPRATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Base Comp Rate Code
Prompt Table:
PKG_COMP_RCD_VW
|