HR_DR_UI_CFG(SQL Table) |
Index Back |
---|---|
Direct Reports UI ConfigThis table is used to define the DirectReports configuration for Manager Desktop transactions. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |