| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DPRT_KEY |
Character(1) |
VARCHAR2(1) NOT NULL |
field used as a key bu the direct report configuration setup and its related language table
Default Value: A
|
| 2 |
FIRST_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the first tab in the Direct Reports Grid.
Default Value: Summary
|
| 3 |
INCLUDE_DISPLAYNAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude employee ID in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 4 |
INCLUDE_FIRSTNAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude employee ID in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 5 |
INCLUDE_LASTNAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude employee ID in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 6 |
INCLUDE_ACTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude employee ID in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 7 |
INCLUDE_POTENTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude potential in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 8 |
INCLUDE_JOBTITLE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude job title in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 9 |
INCLUDE_RATINGBAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude performance rating bar in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 10 |
INCLUDE_COMPRATIO1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude compa-ratio (first field of two) in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 11 |
INCLUDE_SALRANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude position in salary range in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 12 |
SECOND_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the second tab in the Direct Reports Grid.
Default Value: Job Details
|
| 13 |
INCLUDE_EMPLID |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude employee ID in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 14 |
INCLUDE_JOBCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude job code in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 15 |
INCLUDE_TIMEINJOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude time in job in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 16 |
INCLUDE_JOBTITLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude job title in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 17 |
INCLUDE_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude schedule in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 18 |
THIRD_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the third tab in the Direct Reports Grid.
Default Value: Contact
|
| 19 |
INCLUDE_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude phone in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 20 |
INCLUDE_EMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Email in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 21 |
INCLUDE_DEPARTMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude department in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 22 |
INCLUDE_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Location in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 23 |
INCLUDE_CHAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Chat in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 24 |
FOURTH_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the fourth tab in the Direct Reports Grid.
Default Value: Career Plan
|
| 25 |
INCLUDE_PLANREVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude plan review date in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 26 |
INCLUDE_RELOCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude willing to relocate in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 27 |
INCLUDE_GLOBAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude will take global assignment in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 28 |
INCLUDE_TRAVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude willing to travel in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 29 |
FIFTH_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the fifth tab in the Direct Reports Grid.
Default Value: Compensation
|
| 30 |
INCLUDE_ANNSALARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Annual Salary in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 31 |
INCLUDE_SALARYCURR |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Salary Currency in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 32 |
INCLUDE_MINSALARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Salary Range Minimum in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 33 |
INCLUDE_MIDSALARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Salary Range Midpoint in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 34 |
INCLUDE_MAXSALARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Salary Range Maximum in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 35 |
INCLUDE_COMPRATIO2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude compa-ratio (first field of two) in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 36 |
INCLUDE_QUARTILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Quartile in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 37 |
INCLUDE_PCTRANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Percent Range in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 38 |
SIXTH_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the sixth tab in the Direct Reports Grid.
Default Value: Performance
|
| 39 |
INCLUDE_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude performance rating in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 40 |
INCLUDE_PERIODBEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude performance Period Begin Date in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 41 |
INCLUDE_PERIODEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude performance Period End Date in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 42 |
SEVENTH_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the seventh tab in the Direct Reports Grid.
Default Value: Time
|
| 43 |
INCLUDE_COMPBAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Comp Time Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 44 |
INCLUDE_VACABAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Vacation Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 45 |
INCLUDE_SICKBAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Sick Time Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|
| 46 |
EIGHTH_TAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Field to store the name of the seventh tab in the Direct Reports Grid.
Default Value: Succession
|
| 47 |
INCLUDE_KEYPOS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Key Position in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 48 |
INCLUDE_SUCCESSORS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude number of successors in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 49 |
INCLUDE_LEAVING |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Risk of Leaving in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 50 |
INCLUDE_LOSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Risk of Loss in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 51 |
HRCD_SHOW_EMAIL_DM |
Character(1) |
VARCHAR2(1) NOT NULL |
Company Directory
Y/N Table Edit
Default Value: N
|
| 52 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
EP_REVWT_CUR_VW
|
| 53 |
HR_DR_EMPTY_POS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Empty Position
Y/N Table Edit
Default Value: N
|
| 54 |
PIN_ENTL_BAL1 |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 55 |
PIN_ENTL_BAL2 |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 56 |
PIN_ENTL_BAL3 |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 57 |
LEAVE_LABEL1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Balance Type 1 Label
Default Value: Vacation
|
| 58 |
LEAVE_LABEL2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Balance Type 2 Label
Default Value: Sick
|
| 59 |
LEAVE_LABEL3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Balance Type 3 Label
|
| 60 |
INCLUDE_LEAVEBAL1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Comp Time Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 61 |
INCLUDE_LEAVEBAL2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Comp Time Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: Y
|
| 62 |
INCLUDE_LEAVEBAL3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag set to include or exclude Comp Time Balance in Direct Reports Grid.
Y/N Table Edit
Default Value: N
|