HR_ACTN_DTL_NLD (SQL Table)	Index Back
Assignment ActnLst Item Codes Use HR_ACTN_DEF_NLD and HR_ACTN_DTL_NLD to maintain any type of NLD ActionList needed by your company. HR_ACTN_DEF_NLD contains the items code. HR_ACTN_DTL_NLD contains the specific items details.

HR_ACTN_DTL_NLD

(SQL Table)

Assignment ActnLst Item Codes

Use HR_ACTN_DEF_NLD and HR_ACTN_DTL_NLD to maintain any type of NLD ActionList needed by your company. HR_ACTN_DEF_NLD contains the items code. HR_ACTN_DTL_NLD contains the specific items details.

Related Language Record: HR_ACTN_DTL_LNG

Parent record: HR_ACTN_DEF_NLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_ACTNLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Action List Item Code

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 ACTLST_PARTICIPANT Character(3) VARCHAR2(3) NOT NULL Ction List Participant Used by Action Item List to notify participants.
ABS=Absence Administrator
ARB=Health Service Provider
CMG=Case Manager
EE=Employee
HR=HR Administrator
MGR=Manager
SUP=Supervisor

4 EOAWUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
Prompt Table: EOAWUSER_LIST

5 HR_ACTN_CHANNEL Character(1) VARCHAR2(1) NOT NULL Communication Channel uses by the Follow-up action List Items for the Netherlands to send Notifications.
0=None
1=Email
2=Worklist
3=Email and Worklist

6 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
Prompt Table: WL_TEMPL_GEN_VW

7 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_ACTNLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Action List Item Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	ACTLST_PARTICIPANT	Character(3)	VARCHAR2(3) NOT NULL	Ction List Participant Used by Action Item List to notify participants. ABS=Absence Administrator ARB=Health Service Provider CMG=Case Manager EE=Employee HR=HR Administrator MGR=Manager SUP=Supervisor
4	EOAWUSER_LIST_ID	Character(30)	VARCHAR2(30) NOT NULL	Identifies the user list to be used when creating the approval process. Prompt Table: EOAWUSER_LIST
5	HR_ACTN_CHANNEL	Character(1)	VARCHAR2(1) NOT NULL	Communication Channel uses by the Follow-up action List Items for the Netherlands to send Notifications. 0=None 1=Email 2=Worklist 3=Email and Worklist
6	WL_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Template Name Prompt Table: WL_TEMPL_GEN_VW
7	DESCRLONG	Long Character	CLOB	Long Description