PYKB_CN_TERN_VW (SQL View)	Index Back
Payroll INS CN Total Earns Payroll Insights Canada Total Earnings & Other Earnings Merge View

PYKB_CN_TERN_VW

(SQL View)

Payroll INS CN Total Earns

Payroll Insights Canada Total Earnings & Other Earnings Merge View

SELECT COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , PY_CAT_TYPE , PY_CAT_ID , CHECK_DT , BUSINESS_UNIT , DEPTID , EMPLID , EMPL_RCD , EMPL_TYPE , LOCATION , PY_CAT_TYPE_DESCR , PY_CAT_ID_DESCR , PY_TOT_CAT FROM PS_PYKB_CN_ERN_VW UNION ALL SELECT COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , PY_CAT_TYPE , PY_CAT_ID , CHECK_DT , BUSINESS_UNIT , DEPTID , EMPLID , EMPL_RCD , EMPL_TYPE , LOCATION , PY_CAT_TYPE_DESCR , PY_CAT_ID_DESCR , PY_TOT_CAT FROM PS_PYKB_CN_OT_VW UNION ALL SELECT COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , PY_CAT_TYPE , PY_CAT_ID , CHECK_DT , BUSINESS_UNIT , DEPTID , EMPLID , EMPL_RCD , EMPL_TYPE , LOCATION , PY_CAT_TYPE_DESCR , PY_CAT_ID_DESCR , PY_TOT_CAT FROM PS_PYKB_CN_OTH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

3 PAY_END_DT Date(10) DATE Pay Period End Date

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

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 PY_CAT_TYPE Character(1) VARCHAR2(1) NOT NULL Category Type
D=Deductions
E=Earnings
O=Other Earnings
T=Taxes
V=Overtime

9 PY_CAT_ID Character(6) VARCHAR2(6) NOT NULL Category ID

10 CHECK_DT Date(10) DATE Check date.

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

15 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried

16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

17 PY_CAT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Category Type Description

18 PY_CAT_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Category ID Description

19 PY_TOT_CAT Signed Number(19,2) DECIMAL(17,2) NOT NULL Total by Category

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
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	PY_CAT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Category Type D=Deductions E=Earnings O=Other Earnings T=Taxes V=Overtime
9	PY_CAT_ID	Character(6)	VARCHAR2(6) NOT NULL	Category ID
10	CHECK_DT	Date(10)	DATE	Check date.
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
15	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
16	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
17	PY_CAT_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category Type Description
18	PY_CAT_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category ID Description
19	PY_TOT_CAT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Total by Category