FO_DEPTID_VW

(SQL View)
 Index Back

Department View


SELECT SCRT.ROWSECCLASS , DEPT.SETID , DEPT.DEPTID , DEPT.EFFDT , DEPT.EFF_STATUS , DEPT.DESCR , DEPT.DESCRSHORT , DEPT.MANAGER_NAME , DEPT.ACCOUNTING_OWNER FROM PS_DEPT_TBL DEPT ,PS_SCRTY_TBL_DEPT SCRT ,PSTREEDEFN TD ,PSTREENODE TN ,PSTREELEAF TL WHERE DEPT.SETID = SCRT.SETID AND SCRT.ACCESS_CD='Y' AND TD.SETID = SCRT.SETID AND TD.SETCNTRLVALUE = ' ' AND TD.TREE_NAME = 'DEP_SECURITY' AND TD.EFFDT = SCRT.TREE_EFFDT AND TD.EFF_STATUS = 'A' AND TN.SETID = TD.SETID AND TN.SETCNTRLVALUE = TD.SETCNTRLVALUE AND TN.TREE_NAME = TD.TREE_NAME AND TN.EFFDT = TD.EFFDT AND TL.SETID = TN.SETID AND TL.SETCNTRLVALUE = TN.SETCNTRLVALUE AND TL.TREE_NAME = TN.TREE_NAME AND TL.EFFDT = TN.EFFDT AND TN.TREE_NODE = SCRT.DEPTID AND DEPT.DEPTID BETWEEN TL.RANGE_FROM AND TL.RANGE_TO AND TL.TREE_NODE_NUM BETWEEN TN.TREE_NODE_NUM AND TN.TREE_NODE_NUM_END AND TN.TREE_NODE_NUM BETWEEN SCRT.TREE_NODE_NUM AND SCRT.TREE_NODE_NUM_END

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Identifies the name of the manager of a specified department.
9 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner