R_CNTPAY05

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	HP_CONTRACT_NUM	Number(7,0)	INTEGER NOT NULL	Contract Number
8	HP_CONTRACT_SEQ	Number(3,0)	SMALLINT NOT NULL	Contract Sequence
9	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
10	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
11	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
12	HP_PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Payment Status A=Active C=Payroll in Progress J=Adjustment P=Payroll Confirmed S=Payroll Confirmed
13	HP_PROJECT_CRG	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Contract Regular
14	HP_PROJECT_PNE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Paid not Earned
15	HP_PROJECT_ENP	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Earned not Paid
16	HP_ACTUAL_CRG	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Contract Regular
17	HP_ACTUAL_ENP	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Earned not Paid
18	HP_ACTUAL_PNE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Paid not Earned
19	HP_PAID_LEAVE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Paid Leave
20	HP_UNPAID_LEAVE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Unpaid Leave