DEPBUD_DTL_LNG(SQL View) |
Index Back |
|---|---|
Search Vw-Security for BudgetDEPARTMENT_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 DISTINCT A.SETID ,A.DEPTID ,A.FISCAL_YEAR , SEC.OPRID ,A.BUDGET_LEVEL_INDC ,A.POSITION_POOL_ID ,A.SETID_JOBCODE ,A.JOBCODE ,A.POSITION_NBR ,A.EMPLID ,A.EMPL_RCD ,SEC.DESCR ,SEC.COMPANY ,SEC.LOCATION FROM PS_DEPT_BUDGET A ,PS_DEPT_TBL B ,PS_DEPT_SEC_SRCH SEC WHERE A.SETID = SEC.SETID AND A.DEPTID = SEC.DEPTID AND B.SETID = SEC.SETID AND B.DEPTID = SEC.DEPTID AND B.USE_BUDGETS='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: BUD_DEPT_VW |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | BUDGET_LEVEL_INDC |
Character(1) | VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment D=Department J=Jobcode O=Position Pool P=Position |
| 6 | POSITION_POOL_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Position Pool ID
Prompt Table: POOL_BDGT_VW |
| 7 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table: SET_JOB_DEP_VW |
| 8 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_BDGT_VW |
| 9 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSN_BDGT_VW |
| 10 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: DEPT_EE_VW |
| 11 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: DEPT_EE_APPT_VW |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |