FO_DEPT_TBL_VW2

(SQL View)
 Index Back

Departments

Uses SETID_DEPT instead of SETID as first key.

SELECT SCRT.ROWSECCLASS , DEPT.SETID , DEPT.DEPTID , DEPT.EFFDT , DEPT.EFF_STATUS , DEPT.DESCR , DEPT.DESCRSHORT , DEPT.COMPANY , DEPT.SETID_LOCATION , DEPT.LOCATION , DEPT.TAX_LOCATION_CD 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_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

Default Value: OPR_DEF_TBL_FS.SETID

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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

9 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
11 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

Prompt Table: %RECNAME_EDIT