RDM_REGION_VW (SQL View)	Index Back
Region This recird us ysed in company directory.

RDM_REGION_VW

(SQL View)

Region

This recird us ysed in company directory.

SELECT REGION_CATEGORY ,REGION_ID , STATUS , DESCR , PARENT_REGION_ID , SYNCID , SYNCDTTM FROM PS_RB_REGION WHERE REGION_CATEGORY = 'GEOG' AND STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REGION_CATEGORY Character(4) VARCHAR2(4) NOT NULL Region Category
GEOG=Geography
NMGT=Number Management
PROD=Product Sales
TERR=Territory Assignment

2 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

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

5 PARENT_REGION_ID Character(15) VARCHAR2(15) NOT NULL Unique identifier for Parent Region.
Prompt Table: RSF_REGION_VW

6 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

7 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REGION_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Region Category GEOG=Geography NMGT=Number Management PROD=Product Sales TERR=Territory Assignment
2	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	PARENT_REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	Unique identifier for Parent Region. Prompt Table: RSF_REGION_VW
6	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
7	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time