HR_DR_UI_CFG

(SQL Table)
Index Back

Direct Reports UI Config

This table is used to define the DirectReports configuration for Manager Desktop transactions.

  • Related Language Record: HR_DR_CFG_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

    Prompt Table: HR_DR_TRANS_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: Y

    5 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
    1=By Dept Security Tree
    2=By Supervisor ID
    3=By Department Manager ID
    4=By Reports To Position
    5=By Part Posn Mgmt Supervisor
    6=By Part Posn Mgmt Dept Mgr ID
    7=By Group ID
    6 HR_DR_REFRESH_GRP Character(1) VARCHAR2(1) NOT NULL Direct Reports UI: Configuration option to force the refresh of Group Members when the Access Type is "Group".

    Y/N Table Edit

    Default Value: N

    7 UPDATE_OWN_INFO Character(1) VARCHAR2(1) NOT NULL Update Own Info

    Y/N Table Edit

    Default Value: N

    8 HR_DR_ALLOW_IND Character(1) VARCHAR2(1) NOT NULL Allow Indirect Reports

    Y/N Table Edit

    Default Value: Y

    9 HR_DR_ALLOW_MULTI Character(1) VARCHAR2(1) NOT NULL Select Multiple Employees

    Y/N Table Edit

    Default Value: N

    10 HR_DR_EMPTY_POS_SW Character(1) VARCHAR2(1) NOT NULL Allow Empty Position

    Default Value: N

    11 HR_DR_ALLOW_DT_CHG Character(1) VARCHAR2(1) NOT NULL Field is used in Direct Reports

    Default Value: Y

    12 HR_DR_MAX_FETCH Number(10,0) DECIMAL(10) NOT NULL Maximum fetch of direct reports

    Default Value: 999999

    13 HR_DR_EMPLID_SW Character(1) VARCHAR2(1) NOT NULL Employee ID

    Y/N Table Edit

    Default Value: Y

    14 HR_DR_EMPL_RCD_SW Character(1) VARCHAR2(1) NOT NULL Empl Record

    Y/N Table Edit

    Default Value: Y

    15 HR_DR_POSITION_SW Character(1) VARCHAR2(1) NOT NULL Position Number

    Y/N Table Edit

    Default Value: Y

    16 HR_DR_JOBCODE_SW Character(1) VARCHAR2(1) NOT NULL Job Code

    Y/N Table Edit

    Default Value: N

    17 HR_DR_JOBTITLE_SW Character(1) VARCHAR2(1) NOT NULL Job Title

    Y/N Table Edit

    Default Value: N

    18 HR_DR_DEPT_SW Character(1) VARCHAR2(1) NOT NULL Department ID

    Y/N Table Edit

    Default Value: N

    19 HR_DR_DEPT_NAME_SW Character(1) VARCHAR2(1) NOT NULL Department Name

    Y/N Table Edit

    Default Value: N

    20 HR_DR_LOCN_SW Character(1) VARCHAR2(1) NOT NULL Location Code

    Y/N Table Edit

    Default Value: N

    21 HR_DR_LOCN_NAME_SW Character(1) VARCHAR2(1) NOT NULL Location Name

    Y/N Table Edit

    Default Value: N

    22 HR_DR_FULL_PART_SW Character(1) VARCHAR2(1) NOT NULL Full/Part Time

    Y/N Table Edit

    Default Value: N

    23 HR_DR_EMPL_STAT_SW Character(1) VARCHAR2(1) NOT NULL Employee Status

    Y/N Table Edit

    Default Value: Y

    24 HR_DR_REM_WORK_SW Character(1) VARCHAR2(1) NOT NULL Remote Worker Status

    Default Value: N

    25 HR_DR_LIMIT_DRILUP Character(1) VARCHAR2(1) NOT NULL Limit Drill Up

    Default Value: Y

    26 HR_COMBINE_PARTIAL Character(1) VARCHAR2(1) NOT NULL Combine Partial

    Default Value: Y

    27 HR_DR_EX_CWR Character(1) VARCHAR2(1) NOT NULL Person Search - Simple: Switch to indicate whether Contingent Workers should be included in results.

    Default Value: N