HR_EDM_AET (SQL Table)	Index Back
First Hire Date Declaration. Cache record for First Hire Date Declaration.

HR_EDM_AET

(SQL Table)

First Hire Date Declaration.

Cache record for First Hire Date Declaration.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

5 BEGIN_DT Date(10) DATE Begin Date

6 NOTICEDATE Date(10) DATE NoticeDate

7 END_DATE Date(10) DATE End Date

8 EDM_MSG_ID_NLD Character(32) VARCHAR2(32) NOT NULL First Hire Date Declaration.

9 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

10 EDM_DESCR10_NLD Character(10) VARCHAR2(10) NOT NULL Description field of length 10

11 NL_REASON_END Character(1) VARCHAR2(1) NOT NULL Reason for ending Health Insur
D=Death
E=Else
M=Military Service
S=Salary Limit Reached
T=Termination

12 WP_PATH Character(200) VARCHAR2(200) NOT NULL Path for Agreement Document

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	BEGIN_DT	Date(10)	DATE	Begin Date
6	NOTICEDATE	Date(10)	DATE	NoticeDate
7	END_DATE	Date(10)	DATE	End Date
8	EDM_MSG_ID_NLD	Character(32)	VARCHAR2(32) NOT NULL	First Hire Date Declaration.
9	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
10	EDM_DESCR10_NLD	Character(10)	VARCHAR2(10) NOT NULL	Description field of length 10
11	NL_REASON_END	Character(1)	VARCHAR2(1) NOT NULL	Reason for ending Health Insur D=Death E=Else M=Military Service S=Salary Limit Reached T=Termination
12	WP_PATH	Character(200)	VARCHAR2(200) NOT NULL	Path for Agreement Document