RBT_AREA_CODEREGION_IDPrompt Table:
RBT_REGION_VW
Set Control Field: DESCR
RBT_AREA_CD_VW(SQL View) |
Index Back |
|---|---|
View to get Area CodeThis view is created to get the Area Code while executing Configurable Search for page RO_LN_NUM_SRCH_SEC. |
| SELECT DISTINCT RBT_AREA_CODE , REGION_ID FROM PS_RBT_NUMBER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBT_AREA_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Telephone area code for use in number management |
| 2 | REGION_ID |
Character(15) | VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table:
RBT_REGION_VW
|