HS_SS_APHOTO_VW

(SQL View)
Index Back

Health & Safety Employee Photo

H&S Employee photo for fluid approvals

SELECT A.EMPLID , A.ACTION_DT_SS ,A.EFFSEQ , A.INCIDENT_NBR , B.EMPLOYEE_PHOTO FROM %Table(HS_SS_INCDT_DAT) A , %Table(USER_PH_LIST_FL) B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date

Default Value: %date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

Default Value: 0

4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

Default Value: 0

5 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph