RBD_PERSON

(SQL Table)
Index Back

Dashboard Person

This 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.