GPFR_LOAN_NRVW

(SQL View)
 Index Back

Loan definition NPR View

Definitions of the loans

SELECT EMPLID , EMPL_RCD , GPFR_LOAN_ID , GPFR_LOAN_TYPE , GPFR_BGN_DT , GPFR_INIT_AMOUNT , CURRENCY_CD , GPFR_PB_AMOUNT , GPFR_PB_PERIOD , GP_PAYGROUP , GPFR_INSTANCE , PIN_NUM + 50000000 , GPFR_SKIP , GPFR_PI_STATUS FROM PS_GPFR_LOAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GPFR_LOAN_ID Character(25) VARCHAR2(25) NOT NULL Identification of the loan
4 GPFR_LOAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of the loan
A=Salary Advance
L=Loan

Default Value: L

5 GPFR_BGN_DT Date(10) DATE NOT NULL Begin Date
6 GPFR_INIT_AMOUNT Number(15,2) DECIMAL(14,2) NOT NULL Initial amount of the loan
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

8 GPFR_PB_AMOUNT Number(15,2) DECIMAL(14,2) NOT NULL Payback amount for the loan
9 GPFR_PB_PERIOD Number(3,0) SMALLINT NOT NULL Number of payback periods for the loan
10 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

11 GPFR_INSTANCE Number(1,0) SMALLINT NOT NULL Number of the deduction to be used (from the setup), for loan and garnishment
12 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
13 GPFR_SKIP Character(1) VARCHAR2(1) NOT NULL Skip the row in the loan schedule

Y/N Table Edit

Default Value: N

14 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