CHKLST_PERS2_VW

(SQL View)
 Index Back

Checklist Personal 2 View

CHKLST_PERS2_VW is used as a prompt in the letter generation process. If the 'All Person IDs' option was specified, this view will be used to show the user those checklist codes for person type checklists.

SELECT DISTINCT A.Checklist_CD , A.Checklist_Status FROM PS_PERSON_CHECKLST A WHERE SA_ID_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
2 CHECKLIST_STATUS Character(1) VARCHAR2(1) NOT NULL Checklist Status
C=Completed
I=Initiated