PAY_CTX_OVRD(SQL Table) |
Index Back |
---|---|
CAN Payroll Tax OverrideThis record contains one-time Canadian tax overrides for employee paycheck processing |
# | 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 | ADDL_NBR | Number(3,0) | SMALLINT NOT NULL | Additional Pay Line # |
8 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
9 | CTX_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Canadian Tax Type
A=Canadian Income Tax (T4A) B=Canadian Bonus Tax C=Canadian Income Tax (T4) E=Employee EI Premium H=Health Tax I=Quebec Income Tax J=Quebec Parental Insurance - EE K=Quebec Parental Insurance - ER N=Quebec Bonus Tax P=Canada Pension Plan Q=Quebec Pension Plan R=Employer EI Premium T=Payroll Tax V=Quebec Income Tax (RL-2) X=Take No CPP/QPP Exemption Y=Canadian Pension Plan - ER Z=Quebec Pension Plan - ER |
10 | ONE_TIME_CD | Character(1) | VARCHAR2(1) NOT NULL |
PaySheet One-Time Code
A=Addition O=Override P=Arrears Payback R=Refund Default Value: O |
11 | TAX_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | One-Time Tax Amount |