HP_PY_CTX_DSTVW

(SQL View)
 Index Back

Canadian Payroll Tax Dist

This table contains tax distribution information created during the payroll calculation/distribution process. A separate record will be created for each state, locality and tax class per employee, account code, and accounting period.

SELECT COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , PROVINCE , TAX_CLASS_CAN , FISCAL_YEAR , ACCOUNTING_PERIOD , ACCT_CD , BUDGET_DATA , ACCOUNT , EARNS_END_DT , TAX_CUR , DEPTID , POSITION_POOL_ID , JOBCODE , POSITION_NBR , EMPL_RCD , CURRENCY_CD , REVERSED , HP_RETDIST_SEQ_NO , HP_RETDIST_STATUS , HP_RDIST_REV_SEQ , HP_RDIST_GL_INFACE , HP_RETDIST_PAY_DT , DEFAULT_FUND_OPTN , HP_DISTRIB_OVRRIDE FROM PS_PAY_CTX_DIST WHERE HP_RETDIST_STATUS = '0'

  • Parent record: PAY_TAX

    • # 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(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    9 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
    ALL=Total Gross
    CBT=Canadian Bonus Tax
    CIT=Canadian Income Tax (T4)
    CPA=Pension Adjustment
    CPP=Canada Pension Plan Employee
    CPR=Canada Pension Plan Employer
    EIE=Employment Insurance Employee
    EIR=Employment Insurance Employer
    HTX=Provincial Health Tax
    PYT=Payroll Tax
    QBT=Quebec Bonus Tax
    QCD=Quebec Tax Deduction
    QIE=Quebec Parental Plan Employee
    QIR=Quebec Parental Plan Employer
    QIT=Quebec Income Tax (RL-1)
    QPP=Quebec Pension Plan Employee
    QPR=Quebec Pension Plan Employer
    RV2=Quebec Income Tax (RL-2)
    T4A=Canadian Income Tax (T4A)
    TRV=True RL
    TT4=True T4
    10 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

    Prompt Table: ACCT_FY_VW

    11 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period

    Prompt Table: ACCT_PERIOD_VW

    12 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_CA_VW

    13 BUDGET_DATA Character(50) VARCHAR2(50) NOT NULL Budget Data
    14 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_VW

    15 EARNS_END_DT Date(10) DATE Earnings End Date
    16 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax
    17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: BUD_DEPT_EFF_VW
    Set Control Field: BUSINESS_UNIT

    18 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
    19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    20 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    21 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    23 REVERSED Character(1) VARCHAR2(1) NOT NULL Reversed

    Y/N Table Edit

    Default Value: N

    24 HP_RETDIST_SEQ_NO Number(5,0) INTEGER NOT NULL Retro Distrubution process sequence number

    Default Value: 0

    25 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

    26 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

    27 HP_RDIST_GL_INFACE Character(1) VARCHAR2(1) NOT NULL Retroactive Distribution run for GL Interface

    Default Value: N

    28 HP_RETDIST_PAY_DT Date(10) DATE Retro Dist Pay End Date
    29 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
    30 HP_DISTRIB_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Actuals Distribution overriden at the Actuals Distribution Panel

    Y/N Table Edit

    Default Value: N