EMPL_CHK_ITM_VW (SQL View)	Index Back
Medical Checklist Items Medical Checklist Items

EMPL_CHK_ITM_VW

(SQL View)

Medical Checklist Items

SELECT EMPLID , EMPL_RCD , CHECKLIST_DT , CHECKLIST_SEQ , CHKLST_ITEM_CD , BRIEFING_STATUS , STATUS_DT FROM PS_EMPL_CHKLST_ITM

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_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	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_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