ROLE_TYPE_IDPrompt Table: BO_ROLE_TYPE
FLDDFN_IDRBQ_RLFLDDFN_VW(SQL View) |
Index Back |
|---|---|
Role Field ViewPrompt record for Field definition role view. |
| SELECT R.ROLE_TYPE_ID , R.FLDDFN_ID , F.DESCR FROM %Table(RBQ_FLDDFN) F , %Table(RBQ_FLDDFN_RL) R WHERE F.FLDDFN_ID = R.FLDDFN_ID AND (F.FIELDNAME_NAME = ' ' OR F.FIELDNAME_ABE = ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table: BO_ROLE_TYPE |
| 2 | FLDDFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | BO Search Role ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |