ORG_RELATIONBR=Branch
CF=Corporate Foundation
PC=Parent Company
SS=Subsidiary
AV_O_RCP_REL_VW(SQL View) |
Index Back |
|---|---|
Default Reciprocal relationshiDefault Reciprocal relationship |
| SELECT ORG_RELATION, ORG_RELATE_RCP FROM PS_AV_ORG_REL_RCP WHERE DFLT_FLG='Y' |
| # | 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 |
| 2 | ORG_RELATE_RCP | Character(2) | VARCHAR2(2) NOT NULL | Reciprocal Relation |