SETIDPrompt Table: SET_DEPT_VLD_VW
DEPTIDPrompt Table: DEPT_TBL
SCC_DEPT_TBL_VW(SQL View) |
Index Back |
|---|---|
DEPTID/OPRCLASS Security VwSCC_DEPT_TBL_VW is a view used for data security purposes. It identifies which operator classes have access to which departments' employee data. |
| SELECT DEPT.SETID ,DEPT.DEPTID ,DEPT.DESCR ,DEPT.DESCRSHORT FROM PS_DEPT_TBL DEPT WHERE DEPT.EFF_STATUS = 'A' AND DEPT.EFFDT = ( SELECT MAX(DEPT1.EFFDT) FROM PS_DEPT_TBL DEPT1 WHERE DEPT1.SETID = DEPT.SETID AND DEPT1.DEPTID = DEPT.DEPTID AND DEPT1.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_DEPT_VLD_VW |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |