PAY_DED_DIST(SQL Table) |
Index Back |
---|---|
Payroll Deduction Fund DistThis table contains deduction information created during the payroll calculation/distribution process. A separate record will be created for each deduction code and deduction class per employee, account code, and accounting period. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
3 | PAY_END_DT | Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
5 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
6 | LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Line Nbr |
7 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
8 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
9 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BEN_PROG_BENPLN |
10 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: BEN_PROG_BENDED |
11 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |
12 | DED_SLSTX_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Type
B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax |
13 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: ACCT_FY_VW |
14 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Accounting Period
Prompt Table: ACCT_PERIOD_VW |
15 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: ACCT_CD_CA_VW |
16 | BUDGET_DATA | Character(50) | VARCHAR2(50) NOT NULL | Budget Data |
17 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
18 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCOUNT_VW |
19 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table:
BUD_DEPT_EFF_VW
|
20 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
21 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
22 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
23 | HP_RETDIST_SEQ_NO | Number(5,0) | INTEGER NOT NULL |
Retro Distrubution process sequence number
Default Value: 0 |
24 | DED_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Deduction |
25 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
27 | REVERSED | Character(1) | VARCHAR2(1) NOT NULL |
Reversed
Y/N Table Edit Default Value: N |
28 | HP_RETDIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the status of retro distribution on the current distribution record
0=Not changed D=Reversing Entry R=Redistributed Default Value: 0 |
29 | HP_RDIST_REV_SEQ | Number(5,0) | INTEGER NOT NULL |
Pointer to set of data that repalces the current set of data, used by retro distribution
Default Value: 0 |
30 | HP_RDIST_GL_INFACE | Character(1) | VARCHAR2(1) NOT NULL |
Retroactive Distribution run for GL Interface
Default Value: N |
31 | HP_RETDIST_PAY_DT | Date(10) | DATE | Retro Dist Pay End Date |
32 | DEFAULT_FUND_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Default Funding Source Option
A=Distrib over Actual Earnings E=Earnings Funding Source N=No Defaults S=Specified Defaults |
33 | HP_DISTRIB_OVRRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
Y/N Table Edit Default Value: N |