GENL_DEDUCTION

(SQL Table)
 Index Back

EE General Deduction Detail

This record contains the general deduction detail for an employee. A view W3PY_DED_DATA based on this record has been created for the purpose of WEB-enabled Dedn. update. Changes made to the record GENL_DEDUCTION would need to be analyzed and made to W3PY_DED_DATA if necessary.

  • Parent record: GENL_DED_CD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: BEN_PROG_GNLDED

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DED_CALC Character(1) VARCHAR2(1) NOT NULL Deduction Calculation Routine
    A=Flat Amount
    B=Percentage
    C=Calculated by Salary System
    D=Default to Deduction Table
    E=Percent of Special Earnings
    F=Percent of Federal Gross
    G=Percent of Total Gross
    H=Rate x Total Hours
    N=Percent of Net Pay
    P=Rate x Special Hours
    S=Special Deduction Calculation
    W=Rate x Hours Worked

    Default Value: D

    6 DEDUCTION_END_DT Date(10) DATE Deduction End Date
    7 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
    8 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
    9 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount
    10 GOAL_BAL Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Goal Balance
    11 LOAN_INT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Loan Interest Percent
    12 BAS_TAXABLE_BEN Character(1) VARCHAR2(1) NOT NULL Ben Admin Taxable Ben (Canada)

    Y/N Table Edit

    Default Value: N

    13 DED_STOPPED Character(1) VARCHAR2(1) NOT NULL Ded. stopped by Self Serv User
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    14 LAST_ACTION Character(1) VARCHAR2(1) NOT NULL Last Action
    C=System
    D=Hire Process
    O=Online User
    S=Supplier Deduction File
    W=Employee Self Service User
    15 LAST_UPDATE_DATE Date(10) DATE Date of last update
    16 PROCESS_DEDN Character(1) VARCHAR2(1) NOT NULL Process Deduction

    Y/N Table Edit

    Default Value: Y

    17 GVT_DED_DIST_CD Character(10) VARCHAR2(10) NOT NULL Deduction Distribution Cd

    Prompt Table: GVT_DED_DIST

    18 GVT_PYMNT_METHOD Character(1) VARCHAR2(1) NOT NULL Payment Method
    C=Check
    E=Electronic Funds Transfer
    N=None

    Default Value: E

    19 GVT_CHK_NAME Character(25) VARCHAR2(25) NOT NULL GVT Check Payee Name
    20 GVT_ADDRESS1 Character(35) VARCHAR2(35) NOT NULL GVT Address Line 1
    21 GVT_ADDRESS2 Character(35) VARCHAR2(35) NOT NULL GVT Address Line 2
    22 GVT_ADDRESS_CITY Character(16) VARCHAR2(16) NOT NULL GVT Address City
    23 GVT_ADDRESS_STATE Character(6) VARCHAR2(6) NOT NULL GVT Address State

    Prompt Table: STATE_NM_US_VW

    24 GVT_ADDRESS_ZIP Character(10) VARCHAR2(10) NOT NULL GVT Address Zip
    25 GVT_ADDRESS_CNTRY Character(3) VARCHAR2(3) NOT NULL GVT Address Country

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    26 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    27 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number
    28 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
    $=Issue Check
    C=Checking
    L=Liability
    N=Non Applicable
    S=Savings
    X=Expense
    29 GVT_PAYEE_ID_NO Character(9) VARCHAR2(9) NOT NULL GVT EFT Payee ID Number
    30 GVT_PAYEE_NAME Character(22) VARCHAR2(22) NOT NULL GVT EFT Account Holder
    31 GVT_ALLOT_PB Character(1) VARCHAR2(1) NOT NULL GVT Allotment Pushbutton