DED_NA

(SQL Table)
Index Back

Deduction Info

Contains fields for the NA Payroll

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

    Prompt Table: PER_ORG_ASGN

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: R

    4 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID

    Prompt Table: DED_SUBSET_TBL