GPNL_INS_PREMM(SQL Table) |
Index Back |
|---|---|
Insurance Premium Table NLDGPNL Insurance Premium Table NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPNL_INS_CD |
Character(6) | VARCHAR2(6) NOT NULL |
GPNL_INS_CD
Prompt Table: GPNL_INS_CD |
| 2 | GPNL_INS_NBR |
Character(3) | VARCHAR2(3) NOT NULL | Insurance Number |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | GPNL_INS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
GPNL_INS_TYPE
1=Social 2=Additional |
| 7 | GPNL_EE_PCT1 | Number(7,3) | DECIMAL(6,3) NOT NULL | Employee Percentage 1 |
| 8 | GPNL_EE_FRN1 | Number(9,2) | DECIMAL(8,2) NOT NULL | Employee Franchise 1 |
| 9 | GPNL_EE_MIN_1 | Number(9,2) | DECIMAL(8,2) NOT NULL | GPNL_EE_MIN_1 |
| 10 | GPNL_EE_MAX_1 | Number(9,2) | DECIMAL(8,2) NOT NULL | Employee Maximum by Frequency 1 |
| 11 | GPNL_EE_PCT2 | Number(7,3) | DECIMAL(6,3) NOT NULL | GPNL_EE_PCT2 |
| 12 | GPNL_EE_FRN2 | Number(9,2) | DECIMAL(8,2) NOT NULL | Employee Franchise 2 |
| 13 | GPNL_EE_MIN_2 | Number(9,2) | DECIMAL(8,2) NOT NULL | Employee Minimum by Frequency 2 |
| 14 | GPNL_EE_MAX_2 | Number(9,2) | DECIMAL(8,2) NOT NULL | Employee Maximum by Frequency 2 |
| 15 | GPNL_TTL_PCT1 | Number(7,3) | DECIMAL(6,3) NOT NULL | Total Percentage 1 |
| 16 | GPNL_TTL_FRN1 | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Franchise 1 |
| 17 | GPNL_TTL_MIN_1 | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Minimum by Day 1 |
| 18 | GPNL_TTL_MAX_1 | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Maximum by Day 1 |
| 19 | GPNL_TTL_PCT2 | Number(7,3) | DECIMAL(6,3) NOT NULL | Total Percentage 2 |
| 20 | GPNL_TTL_FRN2 | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Franchise 2 |
| 21 | GPNL_TTL_MIN_2 | Number(9,2) | DECIMAL(8,2) NOT NULL | GPNL_TTL_MIN_2 |
| 22 | GPNL_TTL_MAX_2 | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Maximum by Day 2 |
| 23 | GPNL_SOC_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
GPNL_SOZ_FREQ
1=Day 2=Payroll Period 3=Year Default Value: 1 |
| 24 | GPNL_INC_PCT_EE | Number(7,3) | DECIMAL(6,3) NOT NULL | GPNL_INC_PCT_EE |
| 25 | GPNL_INC_PCT_ER | Number(7,3) | DECIMAL(6,3) NOT NULL | Increase Percentage Employer Premium |
| 26 | GPNL_FTE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
FTE Calculation Method
1=Social Security Days Based 2=Worked Days Based 3=Payment Percentage Based Default Value: 1 |
| 27 | GPNL_MIN_AGE | Number(3,0) | SMALLINT NOT NULL |
Insurance Minimum Age
Default Value: 1 |
| 28 | GPNL_MAX_AGE | Number(3,0) | SMALLINT NOT NULL |
Insurance Maximum Age
Default Value: 999 |
| 29 | GPNL_DTRMNTN_DT | Character(1) | VARCHAR2(1) NOT NULL |
Employee Determination Date
0=First Day Payroll Period 1=Last Date Payroll Period Default Value: 0 |
| 30 | GPNL_PENS_AGE | Character(1) | VARCHAR2(1) NOT NULL |
Indication whether the AOW Age (Old Age Allowance) should be applied.
Y/N Table Edit Default Value: N |