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 |