GP_NET_PAY1_TMP (SQL Table)	Index Back
Payment Net Pay generation tmp Work record used in the Payment Generation process

GP_NET_PAY1_TMP

(SQL Table)

Payment Net Pay generation tmp

Work record used in the Payment Generation process

Parent Record Of GP_NET_PAY1_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

8 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

9 PYMT_KEY1 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

10 PYMT_KEY2 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

11 PYMT_KEY3 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

12 PYMT_KEY4 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

14 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

15 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID

16 SEG_END_DT Date(10) DATE Payee Process Segment's End Date

17 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field

18 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table

19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

20 REVERSAL_IND Number(1,0) SMALLINT NOT NULL Reversal Indicator. Used in the GP BANKING process to identify transactions that are reversals. 0 means not reversal, 1 means reversal.

21 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

22 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer

23 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

24 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

25 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro

26 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification

27 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number

28 HIST_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL History Calendar Run Id. Identifies the Calendar Run (or Group) in which the calendar now being pointed to as a starting point for balances was originally processed in. Table containing these pointers also contains CAL RUN ID identifying the Calendar Run (or Group) that is using this pointer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
9	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
10	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
11	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
12	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
15	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
16	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
17	PIN_NET_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
18	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	REVERSAL_IND	Number(1,0)	SMALLINT NOT NULL	Reversal Indicator. Used in the GP BANKING process to identify transactions that are reversals. 0 means not reversal, 1 means reversal.
21	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
22	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
23	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
24	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
25	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
26	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
27	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
28	HIST_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	History Calendar Run Id. Identifies the Calendar Run (or Group) in which the calendar now being pointed to as a starting point for balances was originally processed in. Table containing these pointers also contains CAL RUN ID identifying the Calendar Run (or Group) that is using this pointer.