SAD_SL_STUD_NBRSAD_SL_ACTN_SEQI=Inbound
O=Outbound
SSR_BR_TRNS_NLD(SQL Table) |
Index Back |
|---|---|
BRON-HO Transaction SummaryBRON-HO Transaction Summary Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_SL_STUD_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Student Number |
| 2 | SAD_SL_ACTN_SEQ |
Number(5,0) | INTEGER NOT NULL | Action Sequence |
| 3 | SAD_SL_TRANS_INOUT | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Direction
I=Inbound O=Outbound |
| 4 | SSR_BRHO_MSG_CODE | Character(50) | VARCHAR2(50) NOT NULL | BRON Message |
| 5 | SAD_SL_ACTN_DTTM | DateTime(26) | TIMESTAMP | Action DateTime |
| 6 | SSR_BRHO_ENRSQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | BRON Enrolment Seq Nbr |
| 7 | SSR_BRHO_RESEQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | BRON Result Seq Nbr |
| 8 | SAD_SL_TRANS_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | SAD_SL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Transaction DateTime |
| 10 | SSR_BR_INDEXID_NLD | Character(50) | VARCHAR2(50) NOT NULL | Index ID |