| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
COMPONENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Sal package - Package Component
Prompt Table:
PKG_BSE_CMP_TBL
|
| 6 |
COMPONENT_START |
Date(10) |
DATE NOT NULL |
Sal Package - Component Start Date
Default Value: PKG_MDL_TBL.EFFDT
|
| 7 |
COMPONENT_END |
Date(10) |
DATE NOT NULL |
Sal Package - Component End Date
Default Value: PKG_MDL_TBL.PKG_END_DT
|
| 8 |
COMPONENT_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Component Amount
|
| 9 |
COMPONENT_AMT_TPV |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Pacakge - TPV Component Amount
|
| 10 |
COMPONENT_AMT_TEC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - TEC Component Amount
|
| 11 |
COMPONENT_PER_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Component Amount (Period)
|
| 12 |
COMPONENT_PER_TPV |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Component TPV Amount (Period)
|
| 13 |
COMPONENT_PER_TEC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Component TEC Amount (Period)
|
| 14 |
TAXABLE_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Balance Total Employment Cost
|
| 15 |
COMPONENT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sal package - Component Percent
|
| 16 |
BENEFIT_BASE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Benefit Base
|
| 17 |
PKG_REMAINDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Package Remainder
Y/N Table Edit
Default Value: N
|
| 18 |
TAX_ADJ_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Tax Adjustment Amount (Annual)
|
| 19 |
TAX_EXEMPT_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Tax Exemption Amount (Annual)
|
| 20 |
MV_FBT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal package - Motor veh - FBT Calculation Method
O=Operating Cost
S=Statutory Formula
Default Value: S
|
| 21 |
MV_LEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Motor veh - Leased
Y/N Table Edit
Default Value: Y
|
| 22 |
MV_CAPITAL_COST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Motor veh - Capital Cost
|
| 23 |
MV_CAPITAL_BASE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Motor veh - Capital Cost
|
| 24 |
MV_CAPITAL_GST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Motor veh - GST on Capital Cost
|
| 25 |
MV_DEPRECIATED_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Motor Veh - Depreciated Value
Default Value: PKG_MDL_BSE_CMP.MV_CAPITAL_COST
|
| 26 |
MV_MTHLY_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Motor veh - Employee Contribution (Mthly)
|
| 27 |
MV_ANNUAL_EXP |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Motor Veh - Operating Expense (Annual)
|
| 28 |
MV_MILEAGE |
Number(8,0) |
INTEGER NOT NULL |
Sal Package - Motor veh - Estimated Kilometres
|
| 29 |
MV_PRIVATE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Sal Package - Motor ver - Private Use Days (Annual)
Default Value: 365
|
| 30 |
MV_PRIVATE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sal package - Motor veh - Private Use Percent
Default Value: 100
|
| 31 |
MV_OPERATE_COST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Motor veh - Operating Cost (Annual)
|
| 32 |
MV_LS_COMPANY |
Character(40) |
VARCHAR2(40) NOT NULL |
Sal Package - Motor veh - Lease Company Name
|
| 33 |
MV_LS_START_DT |
Date(10) |
DATE |
Sal Package - Motor veh - Lease Start Date
|
| 34 |
MV_LS_END_DT |
Date(10) |
DATE |
Sal Package - Motor veh - Lease End Date
|
| 35 |
MV_LS_PAYOUT_DT |
Date(10) |
DATE |
Lease Payout Date
|
| 36 |
MV_LS_TERM |
Number(3,0) |
SMALLINT NOT NULL |
Sal Package - Motor veh - Lease Term (Months)
|
| 37 |
MV_LS_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Motor Vehicle Lease Number - Salary Packaging
|
| 38 |
MV_LS_RESID_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Motor veh - Lease Residual Amount
|
| 39 |
MV_LS_RESID_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sal Package - Motor veh - Lease Residual Percent
|
| 40 |
MV_MILEAGE_START |
Number(8,0) |
INTEGER NOT NULL |
Sal Package - Motor veh - Kilometres Start
|
| 41 |
MV_MILEAGE_END |
Number(8,0) |
INTEGER NOT NULL |
Sal Package - Motor veh - Kilometres End
|
| 42 |
MV_START_DATE |
Date(10) |
DATE |
Sal Package - Motor veh - Odometer Reading Start Date
|
| 43 |
MV_END_DATE |
Date(10) |
DATE |
Sal Package - Motor Veh - Odometer Reading End Date
|
| 44 |
MV_MAKE |
Character(15) |
VARCHAR2(15) NOT NULL |
Sal Package - Motor veh - Make
|
| 45 |
MV_MODEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Sal Package - Motor veh - Model
|
| 46 |
MV_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Sal Package - Year
|
| 47 |
MV_BODY_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Sal Package - Motor Veh - Body Type
|
| 48 |
MV_TRANSMISSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Motor veh - Transmission Type
A=Automatic
M=Manual
Default Value: A
|
| 49 |
MV_REG_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Motor Vehicle Registration Number - Salary Packaging
|
| 50 |
MV_REG_EXP_DT |
Date(10) |
DATE |
Sal package - Motor veh - Registration Expiry Date
|
| 51 |
MV_ENGINE_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Motor Vehicle Engine Number - Salary Packaging
|
| 52 |
MV_CHASSIS_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Motor Vehicle Chassis Number - Salary Packaging
|
| 53 |
MV_COLOUR |
Character(15) |
VARCHAR2(15) NOT NULL |
Sal Package - Motor Veh - Colour
|
| 54 |
LN_INTEREST_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sal Package - Loan Interest Rate
|
| 55 |
LN_LOAN_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Loan Amount
|
| 56 |
LN_LOAN_BALANCE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Loan balance
|
| 57 |
LN_ACCOUNT_NBR |
Character(17) |
VARCHAR2(17) NOT NULL |
Loan Account Number - Salary Packaging
|
| 58 |
HS_ACCOM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Housing - Accomodation Type
H=Hotel, Motel, Hostel etc.
O=Other Accommodation
Default Value: O
|
| 59 |
HS_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Housing - Annual Contribution
|
| 60 |
HS_MARKET_VALUE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - House Market Valud
|
| 61 |
LA_ACCOM_COST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Accomodation Cost
|
| 62 |
LA_ADDL_FOOD_COST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Additional Food Cost
|
| 63 |
LA_ALLOW_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Allowance Amount
|
| 64 |
AL_STANDBY_FARE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Standby fare
|
| 65 |
AL_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Annual Contribution
|
| 66 |
PK_FBT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal package - FBT Calculation Method
C=Commercial Parking Station
M=Market Value
Default Value: C
|
| 67 |
PK_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package -Employee Contribution (Annual)
|
| 68 |
PK_DAY_RATE |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Sal Package - Lowest Daily Parking Fee
|
| 69 |
PK_AVAIL_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Sal Package - Available Days (Annual)
Default Value: 365
|
| 70 |
PK_MARKET_VALUE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Market Value (Annual)
|
| 71 |
PY_FBT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - FBT Method
E=External Property
N=In-house Property - Non-retail
R=In-house Property - Retail
Default Value: R
|
| 72 |
PY_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Employee Contribution (Annual)
|
| 73 |
PY_SELL_PRICE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Lowest Selling Price (Annual)
|
| 74 |
RD_FBT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - FBT Method
E=External
I=In-house
Default Value: I
|
| 75 |
RD_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Employee Contribution (Annual)
|
| 76 |
RD_COST_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal pacakge - Cost (Annual)
|
| 77 |
EX_ANN_EXPENSE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Expense Amount (Annual)
|
| 78 |
EX_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Expenense Annual Contribution
|
| 79 |
BR_ANN_BENEFIT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Annual Benefit
|
| 80 |
BR_ANN_CONTRIB |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employee Contribution (Annual)
|
| 81 |
EN_ANN_ENT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Entertainment Amount (Annual)
|
| 82 |
EN_ANN_CONTRIB |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
sal Package - Employee Contribution (Annual)
|
| 83 |
WV_ANN_WAIVER |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Debt Waiver - Debt Waiver - Amount (Annual)
|
| 84 |
WV_ANN_CONTRIB |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Debt Waiver - Employee Contribution (Annual)
|
| 85 |
HO_CAPITAL_COST |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Home Office - Capital Cost
|
| 86 |
HO_LEASE_TERM |
Number(3,0) |
SMALLINT NOT NULL |
Sal Package - Home Office - Lease Term
|
| 87 |
HO_RESIDUAL_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Home Office - Lease Residual Amount
|
| 88 |
HO_RESIDUAL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sal Package - Home Office - Lease Residual Percent
|
| 89 |
HO_START_DT |
Date(10) |
DATE |
Sal Package - Home Office - Lease Start date
Default Value: %DATE
|
| 90 |
HO_EXPIRY_DT |
Date(10) |
DATE |
Sal Package - Home Office - Expiry Date
|
| 91 |
HO_GOODS_DESC |
Character(40) |
VARCHAR2(40) NOT NULL |
Sal Package - Home Office - Goods Desc
|
| 92 |
GST_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package -Gross Amount
|
| 93 |
GST_RATE |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Sal Package - GST Rate
|
| 94 |
CF_GST_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Carried Forward GST Amount
|