SSR_HM_ERR_DTLS(SQL View) |
Index Back |
|---|---|
HEIMS Error DetailsLists all the errors received from TCSI |
| SELECT T.RECNAME ,T.SSR_TRANS_ID ,T.SSR_SEQ_NBR ,T.SSR_ERROR_ID ,E.SSR_ERROR_CAT ,E.SSR_ERROR_DESCR FROM PS_SSR_HM_TX_ERROR T , PS_SSR_HM_ERROR E WHERE E.SSR_ERROR_ID = T.SSR_ERROR_ID |
| # | 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_CAT | Character(15) | VARCHAR2(15) NOT NULL | HEIMS Error Error Category |
| 6 | SSR_ERROR_DESCR | Long Character | CLOB | HEIMS Error Error Description |