SAD_BR_GBA_NLD(SQL Table) |
Index Back |
|---|---|
Update BRON GBA dataInterim record for update of GBA data received from bron |
| # | 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 | SAD_BR_EDU_SEC_NLD |
Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO |
| 4 | BATCH_SERIAL_NUM |
Number(5,0) | INTEGER NOT NULL | Last Sequence Nbr |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Prefix |
| 8 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 9 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 10 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 11 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 12 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 14 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 15 | SAD_BR_SEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Sex
M=Male O=Unknown V=Female |
| 16 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 17 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 18 | SAD_BR_NAT_ID_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Number |
| 19 | SAD_GBA_B_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | GBA Year of Birth |
| 20 | SAD_GBA_B_MN_NLD | Character(2) | VARCHAR2(2) NOT NULL | GBA Month of Birth |
| 21 | LAST_NAME_CD | Character(30) | VARCHAR2(30) NOT NULL | Field Last_Name_CD stores the last name for the name field in the community directory. |
| 22 | SAD_GBA_PRFX_NLD | Character(15) | VARCHAR2(15) NOT NULL | Name Prefix GBA |
| 23 | SAD_BR_FST_NMS_NLD | Character(200) | VARCHAR2(200) NOT NULL | Firstnames |
| 24 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
| 25 | NUM1_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 1 Other |
| 26 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
| 27 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 28 | SAD_BR_PSTAL_C_NLD | Character(12) | VARCHAR2(12) NOT NULL | Modified Postal |
| 29 | SAD_BR_SEX_C_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Modified Sex
M=Male O=Unknown V=Female |
| 30 | SAD_BR_BIRTH_C_NLD | Date(10) | DATE | Modified Birthdate |
| 31 | SAD_GBA_BYRC_NLD | Character(4) | VARCHAR2(4) NOT NULL | Changed Birth Yr GBA |
| 32 | SAD_GBA_BMNC_NLD | Character(2) | VARCHAR2(2) NOT NULL | Changed Birth Month GBA |
| 33 | SAD_BR_NATID_C_NLD | Character(20) | VARCHAR2(20) NOT NULL | Modified SOFI Number |
| 34 | SAD_BR_OWNR_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Number BRON |
| 35 | ACCEPTANCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Acceptance Status
R=Rejected T=Taken |