PY_IC_PI_NCL_MX (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_IC_PI_NCL_MX

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

2 USED_NET_CLAIM_AMT Number(10,2) DECIMAL(9,2) NOT NULL Net Claim Used

3 CAN_GB2 Character(1) VARCHAR2(1) NOT NULL Group Box - Canada

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CIT_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Net Claim Amount
2	USED_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Net Claim Used
3	CAN_GB2	Character(1)	VARCHAR2(1) NOT NULL	Group Box - Canada