HCR_ETHNC_VW_LN (SQL View)	Index Back
Ethnic Group View Lang Rec This Language view selects a distinct list of all Ethnic Group Codes as defined for all Regional Areas. The list is used as a prompt for Search/Match person search.

HCR_ETHNC_VW_LN

(SQL View)

Ethnic Group View Lang Rec

This Language view selects a distinct list of all Ethnic Group Codes as defined for all Regional Areas. The list is used as a prompt for Search/Match person search.

SELECT DISTINCT A.ETHNIC_GRP_CD , A.LANGUAGE_CD , A.EFFDT , A.DESCR50 , A.DESCRSHORT FROM PS_HCR_ETH_GRP_LNI A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HCR_ETH_GRP_LNI A1 WHERE A1.SETID = A.SETID AND A1.ETHNIC_GRP_CD = A.ETHNIC_GRP_CD AND A1.LANGUAGE_CD = A.LANGUAGE_CD)

Related Language Record for HCR_ETHNC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

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

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

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description