OPRIDSUPERVISOR_IDBUSINESS_UNIT_GLBEGIN_DTFC_SUPR_RVW_LST(SQL Table) |
Index Back |
|---|---|
Supervisor ListCaches a list of supervisors along with related forecast horizons that have associated employees. This table is used by the search view for the Forecast Review by Supervisor page. This table is updated with information from EX_EE_AUTH_TBL to determine which employee id's the user has access to. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 3 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 4 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | End Date |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |