REGION_CD_DST (SQL View)	Index Back
Contract Domains of Dst Cnt PO002 Contract Domain for Contract Control Type. Prompt table for contract domain on manufacturer contract markup detail page.

REGION_CD_DST

(SQL View)

Contract Domains of Dst Cnt

PO002 Contract Domain for Contract Control Type. Prompt table for contract domain on manufacturer contract markup detail page.

SELECT C.SETID , C.CNTRCT_ID , A.SETID , A.REGION_CD , A.DESCR FROM PS_REGION_CD A , PS_CNT_CTRL_TYPE C WHERE A.REGION_CD_TYPE = 'CDOM' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_REGION_CD B WHERE A.SETID = B.SETID AND A.REGION_CD_TYPE = B.REGION_CD_TYPE AND A.REGION_CD = B.REGION_CD AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) AND C.CONTROL_TYPE = 'CDOM' AND A.SETID = C.CTRL_SETID AND A.REGION_CD = C.REGION_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To

3 REGION_SETID Character(5) VARCHAR2(5) NOT NULL REGION_SETID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

4 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.

5 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	CNTRCT_ID_DST	Character(25)	VARCHAR2(25) NOT NULL	Contract ID To
3	REGION_SETID	Character(5)	VARCHAR2(5) NOT NULL	REGION_SETID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	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.
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description