GPGB_PMT_AET

(SQL Table)
Index Back

GP UK Payment Cache Record

GP UK Payment Process Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
3 GPGB_DEST_SORTCODE Character(11) VARCHAR2(11) NOT NULL UK Destination Sorting Code for EFT
4 GPGB_DEST_ACCT_NBR Character(35) VARCHAR2(35) NOT NULL UK Destination Account Number for EFT
5 GPGB_DEST_ACCTNAME Character(50) VARCHAR2(50) NOT NULL UK Destination Account Name for EFT
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
8 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
9 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
10 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID (first for a range)
11 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To
12 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
13 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro
14 ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
15 RUN_CALC_IND Character(1) VARCHAR2(1) NOT NULL Calculate Payees

Y/N Table Edit

Default Value: N

16 RUN_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalize Entire Run

Y/N Table Edit

Default Value: N

17 UPDATE_STATS_IND Character(1) VARCHAR2(1) NOT NULL Update Statistics