PER_CHKLST_ITM (SQL Table)	Index Back
Person Checklist Items Used to record the Checklist items of a person.

PER_CHKLST_ITM

(SQL Table)

Person Checklist Items

Used to record the Checklist items of a person.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
Default Value: PER_CHECKLIST.CHECKLIST_CD
Prompt Table: PER_CHECKLIST

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CHECKLIST_DT	Date(10)	DATE NOT NULL	Checklist Date Default Value: %date Prompt Table: PER_CHECKLIST
3	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code Default Value: PER_CHECKLIST.CHECKLIST_CD Prompt Table: PER_CHECKLIST
4	CHECKLIST_SEQ	Number(6,0)	INTEGER NOT NULL	Checklist Sequence
5	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code Prompt Table: CHKLST_ITEM_TBL
6	BRIEFING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Briefing Status C=Completed I=Initiated N=Notified R=Received Default Value: I
7	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date