SSR_BR_BO_SETUP(SQL Table) |
Index Back |
|---|---|
BRON Identification SetupBRON Identification Setup /*21-04-2020 changes for Bug 26928598 */ /*15-02-2021 changes for Bug 32132814 */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: HCR_NM_TYP_I |
| 2 | ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Determines the type of Address. Defined to conform with Email and Phone types.
Prompt Table: HCR_ADDR_TYP_I |
| 3 | SSR_BR_NTGBA_NLD | Character(3) | VARCHAR2(3) NOT NULL |
Updated Name Type
Prompt Table: HCR_NM_TYP_I |
| 4 | SSR_BR_ATGBA_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Updated Address Type
Prompt Table: HCR_ADDR_TYP_I |
| 5 | SSR_BR_EDU_NBR_TYP | Character(6) | VARCHAR2(6) NOT NULL |
Education Number Type
Prompt Table: PERS_NID_TYP_VW |
| 6 | SSR_BR_NID_TYP_NLD | Character(6) | VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table: PERS_NID_TYP_VW |
| 7 | SSR_BR_DEF_FNM_NLD | Character(30) | VARCHAR2(30) NOT NULL | Default value for first name in setup BO |
| 8 | SSR_BR_UNK_BPL_NLD | Character(30) | VARCHAR2(30) NOT NULL | Unknown value for Birth Place in setup BO |
| 9 | SSR_BR_UNK_BCN_NLD | Character(30) | VARCHAR2(30) NOT NULL | Unknown value for Birth Country |
| 10 | SSR_BR_UNK_FNM_NLD | Character(30) | VARCHAR2(30) NOT NULL | Unknown value for First Name |