HRNL_CHKLST_AET

(SQL Table)
 Index Back

Cache record Checklist NL Data

Cache record for the Application Engine HR_ACTN_NLD.

# 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 Record
4 ASOFDATE Date(10) DATE As of Date
5 THRUDATE Date(10) DATE End Date
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
9 COUNTRY_DESCR1 Character(30) VARCHAR2(30) NOT NULL Country Description
10 BIRTHDATE Date(10) DATE Date of Birth
11 DT_OF_DEATH Date(10) DATE Date of Death
12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
13 NAME Character(50) VARCHAR2(50) NOT NULL Name
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
16 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
19 REGISTR_NUM Character(15) VARCHAR2(15) NOT NULL Registration Nbr
20 JOB_EFFDT Date(10) DATE Job Effective Date
21 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
22 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
23 COMMENT_DT Date(10) DATE Comment Date
24 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
25 REASON Character(30) VARCHAR2(30) NOT NULL Reason
26 HIRE_DT Date(10) DATE First Start Date
27 TERMINATION_DT Date(10) DATE Termination Date
28 WAO_DATE_NLD Date(10) DATE WAO/WIA Date
29 WAO_PERCENT_NLD Number(3,0) SMALLINT NOT NULL WAO Percentage
30 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
31 ABSENCE_CODE Character(3) VARCHAR2(3) NOT NULL Absence Code
32 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
33 BEGIN_DT Date(10) DATE Begin Date
34 ABS_BEGIN_TM Time(15) TIMESTAMP Begin Time
35 ILL_PERCENT_NLD Number(3,0) SMALLINT NOT NULL Percentage Ill
36 DUE_DT Date(10) DATE Expected Birth Date
37 HR_ACTION_LIST_DT Date(10) DATE Action List Date

Default Value: %date

38 HR_ACTION_LIST_SEQ Number(6,0) INTEGER NOT NULL Action List Sequence
39 HR_ACTNLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Action List Item Code
40 HR_ACTION_LIST_CD Character(6) VARCHAR2(6) NOT NULL Action List

Prompt Table: HR_ACTN_LST_NLD

41 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

Prompt Table: PERSON_NAME

42 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
43 EOAWCHANNEL Character(1) VARCHAR2(1) NOT NULL Notification Channel
0=None
1=Email
2=Worklist
3=Email and Worklist
4=User Preference

Default Value: 3

44 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
45 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name

Prompt Table: WL_TEMPL_GEN_VW

46 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

47 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
48 STATUS_DT Date(10) DATE Status Date

Default Value: %date

49 ACTION_DT Date(10) DATE Action Date

Default Value: %date

50 PERIOD_END_NLD Date(10) DATE End Period
51 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
52 HR_ACTN_FREQ_NLD Character(1) VARCHAR2(1) NOT NULL Follow-up Action NLD The duration can be determined in Days or Weeks
D=Day
W=Week
53 TOTAL_GOAL Number(7,0) INTEGER NOT NULL Total Goal
54 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count
55 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
56 HR_ACTN_TER_CD_NLD Character(6) VARCHAR2(6) NOT NULL Action List Termination Code. (NL0097)
57 HR_ACTN_4W_CD_NLD Character(6) VARCHAR2(6) NOT NULL Action List 4 Weeks Code. (NL0099)
58 HR_ACTN_SIC_CD_NLD Character(6) VARCHAR2(6) NOT NULL Action List Sickness Code. (NL0098)
59 ABSENCE_SYSTEM_CD Character(3) VARCHAR2(3) NOT NULL What Absence System this Assignment is tied to.
AM=Absence Management
OT=Other
60 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
61 ABS_RECURRENCE Character(1) VARCHAR2(1) NOT NULL Absence Recurrence
62 ORIG_BEGIN_DT_BEL Date(10) DATE Original Start Date
63 ORIG_EMPL_RCD_BEL Number(3,0) SMALLINT NOT NULL Employment Record Nbr
64 ORIG_ABS_TYPE_BEL Character(3) VARCHAR2(3) NOT NULL Original Absence Type
65 RETURN_DT Date(10) DATE Return Date
66 ABS_RETURN_TM Time(15) TIMESTAMP Return Time
67 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit
68 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
69 DEPTID_FILTR Character(10) VARCHAR2(10) NOT NULL Dept ID
70 NOTIF_START_DT_NLD Date(10) DATE Notification Start Date is used for Illness Reporting for The Netherlands tracking the actual date that a certain illness has been reported to the ARBO service.
71 NOTIF_END_DT_NLD Date(10) DATE Notification End Date is used for Illness Reporting for The Netherlands tracking the actual date that the return from a certain illness has been reported to the ARBO service.
72 ILL_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Illness Status field held illness information conform to the vaiPrisma standard: Change, replcae or Original Report.
4=Illness Report Change
5=Illness Report Replace
9=Illness Report Original

Default Value: 9

73 PANEL_NAME Character(18) VARCHAR2(18) NOT NULL Panel name
74 NOTIFIED_DT Date(10) DATE Date First Notified
75 NOTIFIED_TM Time(15) TIMESTAMP Time First Notified
76 DESCRLONG Long Character CLOB Long Description