CHKLST_UPD_SRCH

(SQL View)
Index Back

Checklist Item Update

CHKLST_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