REL_VIEWSEQNOREL_TYPE_IDBO_REL_ADREL_V2(SQL View) |
Index Back |
|---|---|
Add Relationship Drop DownDrop down list of valid relationships used in Add Relationship page |
| SELECT A.REL_VIEW ,C.SEQNO ,C.REL_TYPE_ID ,D.DESCR ,A.PARENT_SEQNO ,B.LEVEL_NUM ,A.ROLE_TYPE_ID ,B.ROLE_TYPE_ID FROM PS_BO_REL_CFG2 A , PS_BO_REL_CFG2 B ,PS_BO_REL_CFG3 C ,PS_BO_REL_TYPE D WHERE A.REL_VIEW = B.REL_VIEW AND A.PARENT_SEQNO = B.SEQNO AND C.REL_VIEW=A.REL_VIEW AND C.SEQNO=A.SEQNO AND D.REL_TYPE_ID=C.REL_TYPE_ID AND D.PRIMARY_IND='N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_VIEW |
Character(25) | VARCHAR2(25) NOT NULL | Relationship View Name................................... |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PARENT_SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 7 | ROLE_TYPE_ID_1 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 8 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |