CHECKLIST_ITEM (SQL Table)	Index Back
Assignment Checklist Items CHECKLIST_ITEM is one of several records used to set up any checklist (list of items to do) appropriate to your company. For example, you might set up a checklist of items for employees being sent on an overseas work assignment. That checklist might include items such as attend briefing, attend language school, submit school applications for dependents, take physical exams, and obtain passports and visas. There are several records involved in checklist maintenance. CHECKLIST_TBL is the parent record that contains the code assigned to the checklist, plus an effective date and descriptions. A subordinate record, CHECKLIST_ITEM, contains the actual items assigned to a checklist. Before you add items to CHECKLIST_ITEM, you must set them up on an edit table named CHKLST_ITEM_TBL.

CHECKLIST_ITEM

(SQL Table)

Assignment Checklist Items

CHECKLIST_ITEM is one of several records used to set up any checklist (list of items to do) appropriate to your company. For example, you might set up a checklist of items for employees being sent on an overseas work assignment. That checklist might include items such as attend briefing, attend language school, submit school applications for dependents, take physical exams, and obtain passports and visas. There are several records involved in checklist maintenance. CHECKLIST_TBL is the parent record that contains the code assigned to the checklist, plus an effective date and descriptions. A subordinate record, CHECKLIST_ITEM, contains the actual items assigned to a checklist. Before you add items to CHECKLIST_ITEM, you must set them up on an edit table named CHKLST_ITEM_TBL.

Parent record: CHECKLIST_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code Prompt Table: CHECKLIST_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	CHECKLIST_SEQ	Number(6,0)	INTEGER NOT NULL	Checklist Sequence
4	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code Prompt Table: CHKLST_ITEM_TBL