SSR_BR_INDEX_IDSSR_BR_MSGUUIDEMPLIDSSR_BR_ENRL_SQ_NLDSSR_BR_ENR_ST_DTSSR_BR_SUP_PR_NLDSSR_BR_ESVA_NLD(SQL Table) |
Index Back |
|---|---|
Enrollment Service Staging 3Staging Table with Supplemental program Data for VAVO 2020-04-15 bug 31180485 - enlarged enrollment seq nbr |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SSR_BR_ENRL_SQ_NLD |
Character(20) | VARCHAR2(20) NOT NULL | 2020-04-15 bug 31180485 - enlarged enrollment seq nbr |
| 5 | SSR_BR_ENR_ST_DT |
Date(10) | DATE NOT NULL | Start Date |
| 6 | SSR_BR_SUP_PR_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRON Supplemental Program |