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

RIM_METADATA_VW

(SQL View)

Comp Attr View

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

SELECT BCNAME , RECNAME , FIELDNAME , 0 , 0 , ' ' , ' ' , 'N' , 0 , 'N' , 'Y' , CASE WHEN BCACCESS = 2 THEN 'Y' ELSE 'N' END , 'Y' , 'N' , 'Y' , 'Y' FROM PSBCITEM WHERE BCTYPE = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BCITEMPARENT Character(30) VARCHAR2(30) NOT NULL Parent Collection Name

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

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

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

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

7 RIM_DEFVALUE Character(18) VARCHAR2(18) NOT NULL This fiels stores the default value for a property on component interface used to save structure of Sales blackberry applications component interfaces.

8 RIM_PICKABLE 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.

9 RIM_POSITION Number(1,0) SMALLINT NOT NULL This field is used in RIM_CI_ATTR_VW. Value is set to 0, so Sendia can assign its own position.

10 RIM_SEARCHABLE Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is searchable, 'N' if not.

11 RIM_VISIBLE Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is visible, 'N' if not.

12 RIM_READONLY Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is readonly, 'N' if not.

13 RIM_NILLABLE Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Nillable (i.e. allow empty content), 'N' if not.

14 RIM_NULLABLE Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Nullable (i.e. allow NULL content), 'N' if not.

15 RIM_CREATEABLE Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Createable (i.e. user specify the value), 'N' if not (system sets the value).

16 RIM_READPICKLST Character(1) VARCHAR2(1) NOT NULL This field is used in RIM_CI_ATTR_VW. 'Y' if the field is visible, 'N' if not.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
2	BCITEMPARENT	Character(30)	VARCHAR2(30) NOT NULL	Parent Collection Name
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
5	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
6	FIELDLABEL	Character(60)	VARCHAR2(60) NOT NULL	Field Label
7	RIM_DEFVALUE	Character(18)	VARCHAR2(18) NOT NULL	This fiels stores the default value for a property on component interface used to save structure of Sales blackberry applications component interfaces.
8	RIM_PICKABLE	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.
9	RIM_POSITION	Number(1,0)	SMALLINT NOT NULL	This field is used in RIM_CI_ATTR_VW. Value is set to 0, so Sendia can assign its own position.
10	RIM_SEARCHABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is searchable, 'N' if not.
11	RIM_VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is visible, 'N' if not.
12	RIM_READONLY	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is readonly, 'N' if not.
13	RIM_NILLABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Nillable (i.e. allow empty content), 'N' if not.
14	RIM_NULLABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Nullable (i.e. allow NULL content), 'N' if not.
15	RIM_CREATEABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is Createable (i.e. user specify the value), 'N' if not (system sets the value).
16	RIM_READPICKLST	Character(1)	VARCHAR2(1) NOT NULL	This field is used in RIM_CI_ATTR_VW. 'Y' if the field is visible, 'N' if not.