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
Y/N Table Edit
AV_O_REL_RC_VW2(SQL View) |
Index Back |
|---|---|
Reciprocal relationshipView of AV_ORG_REL_RCP. Used for reciprocal updates. |
| SELECT ORG_RELATION, ORG_RELATE_RCP, DFLT_FLG FROM PS_AV_ORG_REL_RCP |
| # | 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 | DFLT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit |