GPDE_SI_STATLNG (SQL View)	Index Back
SI Coverage Status Table This table records, which combination of coverage types and SI status codes are valid for the various SI Types.

GPDE_SI_STATLNG

(SQL View)

SI Coverage Status Table

This table records, which combination of coverage types and SI status codes are valid for the various SI Types.

SELECT A.GPDE_SI_TYPE , A.GPDE_SI_COVERAGE , A.GPDE_SI_STATUS , A.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_GPDE_SI_STA_VW A , PS_GPDE_SI_STA_LNG B WHERE B.GPDE_SI_TYPE = A.GPDE_SI_TYPE AND B.GPDE_SI_STATUS = A.GPDE_SI_STATUS AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_GPDE_SI_STA_LNG B1 WHERE B1.GPDE_SI_TYPE = B.GPDE_SI_TYPE AND B1.GPDE_SI_STATUS = B.GPDE_SI_STATUS AND B1.EFFDT <= A.EFFDT )

Related Language Record for GPDE_SI_STA_VW

# 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 GPDE_SI_COVERAGE Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
0=None
1=Mandatory
2=Voluntary
3=Private

3 GPDE_SI_STATUS Character(1) VARCHAR2(1) NOT NULL Contribution Group

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	GPDE_SI_COVERAGE	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private
3	GPDE_SI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contribution Group
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description