GPDE_BK_PG_SBK2

(SQL Table)
 Index Back

PG Source Bank Dflt

Paygroup Source Bank Dflt and payment type assignment

  • Parent record: GPDE_BK_PG_SBK1

    • # 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: GP_PYGRP

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPDE_AL_PAYMT_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Type
    1=Wages and Salaries
    3=Taxes
    4=Social Insurance
    6=Capital Accumulation
    7=Direct Life Insurance
    8=Garnishments
    9=External Transfer
    B=BVV
    L=U1/Sick Leave
    M=U2/Maternity Leave
    V=Advance Payments
    4 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK