SETIDPrompt Table: SET_DEPT_VLD_VW
OPRIDDEPTIDPrompt Table: DEPT_TBL
LANGUAGE_CDDEPT_SEC_LANG(SQL View) |
Index Back |
|---|---|
Search Vw-Security for DeptDEPARTMENT_SRCH is a search view which uses departmental security to grant access to the departments themselves, or other records keyed by department. Users will only see departments which they have security clearance to acccess. It is used as the search record on the budgeting portion of Position Management and for the Salary Planning setup screens which are accessed by department. If you wish to restrict access to the Department Table by security clearance, this record could be used as the search record for the table itself. |
| SELECT %Sql(SCRTY_SEL_DEPTKEY, OPR, DEPT) , L.LANGUAGE_CD , L.DESCR , L.DESCRSHORT FROM %Sql(SCRTY_DEPT_FROM) , PS_DEPT_TBL_LANG L WHERE %Sql(SCRTY_WHERE_DEPT) AND DEPT.SETID = L.SETID AND DEPT.DEPTID = L.DEPTID AND DEPT.EFFDT = L.EFFDT |
| # | 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |