PY_CAN_CALC_AMT (SQL Table)	Index Back
Calulated paroll interim value This record contains interim calculation amounts for canadian pay cheques. The value containd on the record is the value for the net claim amount that is used in the cheque calculation.

PY_CAN_CALC_AMT

(SQL Table)

Calulated paroll interim value

This record contains interim calculation amounts for canadian pay cheques. The value containd on the record is the value for the net claim amount that is used in the cheque calculation.

Parent record: PAY_CHECK

# 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 CIT_NET_CLAIM_AMT Number(10,2) DECIMAL(9,2) NOT NULL CIT Net Claim Amount

#	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	CIT_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Net Claim Amount