BO_IDREL_TYPE_IDPrompt Table: BO_REL_TYPE
BO_ID_1ROLE_TYPE_ID_1BO_ID_2Prompt Table: BO
ROLE_TYPE_ID_2Prompt Table: RB_VALID_ROLTYP
EFFDTDefault Value: %date
LANGUAGE_CDBO_REL_VW_LANG(SQL View) |
Index Back |
|---|---|
Bus Object Relationship RLRelated Language record An instance of a relationship between Business Objects |
| SELECT A.BO_ID , A.REL_TYPE_ID , A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.START_DT , B.LANGUAGE_CD , A.DESCR FROM PS_BO_REL_VW A , PS_BO_REL_TYPE_LNG B WHERE A.REL_TYPE_ID = B.REL_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Relationship Type ID
Prompt Table: BO_REL_TYPE |
| 3 | BO_ID_1 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 4 | ROLE_TYPE_ID_1 |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 5 | BO_ID_2 |
Signed Number(32,0) | DECIMAL(31) NOT NULL |
Business Object ID 2
Prompt Table: BO |
| 6 | ROLE_TYPE_ID_2 |
Number(12,0) | DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table: RB_VALID_ROLTYP |
| 7 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |