GPDE_SI_COV_CHK (SQL Table)	Index Back
Validation SI Coverage This record conatins all illegal SI Coverage combinations among the four SI types. If no value is entered for a certain SI Type, the combination of the other keys is illegal, no matter what the rest would look like.

GPDE_SI_COV_CHK

(SQL Table)

Validation SI Coverage

This record conatins all illegal SI Coverage combinations among the four SI types. If no value is entered for a certain SI Type, the combination of the other keys is illegal, no matter what the rest would look like.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_SI_COV_HLTH Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private

2 GPDE_SI_COV_NURS Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private

3 GPDE_SI_COV_PENS Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private

4 GPDE_SI_COV_UNEMP Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_SI_COV_HLTH	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private
2	GPDE_SI_COV_NURS	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private
3	GPDE_SI_COV_PENS	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private
4	GPDE_SI_COV_UNEMP	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private