XML_DLT_RTSB_VW(SQL View) |
Index Back |
|---|---|
View Delt@ RATSBView Delt@ RATSB |
| SELECT E.RUN_CNTL_ID , I.SSN_EMPLOYER , I.EMPLID , I.INCIDENT_NBR , I.INCIDENT_DT , I.COMPANY , CAL.MONTHCD , CAL.CALYEAR , I.DLT_CONTACT_ESP , I.DLT_BODYPART_ESP , I.DLT_INJURY_ESP , SSN.NATIONAL_ID FROM PS_XML_DLT_INJ_VW I , PS_ABSENCE_CAL CAL , PS_XML_SSN_ESP_VW SSN , PS_XML_ITEM X , PS_DLT_RC_EE_ESP E WHERE X.XMLFILE_ID = E.XMLFILE_ID AND %Substring(X.KEY1_FLD_VAL,1, 11) = E.SSN_EMPLOYER AND E.EMPLID = I.EMPLID AND E.INCIDENT_DT = I.INCIDENT_DT AND SSN.EMPLID = I.EMPLID AND (I.INCIDENT_DT BETWEEN CAL.ABS_MONTH_START_DT AND CAL.ABS_MONTH_END_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 4 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 5 | INCIDENT_DT |
Date(10) | DATE | Incident Date |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 8 | CALYEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 9 | DLT_CONTACT_ESP | Character(2) | VARCHAR2(2) NOT NULL | Contact Mode |
| 10 | DLT_BODYPART_ESP | Character(8) | VARCHAR2(8) NOT NULL | Body Part |
| 11 | DLT_INJURY_ESP | Character(3) | VARCHAR2(3) NOT NULL | Injury |
| 12 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |