| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
HR_GP_PYGRP_VW
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: FA_DTLS_HDR.COMPANY
Prompt Table:
COMPANY_TBL
|
| 3 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Default Value: FA_DTLS_HDR.PAYGROUP
Prompt Table:
PAYGROUP_TBL
|
| 4 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
Default Value: FA_DTLS_HDR.CALENDAR_YEAR
|
| 5 |
FA_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will define the Festive Advance Holiday Type.
CHR=Christmas
CNY=Chinese New Year
DEP=Deepavali
HAR=Hari Raya
N=Value Not Applicable
Default Value: FA_DTLS_HDR.FA_TYPE
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE
|
| 7 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 8 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Default Value: 00
|
| 9 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
DEDUCTION_TBL
|
| 10 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 11 |
FA_AMOUNT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Festive Advance Payment Amount
|
| 12 |
FA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Festive Advance Payment Status
A=Approved
N=Not Approved
P=Posted
Default Value: N
|
| 13 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 14 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 15 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 16 |
PIN_ERN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pin Number Earning
Prompt Table:
GP_ERN_SRCH
|