CHECKLIST_CDC=Completed
I=Initiated
CHKLST_ORG2_VW(SQL View) |
Index Back |
|---|---|
Checklist Org 2 ViewCHKLST_ORG2_VW is used as a prompt in the letter generation process. If the 'All Org IDs' option was specified, this view will be used to show the user those checklist codes for organization type checklists. |
| SELECT DISTINCT A.Checklist_CD , A.Checklist_Status FROM PS_PERSON_CHECKLST A WHERE SA_ID_TYPE = 'O' |
| # | 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 |