RBD_JOB_VW(SQL View) |
Index Back |
|---|---|
Dashboard JobThis record is for the Dashboard Person dimension job data view. |
| SELECT PER.BO_ID , JOB.SETID_DEPT , JOB.DEPTID , JOB.SETID_LOCATION , JOB.LOCATION , JOB.SUPERVISOR_ID , JOB.MANAGER_LEVEL FROM %Table(RB_WORKER) JOB , %Table(RD_PERSON) PER WHERE JOB.PERSON_ID = PER.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_RB.SETID |
| 3 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 4 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL |
Location SetID
Default Value: OPR_DEF_TBL_RB.SETID |
| 5 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 6 | SUPERVISOR_ID | Character(15) | VARCHAR2(15) NOT NULL | ID of a worker's supervisor. |
| 7 | MANAGER_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Manager Level.
0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager Default Value: 9 |