CHKLST_ITEM_CDPrompt Table: SCC_CKLSITM_TBL
Prompt Table: PEOPLE_SRCH
DATE_ENTEREDDefault Value: %date
TIME_ENTEREDY/N Table Edit
Default Value: N
CHKLST_UPDATE(SQL Table) |
Index Back |
|---|---|
Checklist Item UpdateCHKLST_UPDATE records the people who have had a checklist item updated. |
| # | 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 |
| 4 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 5 | DATE_ENTERED |
Date(10) | DATE NOT NULL |
Date Entered
Default Value: %date |
| 6 | TIME_ENTERED |
Time(15) | TIMESTAMP NOT NULL | 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 |