GPGB_PMT_AET(SQL Table) |
Index Back |
---|---|
GP UK Payment Cache RecordGP 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 |