GPJP_SC_CHK_CUR(SQL Table) |
Index Back |
|---|---|
This Record stores Current monThis Record stores Current month data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  JOBINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | GPJP_CHG_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Status Change Reason Field.
01=New enrollment 02=Re-enrollment 03=Loss by Death 04=Loss by Age(PI) 05=Loss by Termination etc. 06=Occasional Revision 07=Regular Decision 08=Other 09=Excluded 10=New Enrollment after Loss 11=Rev. after Mat./Preg. Leave 11=Revision after Maternity Leave 12=Loss by Age (HI) 13=Loss By Disability 14=Loss by Soc Sec Agreement |
| 4 | GPJP_HEL_GRADE | Number(3,0) | SMALLINT NOT NULL | Health Insurance Grade. |
| 5 | GPJP_PEN_GRADE | Number(3,0) | SMALLINT NOT NULL | Pension Insurance Grade. |
| 6 | GPJP_HLTH_CARD_NUM | Number(8,0) | INTEGER NOT NULL | Health Insurance Card Number. |
| 7 | GPJP_EMPLHEL_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Health Insurance Premium |
| 8 | GPJP_COHEL_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Payer's Health Insurance Premium |
| 9 | GPJP_TOTAL_HELPREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Health Premium |
| 10 | GPJP_EMPNUR_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Nursing Care Premium |
| 11 | GPJP_CONUR_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Payer's Nursing Care Premium |
| 12 | GPJP_TOTAL_NURPREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Nursing Care Premium |
| 13 | GPJP_EMPPEN_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Pension Insurance Premium |
| 14 | GPJP_COPEN_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Payer's Pension Insurance Premium |
| 15 | GPJP_TOTAL_PENPREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Pension Premium |
| 16 | GPJP_PENS_FUND | Character(15) | VARCHAR2(15) NOT NULL | Pension Fund Number. |
| 17 | GPJP_EMP_PF_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Pension Fund Premium |
| 18 | GPJP_CO_PF_PREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Payer's Pension Fund Premium |
| 19 | GPJP_TOTAL_PFPREM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Pension Fund Premium |
| 20 | GPJP_TOTAL_HEL_NUR | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Health & Nurse Care |
| 21 | GPJP_TOTAL_PI_PF | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Pension and Pension Fund |
| 22 | GPJP_TOTAL_SI | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Social Insurance Amount |
| 23 | GPJP_TOTAL_2PEN | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total of Pension Insurance |
| 24 | GPJP_PENS_CODE | Number(8,0) | INTEGER NOT NULL | Pension Insurance Code. |
| 25 | GPJP_MTH_RMN_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Monthly Remuneration Amount. |
| 26 | PAYMENT_DT | Date(10) | DATE | Payment Date |