EMPL_CHKLST_ITM (SQL Table)	Index Back
EE Assignment Checklist Items EMP_CHKLST_ITM 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_CHKLST_ITM

(SQL Table)

EE Assignment Checklist Items

EMP_CHKLST_ITM 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.

Parent record: EMPL_CHECKLIST

# 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 Record
Default Value: 0
Prompt Table: PER_ORG_ASGN_VW

3 CHECKLIST_DT Date(10) DATE NOT NULL Checklist Date
Default Value: %date
Prompt Table: EMPL_CHECKLIST

4 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
Prompt Table: CHECKLIST_TBL

5 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence

6 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
Prompt Table: CHKLST_ITEM_TBL

7 BRIEFING_STATUS Character(1) VARCHAR2(1) NOT NULL Briefing Status
C=Completed
I=Initiated
N=Notified
R=Received
Default Value: I

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

9 COMMENTS Long Character CLOB Comment

#	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 Record Default Value: 0 Prompt Table: PER_ORG_ASGN_VW
3	CHECKLIST_DT	Date(10)	DATE NOT NULL	Checklist Date Default Value: %date Prompt Table: EMPL_CHECKLIST
4	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code Prompt Table: CHECKLIST_TBL
5	CHECKLIST_SEQ	Number(6,0)	INTEGER NOT NULL	Checklist Sequence
6	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code Prompt Table: CHKLST_ITEM_TBL
7	BRIEFING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Briefing Status C=Completed I=Initiated N=Notified R=Received Default Value: I
8	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
9	COMMENTS	Long Character	CLOB	Comment