GPUS_NRP_LN2_VW

(SQL View)
Index Back

Loan Schedule Setup

GPUS Loan Schedule Setup

SELECT EMPLID , EMPL_RCD , PIN_NUM + 50000000 , GPUS_LOAN_ID , EFFDT , INSTANCE , PRC_ORDER , GPUS_ENDDT , GPUS_LOAN_AMT , CURRENCY_CD , FREQUENCY_OPTN , FREQUENCY_ID , GCTL_CND_OPTN , PIN_GCTL_NUM + 50000000 , ARR_PYBK_AMT_OPTN , ENTRY_TYPE_ARR_AMT , PIN_ARR_AMT_NUM + 50000000 , ARR_PYBK_AMT FROM PS_GPUS_LOAN_SCHED

# 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 Record
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: GPUS_LOAN_SRCH

4 GPUS_LOAN_ID Character(18) VARCHAR2(18) NOT NULL Loan ID
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
7 PRC_ORDER Number(3,0) SMALLINT NOT NULL Process Order
8 GPUS_ENDDT Date(10) DATE GPUS_ENDDT
9 GPUS_LOAN_AMT Number(19,6) DECIMAL(18,6) NOT NULL Loan Amount
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

11 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
CP=Use Calendar Period Frequency
ED=Use Element Frequency
SP=Use Specified Frequency

Default Value: ED

12 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.

Prompt Table: FREQUENCY_TBL

13 GCTL_CND_OPTN Character(1) VARCHAR2(1) NOT NULL Generation Control Options
E=Use Element Generation Control
N=No Generation Control
S=Specified Generation Control

Default Value: E

14 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number

Prompt Table: GP_PIN_GC0_VW

15 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
A=Use Specified Amount
E=Use Element Payback Amount
N=No Limit

Default Value: E

16 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount

Prompt Table: GP_ENT_APYBK_VW

17 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number

Prompt Table: %GP_EDIT_FLD6

18 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount