GPDE_SI_STAT_RT(SQL Table) |
Index Back |
---|---|
SI Rate CodeSI Rate Code per branch and contribution group |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPDE_SI_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
SI Coverage Type
01=Health Insurance 02=Nursing Care Insurance 03=Old Age Pension Insurance 04=Unemployment Insurance |
2 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
3 | GPDE_SI_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Contribution Group |
4 | GPDE_SI_RATE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Calculation Rate
Prompt Table: GPDE_SI_RATE_CD |
5 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Set As Default
N=No Y=Yes Y/N Table Edit Default Value: N |