RBD_PERSON(SQL Table) |
Index Back |
|---|---|
Dashboard PersonThis is the record for the Dashboard Person temporary table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID | |
| 2 | Character(15) | VARCHAR2(15) NOT NULL | Person ID | |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 4 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 7 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 8 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 10 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 11 | DESCR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | SUPERVISOR_ID | Character(15) | VARCHAR2(15) NOT NULL | ID of a worker's supervisor. |
| 13 | BO_NAME_DISPLAY_1 | Character(80) | VARCHAR2(80) NOT NULL | This field represents the Display Name for a business object |
| 14 | EMAIL_ADDR_ALT | Character(70) | VARCHAR2(70) NOT NULL | alternate email address |
| 15 | 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 |
| 16 | DESCR_OTHER | Character(30) | VARCHAR2(30) NOT NULL | If Other, Describe |
| 17 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |