| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 7 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 8 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 9 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 10 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 11 |
INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Instance Number
|
| 12 |
RECIPIENT_TAG |
Number(3,0) |
SMALLINT NOT NULL |
Used to identify recipients for E/D, PI
|
| 13 |
ACCOUNT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Account ID
|
| 14 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 15 |
GPMX_NID_RFC |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID: RFC
|
| 16 |
GPMX_CLABE |
Character(18) |
VARCHAR2(18) NOT NULL |
CLABE Inter-bank Payment Scheme
|
| 17 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 18 |
BANK_TRANSFER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Bank Transfer ID
|
| 19 |
BANK_ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 20 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 21 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 22 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 23 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 24 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 25 |
COMPANY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Company Descr
|
| 26 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 27 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 28 |
PAY_ENTITY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Pay Entity Description
|
| 29 |
BANK_ID_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank Identifier Code
|