HS_SS_PEOPL_VW(SQL View) |
Index Back |
|---|---|
Incident People ViewUsed in Fluid Self Service |
| SELECT EMPLID , ACTION_DT_SS , EFFSEQ , INCIDENT_NBR , HS_EMPLID , NON_EMPLOYEE_ID , INCIDENT_ROLE , COMMENTS FROM PS_HS_SS_PEOPL_DAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: HS_SS_INCDT_DAT.EMPLID 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 |
| 4 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Default Value: HS_SS_INCDT_SBR.INCIDENT_NBR Prompt Table: INCIDENT_DATA |
| 5 | HS_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID for Health and Safety
Prompt Table: HS_PERSON_SRCH |
| 6 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH |
| 7 | INCIDENT_ROLE |
Character(2) | VARCHAR2(2) NOT NULL |
Incident Role
BP=Bystander/Pedestrian DO=Driver/Operator Of Vehicle EW=Eyewitness IN=Investigator IW=Witness OP=Other Party PA=Passenger In Vehicle PO=Property Owner PW=Pet Owner VO=Vehicle Owner |
| 8 | COMMENTS | Long Character | CLOB | Comment |