PY_IC_DED_VW

(SQL View)
 Index Back

Self Service Genl Deds View

View created to support Serf Service Voluntary Deduction (General Deduction) Update.This view contains the general deduction detail for those deductions that can be updated via internet browser for an employee. This view is based on GENL_DEDUCTION.Changes made to the record GENL_DEDUCTION would need to be analyzed and made to PY_IC_DED_VW, if necessary.

SELECT A.EMPLID ,A.COMPANY ,A.DEDCD ,A.EFFDT ,A.DED_CALC ,A.DEDUCTION_END_DT ,A.DED_ADDL_AMT ,A.DED_RATE_PCT ,A.GOAL_AMT ,A.GOAL_BAL ,A.LOAN_INT_PCT ,A.BAS_TAXABLE_BEN ,A.DED_STOPPED ,A.LAST_ACTION ,A.LAST_UPDATE_DATE ,A.PROCESS_DEDN ,A.GVT_DED_DIST_CD ,A.GVT_PYMNT_METHOD ,A.GVT_CHK_NAME ,A.GVT_ADDRESS1 ,A.GVT_ADDRESS2 ,A.GVT_ADDRESS_CITY ,A.GVT_ADDRESS_STATE ,A.GVT_ADDRESS_ZIP ,A.GVT_ADDRESS_CNTRY ,A.BANK_CD ,A.ACCOUNT_NUM ,A.ACCOUNT_TYPE ,A.GVT_PAYEE_ID_NO ,A.GVT_PAYEE_NAME ,A.GVT_ALLOT_PB FROM PS_GENL_DEDUCTION A

  • 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

    Prompt Table: COMPANY_TBL

    3 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: GENL_DED_CD

    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
    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)

    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
    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