EMPLIDPrompt Table: PEOPLE_SRCH
CHECKLIST_CDC=Completed
I=Initiated
CHKLST_PERS_VW(SQL View) |
Index Back |
|---|---|
Checklist Personal ViewCHKLST_PERS_VW is used as a prompt in the letter generation process. If the 'One Id' option was specified, this view will be used to show the user those checklist codes which belong to the ID selected. |
| SELECT DISTINCT A.Common_Id , 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | CHECKLIST_CD |
Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 3 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |