GPAU_NRP_SP1_AD(SQL Table) |
Index Back |
|---|---|
Pkg Base Component Expense CdsSalatey Pacakaging - Base Component Expense Cds |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COMPONENT |
Character(8) | VARCHAR2(8) NOT NULL | Sal package - Package Component |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | 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 |
| 6 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number Earning |
| 7 | PIN_DED_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number |
| 8 | 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 |
| 9 | 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 |