EODC_REC5_VW

(SQL View)
Index Back

NOT USED


SELECT DISTINCT C.MARKET , C.PNLGRPNAME , A.RECNAME , A.OCCURSLEVEL FROM PSPNLFIELD A , PSRECDEFN B , PSPNLGROUP C WHERE A.PNLNAME = C.PNLNAME AND A.RECNAME <> ' ' AND A.RECNAME = B.RECNAME AND A.ASSOCFIELDNUM = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level