OPRIDDefault Value: PSOPRDEFN.OPRID
RUN_CNTL_IDEMPLIDINCIDENT_DTPrompt Table: ALL_CCC_ESP_VW
0=XML Sent Confirmed
1=Data OK
2=Required Data
3=Data Not Validated
4=Data Not Loaded
Default Value: 4
0=Not Communicated
1=XML Generated
DLT_RC_EE_ESP(SQL Table) |
Index Back |
|---|---|
Employees for Delta XML ESPDelta Employees for XML Reporting ESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PSOPRDEFN.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | INCIDENT_DT |
Date(10) | DATE | Incident Date |
| 5 | XMLFILE_ID | Character(50) | VARCHAR2(50) NOT NULL | XML File ID |
| 6 | SSN_EMPLOYER | Character(13) | VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table: ALL_CCC_ESP_VW |
| 7 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 8 | XML_NODE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Node Status
0=XML Sent Confirmed 1=Data OK 2=Required Data 3=Data Not Validated 4=Data Not Loaded Default Value: 4 |
| 9 | DLT_REPORT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Delta Reporting Status
0=Not Communicated 1=XML Generated |
| 10 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 11 | INSUR_COMP_CD_ESP | Character(5) | VARCHAR2(5) NOT NULL | Insurance Company Code |