RC_CI_VW(SQL View) |
Index Back |
---|---|
Component Interface ViewComponent Interface View. Component Interface View |
SELECT DISTINCT %Substring(B.BCPGNAME, 1, 18) , B.MARKET , B.BCNAME FROM PSAUTHBUSCOMP A , PSBCDEFN B WHERE A.BCNAME = B.BCNAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
3 | Character(30) | VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table: PSBCDEFN |