SSR_BR_INDEX_IDSSR_BR_MSGUUIDACAD_ORGSCC_BRINCD_NLDSSR_RI_EPB_NLD(SQL Table) |
Index Back |
|---|---|
Staging Table (edu prov BRIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_BR_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
| 2 | SSR_BR_MSGUUID |
Character(50) | VARCHAR2(50) NOT NULL | Message ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 4 | SSR_RI_EDU_GOV_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Board Code |
| 5 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
| 6 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 7 | SSR_RI_EPV_COD_NLD | Character(12) | VARCHAR2(12) NOT NULL | Educational Provider Code |
| 8 | FROM_DT | Date(10) | DATE | From Date |
| 9 | END_DT | Date(10) | DATE | end date |