CHKLST_ITEM_CDPrompt Table: SCC_CKLSITM_TBL
Prompt Table: PEOPLE_SRCH
Prompt Table: PEOPLE_SRCH
Prompt Table: PEOPLE_SRCH
DATE_ENTEREDDefault Value: %date
TIME_ENTEREDY/N Table Edit
Default Value: N
CHKLST_UPD_SRCH(SQL View) |
Index Back |
|---|---|
Checklist Item UpdateCHKLST_UPD_SRCH finds people who have had a specific Checklist items codes updated. |
| SELECT DISTINCT CHKLST_ITEM_CD, EMPLID, NAME, SSN, DATE_ENTERED, TIME_ENTERED, OPERATOR, ERROR_REPORTED FROM PS_CHKLST_UPDATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHKLST_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Checklist Item Code
Prompt Table: SCC_CKLSITM_TBL |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL |
Name
Prompt Table: PEOPLE_SRCH |
| 4 | SSN | Character(9) | VARCHAR2(9) NOT NULL |
Social Security #
Prompt Table: PEOPLE_SRCH |
| 5 | DATE_ENTERED |
Date(10) | DATE |
Date Entered
Default Value: %date |
| 6 | TIME_ENTERED |
Time(15) | TIMESTAMP | Time Entered |
| 7 | OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 8 | ERROR_REPORTED | Character(1) | VARCHAR2(1) NOT NULL |
Error Reported
Y/N Table Edit Default Value: N |