GPMY_NRP_LN_VW

(SQL View)
 Index Back

GPMY_NRP_LN_VW

GPMY_NRP_LN_VW

SELECT A.EMPLID ,A.EMPL_RCD ,A.GPMY_LN_CD ,A.GPMY_SEQ_NUM ,A.EFFDT ,A.END_DT ,A.GPMY_LN_TOT_AMT ,A.CURRENCY_CD ,A.GPMY_PERCENTAGE ,A.GPMY_LN_INST_AMT ,A.CURRENCY_CD1 ,A.GPMY_LN_INST_NBR ,A.GPMY_LN_RCV_TER ,A.PIN_NUM +50000000 ,A.FREQUENCY_ID ,A.COMMENTS FROM PS_GPMY_LN_PYE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 GPMY_LN_CD Character(18) VARCHAR2(18) NOT NULL Loan Code
4 GPMY_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

5 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

6 END_DT Date(10) DATE NOT NULL end date
7 GPMY_LN_TOT_AMT Number(13,2) DECIMAL(12,2) NOT NULL Loan Total Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

9 GPMY_PERCENTAGE Number(6,2) DECIMAL(5,2) NOT NULL Percentage
10 GPMY_LN_INST_AMT Number(13,2) DECIMAL(12,2) NOT NULL Installment Amount
11 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

12 GPMY_LN_INST_NBR Number(3,0) SMALLINT NOT NULL Loan Installment Number
13 GPMY_LN_RCV_TER Character(1) VARCHAR2(1) NOT NULL Active Recovery on Termination

Y/N Table Edit

Default Value: Y

14 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: GPMY_LN_VW

15 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
16 COMMENTS Long Character CLOB Comment