| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPONENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Sal package - Package Component
Prompt Table:
PKG_BSE_CMP_TBL
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 3 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 4 |
PKG_PAY_EXP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Package Expenses Payroll Type
D=Deduction
E=Earning
N=N/A
X=Business Expenses
Default Value: N
|
| 5 |
PIN_ERN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pin Number Earning
Prompt Table:
GPAU_ERN_SRCH
|
| 6 |
PIN_DED_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pin Number
Prompt Table:
GPAU_DED_SRCH
|
| 7 |
EXPENSE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Expense code.
01=Airfare
02=Lodging
03=Car Rental
04=Meals
05=Telephone
06=Travel
07=Relocation
08=Entertainment
09=Parking
10=Mileage
11=Advertising
12=Referral Fee
13=Postage
14=Publication
15=Membership
16=Miscellaneous
17=Staff Time
18=Job Boards
19=Pre-Employment Request
|
| 8 |
EXP_GST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - GST Type Calculation
1=GST Excluded
2=GST Included
3=GST Not Applicable
4=GST Only
Default Value: 3
|