GPUS_PRENOT_TMP

(SQL Table)
Index Back

Prenote GPUS Process TMP

GPUS_PRENOTE AE TMP record

# 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 RECIPIENT_NAME Character(30) VARCHAR2(30) NOT NULL Recipient Name
13 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
14 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
15 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
16 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
17 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
18 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
19 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
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 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
24 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
25 DEBIT_DT Date(10) DATE Debit Date
26 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.
27 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
28 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
29 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
30 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
31 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number
32 PYMT_DT Date(10) DATE Payment Date
33 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.
34 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.
35 GPUS_PRENOTE_DATE Date(10) DATE Prenotification Date
36 GPUS_PRENOTE_STAT Character(2) VARCHAR2(2) NOT NULL Prenotification Status
01=Completed
02=Not Submitted
03=Rejected
04=Submitted
37 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
38 PRENOTE_WAIT_DAYS Number(3,0) SMALLINT NOT NULL Prenote Wait Days (U.S.)