REGION_IDCTRY=Country
PHON=Phone
POST=Postal Code
PWLN=Postal Code-Wireline
PWLS=Postal Code-Wireless
REGN=Region
SRVC=Service Area
STAT=State
RB_PRC_REGN_VW(SQL View) |
Index Back |
|---|---|
RegionThis record is a view which gives the inforamtion of region |
| SELECT a.REGION_ID , a.REGION_TYPE , a.DESCR FROM PS_RB_REGION a WHERE a.STATUS = 'A' AND a.REGION_CATEGORY = 'GEOG' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REGION_ID |
Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 2 | REGION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Region Type. e.g., Country, Postal Code, Service Area, State, etc.
CTRY=Country PHON=Phone POST=Postal Code PWLN=Postal Code-Wireline PWLS=Postal Code-Wireless REGN=Region SRVC=Service Area STAT=State |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |