HPCNTPAY02_HDR (SQL Table)	Index Back
Contract Pay Renewal Txn AE work table for E&G contract pay renewal process, use by reporting program CNTPAY02.SQR.

HPCNTPAY02_HDR

(SQL Table)

Contract Pay Renewal Txn

AE work table for E&G contract pay renewal process, use by reporting program CNTPAY02.SQR.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

3 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date

4 CONTRACT_END_DT Date(10) DATE Contract End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
3	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
4	CONTRACT_END_DT	Date(10)	DATE	Contract End Date