AV_SBSDY_FLG_VW (SQL View)	Index Back
Org Subsidiary View Use AV_SBSDY_FLG_VW to determine if any subsidiary relationships exist for the org in context.

AV_SBSDY_FLG_VW

(SQL View)

Org Subsidiary View

Use AV_SBSDY_FLG_VW to determine if any subsidiary relationships exist for the org in context.

SELECT DISTINCT A.EXT_ORG_ID, 'Y' FROM PS_AV_RELATE_E A WHERE ORG_RELATE_RCP='SS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

2 ORG_SBSDY Character(1) VARCHAR2(1) NOT NULL Subsidiaries
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
2	ORG_SBSDY	Character(1)	VARCHAR2(1) NOT NULL	Subsidiaries Y/N Table Edit