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 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
3 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table: PSBCDEFN |