HCDL_INSTALL

(SQL Table)
Index Back

Delegation System Setup

Delegation System Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

2 DAYS_AFTER Number(3,0) SMALLINT NOT NULL This field is used to indicate how many days after the current date to show the end of the history date range.

Default Value: 7

3 PERS_SRCH Character(1) VARCHAR2(1) NOT NULL Allow open Person search for Proxies.

Y/N Table Edit

Default Value: Y

4 ENABLE_HCHY Character(1) VARCHAR2(1) NOT NULL Flag that enables a specific hierarchy (Access Type) for Delegation Proxy selection.

Y/N Table Edit

Default Value: N

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 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

Prompt Table: HCDL_GB_VW

7 HR_PSS_CWR_SW Character(1) VARCHAR2(1) NOT NULL Person Search - Simple: Switch to indicate whether Contingent Workers should be included in results.
8 HR_PSS_POI_SW Character(1) VARCHAR2(1) NOT NULL Person Search - Simple: Switch to indicate whether Persons of Interest should be included in results.
9 HCDL_DELEGATE_OPT Character(1) VARCHAR2(1) NOT NULL Use Fluid Delegation
N=HCM Delegation
Y=Enable EO Delegation

Default Value: N