HCDL_INSTALL

#	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