EE_CKLST_ITM_VW(SQL View) |
Index Back |
|---|---|
EE Assignment Checklist ItemsReturns all checklist items for the current version of the checklist. |
| SELECT I.EMPLID , I.EMPL_RCD , I.CHECKLIST_DT , I.CHECKLIST_CD , I.CHECKLIST_SEQ , I.CHKLST_ITEM_CD , I.BRIEFING_STATUS FROM PS_EMPL_CHECKLIST L , PS_EMPL_CHKLST_ITM I WHERE L.EMPLID = I.EMPLID AND L.EMPL_RCD = I.EMPL_RCD AND L.CHECKLIST_CD = I.CHECKLIST_CD AND L.CHECKLIST_DT = I.CHECKLIST_DT AND L.CHECKLIST_DT = ( SELECT MAX(CHECKLIST_DT) FROM PS_EMPL_CHECKLIST L1 WHERE L1.EMPLID = L.EMPLID AND L1.EMPL_RCD = L.EMPL_RCD AND L1.CHECKLIST_CD = L.CHECKLIST_CD AND L1.CHECKLIST_DT <= %CurrentDateIn) |
| # | 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 |