SSF_ADJ_CN_TAX

(SQL View)
 Index Back

SSF CAN Tax Balance Adjustment

Student Financials Product View of Payroll - North America record BAL_ADJ_CN_TAX. View is used by SF to interface with PNA adjustment data for Canadian Tax Balances.

SELECT EMPLID ,COMPANY ,BALANCE_ID ,BALANCE_YEAR ,WAGE_LOSS_PLAN ,PROVINCE ,TAX_CLASS_CAN ,BAL_ADJ_SEQ ,DT_ENTERED ,BALANCE_QTR ,BALANCE_PERIOD ,NLGRS_YTD ,NLGRS_QTD ,NLGRS_MTD ,NLGRS_YTD_ADJ ,NLGRS_QTD_ADJ ,NLGRS_MTD_ADJ ,NLGRS_ADJ ,TXGRS_YTD ,TXGRS_QTD ,TXGRS_MTD ,TXGRS_YTD_ADJ ,TXGRS_QTD_ADJ ,TXGRS_MTD_ADJ ,TXGRS_ADJ ,TAX_YTD ,TAX_QTD ,TAX_MTD ,TAX_YTD_ADJ ,TAX_QTD_ADJ ,TAX_MTD_ADJ ,TAX_ADJ ,ADJ_REASON FROM PS_BAL_ADJ_CN_TAX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HCR_PERSON_I

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: HCR_COMPANY_I

3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

Prompt Table: SSF_BAL_ID_TBL

4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

Prompt Table: SSF_BAL_ID_DEF

5 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

Prompt Table: SSF_WAGELS_PLN

6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
7 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
8 BAL_ADJ_SEQ Number(3,0) SMALLINT NOT NULL Balance Adjust Sequence Number
9 DT_ENTERED Date(10) DATE NOT NULL Date Entered
10 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

Prompt Table: SSF_BAL_ID_QTR

11 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

Prompt Table: SSF_BAL_ID_DEF

12 NLGRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross YTD
13 NLGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross QTD
14 NLGRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross MTD
15 NLGRS_YTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross YTD Adjusted
16 NLGRS_QTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross QTD Adjusted
17 NLGRS_MTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross MTD Adjusted
18 NLGRS_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross Adjustment
19 TXGRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross YTD
20 TXGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross QTD
21 TXGRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross MTD
22 TXGRS_YTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross YTD Adjusted
23 TXGRS_QTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross QTD Adjusted
24 TXGRS_MTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross MTD Adjusted
25 TXGRS_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross Adjustment
26 TAX_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax YTD
27 TAX_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax QTD
28 TAX_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax MTD
29 TAX_YTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax YTD Adjusted
30 TAX_QTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax QTD Adjusted
31 TAX_MTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax MTD Adjusted
32 TAX_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Adjustment
33 ADJ_REASON Character(50) VARCHAR2(50) NOT NULL Adjustment Reason