GPES_PAYMENT_WK

(SQL Table)
Index Back

EFT Payment Work

Payment data with net distribution

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
10 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
11 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
12 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
13 RECIPIENT_NAME Character(30) VARCHAR2(30) NOT NULL Recipient Name
14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
15 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
16 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
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 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
21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
22 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
23 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
24 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
25 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
28 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
29 DEBIT_DT Date(10) DATE Debit Date
30 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.
31 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
32 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
33 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
34 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
35 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number
36 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
37 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
38 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
39 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
40 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
41 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
42 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
43 BANK_ID_CODE Character(11) VARCHAR2(11) NOT NULL Bank Identifier Code
44 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
45 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
46 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
47 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
48 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
49 CITY Character(30) VARCHAR2(30) NOT NULL City
50 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
51 STATE_DESCR1 Character(30) VARCHAR2(30) NOT NULL State Description
52 COMPANY Character(3) VARCHAR2(3) NOT NULL Company