CREATE VIEW syssegments (segment, name, status) AS
SELECT  0, 'system'     , 0  UNION
SELECT 1, 'default'    , 1  UNION
SELECT 2, 'logsegment' , 0
/****** Object:  View dbo.PSNV_PSN_ORG    Script Date: 2008/1/15 下午 05:19:09 ******/
create view PSNV_PSN_ORG as
SELECT a.AWARD_FAR, a.AWARD_FLAG, a.AWARD_MAR, a.AWAY_FLAG, b.DEPTNAME, b.DEPTNO, a.DIVCODE, a.Email, a.OfficerID as IOFFICER, b.KORG, a.OfficerName as NNAME, b.SUBJNAME, b.SUBJNO, b.UDSCODE, b.UNITNAME, b.UNITNO
FROM officers a, psnv_org b
where a.OrgID=b.UDSCODE