DEPT_SEC_SRCH(SQL View) |
Index Back |
---|---|
Search - Dept Security SrchThis is a search record for Departments that provides for security on access to Departments. |
SELECT %Sql(SCRTY_SEL_DEPTKEY, OPR, DEPT) , DEPT.DESCR , DEPT.DESCRSHORT , DEPT.SETID_LOCATION , DEPT.LOCATION , DEPT.MANAGER_ID , DEPT.COMPANY , DEPT.USE_BUDGETS , DEPT.USE_ENCUMBRANCES FROM %Sql(SCRTY_DEPT_FROM) WHERE %Sql(SCRTY_WHERE_DEPT) |
# | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL |
Location SetID
Prompt Table: SET_LOC_VLD_VW |
7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: SET_LOC_VW |
8 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Manager ID
Prompt Table: WORKER_PROMPT |
9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
10 | USE_BUDGETS | Character(1) | VARCHAR2(1) NOT NULL | Use Comm. Acctg. / Budgeting |
11 | USE_ENCUMBRANCES | Character(1) | VARCHAR2(1) NOT NULL | Use Encumbrance Processing |