HPCNTPAY02_TXN (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_TXN

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PROCESS_SWITCH Character(1) VARCHAR2(1) NOT NULL for app engine fghr002b

5 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

6 PROCESSED Character(1) VARCHAR2(1) NOT NULL Processed?
I=In Process
N=Not Processed
Y=Processed

7 ERROR_CODE Character(1) VARCHAR2(1) NOT NULL Error Code
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No EFC Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists

8 EFFDT_OTH Date(10) DATE Other Effective Date

9 JOB_EFFDT Date(10) DATE Job Effective Date

10 NEW_EFFDT Date(10) DATE New Benefit Program Effdt

11 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

12 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
Default Value: A

13 FREQUENCY_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of a frequency ID.
A=Annual
B=Biweekly
C=Contract
D=Daily
F=Every Four Weeks
H=Hourly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly

14 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date

15 CONTRACT_END_DT Date(10) DATE Contract End Date

16 PAYMENT_BEGIN_DT Date(10) DATE Payment Begin Date

17 PAYMENT_END_DT Date(10) DATE Payment End Date

18 PAYMENT_TERM Character(1) VARCHAR2(1) NOT NULL Payment Term
A=Pay Over 12 Months
C=Pay Over Contract
L=Pay with Lump Sum
X=Pay over 'X' months

19 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

20 CNT_RENEWAL_COUNT Number(2,0) SMALLINT NOT NULL Public Sector Extension This field indicates the number of remaining renewals left for an employee's contract.
Default Value: 0

21 HP_CONTRACT_NUM Number(7,0) INTEGER NOT NULL Contract Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PROCESS_SWITCH	Character(1)	VARCHAR2(1) NOT NULL	for app engine fghr002b
5	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
6	PROCESSED	Character(1)	VARCHAR2(1) NOT NULL	Processed? I=In Process N=Not Processed Y=Processed
7	ERROR_CODE	Character(1)	VARCHAR2(1) NOT NULL	Error Code 1=1 - Student ID not Found 2=2 - Student not at Load Level 3=3 - Final Review Flag Set 4=4 - No EFC Calculation 5=5 - Invalid School Code 6=6 - Student Id already Exists
8	EFFDT_OTH	Date(10)	DATE	Other Effective Date
9	JOB_EFFDT	Date(10)	DATE	Job Effective Date
10	NEW_EFFDT	Date(10)	DATE	New Benefit Program Effdt
11	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
12	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A
13	FREQUENCY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates the type of a frequency ID. A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly
14	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
15	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
16	PAYMENT_BEGIN_DT	Date(10)	DATE	Payment Begin Date
17	PAYMENT_END_DT	Date(10)	DATE	Payment End Date
18	PAYMENT_TERM	Character(1)	VARCHAR2(1) NOT NULL	Payment Term A=Pay Over 12 Months C=Pay Over Contract L=Pay with Lump Sum X=Pay over 'X' months
19	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
20	CNT_RENEWAL_COUNT	Number(2,0)	SMALLINT NOT NULL	Public Sector Extension This field indicates the number of remaining renewals left for an employee's contract. Default Value: 0
21	HP_CONTRACT_NUM	Number(7,0)	INTEGER NOT NULL	Contract Number