RECNAMESSR_TRANS_IDSSR_SEQ_NBRSSR_ERROR_IDSSR_HM_TX_ER_VW(SQL View) |
Index Back |
|---|---|
HEIMS Transaction ErrorsHEIMS Transaction errors |
| SELECT TXER.RECNAME ,TXER.SSR_TRANS_ID ,TXER.SSR_SEQ_NBR ,TXER.SSR_ERROR_ID ,TXER.SSR_ERROR_DETAILS FROM PS_SSR_HM_TX_ERROR TXER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | SSR_TRANS_ID |
Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |
| 3 | SSR_SEQ_NBR |
Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | SSR_ERROR_ID |
Character(50) | VARCHAR2(50) NOT NULL | HEIMS Error Error ID |
| 5 | SSR_ERROR_DETAILS | Long Character | CLOB | HEIMS Error Error Details |