ÿþUSE [ED]

GO

/****** Object:  View [dbo].[v_HR_Transactions]    Script Date: 11/17/2006 13:59:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[v_HR_Transactions]

WITH  VIEW_METADATA

AS

SELECT     trans_id, people_id, submit_to_univ_date, needs_delivery, delivered_to_univ_date, job_descriptor, trans_type, memo, internal_notes, cur_dept, 

                      cur_eclass, new_dept, new_eclass, cur_totalFTE, Cur_CheckDist, Chg_TotalFTE, Chg_CheckDist, Cur_Position, Cur_ChgDate, Cur_Title, Cur_FTE, 

                      Cur_Hourly, Cur_Monthly, Cur_Annual, Cur_Factor, Cur_TSOrg, Cur_EntryMthd, Cur_JobEndDt, cur_visatype, new_visatype, cur_visaexpire_date, 

                      new_visaexpire_date, cur_bdgt_profile, new_bdgt_profile, Chg_Title, Chg_EClass, Chg_FTE, Chg_Hourly, Chg_Monthly, Chg_Annual, Chg_Factor, 

                      Chg_TSOrg, Chg_EntryMthd, Chg_JobEndDt, Chg_Other1, Chg_Other2, New_Position, New_BeginDt, New_JobType, New_Title, New_PClass, New_FTE, 

                      New_Hourly, New_Monthly, New_Annual, New_Factor, New_TSOrg, New_EntryMthd, New_JobEndDt, FoapalChgDt, I9, ExtHelp, GrpChg, CV, OffLet, 

                      MastRef, ServExc, Sep, ChgFTE, FlexYr, Prov, SumExc, TmpUpG, AASum, online_app, newhire_forms, status, submitter_org_cd, submit_to_col_date, 

                      budget_profile, dept_head_approved, delete_requested, created_date, created_by, modified_date, modified_by, timestamp

FROM         dbo.HR_Transactions AS HRT

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

                      EXISTS

                          (SELECT     perm_id, group_name, org_cd, doc_file_path, Created_Date, Created_By, Modified_Date, Modified_By, timestamp

                            FROM          dbo.HR_Group_x_Org AS HRGO

                            WHERE      (HRT.submitter_org_cd = org_cd) AND (dbo.fn_GROUP_IsMember_bln(SYSTEM_USER, group_name) = 'true'))

WITH CHECK OPTION



GO