GPAU_NRP_EF1_AD(SQL Table) |
Index Back |
|---|---|
EFT CEMTEX debit transactionsThe table stores electronic fund transfer transaction data for the creation of CEMTEX format electronic file transfer. Specifically, this table is used to temporarily store debit transactions before they are inserted back into GPAU_EFT_CMX_TR. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPAU_EFT_USER_NO |
Character(6) | VARCHAR2(6) NOT NULL | EFT User Number used in the AE program GPAU_EFT_CMX. |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | SRC_BANK_ID |
Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 7 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | GPAU_EFT_TRANS_CD |
Character(2) | VARCHAR2(2) NOT NULL |
This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX.
13=Debit 50=Recipient Credit 53=Payroll Credit |
| 9 | GPAU_BANK_DB_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
This field distinguishes debit types and is used in the AE program GPAU_EFT_CMX.
10=Group Tax 20=Net Payment 30=Recipient |
| 10 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 11 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 12 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 13 | CAL_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Calendar Sequence Number |
| 14 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 15 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 16 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 17 | PMT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type
01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction |
| 18 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 19 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 20 | GPAU_EFT_PMT_AMT | Character(10) | VARCHAR2(10) NOT NULL | This field tracks the Payment Amount in a specific character formatted format for the AE program GPAU_EFT_CMX. |
| 21 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 22 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 23 | GPAU_LODGEMENT_REF | Character(50) | VARCHAR2(50) NOT NULL | This field is used in the AE program GPAU_EFT_CMX. |
| 24 | GPAU_TR_BRANCH_CD | Character(17) | VARCHAR2(17) NOT NULL | The Trace Branch Code supersedes any Branch Code tracked on the Source Bank Table. |
| 25 | GPAU_TR_ACCOUNT_CD | Character(35) | VARCHAR2(35) NOT NULL | The Trace Account Code supersedes any account code tracked on the Source Bank Table. |
| 26 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 27 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |