EMPL_ACTITM_NLD (SQL Table)	Index Back
EE Assignment ActionList Items EMPL_ACTITM_NLD is primarily used to create a list of tasks for an employee in the International Assignments application. However, it can also be used in Personnel Administration, Recruiting, or anywhere that a task list is a desired feature. There is one record in this table for each item or sequence number within a dated list.

EMPL_ACTITM_NLD

(SQL Table)

EE Assignment ActionList Items

EMPL_ACTITM_NLD is primarily used to create a list of tasks for an employee in the International Assignments application. However, it can also be used in Personnel Administration, Recruiting, or anywhere that a task list is a desired feature. There is one record in this table for each item or sequence number within a dated list.

Related Language Record: EMPL_ACTITM_LNG

Parent record: EMPL_ACTLST_NLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Default Value: 0
Prompt Table: PER_ORG_ASGN_VW

3 HR_ACTION_LIST_DT Date(10) DATE NOT NULL Action List Date
Default Value: %date
Prompt Table: EMPL_CHECKLIST

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

5 ACTION_DT Date(10) DATE NOT NULL Action Date
Default Value: %date

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

7 HR_ACTION_LIST_SEQ Number(6,0) INTEGER NOT NULL Action List Sequence
Default Value: 0

8 ACTN_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Follow-up Action Status.
C=Completed
I=Not Started
N=Notified
P=In Progress
R=Received
Z=Cancelled
Default Value: I

9 STATUS_DT Date(10) DATE NOT NULL Status Date
Default Value: %date

10 NOTIFIED_DT Date(10) DATE Date First Notified
Default Value: %date

11 NOTIFIED_TM Time(15) TIMESTAMP Time First Notified
Default Value: %time

12 DESCRLONG_NOTES Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Default Value: 0 Prompt Table: PER_ORG_ASGN_VW
3	HR_ACTION_LIST_DT	Date(10)	DATE NOT NULL	Action List Date Default Value: %date Prompt Table: EMPL_CHECKLIST
4	HR_ACTION_LIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Action List Prompt Table: HR_ACTN_LST_NLD
5	ACTION_DT	Date(10)	DATE NOT NULL	Action Date Default Value: %date
6	HR_ACTNLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Action List Item Code Prompt Table: HR_ACTN_DEF_NLD
7	HR_ACTION_LIST_SEQ	Number(6,0)	INTEGER NOT NULL	Action List Sequence Default Value: 0
8	ACTN_STATUS_NLD	Character(1)	VARCHAR2(1) NOT NULL	Follow-up Action Status. C=Completed I=Not Started N=Notified P=In Progress R=Received Z=Cancelled Default Value: I
9	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
10	NOTIFIED_DT	Date(10)	DATE	Date First Notified Default Value: %date
11	NOTIFIED_TM	Time(15)	TIMESTAMP	Time First Notified Default Value: %time
12	DESCRLONG_NOTES	Long Character	CLOB	Long Description