GPDE_BK_DP_SBK2

(SQL Table)
 Index Back

Departments Source Bank Dflt

Department Source Bank Dflt and payment type assignment and payment type assignment

  • Parent record: GPDE_BK_DP_SBK1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: DEPT_TBL.EFFDT

    4 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
    5 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK