ORG_RELATIONBR=Branch
CF=Corporate Foundation
PC=Parent Company
SS=Subsidiary
Prompt Table: AV_ORG_REL_HD
ORG_RELATE_RCPPrompt Table: AV_XL_O_REL_VW
AV_O_REL_RCP_VW(SQL View) |
Index Back |
|---|---|
Reciprocal RelationshipUse AV_O_REL_RCP_VW to display all reciprocal relationships for a selected relationship. |
| SELECT A.ORG_RELATION , A.ORG_RELATE_RCP , B.XLATLONGNAME FROM PS_AV_ORG_REL_RCP A , PSXLATITEM B WHERE A.ORG_RELATE_RCP=B.FIELDVALUE AND B.FIELDNAME='ORG_RELATION' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORG_RELATION |
Character(2) | VARCHAR2(2) NOT NULL |
Relationship
BR=Branch CF=Corporate Foundation PC=Parent Company SS=Subsidiary Prompt Table: AV_ORG_REL_HD |
| 2 | ORG_RELATE_RCP |
Character(2) | VARCHAR2(2) NOT NULL |
Reciprocal Relation
Prompt Table: AV_XL_O_REL_VW |
| 3 | RELATIONSHIP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Relationship Name |