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 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
2 | PERSON_ID | 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. |