DED_NA(SQL Table) |
Index Back |
---|---|
Deduction InfoContains fields for the NA Payroll |
# | 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 |