cdrmst_raw
Core Schemas
>
Silverlake
>
cdrmst_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| block_num_ | Repo Block Number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| rpseq_num_ | Sequence Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| blkdsc | Block Description | CHAR(35) | NULLABLE | STRING | 35 |
| secds1 | Security Description 1 | CHAR(35) | NULLABLE | STRING | 35 |
| secsnm | Security Short Name | CHAR(20) | NULLABLE | STRING | 20 |
| secmdt | Secuity Mat. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| secmd6 | Secuity Mat. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| secirt | Security Int. Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| secamt | Security Par Value | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| secmkt | Security Market Value | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| secunc | Auto Uncommitted Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| cusip | CUSIP Number | CHAR(10) | NULLABLE | STRING | 10 |
| mvaldt | Market Value Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| mvald7 | Market Value Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| blktyp | Repo Type | CHAR(2) | NULLABLE | STRING | 2 |
| blkqot | Enter Market or Quote | CHAR(1) | NULLABLE | STRING | 1 |
| blkrsq | Auto Resequence | CHAR(1) | NULLABLE | STRING | 1 |
| blkinc | Auto Resequence Incr | DEC(7,0) | NULLABLE | INTEGER | 7 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Thu Dec 12 2024