GPMX_NRP_PYM_VW

(SQL View)
 Index Back

Banking Process

The purpose of this record is to record values we need in the Banking Process to build our output Flat File.

SELECT CAL_RUN_ID , EMPLID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PIN_NUM + 50000000 , INSTANCE , RECIPIENT_TAG , RECIPIENT_ID , SRC_BANK_ID , CURRENCY_CD , PAY_ENTITY , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , PMT_TYPE , GP_PMT_AMT , PAYMENT_MTHD , DEBIT_DT , REVERSAL_IND , PMT_STATUS , CAL_PRD_ID , PYMT_ID , PYMT_NBR , GPMX_BANK_CD , GPMX_BRANCH_EC_CD , GPMX_ACCOUNT_EC_ID , BANK_CD , BRANCH_EC_CD , ACCOUNT_EC_ID , ACCOUNT_TYPE_PYE , BANK_TRANSFER_ID , NAME , GPMX_BANK_NAME , GPMX_BANK_PAY_DT , GPMX_BANK_TOT_AMT FROM PS_GPMX_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 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
11 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
12 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
15 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
16 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
17 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
18 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
19 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
20 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table
21 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
22 DEBIT_DT Date(10) DATE Debit Date
23 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.
24 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
25 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
26 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
27 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number
28 GPMX_BANK_CD Character(11) VARCHAR2(11) NOT NULL Global Payroll Mexico : Bank Code
29 GPMX_BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
30 GPMX_ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account #
31 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

Prompt Table: BANK_EC_TBL

32 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

Prompt Table: BANK_BRANCH_TBL

33 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
34 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
35 BANK_TRANSFER_ID Character(15) VARCHAR2(15) NOT NULL Bank Transfer ID
36 NAME Character(50) VARCHAR2(50) NOT NULL Name
37 GPMX_BANK_NAME Character(24) VARCHAR2(24) NOT NULL Bank Name
38 GPMX_BANK_PAY_DT Character(5) VARCHAR2(5) NOT NULL Payment Date After Formatting
39 GPMX_BANK_TOT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Total Amount to Pay