GPUS_NRP_LN2_VW(SQL View) |
Index Back |
---|---|
Loan Schedule SetupGPUS 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 |