HP_CONTPAY_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	HP_CONTRACT_NUM	Number(7,0)	INTEGER NOT NULL	Contract Number
4	HP_CONTRACT_SEQ	Number(3,0)	SMALLINT NOT NULL	Contract Sequence
5	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: HP_CNTPAY_CALVW
6	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number. Default Value: 0
8	HP_WORKDAYS	Number(3,0)	SMALLINT NOT NULL	Stores actual work days for contract period Default Value: 0
9	HP_PROJECT_CRG	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Contract Regular Default Value: 0
10	HP_PROJECT_PNE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Paid not Earned Default Value: 0
11	HP_PROJECT_ENP	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Project Earned not Paid Default Value: 0
12	HP_ACTUAL_WRK	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual Worked Default Value: 0
13	HP_LOA_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Calculated equivalent amount for LOA period
14	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 Default Value: A