GPNL_NRP_PAYMVW (SQL View)	Index Back
Payment Processing Results NLD Results table for Payment Process dedicated to the creation of the EFT File

GPNL_NRP_PAYMVW

(SQL View)

Payment Processing Results NLD

Results table for Payment Process dedicated to the creation of the EFT File

SELECT CAL_RUN_ID ,EMPLID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,INSTANCE ,RECIPIENT_TAG ,RECIPIENT_ID ,PIN_NUM + 50000000 ,RSLT_SEG_NUM ,ORIG_CAL_RUN_ID ,RUN_TYPE ,PAY_ENTITY ,SRC_BANK_ID ,SEG_END_DT ,COMPANY ,PYMT_KEY1 ,PYMT_KEY2 ,PYMT_KEY3 ,PMT_TYPE ,GP_PMT_AMT ,CURRENCY_CD ,PAYMENT_MTHD ,DEBIT_DT ,REVERSAL_IND ,PMT_STATUS ,GPNL_BANK_CD ,GPNL_BRANCH_EC_CD ,GPNL_ACCOUNT_EC_ID ,BANK_CD ,BRANCH_EC_CD ,ACCOUNT_EC_ID ,BANK_TRANSFER_ID ,NAME ,GPNL_BANK_NAME ,GPNL_BANK_TOT_AMT ,ACCOUNT_TYPE_PYE ,ACCOUNT_ID FROM PS_GPNL_PAYMENT

# 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 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

7 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI

8 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

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

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

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

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

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

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

16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

17 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

18 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

19 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

20 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction

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

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

23 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

24 DEBIT_DT Date(10) DATE Debit Date

25 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.

26 PMT_STATUS Character(1) VARCHAR2(1) NOT NULL Status field for a generated payment transaction
F=Finalized
M=Manually Paid
N=No Active Allocations
P=Prepared
T=Payment Transferred
V=Hold
W=Void

27 GPNL_BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank Code

28 GPNL_BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Branch Id

29 GPNL_ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account number

30 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
Prompt Table: BANK_EC_TBL

31 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
Prompt Table: BANK_BRANCH_TBL

32 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.

33 BANK_TRANSFER_ID Character(15) VARCHAR2(15) NOT NULL Bank Transfer ID

34 NAME Character(50) VARCHAR2(50) NOT NULL Name

35 GPNL_BANK_NAME Character(40) VARCHAR2(40) NOT NULL Bank Name

36 GPNL_BANK_TOT_AMT Number(14,2) DECIMAL(13,2) NOT NULL Banking Total Amount

37 ACCOUNT_TYPE_PYE Character(1) VARCHAR2(1) NOT NULL Payee Bank Account Type
A=Current Account
B=Building Society Roll Number
C=Checking
G=Giro Account
R=Regular
S=Savings
T=Salary Account

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

#	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	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
7	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
8	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
9	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
11	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
12	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
13	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
14	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
15	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
16	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
17	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
18	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
19	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
20	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
21	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	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
24	DEBIT_DT	Date(10)	DATE	Debit Date
25	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.
26	PMT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status field for a generated payment transaction F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void
27	GPNL_BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank Code
28	GPNL_BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Branch Id
29	GPNL_ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account number
30	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
31	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: BANK_BRANCH_TBL
32	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
33	BANK_TRANSFER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bank Transfer ID
34	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
35	GPNL_BANK_NAME	Character(40)	VARCHAR2(40) NOT NULL	Bank Name
36	GPNL_BANK_TOT_AMT	Number(14,2)	DECIMAL(13,2) NOT NULL	Banking Total Amount
37	ACCOUNT_TYPE_PYE	Character(1)	VARCHAR2(1) NOT NULL	Payee Bank Account Type A=Current Account B=Building Society Roll Number C=Checking G=Giro Account R=Regular S=Savings T=Salary Account
38	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID