HR_LST_ITEM_NLD (SQL Table)	Index Back
Assignment Action List Items HR_LST_ITEM_NLD is one of several records used to set up any Action List (list of items to do) appropriate to your company. For example, you might set up a Action List of items for employees being sent on an overseas work assignment. That Action List might include items such as attend briefing, attend language school, submit school applications for dependents, take physical exams, and obtain passports and visas. There are several records involved in checklist maintenance. HR_ACTN_LST_NLDis the parent record that contains the code assigned to the Action List, plus an effective date and descriptions. A subordinate record, HR_LST_ITEM_NLD, contains the actual items assigned to a Action List. Before you add items to Action List, you must set them up on an edit table named HR_ACTN_DEF_NLD.

HR_LST_ITEM_NLD

(SQL Table)

Assignment Action List Items

HR_LST_ITEM_NLD is one of several records used to set up any Action List (list of items to do) appropriate to your company. For example, you might set up a Action List of items for employees being sent on an overseas work assignment. That Action List might include items such as attend briefing, attend language school, submit school applications for dependents, take physical exams, and obtain passports and visas. There are several records involved in checklist maintenance. HR_ACTN_LST_NLDis the parent record that contains the code assigned to the Action List, plus an effective date and descriptions. A subordinate record, HR_LST_ITEM_NLD, contains the actual items assigned to a Action List. Before you add items to Action List, you must set them up on an edit table named HR_ACTN_DEF_NLD.

Parent record: HR_ACTN_LST_NLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_ACTION_LIST_CD Character(6) VARCHAR2(6) NOT NULL Action List
Prompt Table: HR_ACTN_LST_NLD

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

3 HR_ACTION_LIST_SEQ Number(6,0) INTEGER NOT NULL Action List Sequence

4 HR_ACTNLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Action List Item Code
Prompt Table: HR_ACTN_DEF_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_ACTION_LIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Action List Prompt Table: HR_ACTN_LST_NLD
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	HR_ACTION_LIST_SEQ	Number(6,0)	INTEGER NOT NULL	Action List Sequence
4	HR_ACTNLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Action List Item Code Prompt Table: HR_ACTN_DEF_NLD