BEN_COVRG_SRCH (SQL View)	Index Back
Coverage Code Defn for SES Covrg_Cd_Tbl is a record that defines the coverage codes used to define the coverage level of a health benefit. Each code is defined by the minimum and maximum dependents allowed and whether spousal coverage is allowed, not allowed or required.

BEN_COVRG_SRCH

(SQL View)

Coverage Code Defn for SES

Covrg_Cd_Tbl is a record that defines the coverage codes used to define the coverage level of a health benefit. Each code is defined by the minimum and maximum dependents allowed and whether spousal coverage is allowed, not allowed or required.

SELECT A.COVRG_CD , A.EFFDT , A.DESCR , A.CBR_COVRG_SET , A.EFF_STATUS , A.DESCRSHORT , A.COVRG_CD_CTL_FLG , A.MIN_NUM_COVERED , A.MAX_NUM_COVERED FROM PS_COVRG_CD_TBL A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_COVRG_CD_TBL A_ED WHERE A.COVRG_CD = A_ED.COVRG_CD AND A_ED.EFFDT <= %CurrentDateIn)

Related Language Record: COVRG_CD_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code

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

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

4 CBR_COVRG_SET Character(2) VARCHAR2(2) NOT NULL COBRA Coverage Set

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 COVRG_CD_CTL_FLG Character(1) VARCHAR2(1) NOT NULL Coverage Control Flag - Added field for ERISA compliance
Y/N Table Edit
Default Value: N

8 MIN_NUM_COVERED Number(1,0) SMALLINT NOT NULL Minimum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination

9 MAX_NUM_COVERED Number(2,0) SMALLINT NOT NULL Maximum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	CBR_COVRG_SET	Character(2)	VARCHAR2(2) NOT NULL	COBRA Coverage Set
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	COVRG_CD_CTL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Coverage Control Flag - Added field for ERISA compliance Y/N Table Edit Default Value: N
8	MIN_NUM_COVERED	Number(1,0)	SMALLINT NOT NULL	Minimum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination
9	MAX_NUM_COVERED	Number(2,0)	SMALLINT NOT NULL	Maximum Number Covered for COVRG_CD/COVERED_PERSON_TYP combination