BUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
SAR_IDDefault Value: NEXT
SITE_TYPEPrompt Table: RE_SITE_TYPE_VW
RE_SAR_ADD(SQL View) |
Index Back |
|---|---|
SAR Add ViewSAR Add View |
| SELECT BUSINESS_UNIT ,SAR_ID ,SITE_TYPE FROM PS_RE_SAR_DETAIL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 2 | SAR_ID |
Character(15) | VARCHAR2(15) NOT NULL |
SAR ID
Default Value: NEXT |
| 3 | SITE_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Site Type
Prompt Table: RE_SITE_TYPE_VW |