INCIDENT_NBREMPLIDEMPL_RCDNON_EMPLOYEE_IDSEQUENCE_NBRINJ_DSGCAN_VW(SQL View) |
Index Back |
|---|---|
H&S - First Aid DesignatesView of PS_INJURY_ILL_DESG selecting on First Aid Attendants. Used as prompt for First Aid Sequence. |
| SELECT A.INCIDENT_NBR , A.emplid , A.EMPL_RCD , A.non_employee_id , A.SEQUENCE_NBR , A.DESIGNATE_EMPLID , P.NAME FROM PS_INJURY_ILL_DESG A , PS_PERSON_NAME P WHERE A.DESIG_POSTYP_CD = '10' AND A.DESIGNATE_EMPLID = P.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 5 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | DESIGNATE_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employer Designate ID |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |