AV_O_REL_HD_VW

(SQL View)
 Index Back

Relationship Table

RELATION_HD_TBL is the header table for RELATIN_RCP_TBL.

SELECT ORG_RELATION, RELATIONSHIP_LIMIT FROM PS_AV_ORG_REL_HD

# 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 RELATIONSHIP_LIMIT Character(1) VARCHAR2(1) NOT NULL Limit Relationship

Y/N Table Edit

Default Value: N