SSR_BR_ENRS_NLD(SQL Table) |
Index Back |
|---|---|
BRON Enrollment Setup/* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | SSR_BR_USEPLAN_NLD | Character(1) | VARCHAR2(1) NOT NULL | Use Plans indicator. Used in the Dutch Bron Functionality for educational sector VAVO. |
| 7 | SSR_BR_TRM_END_NLD | Character(1) | VARCHAR2(1) NOT NULL | Term End Date |
| 8 | SSR_BR_ID_WL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Use Identification Incl List
Y/N Table Edit Default Value: Y |
| 9 | SSR_BR_EDPVSEL_NLD | Character(3) | VARCHAR2(3) NOT NULL |
Ed Provider Selection
AC=Configurable Acad Org AP=Academic Program HM=Home Campus NLD Default Value: AC |
| 10 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL |
| 11 | SSR_BR_RIO_BDT_NLD | Date(10) | DATE | RIO Begin Date |
| 12 | SCC_CAF_ATTRIB_NM | Character(20) | VARCHAR2(20) NOT NULL |
Common Attribute
Prompt Table: SSR_BR_APTATRVW |