AR_WC_REGION_CD (SQL View)	Index Back
Region Code View

AR_WC_REGION_CD

(SQL View)

Region Code View

SELECT DISTINCT A.SETID , A.REGION_CD_TYPE , A.REGION_CD FROM PS_REGION_CD A WHERE %EffdtCheck(REGION_CD B, A, %currentdatein) AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 REGION_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Region Code Type
ACCT=Accounting
BO=Backorder/Reservation
CDOM=Contract Domain
CNTR=Contracts
FRT=Freight
MBR=Team Member
PRC=Pricing
RPT=Reporting
RS=Resource Management
SPRS=Procurement
SSRC=Alternate Sources Of Supply
TRPT=Transportation

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	REGION_CD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Region Code Type ACCT=Accounting BO=Backorder/Reservation CDOM=Contract Domain CNTR=Contracts FRT=Freight MBR=Team Member PRC=Pricing RPT=Reporting RS=Resource Management SPRS=Procurement SSRC=Alternate Sources Of Supply TRPT=Transportation
3	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.