RC_CI_VW

(SQL View)
Index Back

Component Interface View

Component 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