RE_EFF_REG_LG (SQL View)	Index Back
Region Codes Language View of effective dated Regions with SETID.

RE_EFF_REG_LG

(SQL View)

Region Codes

Language View of effective dated Regions with SETID.

SELECT DISTINCT A.SETID , A.REGION_CD , A.LANGUAGE_CD , A.DESCR FROM PS_REGION_CD_LNG A WHERE REGION_CD_TYPE = 'RPT' AND A.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_RE_REGION B_ED WHERE A.SETID = B_ED.SETID AND A.REGION_CD = B_ED.REGION_CD AND B_ED.EFFDT <= %CurrentDateIn)

Related Language Record for RE_EFF_REGION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description