RIM_CI_ATTR_VW (SQL View)	Index Back
Comp Attr View This view retrieves label, type, length, xlat for field attributes in a CI.

RIM_CI_ATTR_VW

(SQL View)

Comp Attr View

This view retrieves label, type, length, xlat for field attributes in a CI.

SELECT D.BCNAME , A.FIELDNAME ,D.RECNAME ,C.LONGNAME , A.FIELDTYPE , A.LENGTH , 'N' FROM PSDBFIELD A , PSRECFIELD B , PSDBFLDLABL C , PSBCITEM D WHERE D.BCTYPE=4 AND ((B.LABEL_ID <> ' ' AND B.LABEL_ID = C.LABEL_ID) OR (B.LABEL_ID=' ' AND C.DEFAULT_LABEL=1)) AND B.FIELDNAME=C.FIELDNAME AND A.FIELDNAME=B.FIELDNAME AND A.FIELDNAME = D.BCITEMNAME AND B.RECNAME = D.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label

5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

6 LENGTH Number(5,0) INTEGER NOT NULL Length

7 RIM_XLAT Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if translate value exsits, 'N' if translate value not exits.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDLABEL	Character(60)	VARCHAR2(60) NOT NULL	Field Label
5	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
6	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
7	RIM_XLAT	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if translate value exsits, 'N' if translate value not exits.