COMPANYGPCH_RC_PAY_YEARGPCH_EG_DOMAINIDGPCH_EG_REQUEST_ID0001=Success
0002=Accepted
0003=Warning
0004=Error
0005=Soap Fault
0006=Fault
0007=Ignored
0008=Open
0009=N
0010=File Error
GPCH_EG_FSTATUS(SQL Table) |
Index Back |
|---|---|
ELM Internal XML File StatusGPCH-ELM Internal XML File Status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPCH_RC_PAY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 3 | GPCH_EG_DOMAINID |
Number(3,0) | SMALLINT NOT NULL | Domain Set ID for the ELM Domain Sets |
| 4 | GPCH_EG_REQUEST_ID |
Character(30) | VARCHAR2(30) NOT NULL | Holds Request ID in the ELM File |
| 5 | GPCH_EG_RESPONSEID | Character(30) | VARCHAR2(30) NOT NULL | Response ID for ELM |
| 6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | TIME_STAMP | DateTime(26) | TIMESTAMP | Time Stamp |
| 8 | GPCH_REPORT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Report Status for Year End Process
0001=Success 0002=Accepted 0003=Warning 0004=Error 0005=Soap Fault 0006=Fault 0007=Ignored 0008=Open 0009=N 0010=File Error |
| 9 | FILE_DATA_CHAR | Long Character(32000) | CLOB | File Data |
| 10 | GPCH_EG_REQID_OLD | Character(30) | VARCHAR2(30) NOT NULL | Old Request ID for ELM |
| 11 | GPCH_EG_RESPID_OLD | Character(30) | VARCHAR2(30) NOT NULL | Old Response Id for ELM file |