REGION_IDCTRY=Country
PHON=Phone
POST=Postal Code
PWLN=Postal Code-Wireline
PWLS=Postal Code-Wireless
REGN=Region
SRVC=Service Area
STAT=State
A=Active
I=Inactive
RBF_CUST_REG_VW(SQL View) |
Index Back |
|---|
| SELECT REGION_ID , REGION_TYPE , STATUS FROM PS_RB_REGION WHERE STATUS = 'A' AND REGION_CATEGORY = 'PROD' AND REGION_TYPE = 'POST' |
| # | 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 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |