CHECKLIST_CDCHKLST_ITEM_CDSCC_ITMADM_FL(SQL View) |
Index Back |
|---|---|
Checklist Item & Adnmin functiChecklist Item with CR Adnmin function |
| SELECT A.CHECKLIST_CD ,A.CHKLST_ITEM_CD FROM PS_CS_CHKLST_ITEM A ,PS_CS_CHKLST_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.CHECKLIST_CD = B.CHECKLIST_CD AND B.ADMIN_FUNCTION IN ('AVAK','AVIN','AVMD','AVMS','SFGR','GEN') AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CS_CHKLST_ITEM A1 WHERE A.INSTITUTION = A1.INSTITUTION AND A.CHECKLIST_CD = A1.CHECKLIST_CD) AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CS_CHKLST_TBL B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B.CHECKLIST_CD = B1.CHECKLIST_CD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHECKLIST_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 2 | CHKLST_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |