ÿþUSE [ED]

GO

/****** Object:  View [dbo].[v_HR_Transaction_x_Foapal]    Script Date: 10/12/2006 16:11:58 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[v_HR_Transaction_x_Foapal]

WITH VIEW_METADATA

AS 



SELECT     HRTF.trans_foapal_id, HRTF.trans_id, HRTF.coa, HRTF.index_cd, HRTF.fund, HRTF.org, HRTF.acct, HRTF.program, HRTF.activity, HRTF.loc, 

                      HRTF.amount, HRTF.percentage, HRTF.created_date, HRTF.created_by, HRTF.modified_date, HRTF.modified_by, HRTF.[timestamp], 

                      HRGO.group_name, HRGO.org_cd, HRT.trans_id AS Expr1

FROM         HR_Transactions HRT INNER JOIN

                      HR_Group_x_Org HRGO ON HRT.submitter_org_cd = HRGO.org_cd INNER JOIN

                      HR_Transaction_x_Foapal HRTF ON HRT.trans_id = HRTF.trans_id

WHERE     (dbo.fn_GROUP_IsMember_bln(SYSTEM_USER, HRGO.group_name) = 'true') OR

                      (IS_MEMBER('UIUC\ED DBS HR ADMIN') = 1)



WITH CHECK OPTION