GP_PKG_IDEMPLIDEMPL_RCDGPFR_LOAN_IDA=Salary Advance
L=Loan
CR=Created
ER=Error
PI=Awaiting
PR=Processed
RE=Removed
UP=Updated
GPFR_LOAN_NRAD(SQL Table) |
Index Back |
|---|---|
Loan definitionDefinitions of the loans |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GPFR_LOAN_ID |
Character(25) | VARCHAR2(25) NOT NULL | Identification of the loan |
| 5 | GPFR_LOAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of the loan
A=Salary Advance L=Loan |
| 6 | GPFR_BGN_DT | Date(10) | DATE | Begin Date |
| 7 | GPFR_INIT_AMOUNT | Number(15,2) | DECIMAL(14,2) NOT NULL | Initial amount of the loan |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | GPFR_PB_AMOUNT | Number(15,2) | DECIMAL(14,2) NOT NULL | Payback amount for the loan |
| 10 | GPFR_PB_PERIOD | Number(3,0) | SMALLINT NOT NULL | Number of payback periods for the loan |
| 11 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 12 | GPFR_INSTANCE | Number(1,0) | SMALLINT NOT NULL | Number of the deduction to be used (from the setup), for loan and garnishment |
| 13 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 14 | GPFR_SKIP | Character(1) | VARCHAR2(1) NOT NULL | Skip the row in the loan schedule |
| 15 | GPFR_PI_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status of the positive inputs (created, processed, ...)
CR=Created ER=Error PI=Awaiting PR=Processed RE=Removed UP=Updated |