GPUS_FPMT_PYE

(SQL Table)
Index Back

Payee Final Payment

Payee Final Payment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GPUS_PYGASN_VW

4 TERMINATION_DT Date(10) DATE Termination Date
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

Prompt Table: GP_PAY_CAL_VW

7 GPUS_FPMT_ID Character(10) VARCHAR2(10) NOT NULL Final Payment

Prompt Table: GPUS_FPMT_TBL