INSTITUTION_SETBUSINESS_UNITPrompt Table: BUS_UNIT_TBL_SF
Prompt Table: PEOPLE_SRCH
Prompt Table: LOCATION_TBL
SSF_BUCONTCT_VW(SQL View) |
Index Back |
|---|---|
ISet Business Unit Detail |
| SELECT a.institution_set , a.business_unit , a.contact_id , a.emailid ,%subrec(phone_SBR, A) , a.extension , a.location FROM PS_ISET_BU_DTL a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION_SET |
Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_SF |
| 3 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: PEOPLE_SRCH |
| 4 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 5 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 7 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone number extension |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |